Larry,
Am 25.04.2013 02:19, schrieb Larry Martell:
delete from cdsem_event_message_idx where event_id in ()
The in clause has around 1,500 items in it.
Consider creating a temporary table, filling it with your "IN"
values and joining it to cdsem_event_message_idx ON event_id for
deleti
I changed it to delete one row at a time and it's taking 3 minutes.
On Wed, Apr 24, 2013 at 6:52 PM, Larry Martell wrote:
> That is the entire sql statement - I didn't think I needed to list the
> 1500 ints that are in the in clause.
>
> Also want to mention that I ran explain on it, and it is u
That is the entire sql statement - I didn't think I needed to list the
1500 ints that are in the in clause.
Also want to mention that I ran explain on it, and it is using the
index on event_id.
On Wed, Apr 24, 2013 at 6:49 PM, Michael Dykman wrote:
> You would have to show us the whole sql state
> The "What's new in MySQL 5.7" manual page [1] says:
>
> * InnoDB now supports spatial data types.
>
> What is the difference to previous releases in this respect?
The 5.7.1 Release Notes are a bit more specific:
https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-1.html
InnoDB: Added su
2013/04/24 09:06 -0700, Rajeev Prasad
this table has many columns and only 1 record. select * from table; generates
an unreadable list. how can i list the record as in two columns? (column name
and its value)? i looked at UNPIVOT, but could not get it to work.
SQL> select * from table U
this table has many columns and only 1 record.
select * from table;
generates an unreadable list.
how can i list the record as in two columns? (column name and its value)?
i looked at UNPIVOT, but could not get it to work.
SQL> select * from table UNPIVOTE INCLUDE NULLS;
Dear MySQL users,
MySQL Server 5.7.1 (Milestone Release) is a new version of the world's
most popular open source database. This is the first milestone release
of MySQL 5.7.
http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html
The new features in these release
The "What's new in MySQL 5.7" manual page [1] says:
* InnoDB now supports spatial data types.
What is the difference to previous releases in this respect?
Spatial column types have been supported by InnoDB (and even
Cluster) for a long time already, and spatial indexes on
spatial columns stil
ANN: Database Workbench 4.4.0, the multi-DBMS IDE now available!
Ladies, gentlemen,
Upscene Productions is proud to announce the next version
of the popular Windows-based multi-DBMS development tool:
" Database Workbench 4.4.0 Pro "
This release includes new features and fixes several bugs as
