mysql db_name "." name="description">
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.
If you enjoyed this post then why not add us on Google+? Add us to your Circles
Liked it! Share this Tutorial