For my assessment I have to obtain such result from mysql database: +---------------------------------------+---------------------------------------+-------+ | name | name | item | +---------------------------------------+---------------------------------------+-------+ | Krispy Kreme - Edinburgh Lothian Road | 6 Assorted Doughnuts | 12.95 | | Krispy Kreme - Edinburgh…
I have 2 tables on MySQL: phy and VM. Here is the phy table: and here is the VM table: I want to get a result like an image below: I type the command below like this: select ip, name,…
I need to connect to my database but I keep getting an error that says "driver not found". I have added mariadb-java-client-3.0.8.jar jar file and it is still not working. And this works pretty well on NetBeans, but I need…
I have a mariadb server running on debian. (version: 10.3.34-MariaDB-0+deb10u1-log Debian 10) I have used the package from the repository, so it was compiled with YaSSL (version 2.4.4). Therefore the newest SSL version of the server is TLS1.1. On the…
I have the following tables: Teammate ID Teammate name Team id Teams 1 Amy 11 Sales 1 Amy 12 Support 1 Amy 13 Marketing 2 Peter 12 Support 2 Peter 13 Marketing And I want to group my results so…
I have a 'users' table for general information of every user (primary key is 'user_id') and a table 'chat' to store messages (primary key is 'msg_id') that have 'incoming_msg_id' (which eventually corresponds with 'users.user_id') and 'outgoing_msg_id' (which eventually corresponds with…
I know that this MariaDB version 5.5.68 is really out of date, but I have to stay with this old version for a while. Is there a way to prevent toxic selects, possibly blocking MyISAM tables for a longer time…
let's say i have this id center right 1 Two NULL 1 NULL Three and want to be like this id center right 1 Two Three my first table is just a representation of what actually I am encountering, everything…
So I have a table in my SQL and it saves ServerID from discord, now like 500 users verified and on the table it says like ServerID: 123 User: Test Now I accidentally I have deleted the server on dashboard…
Source: MS Access on Windows network share Target: MySQL/MariaDB on Ubuntu Tools: mdb-export, mysqlimport record count: 1,5 Mio + I wonder if there is a fast and reliable way of comparing the imported data records. Is there an SQL standard…