Jak dodać kolumnę created_at z domyślną wartością bieżącej daty?

ALTER TABLE users ADD COLUMN created_at DATE DEFAULT CURRENT_DATE

ALTER TABLE users ADD created_at DATE DEFAULT CURRENT_DATE

ALTER TABLE users CREATE created_at DATE DEFAULT CURRENT_DATE

ALTER TABLE users ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

Co oznacza ALTER TABLE customers CONVERT TO CHARACTER SET utf8mb4?

Zmienia zestaw znaków tabeli na utf8mb4

Konwertuje wszystkie kolumny na typ utf8mb4

Jak dodać kolumnę updated_at z automatycznym aktualizowaniem na bieżącą datę przy każdej modyfikacji?

ALTER TABLE posts ADD updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

ALTER TABLE posts ADD updated_at DATE DEFAULT CURRENT_DATE ON UPDATE CURRENT_DATE

ALTER TABLE posts NEW COLUMN updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

ALTER TABLE posts ADD updated_at TIMESTAMP AUTO UPDATE

Co robi ALTER TABLE employees AUTO_INCREMENT = 1000?

Ustawia początkową wartość AUTO_INCREMENT na 1000

Zmienia typ danych na AUTO_INCREMENT

Jak usunąć kolumnę salary w tabeli positions?

ALTER TABLE positions DROP salary

ALTER TABLE positions REMOVE COLUMN salary

ALTER TABLE positions DELETE salary

ALTER TABLE positions DROP COLUMN salary

Jak usunąć ograniczenie CHECK z tabeli employees?

ALTER TABLE employees DROP CHECK

ALTER TABLE employees REMOVE CHECK

ALTER TABLE employees DELETE CHECK

ALTER TABLE employees ALTER CHECK

Jak dodać kolumnę email do tabeli employees, aby była unikalna?

ALTER TABLE employees ADD COLUMN email VARCHAR(255) UNIQUE

Jak dodać kolumnę email do tabeli employees, aby była unikalna?

ALTER TABLE employees ADD COLUMN email VARCHAR(255) UNIQUE

ALTER TABLE employees ADD email VARCHAR(255) UNIQUE

ALTER TABLE employees SET email VARCHAR(255) UNIQUE

ALTER TABLE employees INSERT email VARCHAR(255) UNIQUE

Jak zmienić typ kolumny price w tabeli items na DECIMAL(10, 2)?

ALTER TABLE items MODIFY price DECIMAL(10, 2)

ALTER TABLE items CHANGE price DECIMAL(10, 2)

ALTER TABLE items ALTER price DECIMAL(10, 2)

ALTER TABLE items SET price DECIMAL(10, 2)

Jak ustawić wartość domyślną ACTIVE dla kolumny status w tabeli orders?

ALTER TABLE orders ALTER COLUMN status SET DEFAULT 'ACTIVE'

ALTER TABLE orders MODIFY COLUMN status SET DEFAULT 'ACTIVE'

ALTER TABLE orders CHANGE COLUMN status SET DEFAULT 'ACTIVE'

ALTER TABLE orders SET DEFAULT 'ACTIVE'

Jak zmienić kolejność kolumn w tabeli, aby kolumna age była po kolumnie name?

ALTER TABLE employees MODIFY COLUMN age AFTER name

ALTER TABLE employees CHANGE COLUMN age AFTER name

ALTER TABLE employees RENAME COLUMN age AFTER name

ALTER TABLE employees SET COLUMN age AFTER name

Jak usunąć klucz obcy fk_customer z tabeli orders?

ALTER TABLE orders DROP FOREIGN KEY fk_customer

ALTER TABLE orders DELETE FOREIGN KEY fk_customer

ALTER TABLE orders REMOVE FOREIGN KEY fk_customer

ALTER TABLE orders UNLINK FOREIGN KEY fk_customer

Jak dodać klucz obcy fk_customer_id z tabeli orders do kolumny id w tabeli customers?

ALTER TABLE orders ADD FOREIGN KEY (customer_id) REFERENCES customers(id)

ALTER TABLE customers ADD FOREIGN KEY (customer_id) REFERENCES orders(id)

ALTER TABLE orders ADD KEY FOREIGN (customer_id) REFERENCES customers(id)

ALTER TABLE orders FOREIGN KEY customer_id REFERENCES customers(id)

Jak zmienić zestaw znaków w tabeli comments na utf8mb4?

ALTER TABLE comments CONVERT TO CHARACTER SET utf8mb4

ALTER TABLE comments CHANGE CHARACTER SET utf8mb4

ALTER TABLE comments MODIFY CHARACTER SET utf8mb4

ALTER TABLE comments SET CHARACTER SET utf8mb4

Co robi ALTER TABLE users MODIFY COLUMN age INT NOT NULL?

Zmienia kolumnę age na NOT NULL

Jak dodać nową kolumnę birth_date typu DATE do tabeli profiles?

ALTER TABLE profiles ADD birth_date DATE

ALTER TABLE profiles INSERT birth_date DATE

ALTER TABLE profiles NEW COLUMN birth_date DATE

ALTER TABLE profiles SET birth_date DATE

Jak zmienić nazwę kolumny address na location w tabeli clients?

ALTER TABLE clients RENAME address TO location

ALTER TABLE clients CHANGE address location VARCHAR(255)

ALTER TABLE clients MODIFY address location VARCHAR(255)

ALTER TABLE clients SET address AS location

Co wykonuje ALTER TABLE orders AUTO_INCREMENT = 500?

Ustawia wartość początkową AUTO_INCREMENT na 500

Zmienia typ kolumny na AUTO_INCREMENT

Dodaje nową kolumnę AUTO_INCREMENT

Jak zmienić typ kolumny username w tabeli accounts na VARCHAR(50)?

ALTER TABLE accounts MODIFY username VARCHAR(50)

ALTER TABLE accounts CHANGE username VARCHAR(50)

Jak zmienić typ kolumny username w tabeli accounts na VARCHAR(50)?

ALTER TABLE accounts MODIFY username VARCHAR(50)

ALTER TABLE accounts CHANGE username VARCHAR(50)

ALTER TABLE accounts ALTER username VARCHAR(50)

ALTER TABLE accounts SET username VARCHAR(50)

Co robi ALTER TABLE users DROP COLUMN profile_picture?

Dodaje kolumnę profile_picture

Zmienia nazwę kolumny profile_picture

Modyfikuje kolumnę profile_picture

Jak dodać kolumnę status typu VARCHAR(10) z domyślną wartością active do tabeli members?

ALTER TABLE members ADD status VARCHAR(10) DEFAULT 'active'

ALTER TABLE members INSERT status VARCHAR(10) DEFAULT 'active'

ALTER TABLE members MODIFY status VARCHAR(10) DEFAULT 'active'

ALTER TABLE members SET status VARCHAR(10) DEFAULT 'active'

Jak ustawić domyślną wartość inactive dla kolumny status w tabeli users?

ALTER TABLE users ALTER COLUMN status SET DEFAULT 'inactive'

ALTER TABLE users MODIFY COLUMN status DEFAULT 'inactive'

ALTER TABLE users CHANGE COLUMN status DEFAULT 'inactive'

ALTER TABLE users SET COLUMN status DEFAULT 'inactive'

Jak zmienić typ kolumny salary na DECIMAL(15, 2) w tabeli employees?

ALTER TABLE employees MODIFY salary DECIMAL(15, 2)

ALTER TABLE employees CHANGE salary DECIMAL(15, 2)

ALTER TABLE employees ALTER salary DECIMAL(15, 2)

ALTER TABLE employees SET salary DECIMAL(15, 2)

Jak usunąć ograniczenie klucza głównego z tabeli products?

ALTER TABLE products DROP PRIMARY KEY

ALTER TABLE products DELETE PRIMARY KEY

ALTER TABLE products REMOVE PRIMARY KEY

ALTER TABLE products UNSET PRIMARY KEY

Jak dodać kolumnę created_at z domyślną wartością bieżącego czasu do tabeli tasks?

ALTER TABLE tasks ADD COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

ALTER TABLE tasks INSERT COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

ALTER TABLE tasks NEW COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

ALTER TABLE tasks SET COLUMN created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

Jak usunąć kolumnę last_login z tabeli users?

ALTER TABLE users DROP COLUMN last_login

ALTER TABLE users DELETE COLUMN last_login

ALTER TABLE users REMOVE COLUMN last_login

ALTER TABLE users ERASE COLUMN last_login

Jak zmienić nazwę kolumny full_name na name w tabeli contacts?

ALTER TABLE contacts RENAME COLUMN full_name TO name

ALTER TABLE contacts CHANGE full_name name VARCHAR(255)

ALTER TABLE contacts MODIFY full_name name VARCHAR(255)

ALTER TABLE contacts SET full_name AS name

Jak dodać nową kolumnę age do tabeli persons, która nie może mieć wartości NULL?

ALTER TABLE persons ADD age INT NOT NULL

ALTER TABLE persons INSERT age INT NOT NULL

ALTER TABLE persons CREATE age INT NOT NULL

ALTER TABLE persons SET age INT NOT NULL

Jak zmienić domyślną wartość kolumny status na active w tabeli members?

ALTER TABLE members ALTER COLUMN status SET DEFAULT 'active'

ALTER TABLE members MODIFY COLUMN status SET DEFAULT 'active'

ALTER TABLE members CHANGE COLUMN status SET DEFAULT 'active'

ALTER TABLE members SET DEFAULT status 'active'

Pytania dotyczące SQL Alter Table

Quiz

•

Computers

•

8th Grade

•

Practice Problem

•

Medium

Grzegorz Godlewski

Used 2+ times

FREE Resource

ALTER TABLE accounts SET COLUMN status ENUM('active', 'inactive')

ALTER TABLE accounts ALTER COLUMN status ENUM('active', 'inactive')

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Final Test

Quiz

•

8th Grade

40 questions

Digital Technology Quiz

Quiz

•

7th - 8th Grade

34 questions

T3 B2- Kriptografi smkkps

Quiz

•

6th - 8th Grade

40 questions

INFORMATIKA GANJIL KELAS 8 2024

Quiz

•

8th Grade

34 questions

Database Quiz

Quiz

•

6th - 8th Grade

40 questions

Spreadsheet Formulas,Charts,Formatting

Quiz

•

7th - 8th Grade

40 questions

LATIHAN SOAL ASTS GENAP INFORMATIKA 8

Quiz

•

8th Grade

40 questions

Latihan PAT

Quiz

•

8th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

15 questions

Google Sheets

Quiz

•

7th - 8th Grade