Comparing strings as ints

Hi Everyone, After staring blankly at the mysql manual for a long time, I thought it might be time to ask the list... I have a table setup with a varchar(20) column, I am using this column to store a price, the reason I chose varchar(20) is because the prices I am dealing with are fairly

mysqldump issues

I need to generate a tab-delimited text dump of table data ONLY and have it output to a text file. I don't want any table info, delimiters, etc. I need this to copy/paste into a excel spreadsheet. What's the syntax? I'm stuck here: % mysqldump dbname tablename ??? pleasepleaseplease help..!

Re: Adding Customer ID numbers to and already existing table

If v.3.23+, it's a one-step, along the lines of: ALTER TABLE tablename ADD columnname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT = 1000 Prior to 3.23, it's a three-step: 1st, alter the table to include the key: ALTER TABLE tablename ADD columnname INT UNSIGNED NOT NULL PRIMARY KEY