Hi all, Ive installed 7.4 in Linux Mandrake. Now to execute a query in SQLStudio I need to put " in the table name and field name like this: <cut> SELECT * FROM "DBA"."UTENTE" WHERE "DBA"."UTENTE"."ID_UTENTE" = 1 </cut> Why?
and why dont work this statment? <cut> ALTER TABLE "DBA"."UTENTE" DROP COLUMN "DBA"."UTENTE"."ID_UTENTE" RELEASE SPACE ---- Error ------------------------------- Auto Commit: On, SQL Mode: Ansi, Isolation Level: Committed Syntax error or access violation;-3005 POS(1) Invalid SQL statement. ALTER TABLE "DBA"."UTENTE" DROP COLUMN "DBA"."UTENTE"."ID_UTENTE" RELEASE SPACE </cut> If I omit the "RELEASE SPACE" I've: <cut> ALTER TABLE "DBA"."UTENTE" DROP COLUMN "DBA"."UTENTE"."ID_UTENTE" ---- Error ------------------------------- Auto Commit: On, SQL Mode: Ansi, Isolation Level: Committed Syntax error or access violation;-3005 POS(1) Invalid SQL statement. ALTER TABLE "DBA"."UTENTE" DROP COLUMN "DBA"."UTENTE"."ID_UTENTE" </cut> Thank you Max -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
