mysql
mldxs
android
足球
java
篮球
魔兽
展开
-
解决 Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair
MYSQL数据表出现问题,提示:Error: Table './db_name/table_name' is marked as crashed and last (automatic?) repair failed修复数据表操作:1、service mysqld stop;2、cd /var/lib/mysql/db_name/3、myisamchk -r tablena转载 2013-03-20 15:47:48 · 2843 阅读 · 0 评论 -
linux shell下执行mysql脚本
mysql -uroot -p123456 < table原创 2013-01-08 16:00:46 · 678 阅读 · 0 评论 -
mysql 设置utf8
[client]default-character-set=utf8[mysql]default-character-set=utf8[mysqld]collation-server = utf8_unicode_ciinit-connect='SET NAMES utf8'character-set-server = utf8原创 2013-07-19 23:22:45 · 1004 阅读 · 0 评论 -
mysql设置root密码
http://www.linuxidc.com/Linux/2009-10/22006.htm方法一:最简单的方法,也是安装完mysql后,系统提示的方法。使用mysqladmin来完成。shell> mysqladmin -u root password "newpwd"shell> mysqladmin -u root -h host_name password "newp转载 2013-06-27 10:08:07 · 845 阅读 · 0 评论 -
SQL重复记录查询
http://blog.csdn.net/chinmo/article/details/21840201、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select * fromselect * from peoplewhere peopleId in (select peopleId from people group by p转载 2013-06-27 10:06:51 · 564 阅读 · 0 评论 -
ubuntu 下设置mysql字符集为utf-8
修改/etc/mysql/my.conf下[mysqld] [client] 下加入default-character-set=utf8重启mysql服务 /etc/inti.d/mysqk restartOK原创 2012-11-28 13:04:41 · 749 阅读 · 0 评论 -
如何修改mysql的root密码
用UPDATE直接编辑user表 mysql -u root mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';原创 2012-12-28 13:48:15 · 402 阅读 · 0 评论 -
ubuntu下彻底删除mysql【装】
在Ubuntu下配置mysql一直出错,决定彻底卸载mysql,再重新安装,参考下面文章的方法,成功http://www.blogjava.net/yjhmily/articles/336926.html1、删除 mysql1 sudo apt-get autoremove --purge mysql-server-5.02 sudo apt-get remove mysq转载 2013-01-05 17:38:21 · 907 阅读 · 1 评论 -
mysql 连接外部服务的方法 例如sqlyog
进入mysqlgrant all privileges on *.* to 'username'@'%' identified by 'password';flush privileges;退出mysql修改mysql的配置文件 /etc/mysql/my.cnf 将 bind-address = 127.0.0原创 2013-01-24 13:24:20 · 1016 阅读 · 0 评论 -
sql随机返回一条数据
http://stackoverflow.com/questions/580639/how-to-randomly-select-rows-in-sqlsqlite:SELECT * FROM data ORDER BY RANDOM() LIMIT 1;Select a random row with MySQL:SELECT column FROM table转载 2015-01-23 11:36:23 · 5242 阅读 · 1 评论