hello i have table profile that has many attributs, and the profile has on parent but the parent can have a parent etc.. I want to get all the list of the attributs(even the attributs of the parents) i wrote…
I was trying to get a data between yesterday's noon to today's noon. There are two columns for time, one is called in_date(date type) and the other one is called in_time(time type). At first, i tried to put those values…
I'm having trouble with the datatype of the primary key attribute in the MySQL database when deleting multiple records. I'm trying to delete multiple records in the database table, which primary key attribute has "varchar" data type. I dont get…
This is for a school project this page displays a table which is split into sections of 15 per page, however at the bottom of the table their are the numbers on which page to go to. My table has…
In Laravel, I have a model called FeatureRequest that can be voted on, thus creating a FeatureVote in a separate database table. A single FeatureRequest can have many FeatureVotes. I want to execute a query that: Excludes users' own feature…
I am getting Error 3780 when attempting to create the following table Tool in MySQL Workbench: CREATE TABLE IF NOT EXISTS Recipe ( Recipe_ID int primary key, Author varchar(50), Recipe_name varchar(50), Recipe_time int, # in minutes Prep_time int, Cook_time int,…
I am writing a small program in Java with Spring boot. It is connecting to a MySQL Database that is dockerized. upon running the program, I get the following Error message org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in…
I have two tables like this : Enterprises FullName Type ABC aze 1 DEF rty 2 Addresses Address1 Address2 Address3 Postcode City 165 Ward Street E1 7AW London 167 Ward Street E1 7AW London 10 Auckland Street N1 0AA London…
I have the following SQL statement. It selects the visit count (vc) for a particular date (vd) SELECT count(vid) vc, date(visitwhen) vd FROM book_visit where date(visitwhen) >=date_sub(now(), interval 14 day) group by vd order by vd desc This selects a…
For our new MySQL database, we are thinking of using UUID as the primary key stored as BINARY(16). The key values would be generated by the the below function in Java application, or by UUID_TO_BIN(UUID()) built-in functions in data loads…