Newbie MySQL question

[Willow]

I'm pretty much a newbie with installing php scripts. I know you can have several scripts under one database, but do you have to make a different user for each script, or can I use the same user under the same database for all the scripts I want to use?

 

[kabatak]

yes you can use one database

 

[EpidemiK]

Yes you can, just use a different table prefix for each script.

 

[Willow]

Ok, thanks...I got another question though. How do you set up different table prefix? lol, sorry, like I said, I'm a newbie

 

[NukedWeb]

It's not really something you set, any time you're asked for a table name, prefix the table name with something. You can't have 2 tables in the same database with the same name, so you have to do what you have to to make the table names diferent.

 

[georgec]

An sample syntax to creating a table would be:

create table myprefix_table1(
field1 int unsigned,
field 2 text
)