Scenario : You want to test number of allowed parallel connections to your mysql Server . Steps: Create a Database Create a Table Create a PHP insert Script Test the Script Use ab.exe tool from apache. Create a table CREATE TABLE `test_table` ( `id` int(11) NOT NULL, `session_id` varchar(250) DEFAULT NULL, `date_time` timestamp NULL… Read More »
Scenario : You have online website with MYSQL Database and you want to see the live data in excel sheet. Solution : Create a MY SQL User account Give permission for Select query to the specific database Allow remote sql access permission to your ip address Download the .net connector for MYsql for Windows Configure… Read More »
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….