Upscene Productions is proud to announce the next
version of the popular database development tool:
Database Workbench 3.4 Pro
Changes Highlights in 3.4 and previous versions
---
- NexusDB v3 support
- Many diagramming improvements
- Better
It´s working.
The problem was related to grant permission.
Thank you.
Cheers,
Hugo
-Mensagem original-
De: Gavin Towey [mailto:gto...@ffn.com]
Enviada em: terça-feira, 4 de agosto de 2009 19:46
Para: Hugo Leonardo Ferrer Rebello; mysql@lists.mysql.com
Assunto: [SPAM] RE: Remote
Hi, I'm a novel developer of MySql and now I am trying to create a mysql query
to detect table updates.
I query a database table every X seconds, and i want to get only the different
rows in the table. The result that I want to have is simply
TABLE (t = now) - TABLE (t = X second ago)
Every
SQL Image Viewer helps you retrieve, view, convert and export images and
binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and
various ODBC-supported databases (e.g. DB2 and PostgreSQL).
It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF,
and
I have good news and bad news for you when it comes to MySQL 5.x.
Good News if you are counting against MyISAM
Bad News if you are counting against InnoDB
Good News
-
For MyISAM
Just use either
SELECT table_rows FROM information_schema.tables WHERE table_schema='given db
name' and
The problem is that I need to search/sort by ANY of the 284 fields at
times - 284 indexes is a bit silly, so there will be a lot of sequential
scans (table has 60,000 rows). Given that criteria, will fewer columns
in more tables provide a performance benefit?
-j
On Tue, 2009-08-04 at 16:03
Ok, but in this way I can only detect if it's done ONE type of operation, for
example if I add a row and I remove an another one with this query I detect no
difference.
The principal point of the query that I want is to say which rows are changed
(added or deleted). I think it's not a easy
You need a timestamp column that autoupdates upon insert.
http://dev.mysql.com/doc/refman/5.0/en/datetime.html
Then use the DATE_SUB function for x seconds.
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function
_date-sub