Undefined Error in Creating Table For Users in 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: Undefined Error in Creating Table For Users in MySql (/showthread.php?tid=452472)
+- 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: Undefined Error in Creating Table For Users in MySql (/showthread.php?tid=452472)
Undefined Error in Creating Table For Users in MySql[solved] - rouzbeh - 21.07.2013
when i creating a table for users of my server with mysql phpMyAdmin,have undefined error and canceled
i have 121 fields in this table
whats the problem?
Re: Undefined Error in Creating Table For Users in MySql - doreto - 21.07.2013
Did you named your table? , scroll to top and it should give you error name
off: pink browser o.0
Re: Undefined Error in Creating Table For Users in MySql - rouzbeh - 21.07.2013
yes.my table have name users
Re: Undefined Error in Creating Table For Users in MySql - arakuta - 21.07.2013
try a SQL command in you pawn
pawn Код:
mysql_function_query(handle,"CREATE TABLE IF NOT EXISTS `users` (`id` int(11) NOT NULL, AUTO_INCREMENT, `name` VARCHAR(24) NOT NULL,`password` VARCHAR(32))", false, "", "");
Re: Undefined Error in Creating Table For Users in MySql - rouzbeh - 21.07.2013
but we have 121 columns.
Re: Undefined Error in Creating Table For Users in MySql - Vince - 21.07.2013
Exactly. So read up on database normalization and relations. There is no advantage in using SQL if you're just going to treat is as a file system.
Re: Undefined Error in Creating Table For Users in MySql - rouzbeh - 21.07.2013
but i did read mysql is fastest and i using for show userpanel is site too
Quote:
|
So read up on database normalization and relations. |
Re: Undefined Error in Creating Table For Users in MySql - Scenario - 21.07.2013
Quote:
|
Originally Posted by rouzbeh
 but i did read mysql is fastest
|
****** search "MySQL database normalization and relations" and read the stuff from the official MySQL website- it's important!
Re: Undefined Error in Creating Table For Users in MySql - rouzbeh - 21.07.2013
Solved
i first write top 100 in one file and export that.then write 21 other and import 100 fields.
i think that is phpmyadmin's bug!!
very thanks for all replies!!
