By Sumit Gupta on December 13, 2010
Today, I face a new problem with MySQL. I got the database to crash quite a few times since morning. Event logs shows that there is a fault in mysqld.exe, but that error was not very clear on specific reason of fault. After searching for articles and forums, I got a hint that in past [...]
Posted in MySQL, Server Configuration | Tagged crash, Mysql, Upgrade |
By Sumit Gupta on March 10, 2010
I was looking at MySQL.com and found a new GUI, which came as replacement of old MYSQL administrative GUI. My impression was not good to learn that they have something new, as I thought it might be just that they get their old interface opensourced or something. But when I install this application, hmm .. [...]
Posted in Database, MySQL | Tagged GUI, Mysql, SQL, WorkBench |
By Sumit Gupta on July 4, 2008
A useful like to know the reason of “Server has gone away” error of MySQL. http://blog.taragana.com/index.php/archive/mysql-tip-mysql-server-has-gone-away-or-lost-connection-to-server-during-query-fix/ It has very good information on why it happens, so you can check and correct the error.
Posted in Server Configuration, SQL | Tagged Database, Mysql, SQL |
By Sumit Gupta on April 16, 2008
As title says, I was looking to compare User give date range with date range saved in mysql Database. I search internet and found a great small function that solve this problem for me, though they create a function for some programming language but I use same function in mysql (as per mysql syntax) and [...]
Posted in Links, Programming, SQL | Tagged date collision, Date range, Intersection of dates, Mysql |
By Sumit Gupta on January 2, 2008
Often we need to take quick backup of database with data before we can make changes in table. for this I create the image of table within same database, as it is the fastest method. It is one of the reason why one need to create image a table.. or copy one table from another. [...]
Posted in Code Snippets, SQL |
By Sumit Gupta on December 17, 2007
Once you create a table and what to reset autoincrement value of a table to your desire number, you need to set some system table values, which are not available for direct editing. To perform this you need to do following: SELECT OBJECT_ID,OBJECT_NAME(OBJECT_ID) AS TABLENAME, NAME AS COLUMNNAME, SEED_VALUE, INCREMENT_VALUE, LAST_VALUE, IS_NOT_FOR_REPLICATION FROM SYS.IDENTITY_COLUMNS ORDER [...]
Posted in Code Snippets, Programming, SQL |
Recent Comments