Help me with this MYSQL
#1

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
Reply
#2

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 код:
  `Rank1varchar(50NOT NULL,
  `
Rank2varchar(50NOT NULL,
  `
Rank3varchar(50NOT NULL,
  `
Rank4varchar(50NOT NULL,
  `
Rank5varchar(50NOT NULL,
  `
Rank6varchar(50NOT NULL,
  `
Rank7varchar(50NOT NULL,
  `
Rank8varchar(50NOT NULL,
  `
Rank9varchar(50NOT NULL,
  `
Rank10varchar(50NOT NULL,
  `
Rank11varchar(50NOT NULL,
  `
Rank12varchar(50NOT NULL,
  `
Rank13varchar(50NOT NULL,
  `
Rank14varchar(50NOT NULL,
  `
Rank15varchar(50NOT NULL,
  `
Rank16varchar(50NOT NULL,
  `
Rank17varchar(50NOT NULL,
  `
Rank18varchar(50NOT NULL,
  `
Rank19varchar(50NOT NULL,
  `
Rank20varchar(50NOT NULL,
  `
Rank21varchar(50NOT NULL,
  `
Rank22varchar(50NOT NULL,
  `
Rank23varchar(50NOT NULL,
  `
Rank24varchar(50NOT NULL,
  `
Rank25varchar(50NOT 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.
Reply
#3

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)