MySql - Printable Version

MySql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySql (/showthread.php?tid=339855)

MySql - Alex.Cone - 05.05.2012

When I make mysql system in my gamemod I have to make tabels for phpmyadmin. How to make that?

Re: MySql - Pinguinn - 05.05.2012

Read this

Respuesta: MySql - [DOG]irinel1996 - 05.05.2012

Make them with SQL.
I mean, a query with:

PHP код:



CREATE TABLE IF NOT EXISTS tablename (username VARCHAR(24), pass VARCHAR(24))

For example in SQLite:

pawn Код:

db_query(database,"CREATE TABLE IF NOT EXISTS tablename (username TEXT, pass TEXT)");

And normal MySQL:

pawn Код:

new query[128];
format(query,128,"CREATE TABLE IF NOT EXISTS tablename (username VARCHAR(24), pass VARCHAR(24))");
mysql_query(query);

It should work.