View problems

All:
I am trying to create this view in Mysql 4.1.1 and keep getting an
error. Here is my create view stanza and the error message I get. Any
ideas anyone?

mysql> create or replace view otr_titles as
-> select title, subtitle, cd_id cd#,
-> num_of_episodes episodes, undated_episodes undated,
-> start_date startdate, end_date enddate
-> from otrcds_by_name otn, otrcds_by_date otd
-> where otn.otr_id = otd.otr_id
-> order by 1, 3, 2;
ERROR 1064 (42000): 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
'or replace view otr_titles as select title, subtitle, cd_id cd n' at line 1

Keith Lee wrote:
> All:
> I am trying to create this view in Mysql 4.1.1 and keep getting an
> error. Here is my create view stanza and the error message I get.
> Any ideas anyone?
>
> mysql> create or replace view otr_titles as
> -> select title, subtitle, cd_id cd#,
> -> num_of_episodes episodes, undated_episodes undated,
> -> start_date startdate, end_date enddate
> -> from otrcds_by_name otn, otrcds_by_date otd
> -> where otn.otr_id = otd.otr_id
> -> order by 1, 3, 2;
> ERROR 1064 (42000): 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 'or replace view otr_titles as select title,
> subtitle, cd_id cd n' at line 1


I'm not that proficient with MySQL, but I suspect:

cd_id cd#

should be

cd_id AS 'cd#'

AS is not required, but I use normally to keep things clear.

I'm not sure how the professionals think about it but I'd suggest:
1. Always use backtick (`) around fieldnames.
2. Always use quotes (') around text.

Grtz,
--
Rik Wasmus

"Keith Lee" <cmarvel@NOSPAMnethere.com> schreef in bericht
newsan.2006.05.24.13.40.21.493802@NOSPAMnethere. com...
> All:
> I am trying to create this view in Mysql 4.1.1 and keep getting an
> error. Here is my create view stanza and the error message I get. Any
> ideas anyone?
>
> mysql> create or replace view otr_titles as
> -> select title, subtitle, cd_id cd#,
> -> num_of_episodes episodes, undated_episodes undated,
> -> start_date startdate, end_date enddate
> -> from otrcds_by_name otn, otrcds_by_date otd
> -> where otn.otr_id = otd.otr_id
> -> order by 1, 3, 2;
> ERROR 1064 (42000): 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
> 'or replace view otr_titles as select title, subtitle, cd_id cd n' at line
> 1

Views in V4???
I thought this was a V5 feature.

On Fri, 26 May 2006 13:46:50 +0200, spamtoyou wrote:

>
> "Keith Lee" <cmarvel@NOSPAMnethere.com> schreef in bericht
> newsan.2006.05.24.13.40.21.493802@NOSPAMnethere. com...
>> All:
>> I am trying to create this view in Mysql 4.1.1 and keep getting an
>> error. Here is my create view stanza and the error message I get. Any
>> ideas anyone?
>>
>> mysql> create or replace view otr_titles as
>> -> select title, subtitle, cd_id cd#,
>> -> num_of_episodes episodes, undated_episodes undated,
>> -> start_date startdate, end_date enddate
>> -> from otrcds_by_name otn, otrcds_by_date otd
>> -> where otn.otr_id = otd.otr_id
>> -> order by 1, 3, 2;
>> ERROR 1064 (42000): 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
>> 'or replace view otr_titles as select title, subtitle, cd_id cd n' at line
>> 1
>
> Views in V4???
> I thought this was a V5 feature.

Where I can get V5 rpms?

Keith