Tag: tablename

How to only select the very next string after target string but the next string after the target string, regardless of punctation?

I have a df that looks like this: id query 1 select * from table1 where col1 = 1 2 select a.columns FROM table2 a I want to only select the string (table if you know sql) after the string FROM into a new column. FROM can be spelled with different capitalizations (ie From, from,FROM,etc).… Read More How to only select the very next string after target string but the next string after the target string, regardless of punctation?

MRLeave a comment

Cannot create a database with SqlAlchemy (sqlalchemy.exc.OperationalError)

I’m learning sqlAlchemy and I want to establish a connection and create a database to insert data. I have an error message that I don’t understand. According to the documentation, the error may come from the database itself. Has anyone ever encountered this problem? File "C:\Users\A.NAITSAIDI\AppData\Local\Programs\Python\Python310\lib\site- packages\psycopg2\__init__.py", line 122, in connect conn = _connect(dsn, connection_factory=connection_factory,… Read More Cannot create a database with SqlAlchemy (sqlalchemy.exc.OperationalError)

MRLeave a comment