Good Morning Steve
The insertion of comma in your Data works if your columns are VARCHAR and
you have place Data Value in 'tick marks'
e.g.
mysql alter table test CHANGE test test VARCHAR(100);
Query OK, 1 row affected (0.03 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql commit;
Query OK, 0
Hello
I just tried to install the mysql server and I am getting the
following error messgae for the Apply Security Setting:
The security settings could not be applied.
Error number 1045
Access denied for use '[EMAIL PROTECTED]' (using password:YES)
What does this mean and how do I fix it?
Greetings Andrew,
Make sure you have granted access to your user: (run command line)
mysql GRANT ALL ON databaseName.* TO 'your_mysql_name'@'your_client_host';
Sincerely,
Craig Huffstetler
P.S. - What version of MySQL, what operating system and are you using the
command line (I was assuming
Greetings again Andrew,
That error message is usually when you try to login to MySQL by whatever
means (the Windows install Wizard may be attempting this in the final steps
upon starting up? But it should not be starting up as root...).
Can you complete the installation using the wizard (I am
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
I'm trying to dump all the columns of a table but one in a
restructuring of my schema. I found this post:
http://www.jsw4.net/info/listserv_archives/mysql/05-wk49/msg00131.html
which seems to indicate that this isn't
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Subject: Re: mysqldump on specific columns only?
I'm trying to dump all the columns of a table but one in a
restructuring of my schema.
By dump, I assume you mean output, not delete.
I suspect I'm too inexperienced in MySQL
Thanks for the responses, Inline:
On Sun, Mar 9, 2008 at 7:49 PM, Tim McDaniel [EMAIL PROTECTED] wrote:
On Sat, Mar 8, 2008 at 11:55 PM, Waynn Lue [EMAIL PROTECTED] wrote:
Subject: Re: mysqldump on specific columns only?
I'm trying to dump all the columns of a table but one in a
MySQL does provide LOAD DATA INFILE
(http://dev.mysql.com/doc/refman/5.0/en/load-data.html), but I was
hoping to do it through mysqldump instead of SELECT INTO because I
assumed the performance was faster. If that's not the case, though,
I'll go ahead and use SELECT INTO OUTFILE and