Home >Database >Mysql Tutorial >mysql常用的命令_MySQL
mysql常用的命令_MySQL
- WBOYOriginal
- 2016-06-01 13:08:45917browse
show databases;
use nxu_life;
show tables;
select * from news where department='教务处' limit 10,10;
set names gb2312;
show columns from news;
drop database nxu_life;
source D:/nxu_life.sql;
alter table user_info modify column email varchar(50);//修改字符长度
alter table test add myc interger not null default 20;//增加字段
alter table test drop column myc;//删除字段
quit;
exit;//退出
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL存储过程的学习（二）_MySQLNext article：mysql忘记密码怎么办？_MySQL