1、mysql> connect //连接
2、mysql> create database TestOne;//创建TestOne数据库
3、mysql> use TestOne;//选择使用数据库,如果有多个数据库可以使用 “mysql> show databases;”查询后使用。
4、mysql> create table TestTable (TestTableId INTEGER auto_increment not null primary key, TestTableName varchar(100) not null); // 创建表, primary key主 键
5、insert TestTable values("1", "This is first testting name!");
6、select * from testTable;
7、 alter table TestTable add TestTableParama varchar(100) not null; //表中添加字段属性。
8、mysql> update TestTable set TestTableName='This is six testting name!' where TestTableId='6'; //修改字段属性值
9、mysql> alter table TestTable change TestTableParama TestTablePara varchar(100);//修改字段名
10、mysql -h localhost -u root -p //命令行打开。
11、示例代码:
#include "winsock.h"
#include "iostream"
#include <stdio.h>
#include <mysql.h>
#define SELECT_QUERY "select * from testtable"
#define INSERT_VALUES "insert into testtable values (7, 'This is senven testting name!', 'success')"
int main(int argc, char **argv)
{
MYSQL mysql,*sock; //定义数据库连接的句柄,它被用于几乎所有的MySQL函数
MYSQL_RES *res; //查询结果集,结构类型
MYSQL_ROW row ; //存放一行查询结果的字符串数组
char qbuf[160]; //存放查询sql语句字符串
mysql_init(&mysql);
if (!(sock = mysql_real_connect(&mysql,"localhost","root","","TestOne",0,NULL,0)))
{
fprintf(stderr,"Couldn't connect to engine!\n%s\n\n",mysql_error(&mysql));
perror("");
exit(1);
}
mysql_query(sock, INSERT_VALUES);
sprintf(qbuf,SELECT_QUERY);
if(mysql_query(sock,qbuf)) {
fprintf(stderr,"Query failed (%s)\n",mysql_error(sock));
exit(1);
}
if (!(res=mysql_store_result(sock))) {
fprintf(stderr,"Couldn't get result from %s\n", mysql_error(sock));
exit(1);
}
printf("number of fields returned: %d\n",mysql_num_fields(res));
int i = 1;
while (row = mysql_fetch_row(res)) {
printf("Ther userid #%d 's username is: %s %s %s\n", i++,row[0], row[1], row[2]) ;
puts( "query ok !\n" ) ;
}
mysql_free_result(res);
mysql_close(sock);
system("pause");
return 0; //. 为了兼容大部分的编译器加入此行
}