打开cmd:① mysql -u root
② create database if not exists image_database;
③ use image_database;
drop table if exists image_table;
④ create table image_table(
image_id int not null primary key auto_increment,
image_name varchar(50),
upload_time varchar(50),
content_type varchar(50),
md5 varchar(50),
size int,
path varchar(1024)
);
show create table image_table; 展示建表语句
desc image_table; 展示表内细节
MySQL数据库建表的语句
最新推荐文章于 2024-04-16 18:42:22 发布