> 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 dec
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
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?
o
On Tue, Apr 09, 2002 at 09:38:47AM -0500, Aman Raheja wrote:
> 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.
Nope. You need an outside programming language to do it.
Jeremy
--
Jeremy D. Zawo
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
__
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
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
