GGGL的专栏

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

mysql -uroot -p123456 < table

[client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] collation-server = utf8_unicode_ci init-connect='SET NAMES utf8' character-set-server = utf8

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

http://blog.youkuaiyun.com/chinmo/article/details/2184020 1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 select * from select * from people where peopleId in (select   peopleId  from   people  group  by   p

修改/etc/mysql/my.conf 下[mysqld]  [client]  下加入default-character-set=utf8 重启mysql服务    /etc/inti.d/mysqk restart OK

用UPDATE直接编辑user表 　　mysql -u root 　　mysql> use mysql; 　　mysql> UPDATE user SET Password = PASSWORD('123456') WHERE user = 'root';

在Ubuntu下配置mysql一直出错，决定彻底卸载mysql，再重新安装，参考下面文章的方法，成功 http://www.blogjava.net/yjhmily/articles/336926.html 1、删除 mysql 1 sudo apt-get autoremove --purge mysql-server-5.0 2 sudo apt-get remove mysq

进入mysql grant all privileges on *.* to 'username'@'%' identified by 'password'; flush privileges; 退出mysql 修改mysql的配置文件 /etc/mysql/my.cnf   将 bind-address           = 127.0.0

http://stackoverflow.com/questions/580639/how-to-randomly-select-rows-in-sql sqlite： SELECT * FROM data ORDER BY RANDOM() LIMIT 1; Select a random row with MySQL: SELECT column FROM table