2016/3/10 Database simple operation (CREATE database CREATE table numeric type primary key foreign key auto increment)

1, right-click on the root directory under the connection to create the database
Enter the database name, set it up, and click on the page to determine the success of the creation
2. Double-click to open Database
The first of these is the table, the most important and fundamental of the table.
3, CREATE TABLE, find table Right-click, create table.
First of all to determine the column, column name, the database do not use Chinese name to do the column name.
Re-determine the value, type bit Boolean can only store true false

Decimal longer can be defined by its own general float

Char is set to a character length of 1 and can only be 1

varchar is used to store strings that can be set to a length common to 50
Text to save an article about
Binary used to store binary data picture to binary when used but generally the path of storage

4, primary key, foreign key setting. A link between a city table and a table. The foreign key must be disconnected and deleted before the change occurs. After the modification, re-establish. Otherwise you will get an error.

primary key Settings , set the main sequence number. Key is the flag of the primary key

Foreign key settings

Foreign key settings

Auto Increment

：

2016/3/10 Database simple operation (CREATE database CREATE table numeric type primary key foreign key auto increment)