mysql中怎样创建数据库?
男神
男神 2016-12-20 16:35:21
0
5
2650
男神
男神

╰つ ゛思 绪 万 千 , 不 如 努 力 向 前 .ヽ

reply all(5)
钟毅

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;

  1. Determine whether it exists.

  2. Whether there are symbols.

  3. DATE, CHAR, VARCHAR,....

  4. It's generally the same if the engine doesn't support 10G.

  5. 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.

phpcn_u10699

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

本Q已中毒

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数据库

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template