exporting ascii codes from db fields

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 of

restore from mysqldump file

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 dat

command line login question

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 suggestions?

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

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 -- My

question about date range

$date' ; 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

Re: Query help

Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "'Chuck Barnett'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 11:06 AM Subject: RE: Query help > SELECT * FROM mytable WHERE first_name=$first && last_name

Query help

Hi. I have two fields, firstname, lastname. I populate a select box with the firstname lastname. Now when a user selects a name and hits submit, the program will(should) select * from table where the selected name equal firstname+lastname. I guess you have to some how put the first and last na

copying field x to field y for each record in table

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

- 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. T

HELP PLEASE mysql will not start

p 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 t

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

y" <[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

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

How do I copy the data from one table to another table with a time stamp every night? example: table A contains x,y,z. at midnight, I want to copy table A's contents to table B (B has same fields, just adds a date field) and reset x,y,z to zero. my setup is a cobalt raq4i MySQL 3.22.32 Thank