MySQL create command build table SQL statement

Source: Internet
Author: User
Tags character set mysql create php script table name mysql create table mysql database

The basic syntax for the CREATE TABLE statement in MySQL is:

The code is as follows Copy Code

CREATE [temporary] TABLE [IF not EXISTS] tbl_name [(create_definition,...)]
[Table_options] [Select_statement]


Temporary: This keyword indicates that the newly created table with MySQL CREATE TABLE is a temporary table that will automatically disappear after the current session ends. Temporary tables are mainly used in stored procedures, and for MySQL, which does not currently support stored procedures, this keyword is generally not available.

IF not EXISTS: In fact, add a judgment before the table is being built to perform the CREATE TABLE operation only if the table does not currently exist. Use this option to avoid errors where the table already exists and cannot be created again.

Tbl_name: The table name of the table you want to create. The table name must conform to the rules for identifiers. The usual practice is to use only letters, numbers, and underscores in the table name. For example, titles, Our_sales, My_user1 and so on should be regarded as the table name of the comparison specification.

Create_definition: This is the key part of the MySQL CREATE TABLE statement. The properties of each column in the table are specifically defined in this section.

MySQL when getting Started with table statements

The code is as follows Copy Code
CREATE TABLE Class
Stu int
Name varchar (20)
Age int
Area varchar (20)
CREATE TABLE Score (
Stu Int,
Name varchar (20),
ke varchar (10),
Fen int
);

————
To resolve a character set encoding statement:
Declaring the character set:

The code is as follows Copy Code
Set names GBK;
$SETCHARACTERSETSQL = "Set names ' utf8′";
$ziti = mysql_query ($SETCHARACTERSETSQL, $conn);
Var_dump ($ziti);
echo ' <br/> ';

Finding a way seems to solve the problem.

In the installation of MySQL server, whether the choice of gb2312 or utf-8, there is no relationship, these character sets in the phpMyAdmin can be very good work, mainly their own script to correctly display Chinese, you can in the PHP script, after connecting the database, Execute the following statement before the formal data query is submitted:

The code is as follows Copy Code

$SETCHARACTERSETSQL = "Set NAMES ' own use of character set '";

$Recordset 1 = mysql_query ($SETCHARACTERSETSQL, $conn _resource) or Die (Mysql_error ());

Then execute your own query statement, and the result is correct. Just tried gb2312 and utf-8, no problem.

Message This data is created:

  code is as follows copy code
create table MSG (
ID int primary key auto_increment,
Title varchar (),
name varchar (a),
content varchar (1000)
); br>//Note Kanji Add "single quotes
INSERT INTO msg
(id,title,name,content)
Values
(1, ' come out of the intersection ', ' John ', ' It's raining so much today, can you be the boss? ’);
INSERT INTO MSG
(id,title,name,content)
Values
(2, ' I'm coming again ', ' Dick ', ' come late, second place ');
INSERT INTO MSG
(ID, title,name,content)
Values
(3, ' The third title ', ' Liu Bei ', ' male and female double Swords ',
(4, ' fourth title ', ' Guan Yu ', ' Tsing Lung Yan Yue Dao '),
(5, ' fifth title ', ' Zhang Fei ', ' Zhang Eight Serpent Spear ');
INSERT INTO MSG
(id,title,name,content)
Values
(6, ' sixth title ', ' Tang Junhao ', ' I am Handsome ');


Emptying the table's data

The code is as follows Copy Code
Truncate MSG

Add a semicolon after changing the note ID;
Update msg
Set
Id=3
where
name = ' Dick ';
//
Update msg
Set
id=2,
Content = ' I'm still late, so it's second place. '
where
name = ' Dick ';

Delete

The code is as follows Copy Code
Delete from Msg
where id = 2;

Inquire

The code is as follows Copy Code
Select Name,content * from msg where ID > 2//There is no * asterisk
PHP connection MySQL database server
$conn = mysql_connect (' localhost ', ' root ', ' root ');
$sql = ' Use Phptest ';
mysql_query ($sql, $conn);

Read message

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.