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

Advertisements 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,… Read More How to only select the very next string after target string but the next string after the target string, regardless of punctation?

May 26, 2022 MRLeave a comment

How to change id column type already registered in the database

Advertisements I’m trying to change my Id column type from int to bigInt because the records are too big and I’m getting an error if I try to store more records but I’m not sure if it’s safe to just alter the table like this: alter table the_table alter the_column type bigint; I’m using Java… Read More How to change id column type already registered in the database

May 16, 2022 MRLeave a comment

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

Advertisements 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,… Read More Cannot create a database with SqlAlchemy (sqlalchemy.exc.OperationalError)

May 13, 2022 MRLeave a comment

Column update – SQL UPDATE statement

Advertisements I have a column where it stores a reference the reference is usually 30 alphanumeric values The column is set as an nvarchar (30). Id like to update this to nvarchar (5), and update all the values currently stored in this column.. is there a way to do this using update? >Solution : First… Read More Column update – SQL UPDATE statement

May 10, 2022 MRLeave a comment

Correct syntax for table name under Inner Join?

Advertisements I am a complete beginner to BigQuery, and I am trying to create an inner join between two table names, where the column ‘title’ is the joining column. I believe my syntax is correct, but I do not know what I am doing wrong when I input the ON clause. Here is my syntax:… Read More Correct syntax for table name under Inner Join?

January 23, 2022 MRLeave a comment

Dev solutions

Solutions for development problems

Tag: tablename

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

How to change id column type already registered in the database

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

Column update – SQL UPDATE statement

Correct syntax for table name under Inner Join?