exporting ascii codes from db fields

2004-07-15 Thread Chuck Barnett
Hello, I have a db that I did a mysqldump on. It contained different entries for products some of which had the ascii code for the reg. mark. When I looked at the export file, it had exported the reg mark itself instead of the ascii code. Is this normal, and how can I fix it...I've got bunches

restore from mysqldump file

2004-07-02 Thread Chuck Barnett
Hello, I have a huge problem that you guys may be able to help me with. I did a mysqldump all databases into a sql71.sql file. when I try and I get the following error when trying to restore ERROR 1050 at line 204528: Table 'columns_priv' already exists I'm sure that this is for the mysql

command line login question

2004-02-06 Thread Chuck Barnett
Hi, I am trying to create a script that automatically logs in to mysql and chooses a db then runs a query. I can login fine when doing it this way: mysql -u user -p it then asks for a pass and it works. but if I try this: mysql -u user -ppassword dbname I get an access error. any

query help - people who have bought this item have also bought

2003-07-24 Thread Chuck Barnett
Hi I'm looking to create a query that will look through my previous orders and create a table of what items have sold with what products. My current table that holds the order details is set up like this. orderID, productID, quantity. Any suggestions would be appreceiated. Thanks, Chuck --

question about date range

2003-01-24 Thread Chuck Barnett
' ; The $date variable equals 20030124% What can I do to get this range selection query to work? Thanks, Chuck Barnett - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

copying field x to field y for each record in table

2002-04-03 Thread Chuck Barnett
Hi, how do I do the following: I have a table I have added a new field to, I want to take field X and copy it to the new field for each record. What should this query look like? Thanks, Chuck - Before posting, please check:

Re: query help

2002-03-26 Thread Chuck Barnett
- Original Message - From: [EMAIL PROTECTED] To: Chuck Barnett [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 2:09 PM Subject: Re: query help Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include

HELP PLEASE mysql will not start

2001-07-31 Thread Chuck Barnett
and my server started not working. please help thanks, Chuck Barnett - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

Re: automation question: How do I copy the data from one table to another table with a time stamp every night?

2001-01-24 Thread Chuck Barnett
ot; [EMAIL PROTECTED] To: "Chuck Barnett" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 24, 2001 12:34 PM Subject: Re: automation question: How do I copy the data from one table to another table with a time stamp every night? Chuck Barnett wrote: How do I copy the