Archive for January, 2007
I’ve given up on the MySQL manual search
It’s simply too inaccurate to be useful. I’ve switched to using google with firefox bookmark keywords instead. Here is how to set it up. In firefox click on Organize Bookmarks under the Bookmarks menu. Click the New Bookmark button and fill in the following values. Name: MySQL Manual Location: http://www.google.com/search?hl=en&q=site:dev.mysql.com%20%s Keyword: mysql Description: Keyword bookmark [...]
Remapping the Firefox command key for different platforms.
Firefox uses a different command key on different platforms. I often switch between Linux and Mac OS. Having Mac OS use the command key and linux use control was quite confusing. Firefox offers a solution. Point your browser to about:config. This allows you to change settings that aren’t part of the regular options dialogs. In [...]
BACKUP/RESTORE TABLE lose auto increment
One small fact about backup table and restore table that isn’t listed in the manual is that these commands lose the auto increment value if rows at the head of the table are deleted. For example if you have auto increment values of 1,2,3,4 in a table the auto increment value is 5. If you [...]