Executing number of sql queries at a time using “source” command<\/p>\n
Make all the queries in a single file, here i opened a file called “ctechz.sql” and saved all sql queries in this file.<\/p>\n
mysql> use dbname;\u00a0 —– be in that database
\nand then run the “source”\u00a0 command to update the queries into the tables.<\/p>\n
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.<\/p>\n
You will see quite a bit of output as\u00a0mysql<\/b>\u00a0reads queries from the\u00a0 Executing number of sql queries at a time using “source” command<\/p>\n Make all the queries in a single file, here i opened a file called “ctechz.sql” and saved all sql queries in this file.<\/p>\n # mysql -uroot -pmysql <\/p>\n mysql> use dbname; —– be in that database and then run the “source” command to update the […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2278"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2278"}],"version-history":[{"count":2,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2278\/revisions"}],"predecessor-version":[{"id":2280,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2278\/revisions\/2280"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}ctechz.sql<\/code>\u00a0file and executes them.<\/p>\n","protected":false},"excerpt":{"rendered":"