Strange select problem

Dear all, I've encountered a very strange problem. I dumpped one table from a database and then import it into another database. I works successfully, all the data is exactly the same. But when I the below SQL on two tables: select * from foo_table ORDER BY id DESC it shows up different result. A

RE: What's the best way to INSERT a long list of email addresses and names into a TABLE?

I don't know; never tried it that way _ From: axis [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 9:37 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: RE: What's the best way to INSERT a long list of email addresses and names into a TABLE? HTML_MESSAGE,MIME_HTM

What's the best way to INSERT a long list of email addresses and names into a TABLE?

I have a long list of email addresses, and names in a text file in csv format, and I want to know what's the best approach to quickly INSERT them into my customers TABLE. Initially I thought it could be easy to just add SQL INSERTs to the database dump but, the problem is I have to manually add so

RE: What's the best way to INSERT a long list of email addresses and names into a TABLE?

Presuming your csv is set up in the structure of your table - this may help BULK INSERT tablename FROM 'C:\filelocation\my_data.csv' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR ='\n' ) I am going through a SQL class and this is the method we are using to bulk

What's the best way to INSERT a long list of email addresses and names into a TABLE?

Hi, I have a long list of email addresses, and names in a text file in csv format, and I want to know what's the best approach to quickly INSERT them into my customers TABLE. Initially I thought it could be easy to just add SQL INSERTs to the database dump but, the problem is I have to manuall

RE: Getting next Birthdays

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html Read the comments at the bottom. DÆVID > -Original Message- > From: ESV Media GmbH [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 06, 2006 8:05 AM > To: mysql@lists.mysql.com > Subject: Getting next Birthdays

Re: Restarting MySQL on Solaris 8?

> - Original Message - > From: "Jay Paulson" <[EMAIL PROTECTED]> > To: > Sent: Friday, September 08, 2006 9:51 PM > Subject: Restarting MySQL on Solaris 8? > >>A couple questions since I'm not a Solaris person I really don't know how >>to >> do the following and was hoping that someone co

Re: query to find duplicate rows

Hi all, a though query problem for me... I have a table with 2 rows that matter: url and id If url and id are the same in 2 rows, then that's no good (bad data). I need to find all the rows that are duplicates. I can't think of how to approach the sql for this.. any pointers? Select COUNT(*)

Re: query to find duplicate rows

Select COUNT(*) as num_entries, url from table WHERE num_entries>1 GROUP BY url Untested, but the concept should work for you. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Peter Van Dijck wrote: Hi all, a though query problem for me... I have a table with 2 rows that m

query to find duplicate rows

Hi all, a though query problem for me... I have a table with 2 rows that matter: url and id If url and id are the same in 2 rows, then that's no good (bad data). I need to find all the rows that are duplicates. I can't think of how to approach the sql for this.. any pointers? Thanks! Peter --

Re: Distinct select over 2 fields?

You could try using CONCAT: select distinct(CONCAT(lat, long)) from table where ... Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Brian Dunning wrote: Lat & lon are two different fields. Either can be duplicated, but not both. On Sep 12, 2006, at 12:33 PM, Steve Musume

Re: MySQL tuning advice

Really you need to look at what your server is doing, the traffic patterns, then you can tune. There is a lot you can determine by just looking at the output of SHOW STATUS and SHOW VARIABLES. Threads_created number high and growing? Increase the thread_cache_size variable. Opened_tables number

Re: Distinct select over 2 fields?

Lat & lon are two different fields. Either can be duplicated, but not both. On Sep 12, 2006, at 12:33 PM, Steve Musumeche wrote: Select DISTINCT(lat_long_field) from table where... Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Brian Dunning wrote: Many different recor

Re: Distinct select over 2 fields?

Select DISTINCT(lat_long_field) from table where... Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Brian Dunning wrote: Many different records will be returned though, I just don't want any dupes where both lat/lon is the same. :) On Sep 12, 2006, at 12:20 PM, Hiep Nguye

Re: Distinct select over 2 fields?

Many different records will be returned though, I just don't want any dupes where both lat/lon is the same. :) On Sep 12, 2006, at 12:20 PM, Hiep Nguyen wrote: select * from table where . limit 1 that would do it if you don't care which one it returns JC On Tue, 12 Sep 2006, Brian Dun

Re: Distinct select over 2 fields?

select * from table where . limit 1 that would do it if you don't care which one it returns JC On Tue, 12 Sep 2006, Brian Dunning wrote: > I'm searching a database of geopoints, and when two records have the > same latitude and longitude, I only want to return one of them - > basically

Distinct select over 2 fields?

I'm searching a database of geopoints, and when two records have the same latitude and longitude, I only want to return one of them - basically just find all the unique locations. How do you set up a select like this? Thanks... -- MySQL General Mailing List For list archives: http://lists.m

Re: MySQL tuning advice

I highly recommend Jeremy Zawodny's "High Performance MySQL" from O'Reilly. Dan On 9/12/06, Gregory T Pelle <[EMAIL PROTECTED]> wrote: Hello, I am looking for some advice regarding the tuning of a dedicated MySQL database server. The machine in questions is a Dell 2850 with dual Xeon procs a

MySQL tuning advice

Hello, I am looking for some advice regarding the tuning of a dedicated MySQL database server. The machine in questions is a Dell 2850 with dual Xeon procs and 4GB of memory running FreeBSD 6.1. Its sole purpose in life is to run the MySQL 5.0.x database engine serving out databases to mult

Re: resources for tuning

Josh, I highly recommend Jeremy Zawodny's "High Performance MySQL" from O'Reilly. It's written for 4.1 users, so would be perfect for you. Dan On 9/12/06, Josh Trutwin <[EMAIL PROTECTED]> wrote: Hi, We just upgraded our server's RAM from 1 GB to 5 GB - I'd like to now make some adjustments in

anyone using subversion to sync mysql dbs ?

Is anyone using subversion to sync live and development databases? If so, how? Is this desired or a best practice? Everything except my databases are under version control. In theory, I would like my databases to sync with the same subversion 'svn update' command. That way, all web content up

RE: 2 versions of mysql on Unix: problem with the socket

Thank you for your answer. Here is what I did cd /seqweb/mysqlhome mercure{mysql}140: more .my.cnf # The following options will be passed to all MySQL clients [client] user= mysql password= port= 3306 socket = /tmp/mysql4.sock # Here follows entrie

Re: 2 versions of mysql on Unix: problem with the socket

Duhaime Johanne wrote: I am running mysql 4.1.7 on solaris 9. I want to install 2 versions (versions 4.1.7 and 5) on the server. I am reconfiguring my scripts in that perspective. I have a script that start the mysql v4 so that I finally have: 7002 pts/4S 0:00 /bin/sh /seqweb/mysql4/bi

Duplicate Messages

Overnight (Monday night US time) I was receiving some duplicate messages (not ones addressed to me specifically). Has this been fixed? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341

Re: storing URL 2083 characters

the urls never repeat. and it's a very active table so I don't wanna compress right now. And you're right, most URLs are < 255chars, but some are bigger, so can't use varchar. I guess I'll just use TEXT :) Thanks! Peter On 9/12/06, Mike Wexler <[EMAIL PROTECTED]> wrote: Peter Van Dijck wrote:

RE: Moving database to another machine

I am receiving some messages an extra time, also. It seems that something is wrong with the list server. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Nico Sabbi [mailto:[EMAIL

RE: myisam primary key with innodb primary key..

FULLTEXT can only be used with ISAM tables. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Lakshmi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 12, 2006 3:29 AM To: mysql@l

resources for tuning

Hi, We just upgraded our server's RAM from 1 GB to 5 GB - I'd like to now make some adjustments in my.cnf to better tune my server to this new memory amount. I was looking in the MySQL 4.1.21 source dir's support-files at the example my.cnf files provided with the distribution, but these seem hor

Re: storing URL 2083 characters

Peter Van Dijck wrote: Hi, URL's have a practical limit of 2083 characters it seems. To store these in a space efficient way (I have 1,000,000s of url rows), what's the best approach? varchar has a 255 maximum, right? Should I just use TEXT? I'm not searching *in* the urls, I am selecting like th

Re: storing URL 2083 characters

Hi Peter, I'd thought I'd just mention that the varchar length depends on your MySQL version and character set. 5.0.3 and later handles upto 64k chars. See: http://dev.mysql.com/doc/refman/5.0/en/char.html /Johan Peter Van Dijck skrev: Hi, URL's have a practical limit of 2083 characters it seem

2 versions of mysql on Unix: problem with the socket

I am running mysql 4.1.7 on solaris 9. I want to install 2 versions (versions 4.1.7 and 5) on the server. I am reconfiguring my scripts in that perspective. I have a script that start the mysql v4 so that I finally have: 7002 pts/4S 0:00 /bin/sh /seqweb/mysql4/bin/mysqld_safe --defaults

SQL

Is there anyone who has EXTENSIVE sql experience that is available for consulting? This is a short term opportunity for a single project. Maybe an couple hours tops to assist in some COMPLEX queries that do totals and the like across multiple tables. This is NOT for an amateur. IF you can handle CO

Re: Moving database to another machine

Or you can do this to combine the two steps together shell>mysqldump --all-databases -uuser -ppassword | gzip | ssh [EMAIL PROTECTED] 'gunzip > dump.sql' Kishore Jalleda http://kjalleda.googlepages.com/mysqlprojects On 9/12/06, Visolve DB Team <[EMAIL PROTECTED]> wrote: Hi, Try, Compre

Re: IN & ANY subqueries

Or perhaps add a TEXT index to the table? Peter On 9/6/06, Philippe Poelvoorde <[EMAIL PROTECTED]> wrote: 2006/9/5, Ben Lachman <[EMAIL PROTECTED]>: > So possibly a better solution would be to create a temporary table > and then do a subquery on that table? yes. Or do a : SELECT id FROM t1 WHE

storing URL 2083 characters

Hi, URL's have a practical limit of 2083 characters it seems. To store these in a space efficient way (I have 1,000,000s of url rows), what's the best approach? varchar has a 255 maximum, right? Should I just use TEXT? I'm not searching *in* the urls, I am selecting like this: "where url = 'xxx'".

Re: Has InnoDb licensing changed to accommodate Oracle?

Mike, Oracle Corp. and MySQL AB renewed the InnoDB OEM contract in spring 2006. The licensing of InnoDB is the same as before and it is distributed in the official MySQL distros. Best regards, Heikki Tuuri CEO of Innobase Oy VP of Oracle Corporation Has Oracle placed any restri

Re: mysql driver for C++

check out mysql++ I dont think there is a package but configure, make, makeinstall works for me (on FC5, with mysql++ 1.7.40 and 2.1.1) - Original Message From: Shain Lee <[EMAIL PROTECTED]> To: MySql Sent: Tuesday, September 12, 2006 11:31:02 AM Subject: mysql driver for C++ Hi , C

mysql driver for C++

Hi , Could you please tell me , how can i install C++ , mysql driver in Fedora core 5 ? Is that available for any platforms ? does YUM supports for install mysql c++ ? please help me , its really urgent . Thank you, Shaine. - Yahoo! Cars NEW

Re: Moving database to another machine

Chris wrote: An additional note - you can only do this while mysql is completely shut down. You cannot do this while mysql is running on either server. why is it that I received this mail 3 times? I can understand 2 (one to my and one to the list), but 3 ... -- Email.it, the profess

Re: Moving database to another machine

Nico Sabbi wrote: Ratheesh K J wrote: Hlo all, I wanted to move around 50 GB of data on Machine A to Machine B. Both the machines are of same architecture ( LAMP ) Dumping and restoring takes a lot of time. Is there a faster method to accomplish the same? Is there a way to tar the whole th

Re: Moving database to another machine

Ratheesh K J wrote: Hlo all, I wanted to move around 50 GB of data on Machine A to Machine B. Both the machines are of same architecture ( LAMP ) Dumping and restoring takes a lot of time. Is there a faster method to accomplish the same? Is there a way to tar the whole thing and untar on M

Re: myisam primary key with innodb primary key..

Hi Lakshmi , I guess both treated same . But physical structure of storage is different from Myisam and Innodb . Correct me if iam wrong . Lakshmi wrote: Hi, I want to know is there any difference between myisam primary index vs innodb primary index... -- MySQL General Mailing List Fo

Re: myisam primary key with innodb primary key..

Lakshmi wrote: Hi, I want to know is there any difference between myisam primary index vs innodb primary index... One's for a myisam table one's for an innodb table. They are treated exactly the same - both are unique, both have indexes. -- MySQL General Mailing List For list archives: htt

Enums vs prepared statements

Hi, I try to read enums from a database through the prepared statement API, as a number. The enum is defined e.g., as ENUM('Accept', 'Reject', 'Reject_All') The bind structure is filled in the following way: buffer_type = MYSQL_TYPE_LONG buffer points to an uint32_t buffer_length = 4 length poi

myisam primary key with innodb primary key..

Hi, I want to know is there any difference between myisam primary index vs innodb primary index... -- Regards, Lakshmi.M.P. DBA Support Sify Limited. Extn:4134 ** DISCLAIMER ** Information contained and transmitted by this E-MAIL is proprietary to Sify Limited and is intended

Re: Moving database to another machine

Hi, Try, Compress - [Mac A] shell> mysqldump -all -databases |gzip >dbfilename.sql.gz UnCompress [Mac B] shell> gunzip Thanks ViSolve DB Team. - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 12, 2006 12:13 PM Subject: Moving database to an