Technology News, Tech tips, tricks and tutorials: MySQL

Completely remove apache MySQL PHP ubuntu Remove Apache and all of its dependencies. apt-get purge apache2 php5 libapache2-mod-php...Read More

Export MySQL database file using command line through ssh

Export MySQL database file using command line through ssh mysql> exit; # mysqldump -u [username] -p [database name] > [database ...Read More

MySQL database setup & user creation commands

MySQL database setup & user creation commands Login as root user with the below command. mysql -u root -p Create a database wit...Read More

Restore or import MySQL database file command prompt

Restore or import MySQL database file command prompt mysql -u username -P port -ppassword databasename < /tmp/ databasename.sql Read More

Get all tables names from a database using a single query

Get all tables names from a database using a single query SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_TYPE='BASE ...Read More

MySQL PHP

PHP MySQL example

PHP MySQL example <?php // CONNECT TO THE DATABASE $DB_NAME = ‘DATABASE_NAME’; $DB_HOST = ‘DATABASE_HOST’; $DB_USER = ‘DATABAS...Read More

Get lists of all column names from database table

Get lists of all column names and other information from the database table in MySQL using INFORMATION_SCHEMA.COLUMNS. All column n...Read More

Split MySQL string

Split MySQL string Split mysql string using SUBSTRING_INDEX() function http://www.w3resource.com/mysql/string-functions/mysql-substr...Read More

MySQL PHP

Get time of all countries

Get time of all countries http://www.worldtimeserver.com/current_time_in_UTC.aspx Get MySQL time: SELECT CURRENT_TIMESTAMP( ) S...Read More

MySQL PHP

Update existing date field, add interval using MySQL and PHP

Update existing date field, add interval using MySQL and PHP UPDATE tbl_name SET end_date = end_date + INTERVAL 18 DAY – INTERVAL 1 MO...Read More

JQUERY MySQL PHP

Fullcalendar integration with PHP MySQL

Fullcalendar integration with PHP MySQL http://developer-paradize.blogspot.in/2013/06/jquery-fullcalendar-integration-with.html <!...Read More

Search full name in MySQL

Search full name in MySQL SELECT large,fname,middle,lname,url,description FROM mainbirthday WHERE (MATCH(fname,middle,lname) AGAINST...Read More

Mysql tips & functions

Mysql tips & functions http://zetcode.com/databases/mysqltutorial/functions/ http://www.barattalo.it/2012/10/19/13-mysql-tips/ ...Read More

Mysql Joins example

Mysql Joins example http://www.datamartist.com/sql-inner-join-left-outer-join-full-outer-join-examples-with-syntax-for-sql-server ht...Read More

Format integer date in MySQL query

Format integer date in MySQL query mysql> SELECT FROM_UNIXTIME(1196440219); -> '2007-11-30 10:30:19' mysql>...Read More

Drupal MySQL PHP Web Server

Installing Drupal on Linux with Apache Webserver

To install and run Drupal, your web server must meet certain minimum requirements. SYSTEM REQUIREMENTS WEB SERVER Apache DATABASE ...Read More

Select Multiple Rows in One Column in SQL

Select Multiple Rows in One Column in SQL By using FOR XML we can do this NAME MOBILE AAA 1234567890 AAA 3254656796 BBB 324324...Read More

Inserting Comma Separated Values into Individual Rows in MySQL

DECLARE @String_Pos int,@String_Len int,@String_Cont nvarchar(100),@CommaSeparatedValues nvarchar(max) SET @CommaSeparatedValues='1|...Read More

SQL CURSOR