In the following case: CREATE TABLE Persons ( groupId int, age int, Person varchar(255) ); insert into Persons (Person, groupId, age) values('Bob' , 1 , 32); insert into Persons (Person, groupId, age) values('Jill' , 1 , 34); insert into Persons…
I have two columns and i wanted to display all the combinations of a single columns Table 1 column1 column2 value 145 value 146 value2 13 value2 56 value2 364 I have used selfjoin, but that doesnot workout. SELECT a.column1…
I cannot get my spring-boot server to run against my database using docker. If I start up my mysql database (called shape-shop-db-container) and intialize the database like so : docker run -d -p 3306:3306 --name=shape-shop-db-container --env="MYSQL_ROOT_PASSWORD=root" --env="MYSQL_PASSWORD=root" --env="MYSQL_DATABASE=shapeshop" mysql docker…
Schema Details We are maintaining collections data in a project. Main columns of Collections table are id(INT), collectionId(String UUID), versionNo(INT), status(PUBLISHED/NEW/PURCHASED/DELETED/ARCHIVED). Each collection can have several versions. For each different version, versionNo, id, status column will have different values but…
I have 2 tables in Mysql. I want to regroup and count the Number of Orderid per month for each customer. If there is no order, I would like to add 0. Customer Table CustomerID 1 2 3 Order Table…
dept_id course_id student_id CS 101 11 Math 101 11 CS 101 12 CS 201 22 Math 301 22 EE 102 33 Math 201 33 This is the current sql table called "enrolled" and I need to select all the departments…
The central database(blue) will hold all customer data of the project. The local databases(green) will be deployed at the physical locations containing a copy of the customer databases. Multiple stores can be deployed across geographical areas (A, B,...N) to allow…
I am stuck with a problem where I have a table with JSON column like this: ID|VALUE 1 |{"a":"text1234","b":"default"} 2 |{"a":"text1234","b":"default"} 3 |{"a":"text1234","b":"text234"} 4 |{"a":"text1234","b":"default2"} 5 |{"a":"text1234","b":"default2"} I would like to get all rows where value "b" is duplicate, so…
How is it possible to show all orders which are not completely paid off related to a client? for e.g. SHOW ALL order details of ‘unpaid’ ORDERS for CLIENT ‘50’ table: orders id order_total client_id 1 15.00 50 2 18.50…
I noticed that a query that used to be fast in legacy version of Django is now much slower in 4.0.8. There is a fairly large table with a FK 'marker' and a boolean 'flag' that has an index attached.…