mysql

  1. Danishhafeez
    Thread

    What are pros and cons of PostgreSQL and MySQL? With respect to reliability, speed, scalability, and

    Both PostgreSQL and MySQL are popular and reliable relational database management systems. However, there are some differences between them when...
    Thread by: Danishhafeez, Feb 6, 2024, 1 replies, in forum: MySQL
  2. Danishhafeez
    Thread

    MySQL problem: Tackling Slow Query Performance in PHP Application

    Hey PHP and MySQL enthusiasts! I've found myself in a bit of a bind with slow query performance in my PHP application, and I'm turning to this...
    Thread by: Danishhafeez, Feb 2, 2024, 0 replies, in forum: MySQL
  3. Richard To
    Thread

    How to use Query Rewriter Plugin to tune SQL in MySQL database I

    The Query Rewriter Plugin in MySQL is a component that allows you to modify incoming SQL queries before execution. It provides the ability to...
    Thread by: Richard To, Dec 7, 2023, 0 replies, in forum: MySQL
  4. Kurtern84
    Thread

    How to update ranking and points for players in MySQLi when uploading new cvs file

    As the title says. I have a website with table showing ranks of poker tournaments, I have created a db where I uploaded a csv file with the last...
    Thread by: Kurtern84, Jul 18, 2022, 0 replies, in forum: PHP
  5. Richard To
    Thread

    How to Tune SQL Statements with Rewrite and Hints Injection for MySQL?

    There are some SQL statements with performance problem have to be tuned by SQL syntax rewrite and Hints injection, it is a little bit difficult...
    Thread by: Richard To, Jun 29, 2021, 0 replies, in forum: MySQL
  6. Richard To
    Thread

    How to Tune SQL Statements with CONCAT Operator for MySQL?

    There may be some business requirements that need to compare concatenate strings and column with a given unknown length of the bind variable....
    Thread by: Richard To, Feb 19, 2021, 0 replies, in forum: MySQL
  7. Richard To
    Thread

    How to Tune SQL Statement with IN List Bind Variables for MySQL?

    The following is an example shows a SQL statement with a variable on the IN List operator. The SQL retrieve records from EMPLOYEE table that...
    Thread by: Richard To, Dec 10, 2020, 0 replies, in forum: MySQL
  8. Richard To
    Thread

    How to Tune Delete SQL statement with subqueries for MySQL?

    The following is an example shows a DELETE SQL statement with subquery. The SQL delete records from emp_subsidiary that should satisfy with three...
    Thread by: Richard To, Nov 23, 2020, 0 replies, in forum: MySQL
  9. kost36
    Thread

    Group_concat into group_concat with two different separators

    I use the follown as one movie's page SELECT `mt_films`.`Title1` AS `Title1`, GROUP_CONCAT(DISTINCT `t_idiotita`.`idiotita`,...
    Thread by: kost36, Nov 17, 2020, 3 replies, in forum: MySQL
  10. Richard To
    Thread

    How to Tune MySQL UPDATE SQL statement with IN subquery II?

    I showed you how to tune an Update statement with a simple subquery in my last blog, a more complex update statement will be discussed in the...
    Thread by: Richard To, Oct 22, 2020, 0 replies, in forum: MySQL
  11. Richard To
    Thread

    How to tune “order by rand() limit 1” SQL statement ?

    There may be some business requirements that needs to retrieve only some rows from a table (or join tables) randomly. This kind of SQL is normally...
    Thread by: Richard To, Aug 6, 2020, 0 replies, in forum: MySQL
Showing results 1 to 11 of 11
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice