Commands ForĀ Ubuntu mysql connect remote server For a client program to be able to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the…
Category: Mysql
posts related to database (Mysql)
Union Query in Mysql
$query = “( SELECT DATE_FORMAT( Date, ‘%m/%d/%Y’ ) AS date_time, id, type, ‘notes’ as table_name FROM notes WHERE p_id =’”.$pid.”‘ ) UNION ( SELECT DATE_FORMAT( DOS, ‘%m/%d/%Y’ ) AS date_time, id, type, ‘mt_d’ as table_name FROM mt_d WHERE p_id =’”.$pid.”‘…