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
The COUNT() function returns the number of records in a select query. To understand COUNT function, consider an products table, which is having following query First you can need database connection in php Code
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
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
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.
The AVG() function returns the average value of a numeric column. To understand AVG function, consider an products table, which is having following query Code
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 […]
As a CodeIgniter developer, it’s really important for you to understand how to work with the core session library. Of course, you could always use the default $_SESSION syntax. If you want to work with sessions in CodeIgniter, the first thing you’ll need is a built-in session library. While that’s not the case most of […]
You can use multiple tables in your single SQL query. The act of joining in MySQL refers to smashing two or more tables into a single table. Assume we have two or more tables in TUTORIALS. Now take a look at the examples given below. Code
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