一、安装配置
打开:mysql -u root -p
- 安装的关键步骤
- cd /usr/local/bin/
- sudo ln -fs /usr/local/mysql/bin/mysql mysql 修改默认地址为mysql
- sudo /usr/local/mysql/support-files/mysql.server stop 关闭 mysql服务
卸载
sudo rm /usr/local/mysql
sudo rm -rf /usr/local/mysql*
sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/PreferencePanes/My*
sudo vim /etc/hostconfig (ps:需要删除其中的MYSQLCOM=-YES-)
sudo rm -rf ~/Library/PreferencePanes/My*
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /var/db/receipts/com.mysql.*
二、 忘记密码
- 关闭mysql服务
- 打开终端
- cd /usr/local/mysql/bin/
- sudo su 登录管理员权限
- .mysqld_safe –- skip-grant-tables & 禁止mysql验证功能
- ./mysql
- FLUSH PRIVILEGES;
- SET PASSWORD FOR ‘root’@‘localhost’ = PASSWORD(‘123’);
- 密码就是123
三、安全常用语句
- RIGHT,LEFT截取固定长度字符串
SELECT RIGHT(name,4) FROM apple;
- SUBSTRING_INDEX 截取条件之前的字符串
SELECT SUBSTRING_INDEX(tasted,',',1) FROM apple;
如果没有‘,’出现,就会返回所有字符串
1:指第一个逗号之前的所有内容
- 截取一定长度的字符串
SUBSRING (your_string,start_location,length)
- 改变整组字符串的大小写
UPPER(your_string) LOWER(your_string)
SELECT UPPER(name)FROM apple;
- rtrim() 函数
返回去除右边空格后的字符串
SELECT UPPER(rtrim(name))FROM apple;
ltrim() 函数
返回去除右边空格后的字符串
- 按一定顺序返回表中数据
SELECT film_name,grade
FROM movie_table
WHERE category=’family’
ORDER BY title,purchased,……;
- DESC反转查询结果顺序
用于ORDER BY 子句中的列名后,用来反转查询结果的顺序- ASC默认排序
与DESC放置位置相同
- ASC默认排序
- 返回所要求列中值不同的一列
DISTINCT关键字
mysql> SELECT DISTINCT(score)FROM apple;
- 待续