这篇文章主要介绍了Mysql命令大全,用于写mysql语句找不到命令!
select * from bbs where id=1;
insert into bbs (name,data_year) values ("jack","1993-10-01");
update bbs set name="tom",sex=1,age=18 where name="jack";
delete form bbs where id=2;
UPDATE \`category\` SET guid = REPLACE ( guid, 'articles', 'article' );
mysqldump -u root -p test\_db > d:/test\_db.sql
mysqldump -u root -p test_db table1 > d:/table1.sql
mysqldump -u root -p -d --add-drop-table test\_db > test\_db.sql
create database if not exists bbs
create database bbs;
drop database bbs;
create table (id int not null auto\_increment primary key,name char(16) not null default "jack",date\_year date not null);
drop table test_db;
rm -f database\_name/table\_name.* (linux下)
例如: rm -rf bbs/accp.*
insert into bbs set name="jack",date_year="1993-10-01";
insert into table_name values (column1,column2,...);
例如:insert into bbs ("2","jack","1993-10-02")
insert into table\_name (column\_name1,column_name2,...) values (value1,value2);
例如:insert into bbs (name,data_year) values ("jack","1993-10-01");
select * from bbs where id=1;
update bbs set name="tom",age=18 where name="jack";
alter table bbs add column tel char(16) not null;
alter table bbs add column tel char(16) not null,add column address text;
alter table bbs drop tel;
alter table test_db modify name char(16) default not null "yourname";
alter table bbs rename as bbs_table;
``mysql rename table old\_table\_name to new\_table\_name;
例如:rename table test_db to accp;
create table test_db select * from accp where 1<>1;
create table test_db select * from accp;