7-SQL Update-Delete
Presentation
•
Computers
•
6th - 8th Grade
•
Practice Problem
•
Hard
JOEL Colon
FREE Resource
5 Slides • 4 Questions
1
UPDATE
SET
WHERE
Imagina que quieres sustituir el nombre del contacto 1 y su ciudad.
Para eso corres este comando.
UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;
2
UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';
Ese comando hará cambios solo a los records donde la columna Country diga MEXICO
3
UPDATE Customers
SET ContactName='Juan';
Si omites la clausula WHERE vas a afectar todos los records de la tabla.
4
DELETE FROM Customers
WHERE CustomerName='Alfreds Futterkiste';
Este comando BORRA un record especificado
5
DELETE FROM Customers;
Este comando BORRA todos los records pero NO las columnas
6
Fill in the Blanks
7
Fill in the Blanks
8
Fill in the Blanks
9
Fill in the Blanks
UPDATE
SET
WHERE
Imagina que quieres sustituir el nombre del contacto 1 y su ciudad.
Para eso corres este comando.
UPDATE Customers
SET ContactName = 'Alfred Schmidt', City= 'Frankfurt'
WHERE CustomerID = 1;
Show answer
Auto Play
Slide 1 / 9
SLIDE
Similar Resources on Wayground
6 questions
cosmetologia
Presentation
•
KG
6 questions
Ley de conservación de la materia.
Presentation
•
6th - 8th Grade
7 questions
Redes Informaticas
Presentation
•
7th - 9th Grade
7 questions
Los egipcios
Presentation
•
6th - 8th Grade
6 questions
Casas Calientes
Presentation
•
6th - 8th Grade
6 questions
Teorema de pitagora
Presentation
•
KG
9 questions
Geologic Time Scale
Presentation
•
6th - 8th Grade
6 questions
informations techniques S45
Presentation
•
KG
Popular Resources on Wayground
24 questions
PBIS-HGMS Day 10
Quiz
•
6th - 8th Grade
10 questions
HCS SCI 03 Summer School Review 3
Quiz
•
3rd Grade
11 questions
Home Scope
Quiz
•
7th - 8th Grade
15 questions
HCS SCI 05 Summer School Assessment 3 Review
Quiz
•
5th Grade
35 questions
Lufkin Road Middle School Student Handbook & Policies Assessment
Quiz
•
7th Grade
18 questions
Geo 11.3 Area of Circles and Sectors
Quiz
•
9th - 11th Grade