ushastry.blogspot.com
My (SQL) WorkLog: November 2009
https://ushastry.blogspot.com/2009_11_01_archive.html
It’s all about My(SQL) favorite tools, utilities, tips, tricks, code snippets, discoveries and best practices. Wednesday, November 18, 2009. ERROR 1037 (HY001): Out of memory; restart server and try again (needed 123456789 bytes). Today morning when I was trying to execute a peice of SQL code and all the time I was welcomed by the below error. ERROR 1037 (HY001): Out of memory; restart server and try again (needed 123456789 bytes). Posted by Umesh Shastry. Subscribe to: Posts (Atom).
ushastry.blogspot.com
My (SQL) WorkLog: October 2009
https://ushastry.blogspot.com/2009_10_01_archive.html
It’s all about My(SQL) favorite tools, utilities, tips, tricks, code snippets, discoveries and best practices. Friday, October 30, 2009. MySQL - Extract numbers out of a string. Yesterday on EE I saw a very interesting request from a user for "Extracting numbers out of a string". This could be done in other languages with just 1 liner code but he needed it inside a SELECT query. Http:/ www.experts-exchange.com/Programming/Languages/SQL Syntax/Q 24855357.html. There is always room for improvement. If you ...
umaonmysql.wordpress.com
[DYK] MySQL workbench 6.0.3 Beta is here! | [Did You Know] MySQL
https://umaonmysql.wordpress.com/2013/07/24/dyk-mysql-workbench-6-0-3-beta-is-here
A Dolphin's Exploration. Did You Know] MySQL. Feel free to get in touch! Laquo; [DYK] MySQL and MSSQL are different RDBMS? DYK] MySQL for beginners just got easy with the “MySQL Installer”! DYK] MySQL workbench 6.0.3 Beta is here! MySQL Workbench is a GUI tool visual tool for database architects, developers, and DBAs. Since years, we already have 5.2 as the GA version (production ready use). However, recently there has been a lot of work. To reach 6.0.3 release. MySQL Workbench provides features such as:.
ushastry.blogspot.com
My (SQL) WorkLog: September 2010
https://ushastry.blogspot.com/2010_09_01_archive.html
It’s all about My(SQL) favorite tools, utilities, tips, tricks, code snippets, discoveries and best practices. Wednesday, September 01, 2010. MySQL: Kill sleeping connections. Platform: MySQL 5.x. Most of the time it would be handy to have a native MySQL script which would allow one to kill the sleeping connections which are in sleep state for more than 180 sec. On the other hand DBA's can use "wait timeout" etc parameters to control this. DROP PROCEDURE IF EXISTS `uKillSleepingSessions`$. OPEN my cur;.
umaonmysql.wordpress.com
[DYK] MySQL Central @ OpenWorld, Sept 28 – Oct 2, San Francisco | [Did You Know] MySQL
https://umaonmysql.wordpress.com/2014/07/02/dyk-mysql-central-openworld-sept-28-oct-2-san-francisco
A Dolphin's Exploration. Did You Know] MySQL. Feel free to get in touch! Laquo; [DYK] MySQL REPO : Yum repositories for MySQL now available! MySQL User Camp, Bangalore 26th June 2015. DYK] MySQL Central @ OpenWorld, Sept 28 – Oct 2, San Francisco. Attend MySQL Central @ OpenWorld, Sept 28 – Oct 2, San Francisco. Learn about the latest developments directly from Oracle’s MySQL engineers, boost your skills and share experiences with your peers. Http:/ www.oracle.com/openworld/mysql. You can leave a response.
umaonmysql.wordpress.com
[DYK] MySQL for beginners just got easy with the “MySQL Installer”! | [Did You Know] MySQL
https://umaonmysql.wordpress.com/2013/07/24/dyn-mysql-for-beginners-just-got-easy-with-the-mysql-installer
A Dolphin's Exploration. Did You Know] MySQL. Feel free to get in touch! Laquo; [DYK] MySQL workbench 6.0.3 Beta is here! DYK] MySQL Connect 2013! DYK] MySQL for beginners just got easy with the “MySQL Installer”! MySQL Installer provides an easy to use, wizard-based installation experience for all your MySQL software needs. It includes the latest versions of below products:. MySQL Workbench and sample models. MySQL for Visual Studio. It will create MySQL Server connections in MySQL Workbench. If the ...
ushastry.blogspot.com
My (SQL) WorkLog: February 2011
https://ushastry.blogspot.com/2011_02_01_archive.html
It’s all about My(SQL) favorite tools, utilities, tips, tricks, code snippets, discoveries and best practices. Monday, February 21, 2011. MySQL: Bulk import and logging the warnings to a file. But “ SHOW WARINGS. 8221; shows nothing if the last statement used a table and generated no messages. Shows the error, warning, and note messages that resulted from the last statement that generated messages in the current session. Certainly not sounds good if you are serious about your data. 8211;uUserName –...
ushastry.blogspot.com
My (SQL) WorkLog: September 2009
https://ushastry.blogspot.com/2009_09_01_archive.html
It’s all about My(SQL) favorite tools, utilities, tips, tricks, code snippets, discoveries and best practices. Wednesday, September 02, 2009. Scheduled tasks in MySQL. Unix crontab (also known as a “cron job”) or the Windows Task Scheduler can. System variable determines whether the Event Scheduler is enabled and running on the server. Version Introduced 5.1.6. Command Line Format - event-scheduler[=value]. Config File Format event-scheduler. Option Sets Variable Yes, event scheduler. CREATE EVENT [ IF N...
SOCIAL ENGAGEMENT