【原创】 linux-mysql p…

drop PROCEDURE sp_test;

DELIMITER $$

CREATE PROCEDURE sp_test()

begin

    declare o longtext;

    declare t longtext;

    set @o_tr='';

    set @t_tr='';

    set @t = replace(substring(date(now()),1,7),'-','');

    set @tb1 = concat("CREATE TABLE IF NOT EXISTS `once", @t, "` (   `id` char(32) NOT NULL,   `station_id` int(11) DEFAULT NULL,   `artist_id` int(11) DEFAULT NULL,   `song_id` int(11) DEFAULT NULL,   `time` datetime DEFAULT NULL,   `pad_id` int(11) DEFAULT NULL,   PRIMARY KEY (`id`),   KEY `station_id` (`station_id`),   KEY `artist_id` (`artist_id`),   KEY `song_id` (`song_id`),   CONSTRAINT `once", @t, "_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `Station` (`iD`),   CONSTRAINT `once", @t, "_ibfk_2` FOREIGN KEY (`artist_id`) REFERENCES `Artists` (`ID`),   CONSTRAINT `once", @t, "_ibfk_3` FOREIGN KEY (`song_id`) REFERENCES `Songs` (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");

    PREPARE stmt from @tb1;

    EXECUTE stmt;

    set @tb2 = concat("CREATE TABLE IF NOT EXISTS `time", @t, "` (   `id` char(32) NOT NULL,   `station_id` int(11) DEFAULT NULL,   `artist_id` int(11) DEFAULT NULL,   `song_id` int(11) DEFAULT NULL,   `once_id` int(11) DEFAULT NULL,   `time` datetime DEFAULT NULL,   `itime` datetime NOT NULL,   PRIMARY KEY (`id`),   KEY `station_id` (`station_id`),   KEY `artist_id` (`artist_id`),   KEY `song_id` (`song_id`),   KEY `once_id` (`once_id`),   CONSTRAINT `time", @t, "_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `Station` (`ID`),   CONSTRAINT `time", @t, "_ibfk_2` FOREIGN KEY (`artist_id`) REFERENCES `Artists` (`ID`),   CONSTRAINT `time", @t, "_ibfk_3` FOREIGN KEY (`song_id`) REFERENCES `Songs` (`ID`),   CONSTRAINT `time", @t, "_ibfk_4` FOREIGN KEY (`once_id`) REFERENCES `once", @t, "` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");

    PREPARE stmt from @tb2;

    EXECUTE stmt;

    set @tr = concat('before_insert_once', @t);

    set @s = concat("SELECT TRIGGER_NAME INTO @o_tr FROM information_schema.triggers WHERE TRIGGER_SCHEMA = 'DB_Music' AND TRIGGER_NAME = '", @tr,"';");

    PREPARE stmt from @s;

    EXECUTE stmt;

    if length(@o_tr) =0 then

        set @dr_on = concat("DROP TRIGGER IF EXISTS ", @tr);

        set @tr_on = concat("CREATE TRIGGER before_insert_once", @t, "   BEFORE INSERT ON once", @t, "   FOR EACH ROW   SET NEW.`ID` = replace(uuid(),'-','');");

        select reverse(substr(reverse(trim(replace(group_concat(' (select * from ',table_name, ') union'),',',''))),6)) into o FROM information_schema.tables WHERE table_schema = 'DB_Music' and table_name like 'once2%';

        set @o = concat("create or replace view onces as",o);

        PREPARE stmt from @o;

        EXECUTE stmt;

    end if;

    set @tr = concat('before_insert_time', @t);

    set @s = concat("SELECT TRIGGER_NAME INTO @t_tr FROM information_schema.triggers WHERE TRIGGER_SCHEMA = 'DB_Music' AND TRIGGER_NAME = '", @tr,"';");

    PREPARE stmt from @s;

    EXECUTE stmt;

    if length(@t_tr) = 0 then

        set @dr_ti = concat("DROP TRIGGER IF EXISTS ", @tr);

        set @tr_ti = concat("CREATE TRIGGER before_insert_time", @t, "   BEFORE INSERT ON time", @t, "   FOR EACH ROW   SET NEW.`ID` = replace(uuid(),'-','');");

        select reverse(substr(reverse(trim(replace(group_concat(' (select * from ',table_name, ') union'),',',''))),6)) into t FROM information_schema.tables WHERE table_schema = 'DB_Music' and table_name like 'time2%';

        set @t = concat("create or replace view times as",t);

        PREPARE stmt from @t;

        EXECUTE stmt;

        select @dr_on as dr_on, @tr_on as tr_on, @dr_ti as dr_ti, @tr_ti as tr_ti;

    end if;

end$$

call sp_test();\g

#!/usr/bin/python

#-*- coding: utf-8 -*-

import MySQLdb

import datetime

SPLIT = ['，',',','&',' ','、','\\','/',';','@','＠','：','

class Main():

    def __init__(self, splits = ''):

        try:

            self.splits = splits if splits else SPLIT

            self.conn=MySQLdb.connect(host='localhost',user='root',passwd='123',port=3306,db='DB_Music',charset='utf8')

            #conn.set_character_set('utf8')

        except MySQLdb.Error,e:

            print e.args

    def main(self):

        #sql = "CREATE TRIGGER before_insert_once201404   BEFORE INSERT ON once201404   FOR EACH ROW   SET NEW.`ID` = replace(uuid(),'-','');"

        sql = 'call sp_test();'

        result = self.sql(sql)

        for i in result:

            for j in i:

                r = i[j]

                if r:

                    print r

                    self.sql(i[j])

    def sql(self, sql = "select 'ok'"):

        cur = self.conn.cursor(MySQLdb.cursors.DictCursor)

        a = cur.execute(sql)

        r = cur.fetchall()

        cur.close()

        return list(r)

if __name__ == '__main__':

    Main().main()

下面是所有参考的网址，暂时保存下来 - - 

下午4:24 MySQL :: MySQL 5.7 Reference Manual :: 13.5 SQL Syntax for Prepared Statements dev.mysql.com

下午4:21 Triggers and Stored Procedures docs.oracle.com

下午4:21 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0CGcQFjAF&url=http://docs.oracle.com/cd/E12151_01/doc.150/e12155/triggers_proc_mysql.htm&ei=0yVWU8a3Asa4iQec6oDYDg&usg=AFQjCNFm3YcyEZRHIMm7dAH3 dvrMMXcmWQ&sig2=KNqqTm2mrXt1_4gqNJoWrg www.google.com.hk

下午4:19 MySQL :: MySQL 5.6 Reference Manual :: 13.5 SQL Syntax for Prepared Statements dev.mysql.com

下午4:18 MYSQL : How to create trigger from store procedure - Stack Overflow stackoverflow.com

下午4:18 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDQQFjAB&url=http://stackoverflow.com/questions/19046862/mysql-how-to-create-trigger-from-store-procedure&ei=0yVWU8a3Asa4iQec6oDYDg&usg=AFQjCNE6PQEsnfJQiEEn51Bc r0l0MPnc_Q&sig2=bzFt7YYCGFTDSYDQ1ybv1Q www.google.com.hk

下午4:18 Create a trigger with a stored procedure in MySQL - Stack Overflow stackoverflow.com

下午4:18 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=http://stackoverflow.com/questions/7485469/create-a-trigger-with-a-stored-procedure-in-mysql&ei=0yVWU8a3Asa4iQec6oDYDg&usg=AFQjCNFCffwTR5E2atSTNh-i-NB-Ox-XwA&sig2=OyV_mMTMjfT6zyh--FtQuQ www.google.com.hk

下午4:18 mysql create trigger in procedure - Google 搜索 www.google.com.hk

下午4:15 mysql - Call a stored procedure from a trigger - Database Administrators Stack Exchange dba.stackexchange.com

下午4:15 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=http://dba.stackexchange.com/questions/10657/call-a-stored-procedure-from-a-trigger&ei=RiVWU56PO4K1iQftkYG4DA&usg=AFQjCNHppklIW0HHmR-WUZa4jSlpUyeWxA&sig2=X3l1kJR4KwdSGF8pgCMD_Q www.google.com.hk

下午4:15 mysql procedure create trigger - Google 搜索 www.google.com.hk

下午4:14 error: This command is not supported in the prepared statement protocol yet-CSDN论坛-CSDN.NET-中国最大的IT技术社区 bbs.csdn.net

下午4:14 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=10&ved=0CI0BEBYwCQ&url=http://bbs.csdn.net/topics/360106374&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNGJAmxy6y15AHYhDanU E80CCMXsBg&sig2=ZXsj0bzxzp2Zj60TQpJXng www.google.com.hk

下午4:13 MySQL Bugs: #18971: drop trigger with prepare and execute statement inside stored procedure bugs.mysql.com

下午4:12 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=http://bugs.mysql.com/18971&ei=cCRWU9r0DKbBiQeYhIHACg&usg=AFQjCNG2cv3H9S0h3RfSRPR-9t_Hnt_RJQ&sig2=bxg-y7e01hl03r_MGEYOUQ www.google.com.hk

下午4:12 PREPARE stmt from 'DROP TRIGGER IF - Google 搜索 www.google.com.hk

下午4:12 ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet www.mysqlfaqs.net

下午4:12 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=8&ved=0CHcQFjAH&url=http://www.mysqlfaqs.net/mysql-faqs/Errors/ERROR-1295-(HY000):-This-command-is-not-supported-in-the-prepared-statement-protocol-yet&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNHXqmJ8VpHrS6stYxAb -i2l_IOl1A&sig2=dCsxt-eBe5dnUkntMnR4zQ www.google.com.hk

下午4:12 Error Codes: MySQL Error 1295 - SQLSTATE: HY000 (ER_UNSUPPORTED_PS) This command is not supported in the prepared statement protocol yet www.briandunning.com

下午4:12 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0CG0QFjAG&url=http://www.briandunning.com/errors/562&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNFxmkqCUAIDShhW3I65 OFmZzATdXw&sig2=BRmevOhWdmvUlovFSKRF8w www.google.com.hk

下午4:08 Roland Bouman's blog: MySQL 5: Prepared statement syntax and Dynamic SQL webcache.googleusercontent.com

下午4:08 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0CGUQIDAF&url=http://webcache.googleusercontent.com/search?q=cache:CZtadDCmML8J:rpbouman.blogspot.com/2005/11/mysql-5-prepared-statement-syntax-and.html+&cd=6&hl=zh-CN&ct=clnk&gl=cn&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNFiHq5yR9iAu6Oom-EErFo7yNcZmQ&sig2=xdAkB1_78KK9itMiKO_6Bw www.google.com.hk

下午4:08 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0CGIQFjAF&url=http://rpbouman.blogspot.com/2005/11/mysql-5-prepared-statement-syntax-and.html&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNG9OrYNGVo-IefMO9Mu_nS3m_P2AQ&sig2=dDZ3MzADwTaHbQywKlQQiA www.google.com.hk

下午4:01 Google Translate translate.google.cn

下午4:01 Google Translate translate.google.cn

下午4:01 mysql - Dynamic table name & LOAD DATA INFILE - Stack Overflow stackoverflow.com

下午4:01 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&ved=0CE0QFjAD&url=http://stackoverflow.com/questions/16573176/dynamic-table-name-load-data-infile&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNEnif0-pVsO614XfrK_4WnPKcw2ZA&sig2=Mz19fTsUCZFciuKk4SkncA www.google.com.hk

下午4:00 PREPARE statement - MariaDB Knowledgebase mariadb.com

下午4:00 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=0CEQQFjAC&url=https://mariadb.com/kb/v/prepare-statement/&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNEaUwOQk7y4yyXvJP_BFLCXZgRE8w&sig2=abNHGFXygqwi6mrjOoJebg www.google.com.hk

下午4:00 mysql的预处理语句| MacLochlainns博客 blog.mclaughlinsoftware.com

下午4:00 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=http://blog.mclaughlinsoftware.com/tag/mysql-prepared-statements/&ei=nSFWU4b1DeeTiQfjoIGICw&usg=AFQjCNFbpsqEM_d0bTJ24w8GSzaZ65kZpw&sig2=FuIR1e06loetljo0EzBjig www.google.com.hk

下午4:00 ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet - Google 搜索 www.google.com.hk

下午3:48 ERROR 1235 (42000): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' - Google 搜索 www.google.com.hk

下午3:41 MySQL :: MySQL 5.0 Reference Manual :: 13.1.18 DROP TRIGGER Syntax dev.mysql.com

下午3:40 MySQL :: MySQL 5.0 Reference Manual :: 13.1.11 CREATE TRIGGER Syntax dev.mysql.com

下午3:40 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=https://dev.mysql.com/doc/refman/5.0/en/create-trigger.html&ei=6RxWU6r_K9GjiAfhgYGwDQ&usg=AFQjCNEGb3go5BTq_4WOSArxvOgseeW9kw&sig2=1FtiT17izbcAN1-H0HLvuA www.google.com.hk

下午3:40 mysql create trigger or replace - Google 搜索 www.google.com.hk

下午3:39 create trigger or replace - Google 搜索 www.google.com.hk

下午3:28 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=http://blog.mclaughlinsoftware.com/tag/mysql-prepared-statements/&ei=DRpWU-frA6m5iQfK4IC4Aw&usg=AFQjCNFbpsqEM_d0bTJ24w8GSzaZ65kZpw&sig2=OTvJhLrmg18peyh8fFQb7w www.google.com.hk

下午3:27 ERROR 1295 (HY000): This command is not supported in the prepared statement protocol yet - Google 搜索 www.google.com.hk

下午3:19 MySQL :: MySQL 5.0 Reference Manual :: 13.1.12 CREATE VIEW Syntax dev.mysql.com

下午3:19 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=http://dev.mysql.com/doc/refman/5.0/en/create-view.html&ei=xRdWU8KWHuSpiAfM8IAI&usg=AFQjCNEzvNmu6gwTHkkRXPws mRqn1gPOgw&sig2=piENzOe8N3JFHXanxtLZkQ www.google.com.hk

下午3:18 无法访问 http://www.w3schools.com/sql/sql_view.asp www.w3schools.com

下午3:18 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDkQFjAB&url=http://www.w3schools.com/sql/sql_view.asp&ei=xRdWU8KWHuSpiAfM8IAI&usg=AFQjCNHrssxULL4B7dLOeyfA amuY9K1bAQ&sig2=MmUqlcTjqspENz5W7poRng www.google.com.hk

下午3:18 mysql create view or replace - Google 搜索 www.google.com.hk

下午2:57 SELECT INTO Variable in MySQL DECLARE causes syntax error? - Stack Overflow stackoverflow.com

下午2:57 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=http://stackoverflow.com/questions/3075147/select-into-variable-in-mysql-declare-causes-syntax-error&ei=xRJWU4jbKLCyiQfj8oFo&usg=AFQjCNFIpaCmM76ghlWlVEal PgittQPoZA&sig2=VkkdEFJoxmxkJpVFDkCT-g www.google.com.hk

下午2:56 mysql declare select into - Google 搜索 www.google.com.hk

下午2:45 MySQL :: MySQL 5.0 Reference Manual :: 12.5 String Functions dev.mysql.com

下午2:45 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=http://dev.mysql.com/doc/refman/5.0/en/string-functions.html&ei=Zw5WU4DaEsHtiAeYuYCIBg&usg=AFQjCNE2fDzP220Nnis3MBJl XpURGY0ajw&sig2=25MFNGyNohHHXE47qRheSQ www.google.com.hk

下午2:39 MySQL TRIM() function - w3resource www.w3resource.com

下午2:39 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDcQFjAB&url=http://www.w3resource.com/mysql/string-functions/mysql-trim-function.php&ei=Zw5WU4DaEsHtiAeYuYCIBg&usg=AFQjCNHGUF1eWJ9xP0EiVOGz zRp3MTJRqQ&sig2=TyDaDHjJjYBy2vYuCw2XbA www.google.com.hk

下午2:38 mysql strip - Google 搜索 www.google.com.hk

下午2:28 mysql group_concat - Google 搜索 www.google.com.hk

下午2:27 MySQL的 - 显示表像'年％'> = 2010 - 堆栈溢出 stackoverflow.com

下午2:21 mysql - How to SELECT from SHOW TABLE STATUS results - Database Administrators Stack Exchange dba.stackexchange.com

下午2:21 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0CGQQFjAF&url=http://dba.stackexchange.com/questions/3221/how-to-select-from-show-table-status-results&ei=UQpWU478A5a58gXtgYIo&usg=AFQjCNEaAGuEiUIv9IZdb4cA kBuUt2c5kA&sig2=-y1GCQG1FMbAGxL9N_-Vcw www.google.com.hk

下午2:21 完全解析MySQL数据库中Show命令用法:show tables like "%Tbl_User%"; - 向东博客 专注WEB应用 构架之美 --- 构架之美，在于尽态极妍 | 应用之美，在于药到病除 - Life is Short,Play it More,So Playin' with IT,Focus on Killer Application,Marketing Meets Technology.︻┳═一 Ζ〧φ﹀ヘ - www.justwinit.cn

下午2:21 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=5&ved=0CFsQFjAE&url=http://www.justwinit.cn/post/3665/&ei=UQpWU478A5a58gXtgYIo&usg=AFQjCNEcJfgQRWMbkc6u3VFh RBUPruR_Bw&sig2=3FphTO-Rq2Zzi9cA2tuiDQ www.google.com.hk

下午2:20 mysql select table like - Google 搜索 www.google.com.hk

下午2:08 MySQL :: MySQL 5.1参考手册 :: 20. 存储程序和函数 dev.mysql.com

下午2:08 MySQL :: MySQL 5.1参考手册 :: 20. 存储程序和函数 dev.mysql.com

下午2:08 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDYQFjAB&url=http://dev.mysql.com/doc/refman/5.1/zh/stored-procedures.html&ei=bgdWU5yzJ8eOiAfCjYDQAQ&usg=AFQjCNGf7Qgzj96hmpr0-ID2uj9sQKvr0g&sig2=EsY0fC4tcv8OxRbq6wG00w www.google.com.hk

下午2:08 mysql proc declare - Google 搜索 www.google.com.hk

下午2:05 How does MySQL return a result set from a stored procedure? - Database Administrators Stack Exchange dba.stackexchange.com

下午2:05 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=http://dba.stackexchange.com/questions/8291/how-does-mysql-return-a-result-set-from-a-stored-procedure&ei=zQZWU7WXIaObigebyoDICA&usg=AFQjCNFpL3DvUoqPrVNtPIFJ kNHMRCU0wQ&sig2=aJpSZaFu84Ntr9UnPXya_w www.google.com.hk

下午2:05 mysql proc get select result - Google 搜索 www.google.com.hk

下午2:05 sql server 2012 - How to get results of stored procedure #1 into a temporary table in stored procedure #2 - Stack Overflow stackoverflow.com

下午2:05 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CDQQFjAB&url=http://stackoverflow.com/questions/14294311/how-to-get-results-of-stored-procedure-1-into-a-temporary-table-in-stored-proce&ei=kgZWU4HFCJCkiAfkwYCQBg&usg=AFQjCNF97tI0Uc3dXD505R1R 7OlrvuGumA&sig2=GDKxaebH7UMNKXAhAzVmsA www.google.com.hk

下午2:04 PROCEDURE get show table like result - Google 搜索 www.google.com.hk

下午2:02 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=http://stackoverflow.com/questions/10675987/show-tables-like-year-2010&ei=8AVWU7fnLcK5iQeppIGoDw&usg=AFQjCNGQYoZ4I8k6Roe_Uq1ONG5hDnekSg&sig2=1BjFqVAZ391BEjK8489aGg www.google.com.hk

下午2:02 show table like in mysql to string - Google 搜索 www.google.com.hk

下午2:01 MySQL :: MySQL 5.0 Reference Manual :: 13.7.5.34 SHOW TABLES Syntax dev.mysql.com

下午2:01 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=https://dev.mysql.com/doc/refman/5.0/en/show-tables.html&ei=uAVWU4nvM8bsiAediYGgCg&usg=AFQjCNGKI7WtqzxdqVXCnthH NNDrTS_KZA&sig2=XNu9pnBIRWQ6cisljVSZUQ www.google.com.hk

下午2:01 show table like in mysql - Google 搜索 www.google.com.hk

下午2:00 show table like group by name - Google 搜索 www.google.com.hk

下午1:59 mysql set global variable - Google 搜索 www.google.com.hk

下午1:59 mysql set @ - Google 搜索 www.google.com.hk

下午1:59 mysql set - Google 搜索 www.google.com.hk

下午1:58 SQL问题：怎样将两列值相加的结果输出的相关推荐_ITPUB论坛 www.itpub.net

下午1:58 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=9&ved=0CHQQFjAI&url=http://www.itpub.net/zhuanti/1078/mysqlsqljiangliangliezhi lianjie_1078984.shtml&ei=9gRWU5WEBsTkiAf_gIGYDA&usg=AFQjCNEXGhWjpFrsTESOvt4W mxkj3zNYNg&sig2=QbhZmEm8zs94LiDvnmsQbA www.google.com.hk

下午1:57 mysql set 两列值 - Google 搜索 www.google.com.hk

下午1:55 show tables like - Google 搜索 www.google.com.hk

下午1:55 show create view - Google 搜索 www.google.com.hk

下午1:53 用select语句来代替show create table来显示表结构 - 也就这样， type.so

下午1:53 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0CGAQFjAG&url=http://type.so/sql/use-select-instead-of-show-create-table.html&ei=1gNWU8z1D4XOiAfMtIHQAg&usg=AFQjCNFWjAVDtxNXd2_xMMLfK74wOVI4wg&sig2=rQYcXzF2hFM8hQOV_ndYsw www.google.com.hk

下午1:53 SHOW CREATE TABLE取出的语句-RogerZhuo-ChinaUnix博客 blog.chinaunix.net

下午1:53 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=5&ved=0CE4QFjAE&url=http://blog.chinaunix.net/uid-26364035-id-3172112.html&ei=1gNWU8z1D4XOiAfMtIHQAg&usg=AFQjCNFLULU0QhuJaKzjSN_m3eHKMjeOpA&sig2=D9WuokOHiKm4NeLiWbFj6w www.google.com.hk

下午1:53 show create where - Google 搜索 www.google.com.hk

下午1:47 mysql 多表合并查询 - zygzzp的专栏 - 博客频道 - CSDN.NET blog.csdn.net

下午1:47 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=0CD0QFjAB&url=http://blog.csdn.net/zygzzp/article/details/21236961&ei=ewJWU_-CMIPq8AX5yILgDg&usg=AFQjCNFdQ_qTPoJ4alDw6Pb_UPT72K-6gw&sig2=8fUBPIAqUXrkHFLP1JLfEw www.google.com.hk

下午1:47 mysql 两表合并 - Google 搜索 www.google.com.hk

下午1:37 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCwQFjAA&url=http://dev.mysql.com/doc/refman/5.0/en/create-view.html&ei=CwBWU_GxO87QiAfw-YHgBw&usg=AFQjCNEzvNmu6gwTHkkRXPws mRqn1gPOgw&sig2=VbOkX8asR-g5wUWH8Noz1A www.google.com.hk

下午1:37 mysql view if not exists - Google 搜索 www.google.com.hk

下午1:30 我的广播_腾讯微博 t.qq.com

下午1:23 http://s.share.baidu.com/?url=http://fm.baidu.com/#/play/259218/share/tqq&uid=41163&to=tqq&type=text&pic=http://c.hiphotos.baidu.com/ting/pic/item/503d269759ee3d6d64f2b3ea 41166d224f4adede.jpg&title=推荐 ♪沙宝亮 的《暗香》(来自 私人频道)&desc=&sign=off&searchPic=0&key=2239739986 s.share.baidu.com

下午12:04 百度随心听 fm.baidu.com

上午11:08 Mysql中sql语句获得当前时间的long值.(毫秒值)_胆大的人，前面才有路！_百度空间 hi.baidu.com

上午11:08 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=6&ved=0CFMQFjAF&url=http://hi.baidu.com/zhang_zhu_1/item/79d1208076c91affe496e09d &ei=m9xVU9mjA7CeiAfz1ICQCA&usg=AFQjCNHgiClCXdKYefQfJRno 2PvDS9SZpg&sig2=xk6jEa2-F_oipoDkkIEotA www.google.com.hk

上午11:06 mysql 如何获得毫秒数 - MySQL - 网站开发技术 s.yanghao.org

上午11:06 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&ved=0CDoQFjAC&url=http://s.yanghao.org/program/viewdetail.php?i=121816&ei=m9xVU9mjA7CeiAfz1ICQCA&usg=AFQjCNFcESHGCI0ujKUztRnn A5_ZFBuLqA&sig2=w-TxURkeH-p0i-YWx5MjqQ www.google.com.hk

上午11:05 mysql毫秒 - Google 搜索 www.google.com.hk

上午11:02 MySQL :: MySQL 5.5 Reference Manual :: 12.7 Date and Time Functions dev.mysql.com

上午11:01 How to convert MySQL time to UNIX timestamp using PHP? - Stack Overflow stackoverflow.com

上午11:01 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0CCkQFjAA&url=http://stackoverflow.com/questions/4577794/how-to-convert-mysql-time-to-unix-timestamp-using-php&ei=pNtVU-vbJsTJiAe5g4G4Cg&usg=AFQjCNH0QWmAlNw6GdAuU4VX xcItlUC0Bg&sig2=bs4WyGiSKvvw_p5tAio3lQ www.google.com.hk

上午11:01 mysql time to unix time - Google 搜索 www.google.com.hk

上午11:00 Mysql中时间戳，如何将int转换为datetime? 大家帮帮忙-CSDN论坛-CSDN.NET-中国最大的IT技术社区 bbs.csdn.net

上午11:00 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=7&ved=0CGoQFjAG&url=http://bbs.csdn.net/topics/270054503&ei=jdpVU6HnDIiaiAffrYDgBg&usg=AFQjCNF88zkMfYva3DHqvfWD TrELMdUsWQ&sig2=8pE_56r9rMp--u9pChxOvw www.google.com.hk

上午10:57 [MySQL优化案例]系列 -- 用TIMESTAMP类型取代INT和DATETIME | MySQL 中文网 imysql.cn

上午10:57 MySql用int存储时间 - jezz - ITeye技术网站 lijie250.iteye.com

上午10:57 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=4&ved=0CEsQFjAD&url=http://lijie250.iteye.com/blog/250322&ei=jdpVU6HnDIiaiAffrYDgBg&usg=AFQjCNGzL307ZVII7Dh6qz3u T6grB-cglw&sig2=uIXeE60JqL0HrrmBKWhU0w www.google.com.hk

上午10:57 mysql time to int - Google 搜索 www.google.com.hk

上午10:56 Mysql时间字段格式如何选择，TIMESTAMP，DATETIME，INT？ - SegmentFault segmentfault.com

上午10:56 https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=9&ved=0CHgQFjAI&url=http://segmentfault.com/q/1010000000121702&ei=CNpVU5WXCqOXigeVqYDQDg&usg=AFQjCNGIKMqPjt8HQS4wTxk4 8VWqF8GkQA&sig2=9tZOShdT8C-Ojln_skNicQ www.google.com.hk

上午10:54 MySQL :: MySQL 5.1参考手册 :: 11. 列类型 dev.mysql.com

上午10:54 mysql 时间戳类型 - Google 搜索 www.google.com.hk