Gossamer Forum
Home : General : Databases and SQL :

Table and Column Naming MySQL

Quote Reply
Table and Column Naming MySQL
What is the maximum length a MySQL Table and Column name can be (out of curiosity), if anyone knows?


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] Table and Column Naming MySQL In reply to
I don't have a clue! I would imagine that this would depend on the OS in question, and it's maximum length for file names, maybe.

Your question has been asked before, however, and has gone unanswered:

http://groups.google.com/...oogle.com&rnum=3

- wil
Quote Reply
Re: [Wil] Table and Column Naming MySQL In reply to
Hmmm, I guess people never usually reach the limits... but someting that I was pondering all the same.


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] Table and Column Naming MySQL In reply to
 
http://www.mysql.com/doc/T/a/Table_size.html

Last edited by:

Paul: Jul 4, 2002, 1:12 AM
Quote Reply
Re: [Paul] Table and Column Naming MySQL In reply to
Hi Paul

I think Ian is asking how long a length can a table column name be, not the maximum size.

Cheers

- wil
Quote Reply
Re: [Ian] Table and Column Naming MySQL In reply to
I think table names can be about 50 characters...if you try any more chars than that it says "Incorrect table name" or something.

Last edited by:

Paul: Jul 4, 2002, 1:54 AM
Quote Reply
Re: [Paul] Table and Column Naming MySQL In reply to
Thanks guys,

Yes that is what I was looking for! I think at least one of mine is getting close to 40 charsBlush. Time to rename a little.


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] Table and Column Naming MySQL In reply to
Sorry, I just have to post on this thread because we all seem to have similar smilies. Thanks for bearing with me.
Quote Reply
Re: [blackikealamp] Table and Column Naming MySQL In reply to
Yeah, its a meeting of the yellow smiley guys.


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] Table and Column Naming MySQL In reply to
lol. I thought that Paul's avatar of Elliot was the best, closely followed by his one of Andy.
Quote Reply
Re: [CSM001] Table and Column Naming MySQL In reply to
His one of Andy?


http://www.iuni.com/...tware/web/index.html
Links Plugins
Quote Reply
Re: [Ian] Table and Column Naming MySQL In reply to
He had a picture of Andy as his avatar a while back, and Andy got angry and asked him to take it down. It was very funny, I can assure you. I think that's the last person Paul can do it to. Shame.
Quote Reply
Re: [Donald Rumsfeld] Table and Column Naming MySQL In reply to
He could do it to me I guess.



Last edited by:

Donald Rumsfeld: Jul 5, 2002, 4:01 PM
Quote Reply
Re: [Donald Rumsfeld] Table and Column Naming MySQL In reply to
Well I have two minutes left to post...its 11.58....at 12am I disappear.

If you are going to pretend to be someone at least make it someone good....Mayor Rudi....

Last edited by:

Paul: Jul 5, 2002, 4:00 PM
Quote Reply
Re: [Paul] Table and Column Naming MySQL In reply to
I have lots more left. I was thinking about being John Pilger next. Or maybe Noam Chomsky. Now that would be cool.


You could pretend to be Mayor Rudi, and I could be Hiliary Clinton.

Last edited by:

Donald Rumsfeld: Jul 5, 2002, 4:09 PM
Quote Reply
Re: [Donald Rumsfeld] Table and Column Naming MySQL In reply to
In Reply To:
He had a picture of Andy as his avatar a while back, and Andy got angry and asked him to take it down. It was very funny, I can assure you. I think that's the last person Paul can do it to. Shame.

I personally found it very childish!

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] Table and Column Naming MySQL In reply to
Ditto.
========================================
Buh Bye!

Cheers,
Me