I have this table: create table TableName5 ( col1 varchar(200), col2 varchar(200), col3 varchar(200) generated always as ('col1' + 'col2') stored ); The col3 is supposed to be a computed column - the value in col1 plus the value in…
Hello I have a decent amount of experience in as a SQL developer in Microsoft SQL but little to no experience as a DBA and I'm just starting to learn MySQL. Basically I have a scheduled stored procedure that runs…
There are two tables: User table `user` +----+----------------------------+-------------+ | id | date_created_user | email | +----+----------------------------+-------------+ | 7 | 2023-02-23 13:23:09.085897 | [email protected] | | 16 | 2023-02-25 14:23:31.691560 | [email protected] | | 17 | 2023-02-25 14:24:02.089010 | [email protected] |…
I have a table called uk that contains a field called EvName. EvName is mediumtext format and contains entries with the following syntax: Rochdale 1st Jan - 12:20 2 hours 30 min I want to extract the time from EvName…
My goal is to get a result where it will output all exercise entries, with a single related video, then a concatenated string of all associated tags (where tags is one table and tag_linkage is how the tags relate to…
When I try mysql I get: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) This is the result of systemctl status mysql.service : × mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset:>…
this is the error I have tried to re-install, but still same error
This is my table : id name age role --------------------------------------- 1 Rahul 20 1 2 Karan 35 0 3 Vivek 47 0 4 Shubham 40 1 5 Paras 87 1 6 Arjun 18 1 7 Ayush 28 0 I want…
I've got a PHP+mySQL website that shows data of 300,000 products: name, description, how to fix it, where to buy it, etc. Initially, the mySQL table is designed in the following way: - product_id: MEDIUMINT - category_id: SMALLINT - weight_kg:…
exports.signup = async (req, res) => { const { username, password, name } = req.body; // TODO: Validate if username exists await knex("users").insert({ username, password, name }); const user = await knex("users").where({ username }).first(); // const users = await knex("users").where({username});…