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

Authored by Grzegorz Godlewski

Computers

8th Grade

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

38 questions

Show all answers

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

ak zmienić nazwę tabeli orders na purchases?

ALTER TABLE orders RENAME TO purchases

RENAME TABLE orders TO purchases

ALTER orders TO purchases

CHANGE TABLE orders TO purchases

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Jak dodać nową kolumnę age typu INT do tabeli users?

ALTER TABLE users ADD COLUMN age INT

ALTER TABLE users INSERT COLUMN age INT

ALTER TABLE users CREATE COLUMN age INT

ALTER TABLE users NEW age INT

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Co zrobi ALTER TABLE employees DROP COLUMN department?

Doda kolumnę department

Usunie kolumnę department

Zmodyfikuje kolumnę department

Nic nie zrobi

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Jak ustawić kolumnę email w tabeli customers jako unikalną?

ALTER TABLE customers SET UNIQUE(email)

ALTER TABLE customers MODIFY email UNIQUE

ALTER TABLE customers ADD UNIQUE(email)

ALTER TABLE customers CONSTRAINT UNIQUE email

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Jak zmienić typ kolumny phone_number w tabeli contacts na VARCHAR(15)?

ALTER TABLE contacts CHANGE phone_number VARCHAR(15)

ALTER TABLE contacts MODIFY phone_number VARCHAR(15)

ALTER TABLE contacts ALTER phone_number VARCHAR(15)

ALTER TABLE contacts SET phone_number VARCHAR(15)

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Co zrobi poniższa komenda: ALTER TABLE orders DROP PRIMARY KEY?

Usunie klucz główny

Ustawi klucz główny

Zmieni typ kolumny

Doda nowy klucz główny

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Jak dodać kolumnę status typu ENUM('active', 'inactive') do tabeli accounts?

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

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

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

TSDE Final Exam Review

Quiz

•

8th Grade

35 questions

ASLM Genap Analisis Data

Quiz

•

8th Grade

40 questions

Final Semester Exam

Quiz

•

8th Grade

35 questions

DIT Final Exam Review 2

Quiz

•

8th Grade

40 questions

latihan 1

Quiz

•

1st - 10th Grade

33 questions

HTML CSS Quiz

Quiz

•

8th Grade

40 questions

Quiz Mengingat Kembali

Quiz

•

8th Grade

40 questions

Latihan ASTS Ganjil Informatika Kelas 8

Quiz

•

8th Grade

Popular Resources on Wayground

15 questions

Grade 3 Simulation Assessment 1

Quiz

•

3rd Grade

22 questions

HCS Grade 4 Simulation Assessment_1 2526sy

Quiz

•

4th Grade

16 questions

Grade 3 Simulation Assessment 2

Quiz

•

3rd Grade

19 questions

HCS Grade 5 Simulation Assessment_1 2526sy

Quiz

•

5th Grade

17 questions

HCS Grade 4 Simulation Assessment_2 2526sy

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

24 questions

HCS Grade 5 Simulation Assessment_2 2526sy

Quiz

•

5th Grade

20 questions

Math Review

Quiz

•

3rd Grade

Discover more resources for Computers

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

18 questions

Company Logos

Quiz

•

6th - 8th Grade

10 questions

Exploring Cybersecurity Techniques and Threats

Interactive video

•

6th - 10th Grade

9 questions

Health

Interactive video

•

6th - 8th Grade