mysql的安装和使用

http://wenku.baidu.com/view/3f7319a4f524ccbff1218468.html

1. 安装

http://www.cnblogs.com/276815076/archive/2012/04/01/2428364.html

安装包

sudo apt-get install mysql-server

设置root密码

mysqladmin -u root password 'abc123' -p

2. configure the mysql to accept connection from outside.
    In /etc/mysql/my.cnf change this:
        bind-address            = 127.0.0.1
    to
        bind-address            = 0.0.0.0

3. configure mysql to accept root connection from remote host
grant all privileges on *.* to 'root'@'%' identified by 'passwd' with grant option;

这个方法转自http://www.cnblogs.com/wliang22/archive/2009/11/13/1602423.html

4. 创建用户

create user abc;

2. 新建/选择数据库

create database dev;

show databases;

use dev;

drop database dev;

删除数据库。

3. 显示/新建表

show tables;

create table pet(name varchar(20), owner varchar(20), species varchar(20), sex char(1), birth date, death date);

describe pet;

+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| name    | varchar(20) | YES  |     | NULL    |       |
| owner   | varchar(20) | YES  |     | NULL    |       |
| species | varchar(20) | YES  |     | NULL    |       |
| sex     | char(1)     | YES  |     | NULL    |       |
| birth   | date        | YES  |     | NULL    |       |
| death   | date        | YES  |     | NULL    |       |
+---------+-------------+------+-----+---------+-------+

drop table pet;

删除表

4. 从文件中导入表的数据

5. 数据的输入和读取

insert into pet values('Puffball', 'Diane', 'hamster', 'f', '1993-02-01', NULL);

select * from pet;

select 的格式是

select what_to_select

from which_table

where conditions_to_satisfy

select distinct owner from pet;

不显示重复的。

select name,birth from pet order by birth;

排序

6. 删除表的内容

delete from pet;

7. 更新表的记录

update pet set death='3098-09-08' where name='Puffball'；