On Mon, 09 May 2005 17:32:29 +0100, wrote: >Hi, >Is there a query which will "alter" a table to rename all the columns to >lowercase > >eg Price to price, Quantity to quantity
Funny how sometimes a UseNet query is answered in minutes, and or exites a flurry of responses, and othertimes like here zilch! I've got a converted from Excel spreadsheet to mysql database, which has mixed case column names and also columns beginning with a digit eg 01_name, 02_address etc what upsets PHP considerably. So I'd like to have a way to generically rename all columns beginning with a numeric form ^\d.* to someprefix_& Is it not possible to write such a query, or is this best done by Perl or PHP script? -- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
