Brief Analysis of basic functions of mysql
The following content mainly brings you a brief analysis of the basic functions of mysql. The knowledge mentioned here, which is slightly different from books, is summed up by professional and technical personnel in the process of contact with users, and has a certain value of experience sharing. I hope to bring help to the majority of readers.
Add = "insert into library. Table (field name list) values (values list)
Mysql > create table meinvdb.mm (
-> id int (4) not null primary key
-> name varchar (18) not null
->)
Query OK, 0 rows affected (0.23 sec)
Mysql > insert into meinvdb.mm (id, name) values (1, "liuyan"), (2, "yangmi")
Query OK, 2 rows affected (0.09 sec)
Records: 2 Duplicates: 0 Warnings: 0
Change to = "update table name set condition where field name =" value "
Mysql > update meinvdb.mm set id=1 where name= "bingbing"
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0
Look up = "select field list from table name where conditional expression list
Mysql > select name from meinvdb.mm where id=2
+-+
| | name |
+-+
| | yangmi |
+-+
1 row in set (0.00 sec)
Delete = "delete from table name where condition
Mysql > delete from meinvdb.mm where id=1
Query OK, 1 row affected (0.08 sec)
Mysql > select * from meinvdb.mm
+-+ +
| | id | name |
+-+ +
| | 2 | yangmi |
+-+ +
For the above brief analysis of the basic functions of mysql, if you have more to know, you can continue to pay attention to the innovation of our industry. If you need professional answers, you can contact the pre-sales and after-sales on the official website. I hope this article can bring you some knowledge updates.
