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?
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
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
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
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