Some time you want to know the host name of mysql server , but you have only access to the PHMYADING interface. Login to phpmyadmin interface You can use this command: SELECT * FROM `GLOBAL_VARIABLES` WHERE `VARIABLE_NAME` LIKE ‘hostname’;
Scenario : Imagine that you want to run an image service and your clients will use these images in their static site developments. The moment you change these in the server it automatically reflect in the client designs. This is a POC design and can be used in KIOSKS, Web designs etc. Basically wherever you… Read More »
Problem : Mysql database has datetime field and i want to get only date. Solution : SELECT CAST(`datetime_field` AS DATE) AS dateonly FROM etc….