Netvouz / emweb / tag / mysql

» MySQL Cheat Sheet » Blog Archive Alice Hill’s Real Tech News - Independent Tech

emweb — Thu, 26 Apr 2007 09:01:21 GMT

Extended Regular Expression Matching: mysql> SELECT * FROM table WHERE rec RLIKE “^b$”; (. for char, […] for char class, * for 0 or more instances ^ for beginning, {n} for repeat n times, and $ for end) (RLIKE or REGEXP) To force case-sensitivity, use “REGEXP BINARY” Selecting from multiple tables: (Example) mysql> SELECT pet.name, comment FROM pet, event WHERE pet.name = event.name; Auto-incrementing rows: mysql> CREATE TABLE table (number INT NOT NULL AUTO_INCREMENT, name CHAR(10) NOT NULL); mysql> INSERT INTO table (name) VALUES (”tom”),(”dick”),(”harry”); Batch mode (feeding in a script): # mysql -u user -p < batch_file (Use -t for nice table layout and -vvv for command echoing.) Alternatively: mysql> source batch_file;

Advanced MySQL Performance Optimization (pdf)

emweb — Tue, 10 Apr 2007 12:20:58 GMT

Cheat Sheet Round-Up Ajax, CSS, LaTeX, Ruby… | Smashing Magazine

emweb — Thu, 26 Apr 2007 08:50:26 GMT

Whether you’ve forgotten the name of a function or the property of a cascading style sheet - handy cheat sheets deliver the information you are looking for - immediately. Most cheat sheets are available as .pdf or .png-files, so you can print them and use them every day for whatever projects you’re currently working on. We present an extensive overview of useful cheat sheets we’ve found in the Web. Something is missing? Don’t hesistate to comment!

Cheat Sheet Roundup - Over 30 Cheatsheets for developers

emweb — Thu, 26 Apr 2007 08:54:43 GMT

Lets face it, unless you have a photographic memory, no developer can remember all the different functions, options, tags, etc. that exist. Documentation can be cumbersome at times, thats why I like cheat sheets. They are quick references that feature the most commonly forgotten things on a specific topic. You can print them out and hang them on your wall, or just keep them handy in your bookmarks for quick reference. I have rounded up over 30 cheatsheets that developers might find useful. Web Development Cheat Sheets * JavaScript * CSS * CSS * Hex Codes * HTML * XHTML * HTML Entities Databases / SQL Cheat Sheets * MySQL * MySQL * Oracle * SQL * Sybase Language Cheat Sheets * ColdFusion - work in progress

Handy Cheat-Sheet of MySQL Commands

emweb — Thu, 26 Apr 2007 09:11:00 GMT

From your login shell... # Creating a Database # mysqladmin create [databasename] Example: # mysqladmin create mydatabase [Enter] # Dropping (Removing) a Database # mysqladmin drop [databasename] Example: # mysqladmin drop mydatabase [Enter] # Populating an Existing Database from a *.sql File # mysql [databasename] < [databasedumpfile.sql] Example: # mysql mydatabase < mydatabase.sql [Enter] # Dumping Database Structure and Data to a *.sql file mysqldump --opt [database] > [databasefilename.sql] Example: mysqldump --opt techmanual > techmanual.sql; From within the MySQL interface... # Starting MySQL from the Command Line # mysql Example: mysql [Enter] You will be welcomed with the following message: Welcome to the MySQL monitor. Commands end

HIOX FREE MySQL Tutorial - Alter/Modify Table, Rename Table, Adding/Add a column

emweb — Wed, 25 Apr 2007 08:22:56 GMT

bra grund

Hockinson.com: Cheat Sheet for MySQL 4.x Schema

emweb — Thu, 26 Apr 2007 08:49:25 GMT

Portions of the following are quoted from the MySQL web site. Observations and opinions expressed below may be useful to MySQL newbies (use this information at your own risk). Use the underscore character in your column names, e.g. first_name. Subsequently in your PHP scripts the underscore can be easily replaced with a space. Use only lower case letters to ensure portability to other system configurations. Avoid using hyphens in the names of databases, tables, and columns. Situations can arise where the schema is not portable to another system configuration if upper case letters and/or hyphens are used. Hyphens appearing in a double-quoted line of PHP code may be interpreted as a minus sign (crashing the script). Usage of SET and ENUM fields is tricky when

manalang.com » Archives

emweb — Mon, 07 May 2007 07:07:18 GMT

# !mobiledesktop # %s # 2005 # adobe # advice # aggregator # airplane # ajax # algorithms # amazon # amusing # apache # api # apollo # apple # architecture # art # atom # auto # b&w # baby # background # backup # bandwidth # battery # beer # bestof # blogging # blogs # bone # bookmarking # bookmarklet # bookmarklets # bookmarks # books # bpel # browser # bugtracking # business # business2.0 # cabletv # caching # camera # cancer # capture # career # cell # charting # chat # cheatsheet # cherrypy # christmas # cisco # cms # code # color # comet # comic # comparison # complementary # compression # computers # computerscience # computing # conference # congress # cooking # coupon # coupons # cpu # cryonics # css # database # deals # del.icio.us # delicious # de

MySQL Cheat Sheets - ILoveJackDaniels.com

emweb — Thu, 26 Apr 2007 09:03:02 GMT

The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, and a list of useful sample queries to select data from a database. A description of what is on the cheat sheet follows, or if you are impatient, you can go straight to the full size MySQL cheat sheet: * PNG, 106KB * PDF, 435KB Functions in MySQL

MySQL Reference (Cheat) Sheet

emweb — Thu, 26 Apr 2007 08:51:10 GMT

I’ve been putting together a quick reference guide to MySQL for some upcoming projects and thought that it was handy enough others might find it useful. When I went looking for some good references I was surprised to only find a handful of options and none of them alone had all the information I wanted at my fingertips. So, I figured, it would be worth it to spend the time to create my very own super-uber-ultimate MySQL reference. And now, I’m giving it to you… my lucky readers!