Roberto Apasajja's questions

Initially, this is what we can see when I run SELECT * FROM block_custom;:

+-----+------------------+--------+-----------+
| bid | body             | info   | format    |
+-----+------------------+--------+-----------+
|   1 | Block1 body here | Block1 | full_html |
|   2 | Block2 body here | Block2 | full_html |
|   3 | Block3 body here | Block3 | full_html |
+-----+------------------+--------+-----------+

In order to replace info and bodyof table block_custom, I'm using below query:

update block_custom set info = replace(info,'Block2','Block2new');
update block_custom set body = replace(body,'body here','newbody here');

This is explanation of my query:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

When running this query to change body, it will replace in all row of column body.

How to make it change only in row 2 (bid 2)?

MySQL details:

MySQL username: root
MySQL password: z

To run MySQL query without login, the command is:

mysql -u root -pz -e "mysql-query-here"

So, if I want to create database with name db1, it will become:

mysql -u root -pz -e "CREATE DATABASE db1 CHARACTER SET utf8 COLLATE utf8_bin"

Now, I want to run this query for database db1

INSERT INTO `role_permission` VALUES (1,'create about_us content','node')

I dont know how to make it works. I've tried many combinations without luck.

When running use dbname; in MySQL admin, I will get this message:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

But I still not clear about how to use -A?