posts related to database (Mysql)
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 user name and password of your MySQL account. Each connection parameter has a default value, … Read more
$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.”‘ ) UNION ( SELECT DATE_FORMAT( created, ‘%m/%d/%Y’ ) AS date_time, id, type, ‘docs’ as table_name … Read more