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