mariadb get insert id - Revision history

BlueMountains at 08:47, 2 September 2020

2020-09-02T08:47:01Z

@@ Line 12: / Line 12: @@
 == Example ==
 <syntaxhighlight lang="Lua>
-local player_sqlid = mariadb_get_insert_id()
+function CreatePlayerAccount(player)
-print("A new player with #"..player_sqlid.." has registered.")
+	local query = mariadb_prepare(sql, "INSERT INTO accounts (id, steamid, steam_name, game_version, locale, registration_time, registration_ip) VALUES (NULL, '?', '?', ?, '?', UNIX_TIMESTAMP(), '?');",
 </syntaxhighlight>
 {{RelatedFunctions}}
 {{Template:MariaDBFunctions}}

28days at 13:53, 20 November 2019

2019-11-20T13:53:24Z

← Older revision		Revision as of 13:53, 20 November 2019
Line 2:		Line 2:
	{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}		{{Notice\|This function is provided by the official [[MariaDB]] plugin.}}

	{{FuncDescription\|~~__EDIT_ME__~~}}		{{FuncDescription\|Retrieves the ID generated for an AUTO_INCREMENT column by the sent query (usually INSERT).}}

	{{FuncSyntax\|mariadb_get_insert_id()}}		{{FuncSyntax\|mariadb_get_insert_id()}}
Line 9:		Line 9:
	{{FuncNoParam}}		{{FuncNoParam}}

	{{FuncReturnValue\|~~__EDIT_ME__~~}}		{{FuncReturnValue\|new ID generated for an AUTO_INCREMENT column, '''false''' on error.}}

	== Example ==		== Example ==
	~~__EDIT_ME__~~		<syntaxhighlight lang="Lua>
			local player_sqlid = mariadb_get_insert_id()
			print("A new player with #"..player_sqlid.." has registered.")
			</syntaxhighlight>

	{{RelatedFunctions}}		{{RelatedFunctions}}
	~~__EDIT_ME__~~		{{Template:MariaDBFunctions}}

BlueMountains: Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_get_insert_id()}}..."

2019-05-19T10:31:19Z

Created page with "{{Info|Function|Server|1.0}} {{Notice|This function is provided by the official MariaDB plugin.}} {{FuncDescription|__EDIT_ME__}} {{FuncSyntax|mariadb_get_insert_id()}}..."

New page

{{Info|Function|Server|1.0}}
{{Notice|This function is provided by the official [[MariaDB]] plugin.}}

{{FuncDescription|__EDIT_ME__}}

{{FuncSyntax|mariadb_get_insert_id()}}

{{FuncParameters}}
{{FuncNoParam}}

{{FuncReturnValue|__EDIT_ME__}}

== Example ==
__EDIT_ME__

{{RelatedFunctions}}
__EDIT_ME__