mysql
曲艳行
这个作者很懒,什么都没留下…
展开
-
Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘ (2)
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)原创 2023-02-07 11:44:06 · 411 阅读 · 0 评论 -
mysql导出数据到excel
导出mysql某张表数据到excel mysql -h 127.0.0.1 -P 3306 -u 用户名 -p 数据库名 -e "select * from 表名 " >/home/quyanhang/Documents/my.xls (导出目录及文件名) 示例: mysql -h 127.0.0.1 -P 3306 -u root -p weichat -e "select * from tenant " >/home/quyanhang/Documents/my.xls ...原创 2021-07-16 20:35:01 · 231 阅读 · 0 评论 -
mysql-删除语句
删除语句: 1-删除表 DROP TABLE tablename; 2-删除表中全部数据 TRUNCATE TABLE tablename; DELETE FROM tablename; 3-删除指定数据 DELETE FROM tablename WHERE 条件; delete和truncate区别: 1-delete可恢复,truncate不可恢复 2-truncate更快 3-delete返回删除行数,truncate返回0,-1 成功/失败 ...原创 2021-04-09 16:06:58 · 2612 阅读 · 0 评论 -
mysql常用
索引: 查看索引: show index from tablename; show keys from tablename; 查看建表语句: show create table tablename;原创 2021-04-08 15:51:59 · 87 阅读 · 0 评论