Blogspot - mysqlcollection.blogspot.com - MySql tip and trick collection command function
General Information:
Latest News:
MySql The ORDER BY 21 Aug 2008 | 04:56 pm
The ORDER BY keyword is used to sort the result. Sort the Rows The ORDER BY clause is used to sort the rows. Example To display the company names in alphabetical order: SELECT Company, OrderNumber F...
MySQL Basic Statement 21 Aug 2008 | 04:53 pm
The SQL SELECT Statement The SELECT statement is used to select data from a table. The tabular result is stored in a result table (called the result-set). SELECT column_name(s) FROM table_name SELE...
SQL Data Manipulation And Definition Language 21 Aug 2008 | 04:46 pm
SQL Data Manipulation Language (DML) SQL (Structured Query Language) is a syntax for executing queries. But the SQL language also includes a syntax to update, insert, and delete records. These query...
MySql Standart Function 21 Aug 2008 | 04:45 pm
SQL Intro An introduction to SQL. SQL SELECT How the SELECT statement is used to select data from a database. SQL WHERE How the WHERE clause is used to conditionally select data. SQL INSERT INTO Ho...
MySql The WHERE Clause Function 21 Aug 2008 | 04:41 pm
The WHERE Clause SELECT column FROM table WHERE column operator value With the WHERE clause, the following operators can be used: Operator Description = Equal <> Not equal > Greater than < ...
How To Open or Start MySql 3 Jun 2008 | 02:02 pm
To Open or Start MySql : you can lear MySql by clicking these. You can click Icon on desktop (MySQL Command Line Client) Or you can click \programss\MySQL\MySQL Server 4.1\MySQL Command Line Client ...
Free Domain For Your WebSite Or Blog 9 May 2008 | 07:23 pm
How to change website address name You can make your blog become ohter name example http://mysqlcollection.blogspot.com/ You can change your blog name into http://mysqlcollection.co.cc/ , Will becom...
Error in installing MySql 2 May 2008 | 06:55 pm
Error installing MySql in windows XP SP2 Error message saying that MySql cannot start (Error: 0) How to unintall MySql, Problem uninstall and install and changing defalt drive and configure MySql. Co...
How to protect computer from virus 29 Jan 2008 | 03:38 pm
Protecting computer from virus : Use computer program like macav, avg, norton, or other and make an update every time. Backup your system regulary. Do not open the email that the containt is not ve...
MySql command function list 18 Jan 2008 | 04:20 pm
MySQL command and function to create database : Create database ..... ( database name ) ; msql> Create database mastertest1 ; MySQL command and function to create table : Create table ...... (table ...
