Re: After backup/restore view turns to table

Hi All ! I did "mysqldump mydb -uroot -ppass --databases --add-locks --allow-keywords --create-options --extended-insert --routines -r file.sql" and after that in MySQL Command Line Client "source file.sql" After that my view was converted to an empty table. What should I do to backup and

After backup/restore view turns to table

Hi All ! I did "mysqldump mydb -uroot -ppass --databases --add-locks --allow-keywords --create-options --extended-insert --routines -r file.sql" and after that in MySQL Command Line Client "source file.sql" After that my view was converted to an empty table. What should I do to backup and r

Re: SELECT from 3 tables - Need help

I would like to do a SELECT that would return all the fields in the 'Quotes' table plus the client info and plus the product info but only if available. If product info is not available I would like to get a result having all 'Quotes' info and 'Clients' info. My query is: SELECT * FROM `Quote

Re: a lil sql help please.

At 18:51 9.7.2006, you wrote: Hi, I have the following Query and Im a lil lost on this one SELECT DISTINCT tbe_orders.order_id, tbe_orders.order_date, tbe_orders.order_piececount FROM tbe_orders SELECT tbe_orders.order_id, tbe_orders.order_date, sum(tbe_orders.order_piececount) FROM t