MySql tip and trick collection command function

MySql The ORDER BY

2008-08-20T21:56:00.001-07:00

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 FROM Orders
ORDER BY Company

Example
To display the company names in alphabetical order AND the OrderNumber in numerical order:
SELECT Company, OrderNumber FROM Orders
ORDER BY Company, OrderNumber

Example
To display the company names in reverse alphabetical order:

SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC

Example
To display the company names in reverse alphabetical order AND the OrderNumber in numerical order:

SELECT Company, OrderNumber FROM Orders
ORDER BY Company DESC, OrderNumber ASC

Source : w3schools.com

MySQL Basic Statement

2008-08-20T21:53:00.001-07:00

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
SELECT LastName,FirstName FROM Persons

The WHERE clause is used to specify a selection criterion.

The WHERE Clause
To conditionally select data from a table, a WHERE clause can be added to the SELECT statement.
Syntax
SELECT column FROM table
WHERE column operator value
SELECT * FROM Persons
WHERE City='Sandnes'

The INSERT INTO Statement

The INSERT INTO statement is used to insert new rows into a table.
Syntax
INSERT INTO table_name
VALUES (value1, value2,....)
INSERT INTO table_name (column1, column2,...)
VALUES (value1, value2,....)

The Update Statement

The UPDATE statement is used to modify the data in a table.
Syntax
UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value
UPDATE Person SET FirstName = 'Nina'
WHERE LastName = 'Rasmussen'

The DELETE Statement

The DELETE statement is used to delete rows in a table.
Syntax
DELETE FROM table_name
WHERE column_name = some_value
DELETE FROM Person WHERE LastName = 'Rasmussen'
Delete All Rows
It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:
DELETE FROM table_nameorDELETE * FROM table_name

Source : w3schools.com

SQL Data Manipulation And Definition Language

2008-08-20T21:46:00.001-07:00

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 and update commands together form the Data Manipulation Language (DML) part of SQL:

SELECT - extracts data from a database table
UPDATE - updates data in a database table
DELETE - deletes data from a database table
INSERT INTO - inserts new data into a database table

SQL Data Definition Language (DDL)

The Data Definition Language (DDL) part of SQL permits database tables to be created or deleted. We can also define indexes (keys), specify links between tables, and impose constraints between database tables.

The most important DDL statements in SQL are:

CREATE TABLE - creates a new database table
ALTER TABLE - alters (changes) a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

Source : w3schools.com

MySql Standart Function

2008-08-20T21:45:00.001-07:00

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
How the INSERT INTO statement inserts new records (rows) into a database table.

SQL UPDATE
How to modify data in a database using the UPDATE statement.

SQL DELETE
How to delete records (rows) in a database, using the DELETE statement.

SQL Try-It-Yourself
Try some SQL statements of your own.

SQL ORDER BY
The ORDER BY keyword is used to sort the result.

SQL AND & OR
AND and OR join two or more conditions in a WHERE clause.

SQL IN
The IN operator may be used if you know the exact value(s) to search for.

SQL BETWEEN
The BETWEEN operator selects a range of data between two values.

SQL ALIAS
Aliases can be used for column names and table names.

SQL JOIN
How to use the JOIN operator to select data from two or more tables.

SQL UNION
The UNION operator is used to select related information from two tables.

SQL CREATE
How to create a new database and / or a new database table.

SQL DROP
How to drop (delete) a database and /or a database table.

SQL ALTER
How to user ALTER to add or delete table columns.

SQL Functions
SQL has a lot of built-in functions for counting and calculations.

SQL GROUP BY
How to use GROUP BY to group aggregated data.

SQL SELECT INTO
How to use SELECT INTO to save selected data in tables (create backup copies).

SQL CREATE VIEW
How to create a virtual table using CREATE VIEW.

SQL Server
About Database Management Systems (DBMS).

SQL Quick Reference
An SQL Quick Reference. Print it, fold it, and put it in your pocket.

SQL Summary
A summary of this tutorial.

SQL stands for Structured Query Language
SQL allows you to access a database
SQL is an ANSI standard computer language
SQL can execute queries against a database
SQL can retrieve data from a database
SQL can insert new records in a database
SQL can delete records from a database
SQL can update records in a database
SQL is easy to learn

Source : w3schools.com

MySql The WHERE Clause Function

2008-08-20T21:41:00.001-07:00

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
<	Less than
>=	Greater than or equal
<=	Less than or equal
BETWEEN	Between an inclusive range
LIKE	Search for a pattern
IN	If you know the exact value you want to return for at least one of the columns

Source : w3schools.com

How To Open or Start MySql

2008-06-02T19:02:00.000-07:00

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

And after all you can make some statements :

example : show database ;

Don't forget to type " ; " in every last of statement / instruction.

For more : Learing some function or command MySql, Install MySql, Learning Delphi Program, Learning computer tip

thanks

Free Domain For Your WebSite Or Blog

2008-05-09T00:23:00.000-07:00

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 become this name http://mysqlcollection.co.cc/

Better than ....... BlogSpot.com become ..... co.cc
You can registre free with no Limit -- Real Free
Just Click Here

www.DelphiPro7.co.cc/

www.karir2000.co.cc/

So your website will easy to be remember for any body

Relative other topic :

Make Domain Name Easy Tobe Remember - free
Windows keys function tip and trick
Attachment Email can not be send
The best free software often use in the office
Google search secrect Google Tip

Error in installing MySql

2008-05-01T23:55:00.000-07:00

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.

Configure defalt drive is follow these step

You can just take the following three steps :

Click on start->All Programs->MySql Server (4.1) ->MySql Server Instance Config Wizard. Click next then click on Remove Instance. choose remove and Execute.
Now uninstall MySql Server using the Add/Remove Software in the windows in control panel.
After this has been uninstalled, you must manually delete the folder where it was installed Usually In my case it was installed in: C:\Program Files\MySQL. 5)

When this folder has been deleted you can reinstall without restarting and this time you will no longer get the error.

How to Install and Make or change default drive :

You can configure the defauld drive here

Defauld drive of MySql can be can change with the following step :

Better choose Custom.
Click or press Change.
Type Folder Name.

You can Configure or Changing defalt drive

Have a nice day :)

How to protect computer from virus

2008-01-28T18:38:00.000-08:00

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 very important.\
Do not open the email that you don't know the sender.
Don't the email that containt jokes, only picture and from mailling list.
Don't open or download the website that are not very important.
Don't use USB to very computer.
ect.

Cause the email, internet and program can be containt a virus.And the virus can make the computer stop and make the data and file broken.

Other topic that can give you more information :

Computer in General :

Computer Knowledge and Geberak Information :

Testing Web Speed
Memperbaiki Windows system
How to protect computer from virus
Job Description IT / Mis Department

Delphi Function Tip and Trick

Loading and Open Delphi More Faster
Installing BDE - Borland Data Base Engine without Delphi Application
Editing memo in Foxpro Dos
Delphi file manipulation
Memperbaiki Windows system

Google make you big earn :

Free Google Adsense Script
GET MONEY BY CREATING THE ADSENSE AND ADWORD
Put Adsense in the top of Post body

Some Tip To Find Job

Tips Menulis Surat Lamaran Kerja Dengan Baik
Kiat mencari kerja dan mendapatkan perkerjaan dengan cepat
Tips Mengirim Lamaran dengan Email

More About Google Can Do :

Melihat dunia dengan Google Earth
Memeriksa kesehatan gratis di internet

MySql command function list

2008-01-17T19:20:00.000-08:00

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 name) ;

msql> Create table company1 ( code char(10), name char(35), address (40) );

MySQL command and function to see or show structure or scame of table :
Describe ........(table name) ;

msql> Describe company2

Command and function to show tables list :
Show tables ;

Command function to copy structure of schame from other table :
Create Table ..... (new table) like ...... (first table)

msql> Create Table Company2 like company1

Command function to insert data into database :
nsert into ....... (table name) ( ( ....... field name ) ) values ( ( ............value ) ) ;

msql> Insert into company2 (code, name, address) values ( '245' , 'Big City' , 'Road jkt 54 ' ) ;

Command function to delete table :
Drop table ......... (table name) ;

msql> Drop table company1 ;

Command function to create index -(or sort) :
Create index .......(index name) on .... (field name) ;

msql> Create index compidx on address ;

Command function to erase or delete index :
Drop index ...... ( index name) ;

msql> Drop index compidx;

Command function for string :

SubString :

Select vendorid, substring ( vendorid from 2 for 2 ) from transaction where date > '01/01/2008'

Select vendorid, adress from transaction where vendorid like '%Sony%'

Select vendorid, adress from transaction vendorid in ('one' , 'two', 'five' )