Converting a value to Currency – Mysql
this seems like a simple fix but I'm stuck. I have a list of values ex: 8564899 that should be displayed as 85,648.99 and NOT 8,564,899. If I can't convert to currency. I would just like to cut the last…
dockerized django application cannot connect to mysql server on localhost
I have a Dockerized django application I am running and I am trying to connect it to a mysql server I have that is port forwarded from another docker container. I have done a sanity test already and confirmed that…
sqlalchemy.exc.ArgumentError: List argument must consist only of tuples or dictionaries – Mysql
I have been trying to dump data into a mysql database using sqlalchemy. While I try do so its gives the error sqlalchemy.exc.ArgumentError: List argument must consist only of tuples or dictionaries . The following code is being used for…
My WPF application does not start on another PC, while an application with no MySql works, what could be the problem?
This is my first using a database. I've made an application that contains tables in dbForge through mySql localhost with XAMPP. I copied all my files and downloaded the latest 6.0 framework on the other PC, but it does not…
transfer several parameters from a form into SQL query – Mysql
i am working on a table that includes a filter function. For the filter i use a form where i enter the parameters. Those are added to a string which is my SQL query. So far it works fine. There…
How to select from database using explode – Mysql
I want export data from my SQL database. Simply use : SELECT `id`,`tags` FROM `posts` This query give me those results : (1, 'handshake,ssl,windows'), (2, 'office,word,windows'), (3, 'site') I want results in this form: (1, 'handshake'), (1, 'ssl'), (1, 'windows'),…
MySql 8 installation on widows: Database initialization failed, Empty value for 'open_files_limit' specified
I was installing mysql server for a course, and I can't install it, please help. Beginning configuration step: Initializing database (may take a long time) Attempting to run MySQL Server with --initialize-insecure option... Starting process for MySQL Server 8.0.31... Starting…
Count unique event per month – Mysql
Im trying to find the total count of event names. My table has a column Royalty_Month and Event_Combined. If an event appears in Month A, I dont want to count it in Month B. This is the query I have,…
What is the operation logic of WHERE Clause? – Mysql
enter image description here This question is from HackerRank (Top Earners). I wonder why SELECT MAX(months * salary), COUNT(*) FROM Employee WHERE (months * salary) = MAX(months * salary) this query doesn't work, but SELECT MAX(months * salary), COUNT(*) FROM…
MySQL queries waiting for lock never actually time out
I'm trying to test an application's behavior when one of its queries encounters a lock. I'm using InnoDB, so I ran set global innodb_lock_wait_timeout = 5; Then I locked a table in one client: lock tables ``my_table`` write; And tried…