Category: mysql

Mysql Drop Table Query

The DROP TABLE statement is used to drop an existing table in a database. It is very easy to drop an existing MySQL table, but you need to be very careful while deleting any existing table because the data lost will not be recovered after deleting a table. Code

Bootstrap search box

In this tutorial we are going to explain you how to perform Bootstrap class and create search form so below code available just copy and paste that is work and assign Bootstrap css file. HTML Code

Mysql Select Query

In MySql Select query make a big role in data manipulation. select is a DML function. The SELECT statement is used to select data from one or more tables. The SQL SELECT command is used to fetch data from the MySQL database. First you can need database connection in php Code

Left Join Query in Mysql

The SQL LEFT JOIN returns all records from the left table (jobs), and the matched records from the right table (clients). The result is NULL from the right side, if there is no match. Code Here is image to help you understand more about SQL join.

how to make ajax call in laravel

Hello, everyone in this post we are share with you how to make simple ajax crud inlaravel application from the scratch. You are going to work with ajax data post to controller or route in laravel 5. There are some need to get ajax call work correctly. Your requirement is csrf token in meta tag. Ajax data post […]

Mysql UNION Query

The UNION query is used to combine the result-set of two or more SELECT statements. Unions combine the results from multiple SELECT queries into a consolidated result set. Code