Skip to content

Scripts Gurus

  • Home
  • Laravel
  • PHP
  • jQuery
  • Javascript
  • Mysql
  • Codeigniter

Category: Mysql

Create MySQL table by using another table

Create MySQL table by using another table

April 23, 2019June 2, 2019

Create MySQL table based on one or more existing tables. Here we create a new table called TempCustomer for […]

Read More
Mysql Drop Table Query

Mysql Drop Table Query

March 7, 2019May 23, 2021

The DROP TABLE statement is used to drop an existing table in a database. It is very easy to […]

Read More
Mysql WHERE Clause

Mysql WHERE Clause

March 7, 2019May 23, 2021

We have seen the SQL SELECT command to fetch data from a MySQL table. We can use a conditional […]

Read More
MySQL – Create Trigger

MySQL – Create Trigger

January 25, 2019December 29, 2021

A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute […]

Read More
Prepared Statements in PDO – MySQL

Prepared Statements in PDO – MySQL

January 24, 2019January 25, 2019

A prepared statement (also known as parameterized statement) is simply a SQL query template containing placeholder instead of the […]

Read More
Mysql Select Query

Mysql Select Query

December 6, 2018May 23, 2021

In MySql Select query make a big role in data manipulation. select is a DML function. The SELECT statement […]

Read More
Left Join Query in Mysql

Left Join Query in Mysql

December 5, 2018May 23, 2021

The SQL LEFT JOIN returns all records from the left table (jobs), and the matched records from the right […]

Read More
How to use alias in group by clause in php using mysql

How to use alias in group by clause in php using mysql

October 27, 2018December 20, 2019

In last tutorial, we have had a glimpse about how to use Group By clause. Rows in a table […]

Read More

Posts navigation

Newer posts
Proudly powered by WordPress

Theme: moina by ashathemes.