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

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.