以后是要做大数据的人,如果连结构化的数据库都不会的话,那岂不是笑死人?所以果断靠着当年兴趣盎然的时候学的那点基础来复习一下,发现果然学过一遍再来复习那基本就是高中学一段内容看书与翻书的区别,当文字显现刹那,内心就浮出这个命令的用法与局限,很爽的有木有?
[root@host]# mysql -u root -p
Enter password:******
mysql> exit
Bye
[root@host]# mysqladmin -u root -p create test
Enter password:******
或者是登陆之后:
create database test
create database if not exists test DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
逆推即可得到删除数据库:
[root@host]# mysqladmin -u root -p drop test
Enter password:******
drop database RUNOOB
[root@host]# mysql -u root -p
Enter password:******
mysql> use RUNOOB;
Database changed
mysql>
create table table_name (column_name column_type);
具体的示例如:
create table if not exists `runoob_tbl`(
`runoob_id` INT UNSIGNED AUTO_INCREMENT,
`runoob_title` VARCHAR(100) NOT NULL,
`runoob_author` VARCHAR(40) NOT NULL,
`submission_date` DATE,
PRIMARY KEY ( `runoob_id` )
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
//那些`是为了标注column 而特意加的,实操的时候不需要的,看图
drop table table_name ;
insert INTO table_name ( field1, field2,...fieldN ) VALUES ( value1, value2,...valueN );
select column_name,column_name from table_name [where Clause]
[OFFSET M ][LIMIT N]
select field1, field2,...fieldN from table_name1, table_name2...
[where condition1 [and [or]] condition2.....
PS:MySQL 的 where 子句的字符串比较是不区分大小写的。 你可以使用 BINARY 关键字来设定 where 子句的字符串比较是区分大小写的。
mysql> select * from runoob_tbl where BINARY runoob_author='runoob.com';
update table_name SET field1=new-value1, field2=new-value2
[where Clause]
delete from table_name [where Clause]
select field1, field2,...fieldN from table_name where field1 like condition1 [and [or]] filed2 = 'somevalue'
MySQL UNION 操作符
select expression1, expression2, ... expression_n from tables [where conditions]
UNION [ALL | DISTINCT]
select expression1, expression2, ... expression_n from tables [where conditions];
告一段落,过几天继续,今天先学到这儿,想必大家都看得出来了。这个教程来自Mysql - 菜鸟教程 ,这个网站真的是个好东西,太喜欢了!