Supress information in mysql prompt

21
January 13, 2019, at 05:50 AM

I ran the query in mysql prompt , I need to supress the "1 row in set (0.00 sec)" in output prompt. How I can do it

mysql> select concat( " Total Records in Transaction Table : ", count(*) ) from transaction_process ;
+--------------------------------------------------------------+
| concat( " Total Records in Transaction Table : ", count(*) ) |
+--------------------------------------------------------------+
|  Total Records in Transaction Table : 0                      |
+--------------------------------------------------------------+
1 row in set (0.00 sec)
Answer 1

Start the mysql client with the -s or --silent option.

READ ALSO
Union working in localhost MySQL Version 5.5.8 but not working on server MySQL - 5.7.24

Union working in localhost MySQL Version 5.5.8 but not working on server MySQL - 5.7.24

I have a table in which i am fetching Left & Right child of Parent via union query but there is a problem its working fine on localhost but union query fetch only first select statement on live server

43
Is there any Filtering query in Mysql to sorty by relevance?

Is there any Filtering query in Mysql to sorty by relevance?

Is there any way to write a filtering query for the following scenario in mysql

20
Database design for B2B2C system

Database design for B2B2C system

I want to create an application, where my direct clients are business personThey would use the application to make transactions with their customers

21