Jump to content

MYSQL help


srwright

Recommended Posts

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: dot.gif

#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 

Link to comment
https://forums.phpfreaks.com/topic/287211-mysql-help/
Share on other sites

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

Link to comment
https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473737
Share on other sites

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 :)

Link to comment
https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473756
Share on other sites

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.

Link to comment
https://forums.phpfreaks.com/topic/287211-mysql-help/#findComment-1473761
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.