Executing number of sql queries at a time using "source" command
Make all the queries in a single file, here i opened a file called "ctechz.sql" and saved all sql queries in this file.
and then run the "source" command to update the queries into the tables.
it will execute all sql queries in the file ctechz.sql at the same time. When you are using the #mysql command to log into the db make sure that you are doing this from the direcory where you placed the ctechz.sql file.
You will see quite a bit of output as mysql reads queries from the
Make all the queries in a single file, here i opened a file called "ctechz.sql" and saved all sql queries in this file.
# mysql -uroot -pmysql
mysql> use dbname; ----- be in that databaseand then run the "source" command to update the queries into the tables.
mysql> source ctechz.sql
it will execute all sql queries in the file ctechz.sql at the same time. When you are using the #mysql command to log into the db make sure that you are doing this from the direcory where you placed the ctechz.sql file.
You will see quite a bit of output as mysql reads queries from the
ctechz.sql file and executes them. Terima kasih telah membaca artikel tentang Mysql source di blog Tutorial Opensource and Linux jika anda ingin menyebar luaskan artikel ini di mohon untuk mencantumkan link sebagai Sumbernya, dan bila artikel ini bermanfaat silakan bookmark halaman ini di web browser anda, dengan cara menekan Ctrl + D pada tombol keyboard anda.