Sponsored Links
MySQL
Less queries with INSERT ... ON DUPLICATE KEY UPDATE
Let's see how to optimize queries of our applications through the use of ON DUPLICATE KEY clause.
- Duplicate / Copy a record in MySQL
- Reset the MySQL root user password
- Delete those tables using JOIN
- Regular Expressions in MySQL query
- [All items MySQL ]
MySQL Help
This guide is intended to be of help to those facing the first known use of open-source DBMS. The topics covered range from installation to achieve practical examples of use with leading scripting languages.
- [All guides MySQL ]
MySQL has a similar function ucfirst () in PHP to convert a string into m. ..
- How do I count the occurrences of a character inte ...
- And 'possible to create a variable inside a query?
- How do I delete an index from a table?
- What is the difference between the indices (INDEX) and keys (KEY)?
- [All FAQs MySQL ]
REPLACE
Replaces occurrences of a substring
- LTRIM
- RTRIM
- TRIM
- WeekOfYear
- [All references MySQL ]
Sponsored Links
E-Learning
 |
MS Access (Advanced)
Learn how to create and manage databases quickly and easily. Starting from 29 €. |
 |
MySQL (Course)
Management of open-source database. From 39 €. |
 |
SQL and Database (Course)
Create and manage relational databases. From 39 €. |
