At 09:32 PM 3/15/2007, you wrote:
Hey all,
I have a table 'clients' like this:
id int(5),
name varchar(55),
address varchar(55)
I would like to select all the records that have '%x%' and '%y%' but
'%x%' can be in name and '%y%' can be in address. Also in my query
there are generally more words t
Hey all,
I have a table 'clients' like this:
id int(5),
name varchar(55),
address varchar(55)
I would like to select all the records that have '%x%' and '%y%' but
'%x%' can be in name and '%y%' can be in address. Also in my query
there are generally more words to match (x,y,z,t etc) and I can't u
Hello All,
This year, Proven Scaling is sponsoring three people to attend the MySQL
Conference and Expo 2007 in "sunny" Santa Clara, California, April 23-26.
The MySQL Conference and Expo is a great place to meet the MySQL
developers, other MySQL users, and many interesting people. It is the
On 3/14/07, Clyde Lewis <[EMAIL PROTECTED]> wrote:
System Configuration: Sun Microsystems sun4u Sun Fire E2900
System clock frequency: 150 MHZ
Memory size: 65536 Megabytes
CPU: 12 @ 1200 MHz
I'm looking for a tool that will allow us to determine the max number
of databases that can run in a sin
I have 2 tables and I need to update Table1 with the rows from table 2.
They have 15 columns that need updating (that are in both tables). Now I
could delete the old rows from table1, except there are around 1 million
rows, from a 35 million row table. This takes too long. I'd like to update
th
You probably did not change the max_rows setting when you created the table. If you read the manual under AVG_ROW_LENGTH for create
table it says:
"When you create a MyISAM table, MySQL uses the product of the MAX_ROWS and AVG_ROW_LENGTH options to decide how big the resulting
table is. If you do
I have upgraded to 5.25 today and it is true. Outstanding!
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 15, 2007 12:16 PM
> To: mysql@lists.mysql.com
> Subject: RE: Is there a professional quality mySQL GUI for Linux?
>
> "Tim Lucia" <[
On Thu, 15 Mar 2007, Michael Dykman wrote:
> What host OS are you running? And which file system? MySQL is always
> limited by the file size that the host file system can handle.
"Deb Sarge" is a Linux distribution, the "large file support" I mentioned
allows files up to 2 TB in size.
> On 3/15/
the problem is not on the MySQL side.. the problem is in the
connection management of your Java application... Are you using
connection pooling? Nothing on the server is going to close those
connections for you (although they will go stal eventually), that is
up to your client application.
-
What host OS are you running? And which file system? MySQL is always
limited by the file size that the host file system can handle.
- michael dykman
On 3/15/07, JP Hindin <[EMAIL PROTECTED]> wrote:
Greetings all;
I have a quandary regarding table limits, and clearly I am not
understanding ho
"Tim Lucia" <[EMAIL PROTECTED]> wrote on 03/15/2007 07:47:29 AM:
> I trade between SQLYog and SQL Exporer plugin for Eclipse. The former
only
> shows 1 result set at a time (boo) while the latter shows more than one
> (yeah!) The former doesn't let you sort columns from your own query,
only
>
Greetings all;
I have a quandary regarding table limits, and clearly I am not
understanding how this all works together. I have a test database which
needs to keep long-term historical data, currently the total dataset in
this one table is probably about 5.5GB in size - although since I have a
4G
I trade between SQLYog and SQL Exporer plugin for Eclipse. The former only
shows 1 result set at a time (boo) while the latter shows more than one
(yeah!) The former doesn't let you sort columns from your own query, only
the table preview. The latter doesn't let you sort the columns.
Neither on
I use SQLYog emulated with wine and/or cross over office
it works 100% fine :D
wine sqlyog.exe > Next > Next > Next> Finish
:D
On 3/15/07, Daevid Vincent <[EMAIL PROTECTED]> wrote:
Can anyone recommend a real, quality, professional level mySQL GUI for
Linux?
KDE, Gnome, whatever. Doesn't m
Hi Everyone
I have a new MySQL database at the back end of an invoicing and stock control
program. I ran a Performance Monitor thing whilst doing the look-ups involved
in one of the reports (Invoice items in order of customer name between 2 dates
- you know the sort of thing). It appears that t
I hate answering myself...
RTFWBF (Read The Fine WorkBench Forum)
http://forums.mysql.com/read.php?113,142277,142309#msg-142309
Sorry for the wasted bandwidth,
Zac
Ezequiel Panepucci wrote:
Dear list,
Is mysql-workbench, the product derived from DBDesigner,
a commercial product only?
I ha
Dear list,
Is mysql-workbench, the product derived from DBDesigner,
a commercial product only?
I have an alpha version on my computer but now it seems
from the MySQL webpage http://dev.mysql.com/downloads/gui-tools/5.0.html
that the workbench application is no longer available.
On http://www.my
> No, it doesn't have to be free. However I'm not a big fan of Java
What about using Wine?
Ours works fine under Wine.
Or you could try the one at www.sqlly.com
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http:/
No, it doesn't have to be free. However I'm not a big fan of Java
Applications either for the very reason you mention. They tend to be big,
bloated and slow. Zend IDE is an example of that, and is mostly unuseable
for real work IMHO.
Whoa! $400 for single license! Yipes!
http://www.aquafold.com/li
Dear MySQL Users,
This message is for those of you who are interested in going beyond
*using* MySQL, into the realm of those *developing* the MySQL software
itself, for everyone else in the community to use and enjoy.
As I wrote a few days ago in my blog, MySQL is participating in the
Google Sum
On Thu, 2007-03-15 at 01:25 -0700, 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.
>
has it got to be Free of COST and FLOSSware? If Not, then consider Aqua
Data Studi
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't seem to find anything. They're all
either some Admi
I'm just guessing at this, but I think this is a simple update:
UPDATE table1, table2
SET table2.needs_purging = 1
WHERE table1.bounce_email = table2.email
http://dev.mysql.com/doc/refman/5.1/en/update.html
You could also do this same logic with the delete I believe:
DELETE table2
FRO
23 matches
Mail list logo
