DB/mySQL

DB 테이블 2개 만드는법2 | varchar( ) | int | num smalint auto_increment primary key

DEV-HJ 2022. 4. 3. 15:54
반응형

create table food(num smallint auto_increment primary key,
foodname varchar(20),
foodphoto varchar(30),
price int,
cnt int)

 



create table student(num smallint auto_increment primary key,
name varchar(20),
photh varchar(30),
java int,
spring int)

반응형