I'm looking for the efficient way to store week days and times of each event. How do I achieve the following result Events table id name dates rel_id 1 hello w
I am creating one table which has one column which supposed to store more than 5-10k coordinates at a time. I have declared it as longtext but while storing it
Importing CSV file to MySql Server through MySQl WorkBench . Every it gets terminated. Tried lot of solutions from internet. Still not working
Upgraded to Windows 11, now XAMPP MySQL won't start. Tried to change ports, run as Admin etc, no luck. MySQL isn't being run in Services by anything else. Anyon
Recently I noticed few queries are taking very long time in execution, checked further and found that MySQL Optimizer is trying to use COLLATE in Where clause a
A fiddle of the question below can be found here. I'm attempting to get a list of all articles regardless of their joined association. Let's say we have the fol
My database in hosted on AWS RDS. I am having connectivity issue and getting this error: sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2003,
I am trying to connect my local MySQL server, but I am facing this error message. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/l
I have a MySql Function which makes updates to a table, inserts a row into another table and returns an integer value. When I call this function from Superset's
I have run into this a few times now, where I'm trying to insert (or bulk insert) into a MySQL table using VALUES without defining the columns explicitly, but t
I have tried searching around, but could not really find a solution to my question. Either that or I am not really understanding something properly. I have a pa
I am trying to make a my first relationally table structure for a tennis/Padel competition program that registers the scores (sets.)of dubbel matches(4players).
I have this query that receives a parameter from user input and I think that I am vulnerable to SQL injection. $query = "SELECT pcode,price,description FROM pro
I have table with row id, name, created_at and I want to output the created_at row as timestamp time ago in php
There is a table objects, which stores data on real estate objects. Me need to use a query to calculate a new field that will display the date range from Monday
i have a table named test with the below structure like this id mark join_id 1 5 1 2 4 1 3 9 1 4 5 2 5 7 2 6 12 2 i want to write a que
Here is an example of my table. ┌────────┬────────&#
There is a table which has multiple fields including a Date column at which the current record gets updated. Col1 Col2 Col3 Date A X1 Y1 Today B X2 Y2 Today C
**I am trying to connect and read data from MySQL database in node js and react project with client and server setup but unable to get success, here is the code
I have two tables: "Customer" and "Order". The "Customer" table has an attribute called noOfPurchases, and the "Order" table has an attribute called quantity. H