Run SQLyog on Linux with WINE. You can download the sqlyog windows installer and just run it with WINE. SQLyog is my favourite GUI client. It is lightweight and powerful. I use the community edition which comes free. The paid versions of the app are awesome. I particularly miss the …
How to update a field in a table with a field from another table
I needed a table which gave the map between the URLs and nodes in drupal. I ended up creating a table like this :
CREATE TABLE `nid_url_map` (`nid` int(10) NOT NULL DEFAULT '0',`url` varchar(255) DEFAULT NULL,`type` varchar(32) DEFAULT NULL,PRIMARY KEY (`nid`)) ENGINE=InnoDB DEFAULT CHARSET …How to dump or export all the table definitions in a MySQL database
So you have a database with loads of tables. You want the table definitions of all of them. You don't really need the data. mysqldump to the rescue!
[sourcecode]mysqldump -u USERNAME --password=PASSWORD --no-data --opt DB1 > DUMPFILE[/sourcecode]
That's it! Easy as a pie :) The key here is the …
Firebug opens automatically for all pages
Faced this bizzare issue today in Firefox. Firebug was opening automatically for all pages. Even on closing firebug, all I had to do was click on a new link in the same tab for it to appear again. This happened for all tabs.
Turns out I had accidently turned on …
Pirate tweet
September 19 is International Talk Like a Pirate Day.For this day, the Yahoo! Query Language (YQL) team announced on the YDN blog that they were bringing out a "pirate table". This table would allow us to translate plain English to piratespeak using YQL. I had been meaning to play …
Page 1 / 1