devxlogo

MySQL

Using the Replace Command in MySQL

REPLACE is similar to INSERT command. The REPLACE command behaves as INSERT when there is no record matching the constraints. It still removes the existing records and again acts as

Understanding OFFSET in MySQL

Imagine that you have already fetched a few hundreds records matching certain criteria. Now, all that you need is the next 10 from that point on. MySQL has a handy