alter – Tarik Billa

alter composite primary key in cassandra CQL 3.0

December 21, 2023 by Tarik

There is no way to change a primary key, as it defines how your data is physically stored. You can create a new table with the new primary key, copy data from the old one, and then drop the old table.

Adding a Boolean column into an existing table

December 9, 2023 by Tarik

You have to define what you add – a column: alter table chatuser add column activerecord bool;

What happens if you kill a long-running alter query?

December 6, 2023 by Tarik

It depends what you’re doing. If you’re running an alter table…add index command on an InnoDB table (not so sure about MyISAM), then it will just run and run as it copies the whole darn table lock-stock-and-barrel first: if it’s in the middle of “copy to temp table” then it’s pretty much unstoppable. See here: … Read more

How to rename a column name in maria DB

August 28, 2023 by Tarik

Table names, column names, etc, may need quoting with backticks, but not with apostrophes (‘) or double quotes (“). ALTER TABLE subject CHANGE COLUMN `course_number` — old name; notice optional backticks course_id — new name varchar(255); — must include all the datatype info

Hive Alter table change Column Name

August 26, 2023 by Tarik

Change Column Name/Type/Position/Comment: ALTER TABLE table_name CHANGE [COLUMN] col_old_name col_new_name column_type [COMMENT col_comment] [FIRST|AFTER column_name] Example: CREATE TABLE test_change (a int, b int, c int); // will change column a’s name to a1 ALTER TABLE test_change CHANGE a a1 INT;

syntax error at or near “-” in PostgreSQL

July 30, 2023 by Tarik

I have reproduced the issue in my system, postgres=# alter user my-sys with password ‘pass11’; ERROR: syntax error at or near “-” LINE 1: alter user my-sys with password ‘pass11′; ^ Here is the issue, psql is asking for input and you have given again the alter query see postgres-#That’s why it’s giving error at … Read more

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

July 28, 2023 by Tarik

As it was mentioned above you can’t edit enum within transaction block. But you can create the new one. Here are the steps: Change type from request_type to varchar for all columns/tables which use this type: ALTER TABLE table_name ALTER COLUMN column_name TYPE VARCHAR(255); Drop and create again request_type enum: DROP TYPE IF EXISTS request_type; … Read more