Thanks Joerg. You are very correct.
On Thu, Oct 1, 2009 at 2:40 PM, Joerg Bruehe wrote:
> Hi!
>
>
> prabhat kumar wrote:
> > You can use :
> >
> > *ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
> >
> > it will add new column after last.
> >
> > but you can also specify
Hi!
prabhat kumar wrote:
> You can use :
>
> *ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
>
> it will add new column after last.
>
> but you can also specify the particular column after you want to add.
>
> like.
>
> *ALTER TABLE it ADD COLUMN title varchar(25), p
You can use :
*ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6);*
it will add new column after last.
but you can also specify the particular column after you want to add.
like.
*ALTER TABLE it ADD COLUMN title varchar(25), phone number integer (6) AFTER
pusername; *
check
Hello Carlos,
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this case. I created a database called 'staff' and
then in that database I created one simple table:
mysql> show tables;
+---
If you are very new, you may want to go through the tutorial at w3shools:
http://www.w3schools.com/SQl/default.asp
Regards,
- Robert
On Wed, Sep 30, 2009 at 11:45 AM, Carlos Williams wrote:
> I am no doubt very new to MySQL and have been studying the on line
> manual however I find it a bit com
On Wed, Sep 30, 2009 at 1:11 PM, mos wrote:
> Carlos,
> Â Â Get a free copy of SqlYog (Community edition).
> http://code.google.com/p/sqlyog/
Thanks but I don't have any GUI's installed on my machine I manage the
database on or from. I am also trying to learn in case things break
and I only have
Carlos,
Get a free copy of SqlYog (Community edition).
http://code.google.com/p/sqlyog/
Mike
At 11:45 AM 9/30/2009, you wrote:
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this c
alter table it add title varchar(50);
"Carlos Williams" escreveu na mensagem
news:d80f793f0909300945n73394480j468c2cf76dc9c...@mail.gmail.com...
>I am no doubt very new to MySQL and have been studying the on line
> manual however I find it a bit complex and don't understand what it's
> suggestin
I am no doubt very new to MySQL and have been studying the on line
manual however I find it a bit complex and don't understand what it's
suggesting I do in this case. I created a database called 'staff' and
then in that database I created one simple table:
mysql> show tables;
+-+
|
