Java is case sensitive, this is the way JDBC wants you to work. The
Exception is generated by JDBC, not due to an error from MySQL. I would
recommend checking JDBC documentation.
Aman Raheja
http://www.techquotes.com
On Wed, 2004-07-21 at 10:55, Ying Lu wrote:
> Hello,
>
> I have a question ab
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by many
queries in Acce
At 20:43 -0700 4/17/04, Zhang Yu wrote:
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by many
queries in Acce
Zhang Yu <[EMAIL PROTECTED]> wrote:
>
> I am migrating an old Access database to MySQL. After
> migration, we'll keep using Access forms as front end,
> and MySQL as database.
>
> I experienced a strange problem when creating table
> with a column name "id #", which is used by many
> queries in A
Hi Hans,
> Yes, I have used `
>
> I don't think check is reserverd because I can CREATE the column name!
From
> the mysql prompt its possible to insert a record, but not from my Delphi
> Code. After that i try to alter / delete the column but thats impossible.
> Other columns in the same table whe
ent: Wednesday, December 24, 2003 16:41
Subject: Re: Column name: CHECK
>
> > I use the column name CHECK (smallint), but when I insert into the table
I
> > get an error : Check the manual for: Check) values ( etc.etc.
> >
> > When I try to change the column name (alter tabl
Have tried to use back sticks?
Like `check`
Thanks
Emery
- Original Message -
From: "Martijn Tonies" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 24, 2003 16:41
Subject: Re: Column name: CHECK
>
> > I use the column name CHEC
> I use the column name CHECK (smallint), but when I insert into the table I
> get an error : Check the manual for: Check) values ( etc.etc.
>
> When I try to change the column name (alter table tablename change check
> blabla smallint) I get an error too, check your manual..
>
> Does anybody know
Check out the alter table syntax ...
something to note you can't just change the name - you have to retype the
whole column signature:
ALTER TABLE [table] CHANGE [old column name] [new column name] [old column
definition];
ie. ALTER TABLE users CHANGE st state char(2) NOT NULL DEFAULT 'MI';
--J
ALTER TABLE
Simon
-Original Message-
From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 16:30
To: [EMAIL PROTECTED]
Subject: column name
Hi all,
I guess it's a dumb question for you guys, but MySql manual doesn't seem to
offer newbies a great deal of help on this
Jason Kwok writes:
> Even my mysql is compile with Big5, I couldn't use Chinese charaters (big 5)
> as column name. Is that normal?
Did you quote the names? And did they contain any of the illegal
characters discused in
http://www.mysql.com/doc/L/e/Legal_names.html ?
I wonder why ΓΏ is not allo
11 matches
Mail list logo
