I have a server running at let’s say 10.55.1.95 that runs MySQL database engine. I try connecting to it on a different server lets say 10.55.1.98 via a connection string like sql_alchemy_conn=mysql+mysqldb://my_user:[email protected]/my_db but I get an error saying access denied…
I have a table with tax rates. Each tax rate has two date fields: 'valid_from' and 'valid_to'. 'valid_to' can be NULL, then the tax rate is valid until a later tax rate is inserted. Now I want to determine all…
I'm using MySQL: Server version: 8.0.36 Homebrew I'm trying to remove the default value of a column (currently set to 0), and it's erroring: ALTER TABLE comments ALTER COLUMN commentable_id integer DROP DEFAULT; ERROR 1064 (42000): You have an error…
I want to find the lowest missing number from two tables For Example, Table1 columna has 1,2,3,8 Table2 columnb has 4,10,11 I want to return 5 I have been able to get the lowest missing number from one table, i.e.…
Is it possible to count occurences of strings like 'pass' and 'fail' inside a Group_Concat()? I have the following situation there I need to count the occurences of 'pass' and 'fail' I need to count how often 'pass' and 'fail'…
Background: Several years ago I developed a simple WordPress site for my local government that they took over in terms of managing/updating. This summer a local resident contacted me stating the site wasn't loading, and I reached out to the…
As I found out there is strict = true in config.database.php which causes the problem with ONLY_FULL_GROUP_BY mode for Mysql. This mode does not allow to make simple group by and add some weird restrictions on sql queries. I dont…
Question: I have the following table and data setup: CREATE TABLE EMPLOYEE ( empId INTEGER AUTO_INCREMENT PRIMARY KEY, name TEXT NOT NULL, dept TEXT NOT NULL ); INSERT INTO EMPLOYEE(name, dept) VALUES ('Clark', 'Sales'); INSERT INTO EMPLOYEE(name, dept) VALUES ('Dave',…
So I have a result like this gotten from multiple LEFT JOIN statement where one join is available, the other is null user_id | country | purpose_id 2 CA NULL 2 NULL 367 2 NG NULL 2 NULL 368 I…
I want to ONLY select customers who have purchased both products 22 and 36 Customers Id Email Name 1 [email protected] Jack 2 [email protected] Robin 3 [email protected] Pop Sales Id CustId ProdId Amount 1 1 22 100 2 2 22 100…