I've tried to use the import table feature on mysql workbench to transfer csv excel files into mysql workbench but my files appear to be too large to import, it's stuck for hours and eventually fails (see picture). I've even…
I created a register page, in which I have the inputs email, password, first name, and last name. Upon clicking the "Register" button, I received an error message that says "TypeError: Cannot read properties of undefined (reading 'data') at handleClick".…
using Mysql with the following table: CREATE TABLE participants ( id INT AUTO_INCREMENT PRIMARY KEY, puuid CHAR(36) NOT NULL, data JSON, project INT GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(data, '$.project'))) STORED NULL, schoolCode VARCHAR(255) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(data, '$.schoolCode'))) STORED, UNIQUE KEY…
Creating a Auto Generation ID with Prefix in MySQL Without Using Trigger I need Creating a Employee Id with Prefix and Without Using Trigger in MySQL.
I'm working on a project for my class. How can I enter a value into a table with the datatype "DATE"? I tried using apostrophes, and without it. I kept getting errors. I'm using MySql. Edit: I'm getting an Error…
I have a MySQL database named wc_players in which it has a table called players_wc. I want to copy the entire table to another database named as fifa which already has a table named fifa_wc. How can i add this…
My Query is - SELECT ins.*, ic.* FROM insurance_data AS ins LEFT JOIN insurance_companies AS ic ON ins.provider = ic.id LEFT JOIN phone_numbers AS ph ON (ic.id = ph.foreign_id AND ph.type = 2) WHERE (ins.termination_date IS NULL OR ins.termination_date =…
I have two tables that I'm trying to join on authors_2's authorID column and author_note's aaID column: Table authors_2: id | name | aaID | authorID 1 | jimmy | 11129 | 1734 2 | mike | 15813 | 2469…
I've created an RDS instance on AWS and am trying to connect to it using MySQL Workbench from my local machine. I've configured the RDS instance to be publicly accessible, it sits in a public subnet with access to an…
I am working on an SQL problem for a class - "Provide a student/parent list. Formatted child name, parent name 1, parent name 2. If a child doesn’t have a parent, just display null." The expected result should look like…