How to convert any date format to "dd/mm/yyyy" in mysql
I am struggling with one issue in mysql. Can anyone please suggest me, How to convert any date format to "dd/mm/yyyy" in mysql.
Mysql view from tables without duplicates and a concatenated column
I need to collect data from different tables, without duplicates and with a column that collects the presence where I've found each item. So, this is my scenario: TABLEA itemId name 1 John 2 Sam TABLEB itemId name 1 John…
Mysql – Why SELECT … FOR SHARE is not blocked by another transaction's UPDATE？
Schema: CREATE TABLE `table0` ( `pkId` int DEFAULT NULL, `pkAttr0` int NOT NULL, `coAttr0_0` int DEFAULT NULL, PRIMARY KEY (`pkAttr0`), KEY `table0index_pk` (`pkAttr0`), KEY `table0index_commAttr0` (`coAttr0_0`) ) insert into table0 values(1,1,1); Then execute: session1 > begin; session1 > update table0…
Mysql – Laravel does not validate input data before insertion
I encountered an error when the user registers, everything is ok and works perfectly, but when the user registers again with the same previous data, it shows this error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '123456789' for key 'users.users_phone_unique'…
Does changing MYSQL table engine from MYISAM to INNODB can cause a data corruptions?
I have a simple question. I have a mysql databases. I have 2 tables, that uses MYISAM, I want to change to INNODB, one of the table has 1.000 rows, if I do this this change, is there a risk…
How can I construct a MySQL query to select posts with specific associated information?
I am working with three tables in my MySQL database, and I need some help constructing a SELECT query. The structure of my tables is as follows: posts table: (postId, userId, post) likes table: (userId, postId) users table: (userId, email,…
Mysql – Jpa @Query Annotation problem to use IN clause with java ArrayList
i have problem to use in clause in jpa Query when i use c.id IN (1,7) its work fin but when i use c.id IN :categories its give me this error org.hibernate.type.descriptor.java.CoercionException: Cannot coerce value [1, 7] [java.util.Arrays$ArrayList] as Long…
Mysql – Transforming a class diagram to a SQL database
I have this part of a class diagram that I want to translate into SQL: Piece of class diagram: My internship supervisor sent me this SQL code: CREATE TABLE `users` ( `Matricule` varchar(50) NOT NULL, `Password` varchar(50) NOT NULL, `Role`…
Mysql – Constraint check 'something' is violated
I am struggling with a problem and I hope someone could help a brother out. I tried INSERT INTO but got an error message: Error Code: 3819. Check constraint 'inventory_chk_1' is violated. To troubleshoot the issue, i want to examine…
Mysql – SQL handling conflicts with WHERE clause to display irrelevant data
I'm trying to make a monthly report with employee attendance case studies. I have 2 tables which are employee and attendance with the following details: employee teble attendance table after that I created SQL view to display the date column…