Chinese version
Http://pan.baidu.com/s/1Eta1K
Cracked machine included
Navicat
Graphical management tools for relational databases
SQL Structured Query Language structured queries language
Data type of the field in the table:
Blob binary type
Integer integer type
Real character Dot type
Text string
varchar (10) 10 character (s)
Build Table statements: the CREATE table if not exist table name (Field 1 field 1 type, field 2 field 2 type,...);
Delete Table statement: Drop table if not exist name;
The constraint is placed directly behind the field type, and it acts as a modifier
Simple constraint not NULL field value cannot be null
Unique field values are single, non-repeatable
Default Value field value defaults to a value
PRIMARY KEY constraint PRIMARY key PRIMARY KEY constraint
AutoIncrement Automatic growth constraint
PRIMARY key AutoIncrement primary KEY auto-grow constraint
FOREIGN KEY constraint CONSTRAINT foreign key name FOREIGN key (foreign key field) REFERENCES appearance name (Foreign key field)
Insert Data statement: INSERT into table name (Field 1, Field 2,...) Values (value 1, value 2,...);
Modify Data statement: UPDATE table name SET Field 1 = value of field 1, field 2 = value of field 2,...;
Delete Data statement: delete from table name;
SELECT Field 1, Field 2,... from table name;
SELECT * from table name;
Internal connection:
SELECT * from table name table alias, foreign key table name foreign key table alias WHERE table alias. Add foreign key field = foreign key table alias. ID and ...;
SELECT * FROM table name INNER JOIN foreign key table name on table alias. Required foreign key field = foreign key table alias. ID and ...;
Left Outer connection:
SELECT * from table name table alias left OUTER JOIN foreign key table name foreign key table alias on table alias. The foreign key field = Foreign key table alias is required. ID and ...;
Aliases:
SELECT Field 1 alias 1, Field 2 alias 2,... from table name;
SELECT Field 1AS alias 1, Field 2AS alias 2,... From table name as table alias;
SELECT table alias. Field 1, table alias. Field 2,... From table name table alias;
Number of query records:
SELECT Count (*) from table name WHERE a condition;
SELECT count (a field) from the table name WHERE a condition;
Conditional statements:
Single-row data
WHERE a field = a value;
WHERE A field is a value;
WHERE a field! = a value;
WHERE A field is not a value;
Multiple rows of data
WHERE a field > a value;
WHERE a field >= a value;
WHERE a Field 1 = a value and a field 2 > a value;
WHERE a Field 1 = a value or a field 2 > a value;
Sort statements:
Ascending
SELECT * from T_ table name ORDER by field 1 ASC, field 2 ASC,...;
Descending
SELECT * from T_ table name ORDER by field desc, field 2 desc,...;
Line-Limiting syntax:
SELECT * from t_ table name LIMIT skips the first few lines, and then searches for several lines;
Base-Database Navicat