How to use of limit clause in mysql with php script

How to use of limit clause in mysql with php script We can retrieve limited rows from the mysql table using the LIMIT clause. I can be used in pagination where are forced to show only limited records like 10, 20, 30, 40 etc. You can use syntax of LIMIT into PHP function mysql_query().This function […]

SQL ORDER BY Clause

We have already seen SQL SELECT command to fetch data from MySQL table. When you select rows, the MySQL server is free to return them in any order, If you want result in sort form you can sort a result set by adding an ORDER BY clause that names the column or columns you want […]

SQL AND condition

The SQL AND condition is used in a SQL query to create a SQL statement where records are fetching. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement. The SQL AND condition requires that both of conditions should be true. Let’s see the syntax of AND condition in select […]

SQL OR condition

The SQL OR condition is used in a SQL query to create a SQL statement where records are fetching. It can be used in a SELECT statement, INSERT statement, UPDATE statement or DELETE statement. The SQL OR condition requires that one of them conditions should be true. Let’s see the syntax of OR condition in […]

MySQL WHERE Clause

MySQL WHERE Clause We have seen SQL SELECT command to fetch data from MySQL table, UPDATE command for update data into mysql table, DELETE data from mysql table. We can use a conditional clause called WHERE clause to filter out results. Using WHERE clause, we can specify a selection criteria to select required records from […]

Difference between DROP and TRUNCATE statement

Difference between DROP and TRUNCATE statement When you use the drop statement it deletes the table’s row together with the table’s definition so all the relationships of that table with other tables will no longer be valid. When you drop a table: 1. Table structure will be dropped 2. Relationship will be dropped 3. Integrity […]

Difference between delete and truncate statements

Difference between delete and truncate statements There is a slight difference b/w delete and truncate statement. The DELETE statement only deletes the rows from the table based on the condition defined by WHERE clause or delete all the rows from the table when condition is not specified. But it does not free the space containing […]

How to copy a sql table into another sql table

How to copy a sql table into another sql table If you want to copy a SQL table into another table in the same SQL server database, it is possible by using the sql select statement. The syntax of copying table from one to another is given below. Select * into from The Example of […]

sql alter table query

sql alter table query You can modify the mysql table using ALTER TABLE statement, It is used to add, modify or delete columns in an existing table. It is also used to rename a table. You can also use SQL ALTER TABLE command to add and drop various constraints on an existing table. SQL ALTER […]

Tools:

Crypto Currency

PHPKIDA provides free online the best real-time crypto market price, news, predictions, index with graphs & historical data for 2000+ coins including bitcoin, ethereum, & altcoins from major cryptocurrency exchanges.

Visite Tool

Icon Generator

PHPKIDA provides free online icon generator. Our icon generator help you to edit, modify, resize and customize icon for your website and applications. Convert to a shap you like add icon border, you can change icon border color, border size, background color, icon shadow, icons color, icon size in your own way and save it as a png image.

Visite Tool

Youtube Video Downloader

PHPKIDA provides Free online YouTube video downloader to download YouTube videos quickly in MP4, 3GP, and more. Search your video and free fast download youtube videos.

Visite Tool

Sign up for weekly update

Milkshake is almost ready. If you're interested in testing it out, then sign up below to get exclusive access.