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 lar
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 AUTO_I
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..!