Free Database Workbench 3.3 Lite for MySQL available!

2009-04-01 Thread Martijn Tonies
Hello everyone, Upscene Productions introduces the FREE Lite Edition of Database Workbench for MySQL. More info: http://www.upscene.com/displaynews.php?item=20090331 and http://www.upscene.com/products.dbw.index.php#lite This is a limited but useful version of Database Workbench Pro, available

Re: Free Database Workbench 3.3 Lite for MySQL available!

2009-04-01 Thread Virgilio Quilario
Hello everyone, Upscene Productions introduces the FREE Lite Edition of Database Workbench for MySQL. More info: http://www.upscene.com/displaynews.php?item=20090331 and http://www.upscene.com/products.dbw.index.php#lite This is a limited but useful version of Database Workbench Pro,

Re: MySQL - facts

2009-04-01 Thread Virgilio Quilario
Need some facts for a Report ... For a hypothetical Kitchen Company's shopping Catalogue.  a.. What advantages does a database have over flat-file systems ? great advantage when processing large amounts of data.  b.. Are there any disadvantages in switching to a database solution ? database

Re: Joining memory tables is very very slow!

2009-04-01 Thread Virgilio Quilario
I'm using MySQL 5.1.30 and have several memory tables with indexes on the appropriate columns. When I try and join 2 particular memory tables together to get 5k rows, it takes 90 seconds. This is incredibly slow considering table1 has 11k rows and table2 has 5k rows. A table join like this

Total logged in time

2009-04-01 Thread Tom Scheper
Hi, I have a table like so id autoinc userid int action enum ('login', 'logout' ) timestamp -- Is it possible to perform a mysql query that gets the total logged in time for any one user on any one particular day/week/month? And how? -- MySQL General Mailing List For list archives:

Include SQL files

2009-04-01 Thread Jørn Dahl-Stamnes
Hello, After googling for an hour I gave up to find a solution. Problem: A framework is creating a lot of SQL files that will create the database. But I'm tired of doing 10-20-30 'mysql -u... filen.sql' each time I rebuild the model. What I want to do is to create a sql file like: use

Re: Include SQL files

2009-04-01 Thread Michael Dykman
No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes sq...@dahl-stamnes.net wrote: Hello, After googling for an hour I gave up to find a solution. Problem: A framework is creating a lot of SQL

Re: Include SQL files

2009-04-01 Thread Eugene Kosov
What about source? use foobar; source some/dir/file1.sql; source some/dir/file2.sql; ... Though, your solution is much simplier. Michael Dykman wrote: No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM,

ANN: MicroOLAP DAC for MySQL 2.7.1 released

2009-04-01 Thread Mikhail Oleynik
Greetings! We are glad to announce DAC for MySQL version 2.7.1 (April 1, 2009) release. Version 2.7.1 is out. This release brings several optimizations and bugfixes since 2.7.0 release. Minor Design-Time errors fixed also. Don't forget to uninstall old version before installing the new one. If

Re: Total logged in time

2009-04-01 Thread Claudio Nanni
Just a hint: Given the user 'User' and given no missing login/logout event logging you can retrieve the total amount in seconds he was logged on with the following formula: SELECT (SELECT SUM(time_to_sec(time_stamp)) as logoutTime from logevents where event='logout' and userid='User' ) -

mysqldump failing to load data

2009-04-01 Thread Dermot
Hi, MySQL v4.1.22 on Linux 2.6.18-6-686 I have a dump file generate with mysqldump created by a version 4.1.10 server. I want to import the dump file into a different server. When I run mysqldump --database mydb --debug mydumpfile.sql I get the following: -- MySQL dump 10.9 -- -- Host:

how do I select multiple conditions from 1 table column?

2009-04-01 Thread PJ
I am trying to select all books whose authors last names begin with I, J or K. I have 3 tables: book, author and book_author. The following query works with one condition but not with three. SELECT * FROM book WHERE id IN (SELECT bookID FROM book_author WHERE authID IN (SELECT

Re: how do I select multiple conditions from 1 table column?

2009-04-01 Thread David Giragosian
On Wed, Apr 1, 2009 at 1:27 PM, PJ af.gour...@videotron.ca wrote: I am trying to select all books whose authors last names begin with I, J or K. I have 3 tables: book, author and book_author. The following query works with one condition but not with three. SELECT * FROM book WHERE id

Re: how do I select multiple conditions from 1 table column?

2009-04-01 Thread PJ
David Giragosian wrote: On Wed, Apr 1, 2009 at 1:27 PM, PJ af.gour...@videotron.ca mailto:af.gour...@videotron.ca wrote: I am trying to select all books whose authors last names begin with I, J or K. I have 3 tables: book, author and book_author. The following query

Re: Question!

2009-04-01 Thread Jujitsu Lizard
On Tue, Mar 31, 2009 at 1:30 AM, Jarikre Efemena jefem...@yahoo.com wrote: Dear sir, I am young web developer using PHP Script in designing interactive website. I desire to include Mysql database on my websites. Please, how do I import, upload/export Mysql database to a website server

Re: Mysql High load CPU

2009-04-01 Thread Claudio Nanni
Tadeu Alves wrote: Thanks for this heads up i was thinking into some of these i was looking into the page that has the calculation of each looking into mysqlperformance blog it's a good idea of add more memory into this variables? query_cache_size= 1000M to 2000M and

Re: Include SQL files

2009-04-01 Thread Jørn Dahl-Stamnes
On Wednesday 01 April 2009 16:49, Eugene Kosov wrote: What about source? use foobar; source some/dir/file1.sql; source some/dir/file2.sql; ... Gee... why did I not find that on google? :D Thanks... this give me control of the order of the files, which can be important. -- Jørn