TEST table 생성
create table test( no int(5) NOT NULL auto_increment, usrtitle tinytext, contents text, hit int(5) NOT NULL, usrname varchar(12), usrpasswd char(28), filluptime int(11) NOT NULL, PRIMARY KEY (no) ) insert into test(no,usrtitle,contents,hit,usrname,usrpasswd,filluptime) values('01','공부 분량 1.5배 늘어··· 벼락치기, 이젠 안 통한다', '〈공부할 수 있을 것"이라고 말했다.','0', '관리자','0000','06'); update test set contents='◇한국사, 기..
2012. 3. 6.
MySQL Workbench table editor there are 7 column flags available: PK, NN, UQ, BIN, UN, ZF, AI.
PK - Primary Key NN - Not Null BIN - Binary UN - Unsigned UQ - Create/remove Unique Key ZF - Zero-Filled AI - Auto Incremenent [출처] MySQL Workbench table editor there are 7 column flags available: PK, NN, UQ, BIN, UN, ZF, AI.
2012. 3. 6.