Question

mysql insert语句怎么插入变量

if(mysql_real_query(sock,"insert into phone(phone,code,time)values('x','y','z')));
对于其中的xyz是三个变量，应该怎么写？要具体的代码！

Answer 1

char sql[] = "insert into phone(phone,code,time)values(%d,%d,%d)"
char sqlBuf[1024];
sprintf(sqlBuf, sql, x, y, z);
if(mysql_real_query(sock,sqlBuf))

....