MySQL Commands

This is a list of handy MySQL commands that I use time and time again. At the bottom are statements, clauses, and functions you can use in MySQL. Below that are PHP and Perl API functions you can use to interface with MySQL. To use those you will need to build PHP with MySQL functionality. To use MySQL with Perl you will need to use the Perl modules DBI and DBD::mysql. Below when you see # it means from the unix shell. To login (from unix shell) use -h only if needed. # [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. mysql> create database [databasename]; List all databases on the sql server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the db. mysql> show tables; To see database's field formats. mysql> describe [table name]; To delete a db. mysql> drop database [database name]; To delete a table. mysql> drop table [table name]; Show all data in a table. mysql> SELECT * FROM [table name]; Show unique records. Sum column. or

14 Most Useful Web Design Cheat Sheets | Web Design Ledger A well rounded web designer’s day is spent immersed in multiple graphic design programs and writing front end code. All of this moving from one environment to another can make it hard to memorize such things as hot keys and shortcuts for each. This is where cheat sheets come into play. A cheat sheet is simply a printable reference or guide to a particular software package, language, framework, etc. Here are 14 of my favorite cheat sheets. Photoshop Adobe Photoshop CS4 Keyboard Shortcuts Adobe Photoshop CS3 Keyboard Shortcuts Photoshop Lasso Tool Cheatsheet Adobe Pen Tool Cheatsheet CSS Cheat Sheet (V2) Mac OS X CSS Cheat Sheet (X)HTML Elements and Attributes HTML/XHTML in one page JavaScript Frameworks jQuery 1.3 Cheat Sheet mootools 1.2 cheat sheet Prototype 1.6.0.2 Cheat Sheet Flash Adobe Flash CS4 OS X Keyboard Shortcuts Flash CS3 Cheat Sheet About the Author Henry Jones is a web developer, designer, and entrepreneur with over 14 years of experience. Related Posts 1934 shares Read More 2759 shares

Ubuntu Cheat Sheet With the Ubuntu 8.04 release a few days away, there comes a time when one needs an end-all reference to the system. The time is now, and if you're an Ubuntu user and liked the original cheat sheet, then do we have a surprise for you: Click the preview above to download your PDF copy. This sheet is free to modify and redistribute for your own needs; we just ask that you keep the FOSSwire logo on the page. License: Creative Commons Attribution-Share Alike 3.0 Unported. If you haven't seen the previous sheet or would like one with more general Linux and Unix commands, see the original. Translations: As always, we're open to more translations and fixes. Jacob Peddicord - Jacob is a web developer, student, and programmer from Ohio.

HTML5 Canvas Cheat Sheet There are cheat sheets for just about anything out there but I couldn't find one for the HTML5 canvas element, so I decided to do something about that, mostly for my own sake but if other people find it useful that's just all the better. The information is pretty much just a copy of what is found in the WHATWG specs, just condensed and hopefully a bit easier to read. There are virtually no explanations, however, and no examples other than some graphics for compositing values and a few other things (the appearance of which is very much inspired by those found in Mozilla's examples). So, it's basically just a listing of the attributes and methods of the canvas element and the 2d drawing context. Choose between a 2 page PDF document or a PNG file. Corrections and comments are welcome!