Simple implementation of Mysql add, delete, modify and query statements Added record: insert into tablename(...) values(...) //If the added record includes all columns, there is no need to write the data list insert into tablename values(...) Delete Records: delete from tablename where condition ; Modification history: update tablename set xx=xx , xx=xx... where condition ; alter table tablename set xx=xx , xx=xx... where condition ; Query records: select (...) from tablename where condition ; select * from tablename where condition ; Delete the entire table: drop table tablename ; Add columns: alter table tablename add column columnname columntype ... ; To delete a column: alter table tablename drop column columnname ; Thank you for reading, I hope it can help you, thank you for your support of this site! You may also be interested in:
|
<<: How to manually upgrade the node version under CentOs
>>: How to use type enhancement without typingscript
Table of contents JavaScript function call classi...
Business social networking site LinkedIn recently...
I recently deployed Django and didn't want to...
You can easily input Chinese and get Chinese outp...
This article example shares the specific code of ...
Table of contents Where is the source code of the...
Repetition: Repeat certain page design styles thr...
Table of contents 1. Teleport usage 2. Complete t...
Preface This chapter uses basic Linux functions a...
It is standard for websites to enable SSL nowaday...
We can set a background image for the cell, and w...
Preface When making a top menu, you will be requi...
1. Start the Docker container Start a new Docker ...
First, your container must be running You can vie...
Create a container [root@server1 ~]# docker run -...