첨부 파일이 안대더라고요
그래서 이렇게 내용만 떠서 보내드립니다...
그럼 확인해주시고 답주세요..
아래 %김 , 김% , %김% 할때 query 이상하게 나온거입니다.
CREATE TABLE diary (
num int(7) DEFAULT '0' NOT NULL auto_increment,
title varchar(255) DEFAULT '' NOT NULL,
content text NOT NULL,
year int(4) DEFAULT '0' NOT NULL,
month tinyint(4) DEFAULT '0' NOT NULL,
day tinyint(4) DEFAULT '0' NOT NULL,
weather tinyint(4) DEFAULT '0' NOT NULL,
face tinyint(4) DEFAULT '0' NOT NULL,
wdate date DEFAULT '0000-00-00' NOT NULL,
id_fk varchar(20) DEFAULT '' NOT NULL,
temp varchar(50) DEFAULT '' NOT NULL,
st tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (num)
);
#
# Dumping data for table 'diary'
#
#
# Table structure for table 'imagess'
#
CREATE TABLE imagess (
f_name varchar(10),
l_name varchar(10)
);
#
# Dumping data for table 'imagess'
#
#
# Table structure for table 'testone'
#
CREATE TABLE testone (
user varchar(20) DEFAULT '' NOT NULL,
hobby varchar(20),
region varchar(20),
name varchar(20),
PRIMARY KEY (user)
);
#
# Dumping data for table 'testone'
#
INSERT INTO testone VALUES ('baseball','게임','서울','최우원');
INSERT INTO testone VALUES ('sockr','축구','목포','심상민');
INSERT INTO testone VALUES ('ttt1234','야구','경기','신현동');
INSERT INTO testone VALUES ('swim','수영','경기','정종권');
INSERT INTO testone VALUES ('foot','족구','대구','이미정');
INSERT INTO testone VALUES ('pingp','탁구','대전','홍영자');
INSERT INTO testone VALUES ('music','음악','목포','윤대한');
INSERT INTO testone VALUES ('movie','영화','광주','권영주');
INSERT INTO testone VALUES ('drink','음주','서울','김영훈');
INSERT INTO testone VALUES ('mola','야구','서울','윤현식');
INSERT INTO testone VALUES ('toyou','수영','부산','오세홍');
INSERT INTO testone VALUES ('test02','게임','경기','홍길동');
INSERT INTO testone VALUES ('test03','독서','서울','임꺽정');
INSERT INTO testone VALUES ('test04','독서','광주','박찬호');
|