copy tables to another db

Hi there I was wondering how to copy tables from one db to the another? can't find it in the manual... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th

creating database

Hi there, I'm having a hard time creating a databae... My db name is pool and my mySql username is contact. This is what I did... GRANT ALL ON pool.* TO contact CREATE DATABASE pool; The result was access denied... What do I do? -

print

I am having a hard time printing Select * from table_1 \p; the result is: -- Select * from table_1 -- . . . But it doesn't print. Anyone? - Before posting, please check

print

Hi, very simple question. I would like to save and print the contents of myDESCRIBE table_1; How would I do this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

im puzzled

Hi , this is my query SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; this works correctly. The results are what they are supposed to be: However, when I change the = sign to a <> or !=, The results are completely incorrect. -- picks.user_i

column_name

Hi , I was wondering if there was a way to retreive a column_name instead of a value in an sql select query? For example if my table has the fieldfirstname, lastname, telephone, movie1, movie2, movie3.. And my first record is JohnDoe 555- good ba

limited records

Hi, I just created a table which only accepts one record. I can delete and then add a record but I can't have more than one record at the same time. I have another table which only accepts 10 records . I can delete and then add records but I can't have more than 10 records. I created these table

Delete

Hi, im trying to delete a record from a table where the value of a field must be equal to the value of a field of another table.I know this is wrong but I need to show you what I mean. I think I'm missing a very important select statement to join them...can anyo

joining tables

Hi, I would like to know how to create a field that comes from another table and how to insert values from a table into another one. kind of like this table_1 uid1 ...(primary key) first_name ... last_name ... craete table table_2 ( uid2...(primary key) phone... fax... table_1.uid1 ...); inse