Mac下对Mysql数据库的常用操作
1. 开启、停止和重启
(1)启动MySQL服务
sudo /usr/local/MYSQL/support-files/mysql.server start
(2)停止MySQL服务
sudo /usr/local/mysql/support-files/mysql.server stop
(3)重启MySQL服务
sudo /usr/local/mysql/support-files/mysql.server restart
具体操作:
0、登录数据库
/usr/local/MySQL/bin/mysql -u root -p

1、创建一个名字为task_manage数据库 create database task_manage character set utf8;
create database task_manage character set utf8;
2、修改数据库编码:alter database NickYang character set utf8;
3、查看数据库是否创建成功:show databases;
show databases;
4、进入数据库:use NickYang;
use task_manage;
5、创建表并为表分配一个主键:create table yang(id int primary key);
create table project(id int primary key);
6、查看表是否创建成功:show tables;
show tables;
7、查看表结构:desc 表名;
desc project;
8、增加字段:alter table 表名 add 字段名 数据类型[位置];
alter table project add project_name varchar(255) after id;
9、删除字段:alter table 表名 drop 字段名;
alter table project drop name;
网友评论