mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-10 02:01:04 +03:00
8 lines
178 B
SQL
8 lines
178 B
SQL
UPDATE supplier
|
|
SET supplier_name='joe',supplier_state='ca'
|
|
WHERE EXISTS
|
|
( SELECT customer.name
|
|
FROM customers
|
|
WHERE customers.customer_id = supplier.supplier_id);
|
|
|