Well it is Cable Plant not Cable Planet.
abhishek sahay wrote:
> STEP 1: status ->SUCCESS
> -------
> mysql> CREATE TABLE pod_rating select h.he_headend_id 'Cable
> Plant',sk.tf_air_date,d.em_dma DMA,d.em_tv_households 'Households
> TVs',d.em_us_percent Population,p.tf_title 'Program Name',sk.tf_air_time
> Time,st.tf_station_call_sign Network from prog_rec p,stat_rec
> st,sked_rec sk,lineup l,headend h,dma d where
> sk.tf_database_key=p.tf_database_key and
> sk.tf_station_num=st.tf_station_num /* and sk.tf_air_date='2001-04-16'*/
> and st.tf_station_num=l.cl_station_num and
> l.cl_headend_id=h.he_headend_id and h.he_headend_id='NY31656' and
> d.em_rank=1 GROUP BY 6,8 ORDER BY 2,8,7;
> Query OK, 3918 rows affected (2 min 16.73 sec)
> Records: 3918 Duplicates: 0 Warnings: 0
>
>
> STEP 2: status ->SUCCESS
>
> mysql> desc pod_rating;
> +----------------+----------------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +----------------+----------------------+------+-----+---------+-------+
> | Cable Plant | char(7) | | | | |
> | tf_air_date | date | YES | | NULL | |
> | DMA | char(75) | | | | |
> | Households TVs | int(11) | | | 0 | |
> | Population | decimal(5,3) | YES | | NULL | |
> | Program Name | char(120) | | | | |
> | Time | smallint(5) unsigned | YES | | NULL | |
> | Network | char(10) | YES | | NULL | |
> +----------------+----------------------+------+-----+---------+-------+
> 8 rows in set (0.00 sec)
>
>
> STEP 3: status ->SUCCESS
>
> mysql> alter table pod_rating change Network Network varchar(15);
> Query OK, 3918 rows affected (0.03 sec)
> Records: 3918 Duplicates: 0 Warnings: 0
>
>
> STEP 4: status ->Fail (why???????)
>
>
> mysql> alter table pod_rating change 'Cable Planet' cable_plant
> varchar(15);
> ERROR 1064: You have an error in your SQL syntax near ''Cable Planet'
> cable_plant varchar(15)' at line 1
> mysql> alter table pod_rating change "Cable Planet" cable_plant
> varchar(15);
> ERROR 1064: You have an error in your SQL syntax near '"Cable Planet"
> cable_plant varchar(15)' at line 1
> mysql> alter table pod_rating change Cable Planet cable_plant varchar(15);
> ERROR 1064: You have an error in your SQL syntax near 'cable_plant
> varchar(15)' at line 1
> mysql> alter table pod_rating change Cable Planet cable_plant;
> ERROR 1064: You have an error in your SQL syntax near 'cable_plant' at
> line 1
> mysql> alter table pod_rating MODIFY 'Cable Planet' char(10);
> ERROR 1064: You have an error in your SQL syntax near ''Cable Planet'
> char(10)' at line 1
>
>
> Question:
> 1.I have executed these query in MySQL prompt.I got the correct result
> in step1,2 and step 3 BUT I am not getting correct result in step
> 4.Could you please tell me how to change OR modify "caple planet"
> ,"Households TVs","Households TVs" fields.
> 2.Is this the problem with MySQL or with my query?
> 3.I know that while creating table I should not use blank space in a
> field but by mistake i had used space in a field and I was surprised
> that table has created successfully instade of giving logical error.
>
> Waiting for reply...
> Regards,
> Abhi
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php