Good morning to all, Here I going to demonstrate how to reset auto-increment value in MySql. Assign to auto-increment attributes to a column of a table, to generate unique identity for the new row. If new row is inserted it incrementsthe value one. Whenever you insert a new row into a table, MySQL automatically assigns… Read More »
Hi all, The SQL joins are used for combine rows from two or more table based on a common field between them.We are discuss this topic today. It fetch data from two or more tables and which is joined to appear as single set of data. Join Keyword is used in SQL queries for joining… Read More »
Hi all, Here I share some useful information in sql queries like truncate command, drop command alter command. These is more helpful in MYSQL operations. For delete complete data from an existing table using TRUNCATE command. And also delete the data inside the table. For delete a table using DROP command. It helps to remove… Read More »
Hi friends, One of the common question amoung the beginers or freshers is what is the difference between include and require function. In this article describe what are the difference between these two. If you want to include the PHP file into another PHP file, before the server is execute. This will help web developers… Read More »
Welcome to all, Today we practise how to sort an array using php. We know this same problem solving using C, CPP or JAVA etc. But here I share how to solve this problem in php. To arrange the elements in an array in numerical order from highest to lowest values (descending order) or lowest… Read More »
Hi Guys, Today we share our idea related to AND and OR operator with example. The AND and OR operators are the conditional operator in SQL. It is used to filter the data or records based on conditions. The main difference between AND and OR operators are: the AND operator displays a record if both… Read More »
Hi all, Welcome to MYSQL functions tutorial. MYSQL functions are useful while performing mathematical calculations, string concatenations, sub-strings etc. SQL provides many built in functions to performe these functionality or performing calculations on data. The most commonly used MySQL functions including: Aggregate functions String functions Date time functions control flow functions Aggregate Functions The aggregate… Read More »
Hi Guys, In one of the recent web developer interview, one interviewer ask “what is the difference etween == and === in php”. All are face this same situation in interview panel. Nobody knows the theory part. Then everybody shocked. Based on this situation, I just describe what are the difference between these two. These… Read More »
Hi Guys, Welcome to sql set operations. SQL support some set of operations to be performed on MYSQL tadabase table. These are used for getting meaningful results from table, based on different conditions. Union MySQL UNION operator to combine two or more SELECT statements into a single result set. UNION operator helps to select rows… Read More »