Intelligentedu Best New Free Computer IT Training Tutorial Resources

Here are 61 nice MySQL References and Code Examples, at psoug.org. These will help you to learn how to code SQL with the most popular open source database server, MySQL, which is one of the best RDBMS being used for developing web based software applications. By using these references and code examples you will increase your mySQL skills, and can become a better MySQL user or DBA. 


61 MySQL References and Coding Examples:
 
 - A minus B query
 - Add new user
 - Add or Subtract days
 - Add random numbers to columns
 - Add string to field
 - Almost any date to Mysql date
 - Binary RegExp select example
 - Calculate TIMEDIFF with mysql version < 4.1
 - CaSe sEnsiTvE query
 - Change table type
 - Check for duplicates & delete duplicates from database
 - Column copy with string replacement
 - Copy one table to another
 - Counting rows
 - Create monthly partitions
 - Create Random Password
 - Detect Daylight Saving Time
 - Export table to pipe delimited file
 - Extract part of a string
 - Fake Union
 - Fast random row picker #1
 - Fast random row picker #2
 - Find all duplicates in a column
 - Find Duplicates
 - Find Worst Performing Indexes
 - Finding a substring in a string
 - Follow the progress of a mySQL command
 - Format numbers to two decimal places
 - Get HTML/XML output from queries.
 - Get MySQL Database Size
 - Get ordered list of near match items based on tag matches
 - Grouping rows by frequency
 - Import file
 - Lead-In Sentence fragment...
 - Make comma-separated list of strings
 - Move position of mySQL field
 - MySQL Capitalize
 - mySQL DUMP command
 - MYSQL Select time from a date
 - Opposite of mysql_fetch_assoc
 - Opposite of UNION
 - Password setup
 - Rebuild table indexes
 - REGEXP SELECT Example
 - Remove Duplicates
 - Replace a NULL with a given value.
 - Reset auto increment value
 - Return text between delimiters in MySQL
 - Search and Replace
 - Select based on a field that can have a NULL value
 - Select distinct/unique entries
 - SELECT from multiple tables.
 - Select maximum value
 - Select minimum value
 - Select or match a range of dates
 - Select row number in MySQL
 - SELECT within SELECT (SubSelect)
 - Sort comma separated string
 - Update and Subtract single query
 - Update/convert DB field to uppercase
 - url_decode that respects utf8 characters.  

Popularity: 9% [?]

Here are 44 excellent JavaScript References and Coding Examples, at psoug.org. JavaScript is the scripting language of web, and is used in millions of web pages to add functionality, validate forms, detect browsers, and much more. You can use these 44 JavaScript examples to help you to become a better JavaScript programmer, and by reading and using these you will learn how to code its many features and functions, thereby increasing your JavaScript skills.


44 JavaScript References and Code Examples:

 - Accordian Menu   
 - Add more form fields   
 - Add/Remove from Select list   
 - AJAX Inline Editor #1   
 - AJAX Inline Editor #2   
 - Anti_Bot Form Code   
 - Attach to all links   
 - Auto-Link words   
 - Calculate time difference   
 - Capitalize first letter of words   
 - Change text box height   
 - Check or Uncheck all Checkboxes   
 - Check radio button selection   
 - Clear screen   
 - Click to edit Table Cell   
 - Confirm Delete   
 - Copy IFRAME contents   
 - Count checkboxes   
 - Count Textbox Chars   
 - Countdown to link enable   
 - Determine Operating System   
 - DHTML Combo Box Dropdown   
 - Download only once   
 - Dynamically Add/Remove rows in HTML table   
 - Easy Style Sheet Switcher   
 - Hide/Show div   
 - Javascript Cookie functions   
 - JS ComboBox   
 - Pass vars to/from PHP   
 - Password Strength Tester   
 - Prevent framing a page   
 - Prevent the 'enter' key from submiting a form: -   
 - Preview URL/Page On Hover   
 - Put Cursor At Top Of Textarea   
 - Set cookie even after HTML output   
 - Show basic image info   
 - Show/Hide Toggle   
 - Sized Pop-Up Windows   
 - Smooth Div Show/Hide   
 - Toggle All Checkboxes on or off   
 - Trippy Page   
 - Ultimate domain name validator  
 - Variable Speed Horiz Scroll   
 - Window close on any click

Popularity: 9% [?]