RSS

MySql (what i know as of Today)

15 Jul

1) Downloaded and installed mySql on my Local Machine.

Host: Localhost
Username: ODBC
Password:  nothing

2) Installed MySqlQuery Browser, MySqlAdministrator from Mysql Website

3) Connected to MySql Server Using the Below Parameters

i) use the Command prompt and goto  c:/Program files/mysql/mysqlserver 5.4/bin/mysql.exe
ii) To Connect to a Database   “Use Databasename”  ex: Use Text;
iii) To see a list of tables in mySql just type  “SHOW TABLES;”
iv) To See Records in a table type “Select * from test;” will display all records.
v)for help with the mysql  type “help” and press enter at the mysql prompt

General SQL Topic

RE: What is the difference between view and materializ…


view – store the SQL statement in the database and let you use it as a table. Everytime you access the view the SQL statement executes.

materialized view – stores the results of the SQL in table form in the database. SQL statement only executes once and after that everytime you run the query the stored result set is used. Pros include quick query results.

Advertisements
 
Leave a comment

Posted by on July 15, 2009 in Database Administration

 

Tags: ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: