I have a server which contains a python file that connects to two external MySQL DB’s. One of those DB’s can be easily reached while the other server requires that IP’s be whitelisted in order to have access to that DB. That server’s IP is already whitelisted and works as intended when…
Tag: mysql
SSL connect to mysql from django
We just had a migration from a “unsecured” mysql DB to a SSL mysql but my Django application cannot connect anymore. content of settings.py and when I execute this Django command line : python3 manage.py dbshell (which used to work with the pre-migration DB), I receive the error message : As you c…
error 1064 (42000) : You have an error in your SQL syntax near to use %s
I dont know what I done wrong, but the error is : error 1064 (42000) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘%s’ I made this code above in my code : This code is working. So idk why this code
Not all parameters were used in the SQL statement Python – MySql
I want to check if the ID exists already but I get this error: Not all parameters were used in the SQL statement Code: Answer The second argument to execute() should be a sequence of values, one for each placeholder token %s in the query. You did pass a sequence, but not in the way you intended. Strings are s…
Python 3 – How do I extract data from SQL database and process the data and append to pandas dataframe row by row?
I have a MySQL database, its columns are: I need to extract data from it and process the data and add the data to a pandas DataFrame. I know how to extract data from SQL database, and I have already implemented a way to pass the data to DataFrame, but it is extremely slow (about 30 seconds), whereas when I
How to create new table with first name only in table
I have some data that looks like this: I’d like to create a new table with the name column but with the first name only. Answer This gets the first substring before the space character in name as first_name. first_name Arizona Emerald
Sqlalchemy raise ‘NotImplementedError: Operator ‘getitem’ is not supported on this expression’ When use ‘hybrid_property’ in mysql.SET
Hello everyone: I success to create ‘user’ table, but failed to add ‘user’ to table. python version: 3.7.2 SQLAlchemy 1.3.18 create permission enum declare ‘user’ table add one ‘user’ to table raise exception Do you have any good ideas? Answer I think it has bee…
If a table has columns equal to columns in a second table insert values in a third table, python – mysql
I have 3 table in my database: Borrowers: amount of the loan, interest rate, borrower id (PK) Lenders: amount of the bid, interest rate and LenderID (PK) Contracts: ContractID PK, amount, interest rate and the two foreign key(borrowerID, lenderID) I create a loop in python with an input command in which I can…
SQLAlchemy Core – Efficient UPSERT of a python list of dictionaries with Mysql
Assuming an existing mysql table, “user”. Assuming a single column primary key “id”. Assuming the data to be inserted is always given as a list of dictionaries, in the form: [{‘column_name1′:’valueA’, ‘column_name2′:’valueB’}, {‘col…
How to call a function in a different module in Python and not repeating the function
I have defined a function in a different page in Python like so: However, because that function is called in many other files in the project, it is asking me over and over again at runtime to enter the user name. How can I input the user name once and then use that cached value to get the required database