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
http://dev.mysql.com/doc/mysql/en/alter-table.html
ALTER TABLE dtd_test ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD
PRIMARY KEY (id);
On Wed, 16 Mar 2005 14:56:59 -0500, Ed <[EMAIL PROTECTED]> wrote:
> Hi all,
> I am using MySQL Command Line and have created a table called dtd_test. It
>
Check out the alter table syntax in the manual at:
http://dev.mysql.com/doc/mysql/en/alter-table.html
On Wed, 16 Mar 2005 14:56:59 -0500, Ed <[EMAIL PROTECTED]> wrote:
> Hi all,
>I am using MySQL Command Line and have created a table called dtd_test. It
> has two varchar fields at the moment
Hello,
a purely "calculated field" ;(one that is calculated from present values in
the row), doesn' t need to be stored at all, just calculate it when someone
needs to see the calculated value.
In other words.. you don't have to store it if you can calculate it from the
present existing field valu
PROTECTED]
Subject: Re: Adding fields
Hi.
On Fri, Jul 06, 2001 at 03:45:48PM -0600, [EMAIL PROTECTED] wrote:
>
> to many hours anyway I am struggling with what seems to be an easy task
but I am stuck.
>
> I am trying to total the fields with numbers (run + swim + bike) from a
racer n
: Re: Adding fields
Hi.
On Fri, Jul 06, 2001 at 03:45:48PM -0600, [EMAIL PROTECTED] wrote:
>
> to many hours anyway I am struggling with what seems to be an easy task
but I am stuck.
>
> I am trying to total the fields with numbers (run + swim + bike) from a
racer name="joe&
Hi.
On Fri, Jul 06, 2001 at 03:45:48PM -0600, [EMAIL PROTECTED] wrote:
>
> to many hours anyway I am struggling with what seems to be an easy task but I am
>stuck.
>
> I am trying to total the fields with numbers (run + swim + bike) from a racer
>name="joe"
> and insert the ammount into a fiel
Thanks but I got it working
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Fri 7/6/01 15:49
SUBJECT: Adding fields
Hi All
to many hours anyway I am struggling with what seems to be an easy task but I am stuck.
I am trying to total the fields with numbers (run
15 matches
Mail list logo
