MYSQL help

[srwright]

ok i have loaded a .sql file into PHPmyadmin.

 

it is giving me this error :/

 

what can i do?

 

im using this version:  Server version: 5.6.16 - MySQL Community Server (GPL

 

 

--------------------------------------------------------------------------------

SQL query:

 

/*!40000 ALTER TABLE `group_members` ENABLE KEYS */;



-- Dumping structure for table bc.help_subjects
CREATE TABLE IF NOT EXISTS `help_subjects` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`caption` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

 

MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `help_subjects` (
  `id` int(11) unsigned NOT NULL A' at line 6 

Edited March 23, 2014 by srwright

[jazzman1]

 

what can i do?

I'd start running a mysql command line client executing sql statements from a text file using the source command. Here,  it's an example of installation sakila database, use same logic.  

[srwright]

I'd start running a mysql command line client executing sql statements from a text file using the source command. Here,  it's an example of installation sakila database, use same logic.  

Ok the only problem is. i dont really know much about databases. Im simply following a tutorial. and this hasn't happened in the tutorial :/

sorry i know it must be frustrating getting people who dont truly know what theyre doing

[jazzman1]

Ok the only problem is. i dont really know much about databases. Im simply following a tutorial. and this hasn't happened in the tutorial :/

sorry i know it must be frustrating getting people who dont truly know what theyre doing

Then, stop learning tutorials and start learning the core programming logic by reading the docs

[srwright]

Then, stop learning tutorials and start learning the core programming logic by reading the docs

Im not interested in learning to program though. i simply needed the database for something else. as soon as thats setup i wont be using it again. couldn't you just help i im guessing you know how to do this stuff.