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
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,
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
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
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:
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
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
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,
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
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' )
-
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:
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
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
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
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
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
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
17 matches
Mail list logo