mysql db_name "." name="description">

Understanding Various MySQL Executable Files

This lesson you learn how to the execute mysql file. MySQL Provide the executable file and uses the MySQL Client interactive file by this command "shell> mysql db_name ".

Understanding Various MySQL Executable Files


This lesson you learn  how to the execute mysql file. MySQL  Provide the  executable file and uses the MySQL Client  interactive file by  this command "shell> mysql db_name ". It is possible put the SQL statement in file and tell the mysql from input read this file . So the create  text file " text_file" . MySQL use the this command for file execute. It is use this command in MySql execute file this type :-

shell> mysql db_name < text_file

MySQL is a simple SQL shell.  This SQL shell supported the interactive and non- interactive  used. MySQL  when use the interactive quarry then result represent in an ASCII table format. And if you are used the non-interactive quarry then result display the tab-separated format .  

In this command if you use the first line statement db_name then it is  very important to specify for database name on the command line. 

shell> mysql < text_file 

There are already running mysql then you can execute the SQL Script using the source or \ command :

mysql> source file_name
mysql> \. file_name

If you want to your script display the progress information to the user then you can insert the this command.

SELECT '<info_to_display>' AS ' ';

MySQL Executable file:
The MySQL file in this directory is name Apache and execute the file it is operating system X will run during the startup process. This file first thing is that both file and the directory  named Apache. MySQL has execute the file same name as the subdirectory and it is executable in the root level of subdirectory .When are MySQL use the apache HTTP server then display the Massage on the apache Web server.

Share on Google+Share on Google+

Understanding Various MySQL Executable Files

Posted on: March 13, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: Understanding Various MySQL Executable Files   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
John Koshy
April 12, 2012
Your Free Tutorial

Hi: I appreciate the fact that you have spent time, effort, and perhaps money to develop and maintain a free MySQL tutorial on line for people like me. As I am new user of MySQL, I find it very difficult to understand some of the things discussed in the tutorial because the tutorial is filled with mistakes of all sorts. Hope you will be able to improve and maintain the quality of the writing in the future. I also hope that you will consider this comment in a positive sense and not as a criticism. Thanks, John