MySql經常使用操作SQL語句匯總。本站提示廣大學習愛好者：（MySql經常使用操作SQL語句匯總）文章只能為提供參考，不一定能成為您想要的結果。以下是MySql經常使用操作SQL語句匯總正文
MySQL的罕見操作在這裡先做一下總結，曾經整合到代碼外面，經由磨練無誤。
/*創立一個數據庫*/
create database xuning_test;
/*解釋其時應用數據庫對象*/
use xuning_test;
/*向數據庫中添加表而且界說表的構造*/
create table person(
id int not null,
name varchar(16) not null,
sex varchar(16) not null,
age int not null,
address varchar(128) not null,
remark varchar(512) not null
);
/*向數據庫的表中拔出數據*/
insert into person value
(1,'name_1','men',99,'beijing','This is a frindsheep boy'),
(2,'name_2','men',88,'shanghai','ok great'),
(1,'name_3','man',77,'guangzhou','This is lickly'),
(1,'name_4','men',66,'beijing','This is a frindsheep boy'),
(1,'name_5','men',55,'beijing','you dont going to shool'),
(1,'name_6','man',44,'beijing','This is a frindsheep boy'),
(1,'name_7','men',33,'beijing','This is a frindsheep boy'),
(1,'name_8','man',22,'beijing',''),
(1,'name_9','men',11,'beijing','This is a frindsheep boy')
;
/*查詢時否勝利拔出*/
select * from person;
/*上面是多種查詢方法*/
/*依據列的稱號屬性值*/
select name from person;
/*添加前提-依據性別*/
select name from person where sex = 'men';
/*也能夠用比擬符作為前提--必定逗號離隔*/
select name,address from person where age > 50;
/*看作對象去應用數據庫和表的關系=---雙表聯系關系--對象關系必定要明白*/
select xuning_test.person.name, xuning_test.person.id, xuning_test.person.age, xuning_test.person.address
from xuning_test.person, test1.test_xuning
where xuning_test.person.id = test1.test_xuning.id
;
/*應用表的別號停止查詢*/
use xuning_test;
select c.name,sex from person as c where c.age > 40 and c.address='beijing';
