mysql安装，连接，插入(C语言)环境ubuntu16.04

1.mysql安装

1.1 安装

//  （下面这三步一定要完成）

sudo apt-get install mysql-server
apt isntall mysql-client
apt install libmysqlclient-dev 

1.2 若安装出现问题：（没出现问题就跳过）

E: Could not get lock /var/lib/dpkg/lock - open (11: Resource temporarily unavailable)

E: Unable to lock the administration directory (/var/lib/dpkg/), is another process using it

解决办法：

sudo rm /var/cache/apt/archives/lock

sudo rm /var/lib/dpkg/lock

2.mysql连接，插入数据

注意1：要包含头文件<mysql/mysql.h>

注意2：编译的时候要包含连接库 ( 如：gcc -o mysqlTest mysqlTest.c  -L/usr/lib/mysql -lmysqlclient )

	MYSQL m_conn;
	mysql_init(&m_conn);

	memset(m_buf, 0, SIZE);
	sprintf(m_buf,"INSERT INTO t2 values('%s','%s','%s','%s','%s')",\
	m_nameBuf,\
	m_eduBuf,\
	m_subDeptBuf,\
	m_deptBuf,\
	m_companyBuf);

	if(mysql_real_connect(&m_conn, "localhost",
			"root","***","Rose",0,NULL,0))
   	{
		int ret = 0;
 		printf("coneect mysql successful");
 		ret = mysql_query(&m_conn, m_buf);
  		if(!ret)
 		{
     			printf("insert %lu rows\n",
			(unsigned long)mysql_affected_rows(&m_conn));
 		}
 		else
 		{
     			printf("insert error\n");
 		}
 		mysql_close(&m_conn);
    }

参考博客：http://www.cnblogs.com/iscodercn/p/5488633.html

参考博客：http://blog.csdn.net/u012556077/article/details/50074579

参考博客: http://blog.csdn.net/u012016940/article/details/42089169