Ask a Question related to MySQL, Design and Development.
-
Gilles #1
Help on Syntax error please
I'm new to MySQL. Sorry for asking for some probably very basic help. :(
The following code is from a Dump of a php forums database (openBB software,
now discontinued).
It was installed on a server running MySQL 4.0.18
================================================== ======
-- MySQL dump 9.11
--
-- Host: localhost Database: Apxxxxxxxxxx
-- ------------------------------------------------------
-- Server version 4.0.18
--
-- Table structure for table `ap_active`
--
CREATE TABLE ap_active (
member varchar(50) NOT NULL default '',
lastaction int(10) NOT NULL default '0',
record varchar(32) NOT NULL default '',
ip varchar(15) NOT NULL default '0',
location varchar(100) NOT NULL default '',
invisible enum('1','0') NOT NULL default '0',
inforum int(4) NOT NULL default '0',
KEY member (member),
KEY inforum (inforum)
) TYPE=MyISAM;
--
-- Dumping data for table `ap_active`
--.
...... etc
================================================== ======
When trying to restore the base, I get:
.................................................. ..............................
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 ap_active (
member varchar(50) NOT NULL default '
.................................................. ..............................
On my system:
-MySQL is version 4.1.9
-phpMyAdmin is 2.6.1
(Apache 1.3.33 and php 4.3.10, just for information)
What is wrong? I can't figure it out, sorry, I'm new to SQL and I only found
a MySQL 5 manual online so far.
Gilles Guest
-
Syntax error
I posted a question or two on this recently, and posts have been helpful. However, I have a new problem, and don't know what to do. To recap.... -
Syntax error?
Hi, I'm developing an ASP.NET web application with MySql 5. I have a little problem: if i create a stored procedure like this one: CREATE... -
error : syntax error at or near $1 for over select rows
This is the error i am getting when calling select * from cas_reset_qi_changedate('CAS','2003-02-03' ERROR: syntax error at or near "$1" at... -
syntax error ???
Hi, on login.php , we can see that : (...) $sql = "SELECT Login FROM logins WHERE Login='$fusername'"; $result = mysql_query($sql) or... -
SQL Syntax Error
Having some problems with my SQL statement syntax: Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression...



Reply With Quote

