creating database

[Jeremy Morano]

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?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

copy tables to another db

[Jeremy Morano]

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/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

print

[Jeremy Morano]

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:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

print

[Jeremy Morano]

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/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

column_name

[Jeremy Morano]

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   bad bad
My second record isJane  Doe  555- good
goodbad

I would like to know which movies Jane Doe rated good'...Is
this possible and if so how?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

limited records

[Jeremy Morano]

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 tables the
same way as all my other functional records...Can anybody tell me something
that I might have missed or anything to help me out?


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Delete

[Jeremy Morano]

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 anyone
help me out?


Delete from table1 where table1.value = table2.value



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

joining tables

[Jeremy Morano]

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 ...);

insert into table_2
(phone,fax,???)
values
(999-, 555-, );

Please replace the ???..thanx




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php