个人站点： macrotea.cn/nav

[code="sql"]#始:广州 经:长沙SELECT AutoID,tb_train_transfer.`ScheduleID`,(Distance-EndGap) as length FROM `tb_train_schedule` INNER JOIN tb_train_transfer on tb_train_schedule.`AutoID`=tb_train_transfer.`...

#1:硬座价格,#0软座价格select case when 1=0 then HardSeatPrice else SoftSeatPrice end from tb_train_schedulewhere StartStationID=(select id from tb_train_station where name like "%广州%")and EndStationID=(...

http://www.sqlmanager.net/en/products/mysql/manager/download http://download.youkuaiyun.com/down/2211509/ojwftded 界面是2005的

ADDALLALTERANALYZEANDASASCASENSITIVEBEFOREBETWEENBIGINTBINARYBLOBBOTHBYCALLCASCADECASECHANGECHARCHARACTERCHECKCOLLATECOLUMNCONDITION...

1.在如下文件:D:\Program Files\MySQL\MySQL Server 5.0\my.ini找到如下项:[mysqld]然后添加:log-slow-queries=/data/mysqldata/slowquery.loglong_query_time=22.重启服务,查看mysql> show variables like 'long%';...

mysql数据导入与导出在本机写好代码了要转移到其他计算机上去了下面讲一下如何进行mysql数据导入与导出运行--CMD--cd C:\Program Files\MySQL\MySQL Server 5.0\bin---mysqldump.exe -u root(用户名) -p db_schoolMaster（数据库名）>db_sch...

/*有问题:*/select AutoID from tb_train_station where Name like '%?%')/*OK:*/select AutoID from tb_train_station where Name like concat('%',?,'%')) 

连接两个数据表的用法：FROM 表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号连接三个数据表的用法：FROM (表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) INNER JOIN 表3 ON 表1.字段号=表3.字段号连接四个数据表的用法：FROM ((表1 INNER JOIN 表2 ON 表1.字段号=表2.字段号) IN...

 附件 

1. mysql 5.5 可能和别的版本的在my.ini配置中的关键字可能不同2.如何发现关键字mysql> show variables like '%log%';结果:| log_slow_queries                        ON| slow_query_log                         ...