On Wed, 11 May 2005 15:08:50 +0200, wrote: >Selon Jay Blanchard <[EMAIL PROTECTED]>: > >> [snip] >> I've got a converted from Excel spreadsheet to mysql database, which has >> mixed case column names and
With advice from this thread, what I ended up doing was >show create table tbl_products; To get syntax such `01_Desc` varchar(255) default NULL, `01_Lcode` varchar(255) default NULL, I then used a text editor www.vim.org to generate the following mysql command using VIM regexp substitutes alter table tbl_products change `01_Desc` `p01_desc` varchar(255) default NULL, change `01_lLcode` `p01_lcode` varchar(255) default NULL, etc eg VIM commands :%s#^[^ ]\+#change & p\L& :%s# p`# `p# This worked very well -- 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]
