I am migrating from Advantage Database Server 11 to MySQL 8.0.33 and also testing MariaDB 11.0.2. I haven't landed on which one to use yet but I know I will need to use cursor variables and cursors within cursors a…
I have a column from which I would like to retreive only those values which are only consecutive identical characters like 'ppp' 'mmmm', 'ddddd'. The length of the string will be greater than or equals to 3 I tried different…
I run into this situation from time to time, where I want to take a list of things and see if any of them exist in another list. If you have a single number, it's simple enough to use a…
I am having some issues with my php code. The website is ...update.php?operation=pluseinsgast?variable=test and the following code: <?php error_reporting(E_ALL); ini_set('display_errors', 1); $connection = mysqli_connect("censored"); // Step 3: Determine the operation (increment or decrement) $operationa = explode("?", $_GET['operation']); // Assuming the…
I've made a TCP server for a turn-based game in C#. The server uses MySql for the database and uses stored procedures for all database interactions. All database interactions are contained within a repository layer which is injected into a…
I need to get table_schema, Table_name and total number of columns from information_schema in mysql (In short all the table names, with no.of columns each table is having in all schemas). Let me know if there someone is having handy.…
On the server with the operating system ubuntu 22.04.2 installed MySQL version 8.0.33 with the following configuration: /etc/mysql/mysql.conf.d/mysqld.cnf # # The MySQL database server configuration file. # # One can use all long options that the program supports. # Run…
@Query(value = " with cte as (n" + " select id, 1 as quantityn" + " from productn" + " where id = :productIdn" + " union alln" + " select distinct combo_id as id,n" + " quantityn" + "…
I am trying to export a database which is protected by a SSH key and a private network, meaning I can't login to the host itself to run mysqldump locally and somehow the ssh -i "key" doesn't work for me…
I'm currently using PlanetScale for database hosting and I'm trying to monitor my queries' performance so that it doesn't affect pricing too much and I see that my recently added SQL query is hitting the database pretty hard and it…