MySQL數(shù)據(jù)庫技巧增、刪、改、查

    MySQL數(shù)據(jù)庫技巧基礎(chǔ)操作：增、刪、改、查，具體sql語句如下：
    import console;
    import mysql.client;
    console.log("正在連接數(shù)據(jù)庫服務(wù)器...");
    var mysqlDb,err = mysql.client(
    server = "localhost"; //數(shù)據(jù)庫服務(wù)器,可省略默認(rèn)為localhost
    uid = "root";//用戶名,可省略默認(rèn)為root
    pwd = "用戶密碼";
    );
    if(!mysqlDb){
    console.log("連接數(shù)據(jù)庫失敗",err)
    return;
    }
    //如果數(shù)據(jù)庫不存在創(chuàng)建數(shù)據(jù)庫，并自動選擇數(shù)據(jù)庫
    mysqlDb.createDb("testAAutoMySqlClient")
    sql = /*
    CREATE TABLE `library` (
    `name` varchar(100) NOT NULL,
    `auditing` tinyint(1) DEFAULT '0',
    `bytes` BLOB,
    PRIMARY KEY (`name`),
    UNIQUE KEY `name` (`name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    */
    mysqlDb.exec(sql);//執(zhí)行SQL語句
    var ret,err = mysqlDb.listTables()
    for tbl in ret.each(){
    console.log("發(fā)現(xiàn)數(shù)據(jù)表:",tbl);
    }
    //增 - 使用命名參數(shù)
    mysqlDb.exec("REPLACE INTO `library` values('名字1',@num,@str)
    ,('名字2',@num,@str)
    ,('名字3',@num,@str)
    ", {
    num = 123;
    str = "測試:'這是字符串!'命名參數(shù)可以自動處理字符串轉(zhuǎn)義";
    } )
    //刪 - 使用format格式化參數(shù)
    mysqlDb.exec("DELETE FROM `%s` where name='%s';","library",'名字3')
    //改
    mysqlDb.exec("UPDATE `library` SET auditing = 111 WHERE name = '名字2';" );
    //查詢數(shù)據(jù)并返回記錄集,limit指定返回記錄集索引
    var result = mysqlDb.query("select * from `library` limit 0,10");
    for name,auditing,bytes in result.each(){
    io.print( name,auditing,bytes ); //逐行輸出所有記錄
    }
    //移除數(shù)據(jù)庫
    mysqlDb.dropDb("testAAutoMySqlClient");