select replace("naam","from_naam","voornaam");
UPDATE herkansiing
SET afdeling = 'schoonmaken'
WHERE ID= 2;
DELETE FROM herkansiing WHERE tel nummer='0639573920;
zoeken-wijzig-replace-delete-update
4 quarys doen in examen= CRUD- Create-Read-Update-Delete
Myql Database CRUD:
select replace("naam","from_naam","voornaam");
UPDATE herkansiing
SET afdeling = 'schoonmaken'
WHERE ID= 2;
DELETE FROM herkansiing WHERE tel nummer='0639573920;
zoeken-wijzig-replace-delete-update
4 quarys doen in examen= CRUD- Create-Read-Update-Delete
Create:
Create database Studenten;
create table gegevens (
UserID varchar(255),
Firstname varchar(255),
Lastname varchar(255),
Address varchar(255),
city varchar(255)
primary key (userID)
);
Read:
Select * from Studenten;
Select UserID, Firstname,
From gegevens:
Update:
Update gegevens
Set Firstname = ‘hans’, City = ‘Rotterdam’
Where UserID = 1;
Delete:
Delete From gegevens Where Firstname= ‘hans’;
Delete From gegevens;
Delete from Lastname;
-----------------------------------------------------------------
select count (count is rij)
where
from
select count(UserID)
form gegevens1;
select * from gegevens1
where city = 'Rotterdam';
------------------------------------------------------------------
UPdate
set
where
Update gegevens1
set Lastname = 'Lobi', City = 'Amsterdam'
where userID = 26;
------------------------------------------------------------------
Delete
from
where
Delete From gegvens1
where UserID = 'jazz';
------------------------------------------------------------------
change=
select
replace
from
where
between data1, data2
(order by)
select replace("gegevens1","lastname","sirname")
from gegevens1
where lastname;
------------------------------------------------------------------
