alter table query

I have a table that has a column : session_id INTEGER UNSIGNED NOT NULL, I now want to store a hexadecimal value in this column instead. the column already contains values for some records.can I alter the data type of this column (make it a varchar) without loosing the data already stored?

Re: alter table query

If you are unsure you should make a copy of the table and perform you test actions on that table. The answer is yes you can convert your unsigned integer column to a varchar column. On Mon, 05 Apr 2004, joe collins wrote: I have a table that has a column : session_id INTEGER UNSIGNED NOT

Re: alter table query

If you are unsure you should make a copy of the table and perform you test actions on that table. The answer is yes you can convert your unsigned integer column to a varchar column. Yep, first make a backup copy of your table, then alter the column to varchar type. To convert the existing

alter table - query help

Hello everyone I want to alter 50 tables, and for each the names start with the string 'mak' Is there an SQL query, so that I can do the change in one command. I have tried using wildcards - they don't seem to work in SQL. Thanks in advance. Aman

Alter table Query

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