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?
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
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)
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
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?