╰つ ゛思 绪 万 千 , 不 如 努 力 向 前 .ヽ
CREATE TABLE IF NOT EXISTS `runoob_tbl`( `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id` ))ENGINE=InnoDB DEFAULT CHARSET=utf8;
Determine whether it exists.
Whether there are symbols.
DATE, CHAR, VARCHAR,....
It's generally the same if the engine doesn't support 10G.
UTF8 is a must-have option. Otherwise, Heihei will exhaust you to death, debugging.
How to create a database in mysql? -PHP Chinese website Q&A-How to create a database in mysql? -PHP Chinese website Q&A
Please watch and learn.
There are many methods, you can use DOS window, you can also use some MySQL software, such as wampserver, phpmyadmin in this integrated environment, you can directly create a database and insert data
There is a small green plus sign in the upper right corner, click it
mysql创建数据库命令:
1.showdatabases//显示数据库2.createdatabasestudent(数据库名)//创建数据库student3.usestudent//进入student数据库4.createtablestudinfo(表名)(snointprimarykey,sageint(2))//创建表studinfo5.showtable//显示表6.dropdatabasestudent//删除student数据库
CREATE TABLE IF NOT EXISTS `runoob_tbl`(
`runoob_id` INT UNSIGNED AUTO_INCREMENT,
`runoob_title` VARCHAR(100) NOT NULL,
`runoob_author` VARCHAR(40) NOT NULL,
`submission_date` DATE,
PRIMARY KEY ( `runoob_id` ))ENGINE=InnoDB DEFAULT CHARSET=utf8;
Determine whether it exists.
Whether there are symbols.
DATE, CHAR, VARCHAR,....
It's generally the same if the engine doesn't support 10G.
UTF8 is a must-have option. Otherwise, Heihei will exhaust you to death, debugging.
How to create a database in mysql? -PHP Chinese website Q&A-How to create a database in mysql? -PHP Chinese website Q&A
Please watch and learn.
There are many methods, you can use DOS window, you can also use some MySQL software, such as wampserver, phpmyadmin in this integrated environment, you can directly create a database and insert data
There is a small green plus sign in the upper right corner, click it
mysql创建数据库命令:
1.showdatabases//显示数据库
2.createdatabasestudent(数据库名)//创建数据库student
3.usestudent//进入student数据库
4.createtablestudinfo(表名)(snointprimarykey,sageint(2))
//创建表studinfo
5.showtable//显示表
6.dropdatabasestudent//删除student数据库