Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to create data tables in MySQL database, which is very detailed and has certain reference value. Friends who are interested must finish reading it.

MySQL creates a data table

The following information is required to create an MySQL data table:

Table name

Table field name

Define each table field

Grammar

The following is the general SQL syntax for creating MySQL data tables:

CREATE TABLE table_name (column_name column_type)

In the following example, we will create the data table chenweiliang_tbl in the chenweiliang database:

CREATE TABLE IF NOT EXISTS `chenweiliang_ tbl` (`chenweiliang_ id` INT UNSIGNED AUTO_INCREMENT, `chenweiliang_ title` VARCHAR (100) NOT NULL, `chenweiliang_ author` VARCHAR (40) NOT NULL, `submission_ date` DATE, PRIMARY KEY (`chenweiliang_ id`) ENGINE=InnoDB DEFAULT CHARSET=utf8

Instance resolution:

If you do not want the field to be NULL, you can set the property of the field to NOT NULL. If you enter the data of the field as NULL when operating the database, you will report an error.

The AUTO_INCREMENT definition is listed as a self-increasing attribute, which is generally used for primary keys, and the value is automatically incremented by 1.

The PRIMARY KEY keyword is used to define the column primary key. You can use multiple columns to define the primary key, separated by commas.

ENGINE sets the storage engine and CHARSET sets the encoding.

Create a table from the command prompt

You can easily create an MySQL data table through the mysql > command window. You can use the SQL statement CREATE TABLE to create a data table.

Example

The following is the creation of a datasheet chenweiliang_tbl instance:

Root@host# mysql-u root-pEnter password:*mysql > use chenweiliang;Database changedmysql > CREATE TABLE chenweiliang_tbl (- > chenweiliang_id INT NOT NULL AUTO_INCREMENT,-> chenweiliang_title VARCHAR (100th) NOT NULL,-> chenweiliang_author VARCHAR (40) NOT NULL,-> submission_date DATE,-> PRIMARY KEY (chenweiliang_id)->) ENGINE=InnoDB DEFAULT CHARSET=utf8;Query OK, 0 rows affected (0.16 sec) mysql >

Note: the MySQL command Terminator is a semicolon (;).

Create a datasheet using a PHP script

You can use the mysqli_query () function of PHP to create data tables in an existing database.

This function takes two arguments and returns TRUE on successful execution, or FALSE otherwise.

Syntax mysqli_query (connection,query,resultmode); parameter description connection is required. Specifies the MySQL connection to be used. Query is required, specifying the query string. Resultmode is optional. A constant. It can be any of the following values:

MYSQLI_USE_RESULT (use this if you need to retrieve a large amount of data)

MYSQLI_STORE_RESULT (default)

Example

The following example uses a PHP script to create a data table:

Create data Table above is all the content of the article "how to create data Table in MySQL Database". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.