Top "Alter" questions

Difficulty in upgrading SQlite table

I have an application running with a working table called ANIMAL. Upon first creating this table it consisted simply of _…

android sqlite alter

mysql alter int column to bigint with foreign keys

I want to change the datatype of some primary-key columns in my database from INT to BIGINT. The following definition …

mysql foreign-keys int alter bigint

ALTER TABLE Sqlite: how to check if a column exists before alter the table?

I need to execute in python a SQL query that adds a new column, in sqlite3. The problem is that …

python sqlite exists alter

Postgresql - Using subqueries with alter sequence expressions

Is it possible to use subqueries within alter expressions in PostgreSQL? I want to alter a sequence value based on …

sql postgresql subquery sequence alter

How to rename a column name in maria DB

I am new to SQL, I was trying to change column name in my database's table. I am using 'xampp' …

mysql mariadb rename alter

alter column from time with time zone to timestamp

I am having trouble changing a column called end_date in a table called key_request from time with time …

sql postgresql timestamp postgresql-9.2 alter

mysql add "prefix" to every column

I need to add a 'prefix' in front of every value in a certain column. Example: all fields in column …

php mysql prefix alter

error: ALTER TYPE ... ADD cannot run inside a transaction block

I am trying to add new type value to my existing types in PostgreSQL. But I get the following error …

postgresql enums alter

How to alter MySQL table without losing data?

In my application, I make some changes and upload them to a testing server. Because I have no access to …

mysql database alter

on insert current_timestamp in mysql

I need to alter a column with timestamp datatype. The thing is when record is inserted the current time stamp …

mysql alter