Concatenate Multiple Columns in MySQL

Last Updated On: January 1, 2021January 1, 2021| By: Parvez

in this tutorial, We ll concatenate two or multiple columns in MySQL.We will select the values and concat multiple columns using MySQL inbuilt method. It can also achieve same thing using programmatically. You need to select columns fields value separately from MySQL Table and store their values in the single variable after concat their values. […]

Create Dynamic SQL Insert Query in PHP and MySql

Last Updated On: March 26, 2018March 26, 2018| By: Parvez

This PHP tutorial help to create dynamic sql insert query using table and data .I have taken this function reference from google search. This function is very useful when you are working model level architecture. In this function main restriction is data key value is same as table column name like other framework ORM. Example […]

Simple Example to Create View in MySQL

Last Updated On: June 24, 2017June 24, 2017| By: Parvez

MySql View is very important factor of Database based on performance. View is virtual table that’s contains result set of your SQL statement. In SQL statement yo can use SQL functions, WHERE, and JOIN statements to get result set. The View table can contain rows and column like your original table the column name may […]

How To Run PHP and Mysql from Command line in Windows

Last Updated On: March 9, 2017March 9, 2017| By: Parvez

This tutorial will cover run php script from command line and Run MySQL from command line in windows, Sometimes we have big file and run through command line instead of browser, So we need run php script with help of command line.We can also import big data file from sql file to database through command […]

phpMyAdmin Not Showing Tables Even Table exists

Last Updated On: February 23, 2017February 23, 2017| By: Parvez

This is common problem when you are importing database in phpmyadmin, you can see these tables on workbench but not in phpmyadmin view. This problem due to user access of database. Your database has some views which has privilege of user which is not existing in your phpmyadmin. You can solve above problem following ways: […]

Sponsors