CSV-to-SQL?

Thanks to everyone who helped me with my question below. Here is the solution I found: 1. I found a website that has a CSV-to-SQL utility. Halfway down the page you'll see a form where you can upload a CSV file and it will display corresponding SQL statements, both to create the table and

Recreating primary index on MyIsam table

Hi MySQL fans ;-), I was just asked recently with the task to recreate a tables index gracefully on a MyIsam table. This is the table layout: CREATE TABLE `cl` (   `c_serial` int(11) NOT NULL auto_increment,   `cname` tinytext NOT NULL,   `cl_vals` text NOT NULL,   `utime` int(11) NOT NULL

Re: Recreating primary index on MyIsam table

Nils, So the task is to recreate the current primary key (c_serial),so that the current index would start with 1,2,3,4, SET @i=0; UPDATE c1 SET c_serial=(@i:[EMAIL PROTECTED]); PB - Nils Valentin wrote: Hi MySQL fans ;-), I was just asked recently with the task to recreate a tables index

Find valid numeric values in a string field?

I have a column like this my_col varchar(20) null. The values in the column can be text or numbers. How can I select only those rows where the value in this column is a valid number? I need something like IS_DECIMAL(), but I can't find that function. The following SQL fails to do the job

retrieving a value from mysql and use it later

Hi, I would like to ask about how to retrieve a value from mysql and use it later. What I mean is like this my $ref = $sth-fetchall_arrayref(); foreach my $row (@$ref) { my ( $passengerIndex, $passengerName, $passengerEmailAddress, $passengerLoginPassword ) = @$row; my $new = $passengerIndex;

Re: retrieving a value from mysql and use it later

On Apr 10, 2005, at 11:30 AM, Eko Budiharto wrote: Hi, I would like to ask about how to retrieve a value from mysql and use it later. What I mean is like this This is really a perl question, not mysql. my is a scoping operator. Variables declared with my disappear when they go out of scope.

Re: Recreating primary index on MyIsam table

Hi Peter, thanks a bunch, I new that it must have been something simple like this. I am just no programmer. ;-) Thanks a bunch !! Best regards Nils Valentin Tokyo / Japan On Sunday 10 April 2005 23:41, Peter Brawley wrote: Nils, So the task is to recreate the current primary key

Getting Started with MySQL

Help, please, for a beginner to mysql, but with a (long time ago) background in 'C'. 1. I can install and get running version 4.1.11-nt of mysql. I cannot ugrade this to version 5 - it simply will not install properly depite doing all the things it says in the documentation. I hope to use the

Re: UDF Request AGGLOM()

Hi Dan, On Sat, 2005-04-09 at 02:59, Dan Bolser wrote: Who can I prod about setting up a UDF repo at MySQL. I think 'they' should do this ;) Yep it's an existing idea, a very good one, and it's on the todo. Putting such an infrastructure into place will take some time though. Would a special

foreign key design stratgies

Hey folks - I'm having a little problem understanding ON DELETE foreign key constraints. Here's my options from the manual: [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION | SET DEFAULT}] When do I use each one? I can find anything in the online manual that suggests how to construct a

Warning

I;m using redhat linux 9.0 and MySQL 4.1.9 I found this lines on my log file 050411 11:31:50 [Warning] Asked for 196608 thread stack, but got 126976 050411 11:31:50 [Warning] Asked for 196608 thread stack, but got 126976 Is it bad ? -- MySQL General Mailing List For list archives: