mysql database

[geevaa]

how to copy a database or table in a database to my pen drive? In
which path the MYSQL database and tables will be stored?

i just wanto insert a new fieldname(colum n)in my table .. not as the
last column but at the middle (say insert as 3rd fieldname)
what is the MYSQL query used to alter a table with the above said
condition?

[Erwin Moller]

Re: mysql database

geevaa wrote:

how to copy a database or table in a database to my pen drive? In
which path the MYSQL database and tables will be stored?

Hi,

Why not rftm? (hint: mysqldump)
And since Jerry is not online yet: Why not ask in a mysql newsgroup?

>
i just wanto insert a new fieldname(colum n)in my table .. not as the
last column but at the middle (say insert as 3rd fieldname)
what is the MYSQL query used to alter a table with the above said
condition?

Why not rftm? (hint: lookup in the index 'alter table')
And since Jerry is not online yet: Why not ask in a mysql newsgroup?

Regards,
Erwin Moller

PS: What is a pen drive?

[geevaa]

Re: mysql database

On Mar 27, 12:44 pm, Erwin Moller
<since_humans_r ead_this_I_am_s pammed_too_m... @spamyourself.c omwrote:

geevaa wrote:

how to copy a database or table in a database to my pen drive? In
which path the MYSQL database and tables will be stored?

>
Hi,
>
Why not rftm? (hint: mysqldump)
And since Jerry is not online yet: Why not ask in a mysql newsgroup?
>
>
>

i just wanto insert a new fieldname(colum n)in my table .. not as the
last column but at the middle (say insert as 3rd fieldname)
what is the MYSQL query used to alter a table with the above said
condition?

>
Why not rftm? (hint: lookup in the index 'alter table')
And since Jerry is not online yet: Why not ask in a mysql newsgroup?
>
Regards,
Erwin Moller
>
PS: What is a pen drive?

pen drive is some thing like thumb drive