Re: Copy large amount of data from non-normalized to normalized table

ltiple rows in the INSERT: (id, 1, c1), (id, 2, c2), (id, 3, c3). Afaik there is no such thing so I need an equivalent method - one that isn't going to kill my server (like the several attempts I've made so far!) Run 30 INSERT ... SELECT ... One for each column. -- René Seindal

Re: How to best accomplish selecting string (unless it is null)

> > I would like the select statement to return: > Key | Str > 0 | "str1" > 1 | "string" > 2 | NULL > > How possible is this? select coalesce(str1, str2); > > Adam Clauss > [EMAIL PROTECTED] > > -- René S

Estimating size of a MySQL Heap table?

ve no affiliation with webmasterworld, besides being a user of the site. sql,query -- René Seindal ([EMAIL PROTECTED]) http://sights.seindal.dk/   - Before posting, please check: http://www.mysql.com/manual.php

Re: how to check if table exists?

; >> Try to create the table, and catch the error? > > >> Other options? > > What about > > show tables like 'TABLE'; > > If TABLE exists it returns a row, otherwise the empty set. > > -- > René Seind