Re: LEFT JOIN and WHERE: identical or not and what is better?

'where' is a filter. You're limiting records based on a criterion. 'on' is used for joining. On Mon, Apr 25, 2011 at 10:42 AM, Andre Polykanine an...@oire.org wrote: Hello everyone, Sorry for my beginner question. Actually I have been using MySql for a long  time  but  I  just  start  using

better way to backup 50 Gig db?

I'm using MySQL to manage data on my computer . The total data is 50 Gig in MyISAM folders. As I type, I already have the folder with the myd, frm, etc being copied offsite. As I understand it, if this computer dies tomorrow, I can reinstall MySQL on a new computer, drag over the archive, stick

reshaping challenge

I have a table with two columns, ID and order. Each ID can be repeated up to 16 timers. I need to reshape it so that I have one row per ID, and columns order1, order 2,...order 16, and one number that lists how many orders there actually were. No this is not a homework assignment. I'm trying

fast update with 1:1 table?

I have two tables, A and B. B has newer data, A has more columns. I want to update some of the columns in A with all but one of the columns in B. They have the same number of records -- about eight million -- and one key column in common for matching. (That's the one from B I don't want to

getting 64 bit machine -- need to compile workbench?

I've already downloaded the 64 bit build of MySQL to have ready for a 64 bit machine I have coming. But the only available download for Workbench binaries is 32 bit. So I have a few questions: (1) will the 32 bit Workbench work with 64 bit MySQL under Windows XP (64 bit)? (2) if I need to

MyISAM better than innodb for large files?

I'm going to be setting up a MySQL database for a project. My reading indicates that MyISAM (default) is going to be better than InnoDB for the project but I want to be sure I have the trade-offs right. This is going to be a very large data file -- many gigabytes -- only used internally, and

Re: MyISAM better than innodb for large files?

You want the crash safety and data integrity that comes with InnoDB.  Even more so as your dataset grows.  It's performance is far better than myisam tables for most OLTP users, and as your number of concurrent readers and writers grows, the improvement in performance from using innodb over

Re: MyISAM better than innodb for large files?

though, but it does give performance benefits: http://dev.mysql.com/doc/refman/4.1/en/myisampack.html good luck! Walter Heck Engineer @ Open Query (http://openquery.com) On Sat, Apr 3, 2010 at 08:50, Mitchell Maltenfort mmal...@gmail.com wrote: You want the crash safety and data integrity

music.sql with FK from Learning MySQL -- 1005 error?

I've been mucking with the O'Reilly book Learning MySQL for the obvious purpose of learning MySQL. The book offers two versions of a program: http://learningmysql.com/Downloads/Files/Data/SQL_files_with_foreign_key_references/music.sql sticks at creating the track table. However, its sibling

Re: music.sql with FK from Learning MySQL -- 1005 error?

that makes sense except why is that not a problem for flight.sql and university.sql? On 3/22/10, Martin Gainty mgai...@hotmail.com wrote: FOREIGN KEY (album_id) REFERENCES album(album_id)whichever value is being used for to populate album_id is NOT presently as a row in the album table (and

Q on Mysql install on OS X (SNow Leopard)

For some reason, the thing doesn't show the problem I posted already about foreign keys, but what it won't let me do is drop a schema once I've created it. How do I change permissions so MySQL on OS X can delete directories? Thanks! -- MySQL General Mailing List For list archives:

Re: Newbie mysql.sock question

the problem. Paul == Paul Mitchell email: [EMAIL PROTECTED] phone: (919) 962-9778 office: I have an office, room 14, Phillips Hall

Re: Newbie mysql.sock question

On Thu, 16 Jun 2005, Spenser wrote: Try it with an absolute file path instead of a relative one. For instance, /usr/local/mysql/bin/mysqld_safe --user=mysql --datadir = /usr/local/mysql/tmp same old... /usr/local/mysql/bin/mysqld_safe --user=mysql --datadir=/usr/local/mysql/tmp cat

Newbie mysql.sock question

/tmp.mysql.sock, and what it should be pointing to will be a great help. Thanks in advance for any help, Paul Mitchell == Paul Mitchell email: [EMAIL PROTECTED] phone: (919) 962-9778

MySQLGUI Win32 Static Binary

I seem to be downloading a corrupted zip file? Help! ### Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of the National Bank of Malawi Ltd (NBM). The information,

phpmyadmin

Greetings everyone, A quick question: Is phpmyadmin secure? Anyone have an negative experiences having it installed on their server? I found notes on one exploit, but in my google searches did not bring up anything too serious. Regards, Mitchell - sql query

Re: phpmyadmin (OT)

is purely with phpmyadmin. Any advice would be most appreciated, Mitchell On 10/25/02 11:47 AM, Thomas Seifert [EMAIL PROTECTED] wrote: I don't want to start a flame but where do take this from? Every security-hole in php has been fixed shortly after it was known. Its as secure as any other

Query using the same table twice

I am trying to make a query that usses the same table twice. I have a table of scores and a table of teams and the scores table has both the visitors and home team in it as an ID that is in the teams table. I can't get my MySQL statement to work, it does not like the parentheses. SELECT

Optimizing Configuring For Heavy Loads

am new to this level of system administration and have been reading till my eyes blur getting up to speed. Mitchell - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

References to set up a caching mysql box

Hello all We want a fast box which will only handle username/password queries. I got a recommendation to look into a dedicated mysql box, setup so that it apparently caches large amounts of the data from the database in RAM for very fast lookups. Sounds great, but I have never done anything to

Question on maximum record input frequency and table lengths.

in this scenario? Thank you for any help you are able to give, or any resources you can point us to. Michael Mitchell, Principal, DGRI Systems - Before posting, please check: http://www.mysql.com/manual.php (the manual

REAL MONEY

, materials and opportunity to become financially independent. IT IS UP TO YOU NOW! MORE TESTIMONIALS My name is Mitchell. My wife, Jody and I live in Chicago. I am an accountant with a major U.S. Corporation and I make pretty good money. When I received

RE: mySQL databases over two drives

You can do this with NT Server as well. It is called Distributed File System (DFS). You may have to download it from Microsoft but it is free. I think it is built into Win 2000. You will have to muck around in the documentation for the details. HTH Tracy -Original Message- From:

Porting Access to MySQL

Hi, I have a user who want to move there database from Access to MySQL. Are there tools available to make the conversion simple, or what is the best way of going about this? Thanks - Before posting, please check: