当前位置：网站首页>MySQL related commands

MySQL related commands

2022-07-18 23:10:00 【sarah0619】

use Library name ;create table Table name ( Field name varchar（20）, Field name char（1）);	Create a table in a library
for example :use test;	( open test This database )
drop database Library name ;	Delete database
drop table Table name ;	Delete data table
delete form Table name ;	Empty the records in the table
select * from uu;	List uu The records in this table
insert into test（name,age）values（'sarah','28'）;	Insert new data
update Table name set Field name 1='a', Field name 2='b'where Field name 3'c';	Update the data in the table
describe Table name ;	Display the data table in the database
select database();	Show all databases
select user();	Show all the tables
select * from Table name where sex= " Woman ";	Choose a female from this list
select name,sex from Table name ;	Check the names and genders of all people in this table
select count(*) from Table name ;	Count the rows of this table
select sex,count(*) from Table name group by sex;	Group genders and count

版权声明
本文为[sarah0619]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/199/202207162046010124.html