Re: Problem In Alter Table

2001-08-29 Thread Dan Nelson
In the last episode (Aug 29), abhishek sahay said: > 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 I believe you need to use backtics ` ` to put spaces in fi

Problem In Alter Table

2001-08-29 Thread abhishek sahay
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