I want to take my existing columns First_Name and Last_Name and concatenate them to add a new column Full_Name to the table Employees. (I am working on MySQL Workbench.) So, I tried concatenating columns of First_Name and Last_Name using the…
I would like to select all active categories and view it with a breadcrumb. In my database I have the following: id_category category_name velleman_id velleman_parent prestashop_category prestashop_category_2 prestashop_category_3 prestashop_category_4 deleted 1 Car & Bike 10 0 2 Bike 10.10 10…
I have the following collection { "_id": "12345", "Products": [ "Product1", "Product2" ], "State": "active", } And would like to project it similar to the output below _id: "12345" Products: "Product1, product2" I tried this but im not getting the…
I have a table like this. employee_id join_year join_month joindatetime first_name last_name 1 2011 03 2011-03-06 06:00:00 Mike Jordan 2 2012 11 2012-11-19 07:00:00 John Simpson 31 2019 12 2019-12-05 11:30:00 Jane Athur and I need to add a column…
I have such an example of tables: table1: col 1 col2 col3 col4 1 a x1 asdc 2 b x2 czxa 3 c x3 xfsdaa table2: col2 col3 l x56 q x99 All I want is to receive such a…
I need to group the data from my 2d array into an associative array of associative arrays where d values are the first level keys, and the s values will become the second level keys, and the i values should…
I have a DB that stores student records and there are 4 tables that I need to query from to get a student grade report. The tables being JOIN are school, students, subject, student_score, class The table structure are as…
I have a list of alphanumeric strings that includes two special characters + and -. The input, as shown below, represents part numbers for our company's products. I would like to extract the individual components as an output. There are…
I'm writing simple rock-paper-scissors game. In this piece of code I'm trying to assign id value of the clicked img to a variable using .forEach method. It just doesn't work. If statements does work but somehow string doesn't add to…
I have got a very large string, it contains about 13000 times different data of the same kind. I have now created a function to split this string into an array of 13000 elements. Now each element of those 13000…