mysql 常用sql語句 一

create database if not exists wsp_test  default charset utf8 collate utf8_general_ci

use wsp_test;

source sql檔案路徑

create table if

not exists user (
user_id int(
11) not null auto_increment,
name varchar(
255) default
null,
create_time date 
default
null,
primary key (user_id)    
);注意點：
預設值是否非空
表型別主鍵
自增常用表欄位型別：
intchar
varchar
datetime
double

修改表欄位資料型別

alter table wsp_test change column user_id id 
int(5) not null
auto_increment;
增加列alter table user add column descss varchar(
255) default
null
;刪除列
alter table user drop column descss;
重新命名錶
alter table user rename to users;
清空表truncate table users;

insert into users(name) values("小名"

);insert into users(name) values("小紅
");insert into users(name) values("小白
");insert into users(name) values("小青
");insert into users(name) values("小紫
");

update users set name = '小黃'

where name = '小白'
;update users,salary 
set salary = salary + salary*percent where salary = 1000  ## 連表更新

delete from salary where salary = 1100

;delete users,salary 
from users inner join salary on users.id = salary.user_id  where salary.salary = 200; ## 多表刪除

mysql 常用 sql 語句（一）

清空表語句 truncate table fke message 重設自增欄位起始值 alter table fke message auto increment 10001 常用建表語句 drop table if exists fke message create table fke messa...

常用SQL語句（mysql）

insert into語句用法 insert into m new car sale car id,type,car type,price,exhaust,volume,tran ission,image select carid,type,cartype,price,fuel,displaceme...

MySql 常用Sql語句

create database kali use kali show tables create table students sno varchar 10 primary key,sname varchar 10 not null,varchar 2 check in 男 女 age varcha...