הוסטס - פורום אחסון האתרים הגדול בישראל - View Single Post

Shoko · 21-10-05, 19:36

SQL query:

CREATE TABLE Customers( CustomerID COUNTER PRIMARY KEY ,
Last_Name TEXT( 50 ) ,
First_Name TEXT( 50 ) ,
Phone TEXT( 10 ) ,
Email TEXT( 50 ) ,
Comments MEMO
)

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 'COUNTER PRIMARY KEY,
Last_Name TEXT(50),
First_Name TEXT(50),
Pho' at line 3

21-10-05, 19:36	# 1
Shoko משתמש בעל גישה מוגבלת מיני פרופיל תאריך הצטרפות: Oct 2005 גיל: 34 הודעות: 374	בעיה במסד SQL query: CREATE TABLE Customers( CustomerID COUNTER PRIMARY KEY , Last_Name TEXT( 50 ) , First_Name TEXT( 50 ) , Phone TEXT( 10 ) , Email TEXT( 50 ) , Comments MEMO ) 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 'COUNTER PRIMARY KEY, Last_Name TEXT(50), First_Name TEXT(50), Pho' at line 3 Last edited by Shoko; 21-10-05 at 19:39..