Re: MySQL refusing to accept passwords

2011-07-23 Thread Johan De Meersman
- Original Message - > From: "Tim Thorburn" > > Before this, I did try to simply reset the root password by once > again stopping the MySQL service, starting it with --skip-grant-tables; > however regardless of what I changed the password to, I received the > same error. This error was p

Re: rebuilding table

2011-07-23 Thread shawn wilson
Look into select into or just insert. The mysql doc covering this might even have a suitable example. On Jul 23, 2011 8:42 AM, "Velen Vydelingum" wrote: > Hi, > > I have 2 tables and need to create a 3rd one as follows: > > Table Sales: > Code Price sQty sDate > 123 12.00 2 2011-03-12 > 190 10.00

rebuilding table

2011-07-23 Thread Velen Vydelingum
Hi, I have 2 tables and need to create a 3rd one as follows: Table Sales: Code Price sQtysDate 12312.0022011-03-12 19010.0012011-03-14 12313.0022011-03-29 12313.0032011-03-31 19011.0022011-03-31 Table Costs