| 语法: |
mysql_execSQLWithResult(handle,sql) |
|
| 参数 |
类型 |
说明 |
| handle |
整数类型 |
由mysql_connect返回 |
| sql |
字符串类型 |
sql语句,请参考sql语法 |
return |
布尔/字符
|
返回值有两个个第一个布尔类型表示是否成功,第二个是失败原因 |
|
handle/布尔 |
是否成功,true成功,false失败 |
|
err /字符 |
失败原因 |
local handle,err = mysql_connect("192.168.2.103",3306,"testdb","test","Abc!123456")if handle ~= nil thenmysql_execSQL(handle,"delete from tb_person where id = 2")local ret,err,tb = mysql_execSQLWithResult(handle,"select * from tb_person")if ret thenfor i=1,#tb doprint(tb[i]) --打印每一行endelseprint(string.format("执行失败 %s",err))endmysql_close(handle)elseprint(string.format("连接失败,错误原因 %s",err))end