RobinWu

http://forum.slime.com.tw/thread208827.html aroot@agideo-desktop:~# mysql -uroot -pEnter password: Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 11Server v...

Mysql 字符串按拼音排序[code="mysql"] SELECT * FROM table_name ORDER BY CONVERT(FieldName USING GBK) ASC[/code]

[url]http://forum.ubuntu.org.cn/viewtopic.php?f=54&t=22321&view=previous[/url]/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through soc...

[code="sql"]select @@sql_mode;CREATE TABLE `t` ( `name` varchar(20), `email` varchar(40));desc t;set session sql_mode="REAL_AS_FLOAT,PIPES_AS_CONCAT,ANSI_QUOTES,IGNORE_SPACE,ANSI";...

Mysql 存储引擎对比图[img]http://www.iteye.com/upload/attachment/68079/00702d91-844c-360f-8a14-7890378b09eb-thumb.png[/img]

[code="sql"]show variables;[/code][code="sql"]+---------------------------------+--------------------------------- ------+| Variable_name | Value ...

登录 [code="sql"]mysql -u -pmysql --default-character-set=utf8 -u -p[/code]查看数据库的数据类型[code="java"]SELECT * FROM information_schema.SCHEMATA where schema_name = "schemaname";[/code]查看数据表的...

前提master server ip 192.168.1.131 ubuntuslave server ip 192.168.1.104 win2003Master server[code="java"]grant REPLICATION SLAVE on . to ‘slave_server’@’192.168.1.104’ identified by ‘12345678’;...

sql 代码 CREATE TABLE `customers` (      `id` int(11) NOT NULL auto_increment,      `name` varchar(255) default NULL,      `full_name` varchar(255) default NULL,      `bank_accoun...

[code="mysql"]SELECT CAST( SUM( CASE orders.currency WHEN 'EUR' THEN ((orders.unit_price * assignings.quantity) * 1.4) WHEN 'CNY' THEN ((orders.unit_price * assignin...