mysql Questions

Unknown column 'a.EntityVersion' in 'field list' – Mysql

March 24, 2023
grayjer
2 Answers

MySqlException: Unknown column 'a.EntityVersion' in 'field list' MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask<ArraySegment> task) in ServerSession.cs, line 962 MySqlException: Unknown column 'a.EntityVersion' in 'field list' MySqlConnector.Core.ServerSession.ReceiveReplyAsyncAwaited(ValueTask<ArraySegment> task) in ServerSession.cs System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable+ConfiguredValueTaskAwaiter.GetResult() MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in ResultSet.cs MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in MySqlDataReader.cs MySqlConnector.MySqlDataReader.CreateAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary<string, CachedProcedure> cachedProcedures,…

VIEW QUESTION

How do i achieve this result in MysQL with a single Query

March 24, 2023
jiji
2 Answers

i want to count how many times the code is repeated in each query without the last 3 letters. The capital letters in the code column is what i need. IDs Code 58112 DFGH dds 25554 JIIK sdf 58112 ABCD…

VIEW QUESTION

Create a stored procedure in MySQL to update a table with a flexible/dynamic set of columns?

March 23, 2023
mattstuehler
2 Answers

I can easily write a stored procedure that would take inputs and use them to update a table: CREATE PROCEDURE update_table ( IN parameter1 datatype1, IN parameter2 datatype2, ..., IN parameterN datatypeN ) BEGIN UPDATE table_name SET column1 = parameter1,…

VIEW QUESTION

Counts by eight-hour time interval – Mysql

March 23, 2023
Marco
3 Answers

I'm using this query to count the records in the table and it works, I perform a calculation by time interval, every eight hours, but now I have the problem that I can't calculate from 11.00pm until 7.00am the next…

VIEW QUESTION

How to wait until files are uploaded to Cloudinary before executing the next function in Node.js – Mysql

March 23, 2023
Sandaru Fernando
2 Answers

I want to upload the files to Cloudinary and then get the 'secure_url' s and insert them into a MySQL database. However my current code immediately execute the SQL function. How to make the SQL function wait till the Cloudinary…

VIEW QUESTION

DOUBLE value is out of range – Mysql

March 23, 2023
John Warwick
2 Answers

I am getting the error "DOUBLE value is out of range," but the suggested answers don't seem to work. The equation is: select 144254*8.524789415648847e307; I am going to guess that this is just a limitation of MySQL. The answer should…

VIEW QUESTION

Update with multiple joins in MySQL

March 23, 2023
Marwan
2 Answers

I'm having a problem updating tables in a MySQL database (InnoDB). I have three tables 1-orders Table orderId userId status 7 4 bending 8 4 bending 2- orderedProducts orderId productId quantity 7 22 1 7 24 1 8 22 2…

VIEW QUESTION

How to extract only numbers from string in mysql

March 23, 2023
Manish Chaudhary
3 Answers

I have a data like under mentioned in table in one column name remarks Will0017,Will0018, Kind0045 , DGRG0012 I want to extract only numbers from the same only like 0017,0018,0045,0012 How can I do the same in mysql. I have…

VIEW QUESTION

How to get all dates where the customer's total balance reaches 0 – Mysql

March 23, 2023
Programmer
2 Answers

I have a table as follows. It consists of many customers (only showing one customer, James, here for simplicity) who can have many accounts. Each account has a balance every day. My goal is to get all the dates for…

VIEW QUESTION

Get the Timestamp value from database as same as it is using java – Mysql

March 23, 2023
WCM
2 Answers

In a MySQL database table, there is column named loginTime and its type is timestamp. Its value is 2023-02-14 10:02:26. when I get the value to date type variable using java and I get value as 2023-02-14 10:02. How can…

VIEW QUESTION