A brief discussion on MySQL drifting (3)

Friends who have read MySQL Drifting (1) and MySQL Drifting (2),
You will find: Wow, why is it all theoretical stuff? Can I get some goodies? Haha, I am listed as a guest officer, please let me know some useful information.

Start getting started and enter our Add, Delete, Modify and Check
Step one: New library
We create a database named 'test':
Syntax:

create  database +数据库名字 
Case:  create  database    test;

Step two: Create a new table in the library
We create a data table 'test_01' in this database called test, and create three new fields: name + age + address;

Syntax:

use +需要使用的数据库名字 
Case:   use test;

Grammar:

create table +表名字 
Case:  create table test_01( 

                        name nvarchar(40), 

                        age  int(5) 

                        address nvarchar(100));

Step 3: Increase
To add data to the table, we use the insert into command;
Grammar:

insert into+表名+values(字段名，字段值…) 
现在往test01表格里面添加一条数据，name=’wangwu’, 
age=’21’,address=’北京’ 
Case：insert into test_01 values(‘wangwu’,’21’,’北京’);

Step 4: Check
We just added a piece of data, now you can view the data just added to the table, so use the query command select
Syntax:

select  字段名  from  表名  
备注：当我们只想查看某个表中所有的数据时，直接用select * from 表名即可： 
Case: select  *  from  test_01;

Step 5: Change
After viewing the data we just added, now we want to modify the data just added to the test_01 table, change name='wangwu' to name='lisi', use the update command
Grammar:

update 表名 set 字段名=value where  条件 
Case: update test_01 set name=’lisi’ where name=’wangwu’;

Step 6: Delete
Now I don’t want the content I just modified. I want to delete the record name='lisi' using the delete command.
Grammar:

delete from 表名 where 条件 
Case: delete from test_01 where name=’lisi’

So far, a set of simple additions, deletions, modifications and checks are basically implemented. Dear readers, please look forward to Xiaosheng’s next rafting~
Thank you for your support!

Friends who have read MySQL Drifting (1) and MySQL Drifting (2),
You will find: Wow, why is it all theoretical stuff? Can I get some goodies? Haha, I am listed as a guest officer, please let me know some useful information.

Start getting started and enter our Add, Delete, Modify and Check
Step one: New library
We create a database named 'test':
Syntax:

create  database +数据库名字 
Case:  create  database    test;

Step two: Create a new table in the library
We create a data table 'test_01' in this database called test, and create three new fields: name + age + address;

Syntax:

use +需要使用的数据库名字 
Case:   use test;

Grammar:

create table +表名字 
Case:  create table test_01( 

                        name nvarchar(40), 

                        age  int(5) 

                        address nvarchar(100));

Step 3: Increase
To add data to the table, we use the insert into command;
Grammar:

insert into+表名+values(字段名，字段值…) 
现在往test01表格里面添加一条数据，name=’wangwu’, 
age=’21’,address=’北京’ 
Case：insert into test_01 values(‘wangwu’,’21’,’北京’);

Step 4: Check
We just added a piece of data, now you can view the data just added to the table, so use the query command select
Syntax:

select  字段名  from  表名

Note: When we only want to view all the data in a certain table, just use select * from the table name:

Case: select  *  from  test_01;

Step 5: Change
After viewing the data we just added, now we want to modify the data just added to the test_01 table, change name='wangwu' to name='lisi', use the update command
Syntax:

update 表名 set 字段名=value where  条件 
Case: update test_01 set name=’lisi’ where name=’wangwu’;

Step 6: Delete
Now I don’t want the modified content. I want to delete the record name='lisi' using the delete command.
Syntax:

delete from 表名 where 条件 
Case: delete from test_01 where name=’lisi’

So far, a simple set of additions, deletions, modifications and checks has been basically implemented. Dear readers, please look forward to Xiaosheng’s next rafting~
Thank you for your support!

The above is the detailed content of A brief discussion on MySQL drifting (3). For more information, please follow other related articles on the PHP Chinese website!