mysql基本语法

mysql的启动重启命令

sudo /usr/local/mysql/support-files/mysql.server start
sudo /usr/local/mysql/support-files/mysql.server stop
sudo /usr/local/mysql/support-files/mysql.server restart

可以设置vi ~/.bash_profile，记得source ~/.bash_profile。

alias mysqlst='sudo /usr/local/MySQL/support-files/mysql.server start'
alias mysqlsp='sudo /usr/local/MySQL/support-files/mysql.server stop'

基本语法：

// 登录本地
mysql -u root -p 

// 远程登录
mysql -u {username} -p{password} -h {remote server ip} -P {port} {DB name}

source <.sql文件路径> // 导入.sql文件

mysqldump -u root -p 数据库名>sql_name.sql // 导出.sql文件到当前路径下

show databases;

CREATE DATABASE 数据库名;

drop database <数据库名>;

use 数据库名;

show tables;

desc  table_name; // 查看表结构

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;

DROP TABLE table_name ;

INSERT INTO table_name ( field1, field2,...fieldN )
                       VALUES
                       ( value1, value2,...valueN );

推荐阅读

MySQL 教程
mysql 查看数据库、表的基本命令
Mac Mysql 修改初始化密码
Mac 下修改mysql初始密码
关于MySql链接url参数的设置