Death By phpMyAdmin SQL Dump
-
Hi
I am new to php and SQL and have recently started trying to use it and implement scripts onto my websites, all have being successfull with some fiddling, but I am totally stumped with this one. I need to execute a .sql file in MyPHP Admin to to create the correct tables in the database. But I keep receiving this error :
“#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 ‘idint(255) NOT NULL auto_increment,url
varchar(255) NOT NULL default '',
' at line 2 "The table in question is:
SQL query:-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 10, 2005 at 02:00 PM
-- Server version: 4.0.22
-- PHP Version: 4.3.9
--
-- Database: royascom_asbasb_articles
--
-- --------------------------------------------------------
--
-- Table structure for tableasb_articles
--
DROP TABLE IF EXISTS;CREATE TABLE asb_articles
(id
int( 255 ) NOT NULL AUTO_INCREMENT ,url
varchar( 255 ) NOT NULL default '',title
longtext NOT NULL ,author
varchar( 200 ) NOT NULL default '',article
longtext NOT NULL ,resource_box
longtext NOT NULL ,category
varchar( 255 ) NOT NULL default '',id
PRIMARY KEY () ,url
UNIQUE KEY(url) ,article
FULLTEXT KEY(article` )
) TYPE = MYISAMAny help would be greatly appreciated as I am a total newbie to this stuff …
Thanks
The topic ‘Death By phpMyAdmin SQL Dump’ is closed to new replies.