Re: Integrity on large sites

Hi Naz, Just to throw out (plug) an ongoing project: http://www.hivedb.org/ From the site: > HiveDB is an open source framework for horizontally partitioning MySQL systems. Building scalable and high performance MySQL-backed systems requires a good deal of expertise in designing the sy

RE: Need confirmation: Subselects are broken with regards to index usage?

Lets hope something is done about it soon, not all sub queries SHOULD be re-written as joins. Generally joins that result in the need to use DISTINCT are better off re-written as IN OR EXISTS sub queries. In any event, I have a lot of very complex queries that work great for our other database bac

Re: do I need 2 selects?

- Original Message - From: "James Lockie" <[EMAIL PROTECTED]> To: "MySQL Mailing List" Sent: Friday, May 25, 2007 3:11 PM Subject: do I need 2 selects? Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the late

Re: do I need 2 selects?

Hi James, James Lockie wrote: Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'? Is the

Strange result from multiple JOIN

I'm trying to construct a join, but the effect I want seems to be impossible to achieve. In this schema, the "uid" field is unique in the "players" table, but not in the "ranking" table (one player per uid, multiple rankings per player) I want to select player names and rankings for a particila

Re: do I need 2 selects?

Hi James, all! James Lockie wrote: Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'?

Re: do I need 2 selects?

Baron Schwartz wrote: Hi James, James Lockie wrote: Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) wher

RE: How to get the table.column in mysql client tab completion? Or feature request to add this.

> Daevid Vincent wrote: > [snip] > > Also, it would be great if mysql client was "smart" enough > to limit my > > tab completion choices to possibilities based upon the > current SQL query > > I'm crafting. So If I have: > > > > "select t[TAB] from ResolveTable join Tickets;" > > > > It shoul

Re: Integrity on large sites

> It is my contention that as the clustering capabilities of MySQL > continue to grow and mature (think of when version 6.0 goes stable) > companies will move to MySQL in droves. THEN you have the ability to > build a single "virtual" database (at least from the point of view of > your applicatio

Re: select with like not working...

would you can post the table script?? create and insert... because it should be work ... Jason Pruim escreveu: I have tried %jason%, %jason, & jason% all with the same result... Do you need to have an index of the column? Currently I didn't intentionally make one so I'm not sure if it's automat

Re: select with like not working...

I have tried %jason%, %jason, & jason% all with the same result... Do you need to have an index of the column? Currently I didn't intentionally make one so I'm not sure if it's automatic or not... On May 25, 2007, at 1:26 PM, Mike Lockhart wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SH

do I need 2 selects?

Say I have x rows of 2 columns each. For example, 2 rows: 'A 10:00pm' and 'A 11:00pm'. I want to return one 'A' row with the latest time (eg. 'A 11:00pm). I could do 'select distinct(col1) from table' and then 'select col1, max( col2 ) where col1=row[0]'? Is there a way to do it in one select?

Re: Need script to populate data.

In the last episode (May 25), SRM SRM said: > Thanks for your help. I'm not able to ssh into this box - how can I > run this script, basically all I have to work with is MySQL Query > Broswer. You can generate data by using a stroed procedure, too. I prefer this method because it doesn't requ

Re: Need script to populate data.

Ryan, Thanks for your help. I'm not able to ssh into this box - how can I run this script, basically all I have to work with is MySQL Query Broswer. TIA From: Ryan Stille <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Subject: Re: Need script to populate data. Date: Fri, 25 May 2007 13:19

Re: Need script to populate data.

This should do it. Save it in a file then run it like "perl newfile.pl". Save the output into a text file, then run it against your database. $records = 100; for ($i=1;$i<=$records;$i++) { print "INSERT INTO MyTable (forumid, styleid, title, title_clean, " . "description, description_clean, opti

Need script to populate data.

Group, I'm an oracle dba and new to mysql. I've just recieved responsiblity to work on a mysql project. Basically I have 1 table: forumid smallint(5) unsignedNO (null) 0 (null) styleid smallint(5) unsignedNO (null) 0 (null) title varchar(100)NO (n

Need script to populate data.

Group, I'm an oracle dba and new to mysql. I've just recieved responsiblity to work on a mysql project. Basically I have 1 table: forumid smallint(5) unsignedNO (null) 0 (null) styleid smallint(5) unsignedNO (null) 0 (null) title varchar(100)NO (n

Re: select with like not working...

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Have you tried using 'jason%' instead of '%jason%'? Also, do you have an index on that column? Jason Pruim wrote: > Hi all, > > I'm new to the list so please excuse me if I make some newbie mistakes, > I am having trouble figuring out why a select s

select with like not working...

Hi all, I'm new to the list so please excuse me if I make some newbie mistakes, I am having trouble figuring out why a select statement won't work, Here's the statement: "SELECT 'FName' FROM `current` WHERE `FName` like '%jason%';". if I run select 'FName' FROM current; then I get 6 rows

Re: Integrity on large sites

Hey there, thanks for your comments. There are issues where sharding may be appropriate, but you are talking about the heaviest of heavy duty loads. Not only that, hardware is getting to the point where it is surpassing our needs. Remember the days when it cost $200k to run a library database? Nowa

Re: Integrity on large sites

> You youngsters may not realize that there were billing applications > serving millions of customers long, long before there were any kind of > database management systems. They employed concepts called "flat > files" and "batch processing". And they ran on machines far weaker > than anything a

Re: How to get the table.column in mysql client tab completion? Or feature request to add this.

Hi, Daevid Vincent wrote: [snip] Also, it would be great if mysql client was "smart" enough to limit my tab completion choices to possibilities based upon the current SQL query I'm crafting. So If I have: "select t[TAB] from ResolveTable join Tickets;" It should only show me columns that sta

error message

Hi All, We are using 5.0.40-enterprise-gpl-log version on our production db. If we run a stored proc, we are getting the below error Query OK, 0 rows affected, 1 warning (0.01 sec) ERROR 1308 (42000): LEAVE with no matching label: SWL_return mysql> show warnings; -> // +---+--+---

Re: Integrity on large sites

B. Keith Murphy wrote: Here is the kicker. Each box was a top of the line Sun server that had 32 processors and 32 gigs of RAM. They could handle up to 64 procs and 64 gigs. And each cost well over a million dollars for the hardware alone. Running Oracle on it must have cost over 100,000 d

RE: Integrity on large sites

In my experience this happens a lot if you put application programmers in charge of the database. I've upset quite a few in my time by introducing RI and then their horribly coded application falls over! -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: 24 May 2007 17: