Modules/MTA-MySQL/mysql select db: Difference between revisions

From Multi Theft Auto: Wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
Line 26: Line 26:
==See also==
==See also==
{{Modules/MTA-MySQL/Handler_functions}}
{{Modules/MTA-MySQL/Handler_functions}}
[[RU:Modules/MTA-MySQL/mysql_select_db]]

Latest revision as of 16:42, 2 December 2017


Package-x-generic.png This function is provided by the external module MTA-MySQL. You must install this module to use this function.

Changes the current default database.

Syntax

bool mysql_select_db ( MySQLConnection handler, string database )

Required arguments

  • handler: A valid MySQL link
  • database: The new database name

Returns

It it succeeds returns true, in other case returns false

Example

Example 1: This example changes the current default database to another one 

local handler = mysql_connect("localhost", "user", "password", "mta_users")
if ( not mysql_select_db(handler, "another_database") ) then
  outputDebugString("Unable to change default database: (" .. mysql_errno(handler) .. ") " .. mysql_error(handler))
end

See also

Retrieved from "https://wiki.multitheftauto.com/wiki/Modules/MTA-MySQL/mysql_select_db?oldid=53017"