How to update the content using CMD in Magento 2
Hi There !
You know our Magento 2 providing one cool feature that is page Builder.now you can create your CMS pages with the help of page builder.it will be very easy for you because it’s just a drag of drop operation. let’s come to the point.
Apart from these features, you can update your content using CMD. Let’s have a look at it and follow the simple steps. now we are going to update content for CMS pages using CMD
STEP 1: First open your mysql bin folder in CMD
EX: C:\xampp\mysql\bin
STEP 2: Now you need to login. follow the given syntax
// Syntax
EX: C:\xampp\mysql\bin > mysql -u USERNAME -p PASSWORD -h HOST
// Syntax with Sample Data
EX: C:\xampp\mysql\bin > mysql -u root -p pass -h 127.0.0.1
Now you will have a Welcome message. if the given credentials are wrong it will through the error
STEP 3: By-default CMS page table name is “cms_page”. before that, you must have knowledge about SQL queries. Now you need to select your database and cms_page table using SQL query.
STEP 4: Finally you need to run update query with your updated data.