Executing SQL Statements from a Sql File

Use the follwoing command:

mysql> source file_name
or
mysql> \. exact_path_file_name

for an example:

mysql> \. /tmp/Marbil/marbil.sql

for further reading go to :
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html

mysql 5.1.23 installation in solaris spark 10 machine (64 bit)

uninstallation:

check the package using the command:
pkginfo | grep mysql

previous installation using
pkgrm mysql

installation:

just follow the instruction : http://instmysql5sol10.blogspot.com/
(must create user and group)


post installation works have to be done by follwoing the website.

some mysql commands

1. show databases;
2. use mysql;
show tables;

Problems:
Root password have not set yet.

Limit the resultset in MySQL

You can limit the resultset of the database query by adding :


///**********************************************************
limit index, length
///**********************************************************

for example: select * from tblCustomers limit 0,10;
which shows the out put from the database only first 10 customers from 0 rows.