Help me with this MYSQL - Printable Version

Help me with this 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: Help me with this MYSQL (/showthread.php?tid=639734)

Help me with this MYSQL - LozNae - 22.08.2017

I connected it properly and then when I tried to Import it on my PHPMYADMIN.

It says:

please help me, this is the mysql.

https://pastebin.com/EXCgnJsu

Re: Help me with this MYSQL - Vince - 22.08.2017

If the database exists then just delete the line. The account may not have sufficient privileges to create a new database.

Also that is some really horrible database design. By the looks of it, it needs at least thirty extra tables to be properly normalized, and possibly quite a few more. Stuff like this makes me cringe so hard:

PHP код:



  `Rank1` varchar(50) NOT NULL,
  `Rank2` varchar(50) NOT NULL,
  `Rank3` varchar(50) NOT NULL,
  `Rank4` varchar(50) NOT NULL,
  `Rank5` varchar(50) NOT NULL,
  `Rank6` varchar(50) NOT NULL,
  `Rank7` varchar(50) NOT NULL,
  `Rank8` varchar(50) NOT NULL,
  `Rank9` varchar(50) NOT NULL,
  `Rank10` varchar(50) NOT NULL,
  `Rank11` varchar(50) NOT NULL,
  `Rank12` varchar(50) NOT NULL,
  `Rank13` varchar(50) NOT NULL,
  `Rank14` varchar(50) NOT NULL,
  `Rank15` varchar(50) NOT NULL,
  `Rank16` varchar(50) NOT NULL,
  `Rank17` varchar(50) NOT NULL,
  `Rank18` varchar(50) NOT NULL,
  `Rank19` varchar(50) NOT NULL,
  `Rank20` varchar(50) NOT NULL,
  `Rank21` varchar(50) NOT NULL,
  `Rank22` varchar(50) NOT NULL,
  `Rank23` varchar(50) NOT NULL,
  `Rank24` varchar(50) NOT NULL,
  `Rank25` varchar(50) NOT NULL,

I don't know who wrote this script but I am appalled that it didn't occur to them that they may have needed another table for this.

Re: Help me with this MYSQL - LozNae - 22.08.2017

I really don't know things about this, I don't even know what are you talking about.
I just need someone to make it fixed.