Base-Database Navicat

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.