Re: Is there a professional quality mySQL GUI for Linux?

On Mar 15, 2007, at 4:25 AM, Daevid Vincent wrote: Can anyone recommend a real, quality, professional level mySQL GUI for Linux? KDE, Gnome, whatever. Doesn't matter. Beggars can't be choosers right. Something along the lines of SQLYog (Enterprise ideally). I'm kind of disappointed that I can

10 minutes seems excessive...

Hello all... Source table has approximately 23,000,000 rows. The explain below shows we'll be working with 2,707,366 of those rows just inserting them into a table. Why does this take 10 minues to run? System specifications below all that. * Precompiled binary from mysql.com * Completely idle

RES: SQL Select Idea [ORDER BY]

n Thu, Dec 05, 2002 at 08:54:29PM -0200, Felipe Moreno - MAILING LISTS wrote: > > Well, could you explain the behave of ORDER BY DATE,COD? Just try it (it will order by date, then cod). What I think you want is (as I originally said, but briefly): create temporary table top10 select * from .

RES: SQL Select Idea [ORDER BY]

ten dates). So, >what I really need ia an way to make a select without any "data" from the >DB. I tried to use de LAST_INDEX() function to do this but I didn't go >anywhere. Any ideas??? -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quinta-feira,

RES: RES: RES: SQL Select Idea

: SQL Select Idea On Wed, Dec 04, 2002 at 08:55:51AM -0200, Felipe Moreno - MAILING LISTS wrote: >Well, the SQL Query you requested is exatcly the one I'm asking! :-) No; I want to know what you intended for those 10 dates to do. The LIMIT query worked, as posted by someone else, w

RES: RES: SQL Select Idea

what I'm doing above using only ONE select. Any tips? Best Regards, Felipe -Mensagem original- De: Michael T. Babcock [mailto:[EMAIL PROTECTED]] Enviada em: quarta-feira, 4 de dezembro de 2002 02:06 Para: [EMAIL PROTECTED] Assunto: Re: RES: SQL Select Idea On Tue, Dec 03, 2002 at

RES: RES: SQL Select Idea

zembro de 2002 01:03 Para: Felipe Moreno - MAILING LISTS Assunto: Re: RES: SQL Select Idea Felipe - Maybe you could... (1) Put the first result set into a temp table, on which you could execute subsequent queries, or (2) Use php to construct an array of the result rows, and then use php's arra

RES: SQL Select Idea

---Mensagem original- De: Jim Esten [mailto:[EMAIL PROTECTED]] Enviada em: terça-feira, 3 de dezembro de 2002 17:40 Para: 'Felipe Moreno - MAILING LISTS'; [EMAIL PROTECTED] Assunto: RE: SQL Select Idea Something on the order of... SELECT * FROM processo_arquivos ORDER BY DATE DESC LIMIT

MySQL: Select HELP!

Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but

SQL Select Idea

Hi List Users, I want to know if anyone has any idea on how can I do the SQL command below to archive a result. I have one table called processo_arquivos that have a filed called DATE and another FIELD called COD (primary key). I want to select the last TEN (10) dates from the Database, but

Test for table lock

Hi, Using MySQL, perl and DBI, is there a way to test to see if a table is locked (as in "LOCK table..."). We batch process our updates every 3 hours or so (it's not a set schedule though, it depends when a certain level of new updates is reached), and our main tables are locked during this t

Transaction Support in MySQL

What sort of support for transactions and table/record locking is there in MySQL right now? I had heard that only table locking was supported, and limited support for transactions. Aaron - Before posting, please check: h

reusing unique id's when deleting/inserting?

Hi all, Here are two tables I'm working with. I apologize if you are not using a monospaced font and they are messed up. This is used by a gradebook program. When a professor adds an assignment to a class he teaches, it inserts the information about the assignment into the assignments table,

Re: RDBMS question on coding "expanding series-like fields"

Hi Warren, What I personally would do is simply include some sort of 'ID' field. In other words, each question would have a unique ID. Question 1's ID would be 1, Question 2's ID would be 2, etc. Or however you wanted to number them. You could even set this up as an auto_increment and have t

mod_auth_mysql

Hi all, Does anyone know if mod_auth_mysql is still under active development, and if so, where can I find current information on it? I have searched the list archives here and indeed turned up 254 instances of people having problems with mod_auth_mysql. From the sounds of it, it doesn't look