I have a table with codes for multilingual commands with a structure like this: id code lang text 1 exit_command de Fenster Schliessen 2 exit_command en Close window .... (The column lang also contains other languages such as Italian, Japanese,…
I get an error when running the integration tests: 0 passing (17s) 1 failure 1) Registration page register new users allowed and update status in the database: TypeError: Net.connect is not a function at new Connection (webpack:///./node_modules/mysql2/lib/connection.js:50:0) at ./node_modules/mysql2/index.js.exports.createConnection (webpack:///./node_modules/mysql2/index.js:10:0)…
I have a table with an item, its cost and the date it was added. CREATE TABLE item_prices ( item_id INT, item_name VARCHAR(30), item_price DECIMAL(12, 2), created_dttm DATETIME ); INSERT INTO item_prices(item_id, item_name, item_price, created_dttm) VALUES (1, 'spoon', 10.20 ,…
Using Spring Boot and JPA in Java, I am creating a vending machine simulator whereby there are 2 roles: "BUYER" and "SELLER". I have a table called users in a MySQL database that stores users along with their usernames, passwords…
I find this query and that takes 20 seconds for few rows... SELECT DISTINCT(BINARY `meta_key`) as meta_key_binary, `meta_key` FROM wp_postmeta ORDER BY `meta_key` ASC Is that deprecated in mysql 8? How to change it for mysql 8 than? Or any…
I am able to connect via the mySQL shell, but when I try from VS Code Nodemon crashes and i get the error. code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlMessage: "Access denied for user 'root'@'localhost' (using password: YES)", sqlState: '28000', fatal: true…
I have 3 tables: customers (CustomerID) orders (OrderID, CustomerID) orders_products (OrderID, ProductID) I need to select each customer with their total orders and total number of products ordered by them. To count total orders by each customer, the query is:…
Mysql version: 8.0.21 I am lookig of get the latest value of each "TableData" which has the type "fruit". Table Name: TableNames _________________________________________ | id | name | id_group | type | |-----------------------------------------| | 0 | AppleGroup | apple |…
the query is CREATE TABLE order( order_id int primary key, customer_name varchar(30) not null, product_name varchar(20) not null, date_ordered date, quantity int, unit_price float, phone_no varchar(20) ); the error is : ERROR 1064 (42000): You have an error in your…
I have the following tables in a MySQL database: team team_id name 3 Rangers 12 Capitals 19 Red Wings 4 Bruins 212 Avalanche 102 Flyers 20 Islanders 50 Sabres 7 Stars player id name 2 Zach 1 Deb 17 William…