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;
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; *
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), phone
Thanks Joerg. You are very correct.
On Thu, Oct 1, 2009 at 2:40 PM, Joerg Bruehe joerg.bru...@sun.com 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
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;
+-+
|
alter table it add title varchar(50);
Carlos Williams carlosw...@gmail.com 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
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
On Wed, Sep 30, 2009 at 1:11 PM, mos mo...@fastmail.fm 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
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 carlosw...@gmail.com wrote:
I am no doubt very new to MySQL and have been studying the on line
manual however