Category: MySql

0

Mysql FullText Tutorial

With the improved version mysql Mysql also got enriched with various smart tectiques. One of the most beautiful technique is “MySql Fulltext” . This blog is totally dedicated to “Mysql Fulltext Feature”. What is...

0

Calling a Stored Procedure from PHP

Calling a stored procedure with PHP only possible after connecting PHP with Mysql. Apart from conventional way of mysql connection . There are two ways to connect PHP with mysql i)    The database independent...

0

Disable Foreign Key checks or constraint in Mysql

Referential integrity/relation is one of the best feature for database architecuture. But in certain case we need to clear or disable these checks otherwise we can’t do normal modification within our data because if...

0

Insert into select Mysql query example

We often looking for mysql query to copy data from one table to another table.To handle such kind of scenario using mysql query mysql we can use below mysql command. INSERT INTO new_table (column1,...

1

Remove duplicate records using mysql query

As a developer we always require to remove duplicate field values from our db tables. Some time we are in hurry and we don’t want to do brain storming to find out the solution...

0

Concepts of Locking in Mysql Database

Mysql Database is a RDBMS which also support transactions. Transactions are guaranteed only through ACID property. Following are the full form of ACID A- Automicity (Any Transction within the database should follow “Do All...

1

Maximum rows in Mysql database table

This is the very general question which usually comes in a developers mind that “How much data a mysql table may contain”. This question is also important because as a developer we must know...