List of Tables and Fields... No, No

Where is that list?

[henry0]

I just had a bad, very bad time!
trying to figure why I was not able to create a table

A while ago we discussed a list of NO NO names not to be used in tables and fields

well I had a table named "group"
and a field named "type"

no way to create a table named "group" , further "type" field's name does not work ...took me 90 min to figure it out
not to mention head banging.

I looked around but cannot find the thread

thanks

[ergophobe]

That's one reason why I like to use the mysql-front command line rather than the standard mysql client command line. mysql-front has syntax highlighting, so you type "group" and it goes bold and blue.

When your brain is going mushy, it helps!

[henry0]

good Point
I shall just do that :)
Henry

[coopster]

In MySQL?
[dev.mysql.com...]

[henry0]

Thank you
I bookmarked it

I was ref to an earlier thread where it was discussed
(not sure +/- a month ago)

but that list will indeed do fine