mysql

最新推荐文章于 2023-11-05 16:27:28 发布
最新推荐文章于 2023-11-05 16:27:28 发布
阅读量1k 收藏
点赞数
分类专栏： lua 文章标签： mysql lua query function null table
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/chencong112/article/details/7379970
版权 
#include <lua.h>
#include <lauxlib.h>
#include <mysql.h>
#include <string.h>
#include <stdio.h>
 
#define YO2MYSQL_CONN "YO2MySQL"
typedef struct {
	MYSQL *conn;
	char *dbname;
	int num_rows;
	int found_rows;
	int per_page;
} yo2mysql_connection_type;
 
int luaopen_yo2mysql (lua_State *L);
 
// Create a metatable and leave it on top of the stack.
int yo2mysql_register (lua_State *L, const char *name, const luaL_reg *methods) {
    if (!luaL_newmetatable (L, name))
        return 0;
 
    /* define methods */
    luaL_register (L, NULL, methods);
 
    /* define metamethods */
    lua_pushliteral (L, "__gc");
    lua_pushcfunction (L, methods->func);
    lua_rawset (L, -3);
 
    lua_pushliteral (L, "__index");
    lua_pushvalue (L, -2);
    lua_rawset (L, -3);
 
    lua_pushliteral (L, "__metatable");
    lua_pushliteral (L, "you're not allowed to get this metatable");
    lua_rawset (L, -3);
 
    return 1;
}
 
static int yo2mysql_connect (lua_State *L) {
 
	// This function init a connection and connect to a real database
	char * sqlarg[3]; // The first 3 arguments for mysql_real_connect: server, user, passwd
 
	// Get the first 3 arguments
	int i;
	for ( i = 0; i < 3; i++) {
		if (!lua_isstring(L, i+1)) {
			lua_pushnil(L);
			lua_pushstring(L, "Wrong type of argument!");
			return 2;
		}
		else {
			sqlarg[i] = lua_tostring(L, i+1);
		}
	}
 
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)lua_newuserdata(L, sizeof(yo2mysql_connection_type));
	luaL_getmetatable (L, YO2MYSQL_CONN);
	lua_setmetatable (L, -2);
	// Init the connection and connect it to a real database
	yo2mysql_connection->conn = mysql_init(NULL);
	if (!yo2mysql_connection->conn) {
        lua_pushstring(L, "Cannot init connection!");
		return 2;
    }
	if (!mysql_real_connect(yo2mysql_connection->conn, sqlarg[0], sqlarg[1], sqlarg[2], NULL, 0, NULL, 0)) {
		lua_pushstring(L, mysql_error(yo2mysql_connection->conn));
		return 2;
	}
 
	// Push the connection pointer onto the stack
	return 1;
}
 
static int yo2mysql_close (lua_State *L) {
	// This function closes the given connection
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
	mysql_close(yo2mysql_connection->conn);
	yo2mysql_connection->conn = NULL;
	return 0;
}
 
char * yo2mysql_up_add(char *query) {
	// This function convert the query statement to UPPERCASE
	char *new = malloc(strlen(query)+10);
	char *s;
	strcpy(new, query);
 
	for (s = new; *s; s++){
		if ((*s>='a') && (*s<='z')) {
			*s-=32;
		}
	}
 
	// and add LIMIT 1 if it doesn't have the limitation
	char *slimit = " LIMIT";
	if (strstr(new, slimit) == NULL) {
		sprintf(new, "%s LIMIT 1", query);
	}
 
	return new;
}
 
int yo2mysql_calcperpage(char *query) {
	// This function returns the number after the comma after 'LIMIT' to the query statement
	// e.g a query with 'LIMIT 10, 20' will return 20
 
	// First convert the query statement to UPPERCASE
	char *new = malloc(strlen(query)+10);
	char *s;
	strcpy(new, query);
 
	for (s = new; *s; s++){
		if ((*s>='a') && (*s<='z')) {
			*s-=32;
		}
	}
 
	int per_page = 0;
 
	// and add LIMIT 1 if it doesn't have the limitation
	char *slimit = "LIMIT";
	if ((s = strstr(new, slimit)) != NULL) {
		s += 5;
		while (*s == ' ')
			s++;
		while (*s >= '0' && *s <= '9')
			s++;
		if (*s = ',') {
			s++;
			while (*s >= '0' && *s <= '9') {
				per_page = per_page * 10 + *s - '0';
				s++;
			}
		}
	}
 
	free(new);
 
	return per_page;
}
 
static int yo2mysql_query (lua_State *L) {
	// This function returns whether the query on a given connection has results
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	MYSQL_RES *res;
 
	// Get the query statement
	char *sqlquery;
	if (!lua_isstring(L, 2)) {
		lua_pushnil(L);
		lua_pushstring(L, "Wrong type of argument");
		return 2;
	}
	else {
		sqlquery = lua_tostring(L, 2);
	}
 
	// Do the query on the given connection
	if (mysql_query(yo2mysql_connection->conn, sqlquery)) {
		lua_pushnil(L);
		lua_pushstring(L, mysql_error(yo2mysql_connection->conn));
		return 2;
	}
 
	// Get the results set
	res = mysql_use_result(yo2mysql_connection->conn);
	unsigned int field_count = mysql_field_count(yo2mysql_connection->conn);
	if (res) {
		lua_pushnumber(L, 1);
	}
	else {
		if (field_count == 0) {
			lua_pushnumber(L, mysql_affected_rows(yo2mysql_connection->conn));
		}
		else {
			lua_pushnil(L);
			lua_pushstring(L, mysql_error(yo2mysql_connection->conn));
			return 2;
		}
	}
	mysql_free_result(res); // Free the results set
 
	return 1;
}
 
static int yo2mysql_getresults (lua_State *L) {
	// This function returns a 2d table for a query on a given connection
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	// Get the query statement
	char *sqlquery;
	if (!lua_isstring(L, 2)) {
		lua_pushnil(L);
		lua_pushstring(L, "Wrong type of argument!");
		return 2;
	}
	else {
		sqlquery = lua_tostring(L, 2);
	}
 
	// Do the query on the given connection
	if (mysql_query(yo2mysql_connection->conn, sqlquery)) {
		lua_pushnil(L);
		lua_pushstring(L, mysql_error(yo2mysql_connection->conn));
		return 2;
	}
 
	// Get the results set
	MYSQL_RES *res = mysql_use_result(yo2mysql_connection->conn);
 
	// Get the fields for field name
	unsigned int num_fields = mysql_num_fields(res);
	unsigned int i,row_num = 0;
	MYSQL_FIELD *fields;
	fields = mysql_fetch_fields(res);
 
	// Push the outter table for different rows onto the stack
	lua_newtable(L);
 
	// Get each row
	MYSQL_ROW row;
	while ((row = mysql_fetch_row(res)) != NULL) {
		row_num++;
		lua_pushnumber(L, row_num);// And push the row number
		lua_newtable(L); // Push the inner table for a single row onto the stack
		for ( i = 0; i < num_fields; i++) {
			lua_pushstring(L, fields[i].name); // Push the field name as key
			lua_pushstring(L, row[i]); // Push the actual data in string format as value
			lua_rawset(L, -3); // Finish a single key/value record of the inner table
		}
		lua_rawset(L, -3); // Finish a single row of records of the outter table
	}
	yo2mysql_connection->num_rows = row_num;
	yo2mysql_connection->per_page = yo2mysql_calcperpage(sqlquery);
 
	mysql_free_result(res); // Free the results set
 
	if (strstr(sqlquery, " SQL_CALC_FOUND_ROWS ") != NULL) {
		mysql_query(yo2mysql_connection->conn, "SELECT FOUND_ROWS()");
		res = mysql_use_result(yo2mysql_connection->conn);
		row = mysql_fetch_row(res);
		yo2mysql_connection->found_rows = atoi(row[0]);
		mysql_free_result(res);
	}
 
	return 1;
}
 
static int yo2mysql_numrows (lua_State *L) {
	// This function just returns the global variable set in yo2mysql_getresults or yo2mysql_setnumrows
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	lua_pushnumber(L, yo2mysql_connection->num_rows);
 
	return 1;
}
 
static int yo2mysql_perpage (lua_State *L) {
	// This function just returns the global variable set in yo2mysql_getresults or yo2mysql_setperpage
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	lua_pushnumber(L, yo2mysql_connection->per_page);
 
	return 1;
}
 
static int yo2mysql_foundrows (lua_State *L) {
	// This function just returns the global variable set in yo2mysql_getresults or yo2mysql_setfoundrows
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	lua_pushnumber(L, yo2mysql_connection->found_rows);
 
	return 1;
}
 
static int yo2mysql_getrow (lua_State *L) {
	// This function returns a table contains the data in a single row for a query on a given connection
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	// Get the query statement
	char *sqlquery;
	if (!lua_isstring(L, 2)) {
		lua_pushnil(L);
		lua_pushstring(L, "Wrong type of argument!");
		return 2;
	}
	else {
		sqlquery = lua_tostring(L, 2);
	}
	// Convert the query statement to UPPERCASE and add ' LIMIT 1' if it doesn't have the limitation
	sqlquery = yo2mysql_up_add(sqlquery);
 
	// Do the query on the given connection
	if (mysql_query(yo2mysql_connection->conn, sqlquery)) {
		if(sqlquery) {free(sqlquery);}
		lua_pushnil(L);
		lua_pushstring(L, mysql_error(yo2mysql_connection->conn));
		return 2;
	}
	// Get the results set
	MYSQL_RES *res = mysql_use_result(yo2mysql_connection->conn);
	if(sqlquery) {free(sqlquery);}
	// Get the fields for field name
	unsigned int num_fields = mysql_num_fields(res);
	unsigned int i,row_num = 1;
	MYSQL_FIELD *fields;
	fields = mysql_fetch_fields(res);
 
	// Get the first (and only) row
	MYSQL_ROW row = mysql_fetch_row(res);
	if (row == NULL) {
		lua_pushnil(L);
		lua_pushstring(L, "No row found");
		return 2;
	}
	else {
		lua_newtable(L); // Push a table onto the stack
		for ( i = 0; i < num_fields; i++) {
			lua_pushstring(L, fields[i].name); // Push the field name as key
			lua_pushstring(L, row[i]); // Push the actual data in string format as value
			lua_rawset(L, -3);// Finish a single key/value record of the table
		}
	}
 
	mysql_free_result(res); // Free the results set
 
	return 1;
}
 
static int yo2mysql_getvar (lua_State *L) {
	// This function returns only the first data for a query on a given connection
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	// Get the query statement
	char *sqlquery;
	if (!lua_isstring(L, 2)) {
		lua_pushnil(L);
		lua_pushstring(L, "Wrong type of argument!");
		return 2;
	}
	else {
		sqlquery = lua_tostring(L, 2);
	}
 
	// Convert the query statement to UPPERCASE and add ' LIMIT 1' if it doesn't have the limitation
	sqlquery = yo2mysql_up_add(sqlquery);
 
	// Do the query on the given connection
	if (mysql_query(yo2mysql_connection->conn, sqlquery)) {
		lua_pushnil(L);
		lua_pushstring(L, mysql_error(yo2mysql_connection->conn));
		return 2;
	}
 
	// Get the results set
	MYSQL_RES *res = mysql_use_result(yo2mysql_connection->conn);
 
	// Get the first (and only) row
	MYSQL_ROW row = mysql_fetch_row(res);
	if (row == NULL) {
		if(sqlquery) {free(sqlquery);}
		lua_pushnil(L);
		lua_pushstring(L, "No row found!");
		return 2;
	}
	else {
		lua_pushstring(L, row[0]); // Push the first (and only) data onto the stack
	}
 
	if(sqlquery) {free(sqlquery);}
	mysql_free_result(res); // Free the results set
 
	return 1;
}
 
static int yo2mysql_insertid (lua_State *L) {
	// This function returns the id of the object just been inserted or updated on a given connection
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	lua_pushnumber(L, mysql_insert_id(yo2mysql_connection->conn)); // Push the id onto the stack
 
	return 1;
}
 
static int yo2mysql_setnumrows (lua_State *L) {
	// This function directly changes the value of the global gyo2mysql_num_rows
	if (lua_isnumber(L, 1)) {
		yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
		yo2mysql_connection->num_rows = lua_tonumber(L, 1);
	}
 
	return 0;
}
 
static int yo2mysql_setperpage (lua_State *L) {
	// This function directly changes the value of the global gyo2mysql_per_page
 
	if (lua_isnumber(L, 1)) {
		yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
		yo2mysql_connection->per_page = lua_tonumber(L, 1);
	}
 
	return 0;
}
 
static int yo2mysql_setfoundrows (lua_State *L) {
	// This function directly changes the value of the global gyo2mysql_found_rows
 
	if (lua_isnumber(L, 1)) {
		yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
		yo2mysql_connection->found_rows = lua_tonumber(L, 1);
	}
 
	return 0;
}
 
static int yo2mysql_selectdb (lua_State *L) {
	// This function changes the connection's default database
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	char *sqlquery;
	if (!lua_isstring(L, 2)) {
		lua_pushnil(L);
		lua_pushstring(L, "Wrong type of argument!");
		return 2;
	}
	else {
		sqlquery = lua_tostring(L, 2);
	}
 
	mysql_select_db(yo2mysql_connection->conn, sqlquery);
 
	return 0;
}
 
static int yo2mysql_setcharset (lua_State *L) {
	// This function changes the connection's default character set
	yo2mysql_connection_type *yo2mysql_connection = (yo2mysql_connection_type *)luaL_checkudata (L, 1, YO2MYSQL_CONN);
	if (!yo2mysql_connection->conn) {
		lua_pushnil(L);
		lua_pushstring(L, "MySQL connection has gone!");
		return 2;
	}
 
	char *sqlquery;
	if (!lua_isstring(L, 2)) {
		lua_pushnil(L);
		lua_pushstring(L, "Wrong type of argument!");
		return 2;
	}
	else {
		sqlquery = lua_tostring(L, 2);
	}
 
	mysql_set_character_set(yo2mysql_connection->conn, sqlquery);
 
	return 0;
}
 
static const luaL_reg yo2mysql_connection_lib[] = {
		{"set_charset", yo2mysql_setcharset},
		{"select_db", yo2mysql_selectdb},
		{"query", yo2mysql_query},
		{"get_results", yo2mysql_getresults},
		{"get_row", yo2mysql_getrow},
		{"get_var", yo2mysql_getvar},
		{"num_rows", yo2mysql_numrows},
		{"found_rows", yo2mysql_foundrows},
		{"per_page", yo2mysql_perpage},
		{"insert_id", yo2mysql_insertid},
		{"set_num_rows", yo2mysql_setnumrows},
		{"set_found_rows", yo2mysql_setfoundrows},
		{"set_per_page", yo2mysql_setperpage},
		{"close", yo2mysql_close},
		{NULL, NULL}
};
 
int luaopen_yo2mysql (lua_State *L) {
	lua_pushcfunction(L, yo2mysql_connect);
	lua_setglobal(L, "open_mysql");
	yo2mysql_register (L, YO2MYSQL_CONN, yo2mysql_connection_lib);
	lua_pop (L, 2);
	return 1;
}
千山万水
关注
专栏目录
MySQL 安装
wuhaifei
01-05 5896
所有平台的 MySQL 下载地址为：MySQL 下载。 挑选你需要的MySQL Community Server版本及对应的平台。 注意：安装过程我们需要通过开启管理员权限来安装，否则会由于权限不足导致无法安装。 Linux/UNIX 上安装 MySQL Linux平台上推荐使用RPM包来安装Mysql,MySQL AB提供了以下RPM包的下载地址： MySQL- MySQL...
Mysql超详细安装配置教程(保姆级)
星浩的博客
07-22 27万+
有mysql官方的mysql workbench，有DataGrip，还有navicat等等。这个工具官方下载是会收费的，免费版本可以关注下面的公众号，输入navicat进行领取。安装好之后，在桌面右键点击我的电脑(有些是此电脑)，然后点击属性，进入系统信息设置。执行完成点击Finish即可，然后点击next，再点击Finish即可。（其中123456是你预设置的root密码，我的密码是：123456。如果要新建数据库，可以右键对应的连接，然后点击新建数据库即可。然后点击连接，再选择Mysql。
2024 年 MySQL 8.0 安装 配置 教程 最简易（保姆级）
mobeiCanyue
12-09 46万+
首先去官网下一个MySQL MySQL :: Download MySQL Installer 这里没有看到64位的安装包, 不要着急, 这只是一个安装器, 安装包里有64位的MySQL Server8.0 这时候如果直接安装你会发现: 默认装到 C:\Program Files\MySQL , 而且不给你路径选择 我们知道, 如果是msi安装包安装, 会安装到C盘且没有路径选择. 如果是压缩包安装, 就是在命令行里调试, 可以解压安装到指定的路径. 但是, 命令行安装有致命...
MySQL 8.0.19安装教程(windows 64位)
热门推荐
日日言谧
08-15 98万+
话不多说直接开干 目录 1-先去官网下载点击的MySQL的下载​ 2-配置初始化的my.ini文件的文件 3-初始化MySQL 4-安装MySQL服务 + 启动MySQL 服务 5-连接MySQL + 修改密码 先去官网下载点击的MySQL的下载 下载完成后解压 解压完是这个样子 配置初始化的my.ini文件的文件 ...
Docker部署Mysql数据库详解
qq_43649937的博客
07-10 2万+
docker mysql
MySQL备份
spring℡
05-11 2万+
一、直接拷贝数据库文件 首先关闭数据库 [root@host1 mysql]# pwd /var/lib/mysql 压缩、拷贝到host2 [root@host1 mysql]# tar czf db.tar.gz * [root@host1 mysql]# scp db.tar.gz 192.168.157.11:/beifen host2 首先关闭数据库，清理/var/lib/mysql/下的内容 [root@host2 beifen]# tar xf db.tar.gz /var/lib/my
MySQL（免安装版）的安装与配置详细教程及相关问题解决办法、开启远程连接
小包同学_
07-30 8万+
MySQL（免安装版）的安装与配置详细教程及相关问题解决办法、开启远程连接
安装mysql步骤
Darker的博客
03-28 4529
一、安装mysql的repo源 # 查看系统是否安装mysql软件 rpm -qa|grep -i mysql # 卸载历史软件 yum remove '软件名' # centos7中yum源默认没有mysql，下载安装mysql的repo源 wget http://repo.mysql.com//mysql57-community-release-el7-7.noarch.rpm # 安装mysql的repo源 rpm -ivh mysql57-community-release-el7-7.noarch
Mysql连接指令
最新发布
喻师傅的学习笔记
11-05 4630
mysql命令行连接数据库
MySQL设置时区
Java+GO+JS全栈工程师-鹤冲天的博客：编程辅导~商务合作~技术交流
09-08 1万+
MySQL时区设置对于数据库的处理时间值非常重要，可以让不同的时区用户正确的处理时间值。本文从设置时区的方法、时区转换和时区的影响三个方面详细说明了MySQL的时区设置，在实际开发中需要根据实际需要进行设置和使用。
mysql jdbc连接驱动jar包（适用于mysql5.7版本，亲测可用）
08-17
MySQL JDBC连接驱动是Java应用程序与MySQL数据库之间通信的桥梁，使得开发者可以使用Java语言来执行SQL语句，处理数据库中的数据。本驱动适用于MySQL 5.7版本，并且经过实际测试，确认可用。这个jar包是完全免费的，...
mysql-connector-java-8.0.27
12-24
MySQL Connector/J 8.0.27 是MySQL数据库与Java应用程序之间的重要桥梁，它是一个实现了JDBC（Java Database Connectivity）接口的驱动程序，允许Java开发者在应用中无缝地访问MySQL数据库。MySQL Connector/J使得...
mysql驱动jar 文件适用MySQL5.7
01-18
MySQL驱动jar文件是Java应用程序与MySQL数据库之间通信的关键组件，主要功能是提供Java Database Connectivity (JDBC) API，使得Java开发者能够通过编写Java代码来执行SQL语句，从而操作MySQL数据库。标题提到的...
mysql驱动（适用于mysql5.7版本）
12-07
MySQL驱动是Java应用程序连接到MySQL数据库的关键组件，它允许程序通过Java Database Connectivity (JDBC) API与MySQL服务器进行通信。本压缩包包含了两个适用于MySQL 5.7版本的驱动文件：`mysql-connector-java-...
MySQL安装配置教程（超级详细、保姆级）
Soloversion的博客
03-26 42万+
一、 下载MySQL Mysql官网下载地址https://downloads.mysql.com/archives/installer/ 1. 选择想要安装的版本，本篇文章选择的是5.7.31版本，下面的那个文件，点击Download下载 二、 安装MySQL 1. 选择设置类型 双击运行mysql-installer-community-5.7.31.0.msi 这里选择是自定义安装，所以直接选择“Custom”，点击“Next” “Developer Default”是开发者默认
Lua中用Split函数分割字符串
chencong112的专栏
08-31 3万+
function Split(szFullString, szSeparator) local nFindStartIndex = 1 local nSplitIndex = 1 local nSplitArray = {} while true do local nFin
lua 转 utf8编码
chencong112的专栏
08-19 2万+
-- convert numeric html entities to utf8 -- converts from stdin to stdout -- example: € -> € local char = string.char local functi
lua 重新加载模块
chencong112的专栏
03-26 8211
重新加载模块 [c-sharp] view plaincopyprint? function reload( moduleName )       package.loaded[moduleName] = nil       require(moduleName)   end     使用以上代码即可重新载入一个文件。 这
Lua 学习笔记：C API 遍历 Table
chencong112的专栏
10-26 5200
前情提要 Lua 通过一个虚拟栈与 C 的交互，正数索引自底向上取值，负数索引自顶向下取值。 Lua 中的 Table（表）结构可以使用任何数据作为 key 进行取值。使用 C API 访问 Table 中的元素有两种方法： lua_getglobal(L, t); lua_pushinteger(L, k); -- 这里可以换成其它类型的 lua_pushXXXX(L, k) 压数
MySQL 5.1.58 安装教程
2. 创建用户组和用户：`groupadd mysql` 创建名为mysql的用户组，`useradd -g mysql mysql -s /sbin/nologin` 添加一个名为mysql的用户并将其添加到mysql组，且指定不登录 shell。 3. 解压MySQL源码包：`tar xzf ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值