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 1. Background 2. Operation step...
Uses of new The function of new is to create an i...
Database MySQL version 8.0.18 Download a DBeaver....
This article describes how to boot the Linux syst...
Preface As Linux operation and maintenance engine...
Preface Review and summary of mobile terminal rem...
Today I had some free time to write a website for...
1. Download Download mysql-5.7.19-linux-glibc2.12...
Table of contents 1. Set Deduplication 2. Double ...
ps: Here is how to disable remote login of root a...
The warning points in this article have nothing t...
echarts word cloud is an extension of echarts htt...
accomplish This effect is difficult to replicate ...
Preparation 1. Start the virtual machine 2. git t...
1. Top-level usage 1. Install cnpm npm i -g cnpm ...