I'm using this version of MySQL Ver 15.1 Distrib 10.5.4-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2 and here is my server cpu info: cat /proc/cpuinfo I have 2 tables. Office and Customer. I have 1 row in my Office table…
I have two tables, tbl_msg and tbl_details.(Like the photo below) I want to select the last message of each chat, like the image embedded with SQL, such as WhatsApp and Telegram chat lists.(sql code). please help me. thank's
I want to connect my android application to my phpmyadmin sql database please anyone give me a simple code to do that
I have 2 table with this sample data. Parent id title 1 A 2 B 3 C Childs id p_id number 1 1 1 2 1 2 3 1 3 4 2 4 5 2 5 6 2 6 7…
Wordpress. from litespeed to ngix server. All of my links to plugins, images CSS and scripts added "%20" on the end. Example: https://example.com%20/wp-content/plugins/wp-maintenance-mode/assets/css/style.min.css? I assume the solution would be to change all "example.com%20" to "example.com" in the database. What would…
A tip would be welcome. I tried to create an expression index on id_contrato but it gave me only 1s of speed. The query is taking 17s. I just need some medium to small improvement . I am using Firebird…
I've created table in PostgreSql: DROP TABLE IF EXISTS es_events; CREATE TABLE IF NOT EXISTS es_events ( id SERIAL, name VARCHAR (50) NOT NULL, version INT NOT NULL, data BYTEA NOT NULL ); now i'm trying to select from this…
SELECT * FROM userfeedback WHERE DATE LIKE '2020-07%' OR DATE LIKE '2020-08%' OR DATE LIKE '2020-09%' OR DATE LIKE '2020-10%' OR DATE LIKE '2020-11%' OR DATE LIKE '2020-12%' OR DATE LIKE '2021-01%' OR DATE LIKE '2021-02%' OR DATE LIKE '2021-03%'…
So I'm trying to search and print the value from the PHPMyAdmin database. But the result shows all row which has variable with containing the value. Like when I try search variable int bulan that has value 2. This also…
I have tried to create a table in a MySQL database with phpmyadmin. The problem occurred when I try to execute this following query: CREATE TABLE users( account_id INT(20) NOT NULL AUTO_INCREMENT DEFAULT '100001', PASSWORD INT(20) NOT NULL DEFAULT '0',…