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 …
Page 1 / 1