写这个博客是因为我自己在安装的时候走了很多弯路,所以写下来供自己查看也希望对他人有所帮助。
首先下载,我下载了俩个安装包mysql-workbench-community-6.3.9-osx-x86_64.dmg和mysql-5.7.19-macos10.12-x86_64.dmg
1.安装mysql-5.7.19-macos10.12-x86_64.dmg,安装完成后可以在偏好设置内看到MySQL,此时可以设置开启。
2.安装mysql-workbench-community-6.3.9-osx-x86_64.dmg,安装完后可以查看创建等一系列对数据库的操作。
3.安装完成后开始配置,打开Xcode新建一个工程。 选中TARGETS下的
/usr/local/mysql/include
/usr/local/mysql/lib
other link flag
4.配置完成后代码部分
#import "AppDelegate.h"
#import <mysql.h>
@interface AppDelegate ()
@property (weak) IBOutlet NSWindow *window;
@end
@implementation AppDelegate
- (void)applicationDidFinishLaunching:(NSNotification *)aNotification {
// Insert code here to initialize your application
MYSQL mysql;
MYSQL_RES *result;
MYSQL_ROW row;
mysql_init(&mysql);
if (!mysql_real_connect(&mysql,"127.0.0.1","root","123456","test",0,NULL,0)) {
NSLog(@"error");
}
int flag = mysql_query(&mysql, "INSERT INTO test.test1 (name, content) VALUES ('coox', '12345678qwx')");
flag = mysql_query(&mysql, "DELETE FROM test.test1 where name = 'coco'");
mysql_query(&mysql,"SELECT * FROM test1");
result = mysql_store_result(&mysql);
while ((row = mysql_fetch_row(result))) {
NSLog(@"%s%s%s",row[0],row[1],row[2]);
}
}