[TriLUG] MySQL - Alter Table command

[Justin Skinner]

My SQL is a bit rusty, but did you include the semicolon ?

On 11/24/06, Michael Rulison <13miketele at bellsouth.net> wrote:
>
> I am trying to catenate two columns from b onto c, making sure that the
> field 'name' is matched before each record is added with the following
> sql:
>
> ALTER TABLE cust_extract AS c ADD COLUMN prev_billing_date,
> ADD COLUMN next_billing_date FROM billing AS b WHERE c.name = b.name
>
> I get this error message:
>
> #1064 - You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'as c add column prev_billing_date
> FROM billing AS b
> WHERE c.name = b.name' at line 1
>
> With thanks to those with sharper eyes than mine,
>
> Mike Rulison
> ------------------------------------------------------------------------
> Go to source>>
> <http://mysql.meetup.com/144/boards/view/viewthread?thread=2439669>
> --
> TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ  : http://trilug.org/faq/
> TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
>



-- 
Justin Skinner
http://www.180mph.com
Powered by Electricity & NetBSD - http://www.netbsd.org