Using the last_insert_id() function

Hi everyone, I¹m trying to figure out the best sequence to enter data into my database (the SQL code for the structure is included below). If I have a number of tab delimited .txt files containing the data for the different tables, I thought as a first step I could use the following code to popula

Exporting blob / text column with hyphen delimited text

Hi all! I have a table that contains a column (blob, text type, formatted as MEDIUMTEXT) with text hyphen (-) delimited, listing rooms by numbers, and I need to export or insert that data into another table, where all other info on the other columns remains the same, but I need the data on the

Re: Find and Add Unmatched Records

Hi John, Yes, that looks right to me. Baron Kebbel, John wrote: Same situation, but let's say it's not preceding_quarter and current_quarter for the table names. To make the flow of records more clear, let's say the one I was calling preceding_quarter is now called keepers and the one I called

Re: Data migration Verification

Besides the sample approach, output data (a set you would output on a live system anyway) from both db setups and see if you can get the same output from both Olaf On 6/1/07 10:35 AM, "paulizaz" <[EMAIL PROTECTED]> wrote: > > Hi all, > > I have somebody creating a C# class to migrate data fr

RE: Find and Add Unmatched Records

Same situation, but let's say it's not preceding_quarter and current_quarter for the table names. To make the flow of records more clear, let's say the one I was calling preceding_quarter is now called keepers and the one I called current_quarter is now called pickThroughThenDelete. I'll delete the

Re: Find and Add Unmatched Records

Hi John, Kebbel, John wrote: I have a table of middle school students I want to update quarterly. I am only interested in finding and adding new students (not in finding and deleting students who have been dropped from the school district). I'm pretty sure I could put together a PHP script that

Data migration Verification

Hi all, I have somebody creating a C# class to migrate data from one SQL database to another slightly differently structured SQL database. Please can anybody suggest ways to verrify that the data has migrated successfully, in whole and acurrate?? I feel a sample approach would not quite be subs

RE: Find and Add Unmatched Records

The "REPLACE" staement might work for you... http://dev.mysql.com/doc/refman/4.1/en/replace.html... -Original Message- From: Kebbel, John [mailto:[EMAIL PROTECTED] Sent: 01 June 2007 15:31 To: mysql@lists.mysql.com Subject: Find and Add Unmatched Records I have a table of middle schoo

Find and Add Unmatched Records

I have a table of middle school students I want to update quarterly. I am only interested in finding and adding new students (not in finding and deleting students who have been dropped from the school district). I'm pretty sure I could put together a PHP script that would do this, but is there a My

Re: Server/Client connection compression

Hi, Giorgio Zarrelli wrote: Hi, I saw that to enable server/client protocol compression I can start mysql with the "-C" option. Is there a configuration keyword to write in my.cnf to enable server/client protocol compression? Yes. In general, most command-line options can be written into

Re: error while doing a select

Hi, Ananda Kumar wrote: Hi All, We are using mysql version 5.0.40. We took a snapshot of the our database, and copied over the snapshot to anther machine and start mysql on the new snapshot. Its innodb engine when i treid to select from one of the tables i am getting this error, how do i fix t

error while doing a select

Hi All, We are using mysql version 5.0.40. We took a snapshot of the our database, and copied over the snapshot to anther machine and start mysql on the new snapshot. Its innodb engine when i treid to select from one of the tables i am getting this error, how do i fix this ,please help select c

MySQL 5.1.19-beta has been released

Dear MySQL users, We are proud to present to you the MySQL Server 5.1.19 Beta release, a new Beta version of the popular open source database. Bear in mind that this is a beta release, and as any other pre-production release, caution should be taken when installing on production level systems or

Endianness

I am an experienced Oracle DBA, but new to MySQL. I have been tasked with moving a number of MySQL 4.1 servers from a Solaris 7 SPARC environment to Solaris 10 x86. The most significant difference between these environments is the endianness of the hardware. My question is - Which of the MySQL

Server/Client connection compression

Hi, I saw that to enable server/client protocol compression I can start mysql with the "-C" option. Is there a configuration keyword to write in my.cnf to enable server/client protocol compression? Thanks Giorgio Zarrelli -- MySQL General Mailing List For list archives: http://lists.mysql.