php/ajax ondersteuning:

aanvraag readystate:

aanvraag status:

database-verbinding: (elders...)

testveld:

SQL historie:

info SQL commando's:

CREATE DATABASE database_name

CREATE TABLE table_name (ID int NOT NULL, naam var NULL, etc. )

INSERT INTO TabelNaam VALUES (rij met alle gegevens)

INSERT INTO Tabelnaam (geslecteerd veld1, veld5) VALUES (inhoud1, inhoud5)

UNION (<< riskant en weinig toepasbaar)

UPDATE TabelNaam SET kolomNaam="naam", kolom2="etc" WHERE id=15

ALTER TABLE TableName1 ADD COLUMN kolomNaam int NOT NULL

ALTER TABLE TableName1 ALTER kolomNieuw (Prior5, double) NUL

ALTER TABLE table_name RENAME COLUMN old_name to new_name // werkt niet...

ALTER TABLE s103 change dMaand dBeginDate smallint NULL

ALTER TABLE TableName1 MODIFY supplier_name varchar2(100)not null;

SELECT KolomNaam, KolomNaam2 FROM TabelNaam WHERE ID=x OR .... AND ... ORDERED BY

SELECT * FROM TabelNaam WHERE ID=x ORDERED BY KolomNaam1, Kolom2

SELECT * FROM TabelNaam HAVING Prioriteit<5

SELECT * FROM Tabel1, Tabel2 WHERE tabelNaam.kolomNaam=tabel2.kolom8

SELECT COUNT(*) FROM tabelnaam1 (andere funties: AVG, MIN, MAX, SUM)

DISTINCT en GROUP belangrijk bij dubbel vorkomende namen

select* FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'soorten'

select COLUMN_NAME FROM INFORMATION_SCHEMA.Columns where TABLE_NAME = 'soorten'

SHOW COLUMNS FROM `person`; of: describe soorten

DELETE FROM soorten WHERE sid=0

select snaam from soorten where scat>70 order by sid

dID SMALLINT (UNSIGNED?) NOT NULL AUTO_INCREMENT, etc. en bij insert wordt het eerste veld eenvoudigweg weg gelaten

lat decimal(11,7) NULL

create table s299(dID SMALLINT unsigned NOT NULL AUTO_INCREMENT, dNaam varchar(40) NULL, vNaam varchar(40) NULL, tNaam varchar(10) NULL, extNaam varchar(40) NULL, dOrde smallint NULL, dLat decimal(11,7) NULL, dLng decimal(11,7) NULL, dStraal decimal(8,3) NULL, dLLprec decimal(6,3) NULL, dJaar decimal(8,3) NULL, dBeginDate smallint NULL, dEindDate smallint NULL, dTijd smallint NULL, dDuur decimal(8,3) NULL, dTPrec decimal(6,3) NULL, dLandID smallint NULL, dStadID smallint NULL, dWaar tinyint NULL, dPriorS1 tinyint NULL, dPriorT1 tinyint NULL, dLink01 varchar(10) null, dLink02 varchar(10) null, dLink03 varchar(10) null, primary key(dID))

create table s4k (dID SMALLINT NOT NULL, dNaam varchar(40) NULL, ken1sID smallint NULL, ken1dID smallint NULL, ken2sID smallint NULL, ken2dID smallint NULL, ken3sID smallint NULL, ken3dID smallint NULL , ken4sID smallint NULL, ken4dID smallint NULL, ken5sID smallint NULL, ken5dID smallint NULL, ken6sID smallint NULL, ken6dID smallint NULL, ken7sID smallint NULL, ken7dID smallint NULL, ken8sID smallint NULL, ken8dID smallint NULL ,ken9sID smallint NULL, ken9dID smallint NULL, ken10sID smallint NULL, ken10dID smallint NULL, ken11sID smallint NULL, ken11dID smallint NULL, ken12sID smallint NULL, ken12dID smallint NULL)

Create table s103t (dID smallint not null, dNaam varchar(40) null, dSinds datetime null, aID1 int null, aID2 int null, aID3 int null, vermeld tinyint null, dnNL varchar(40) null, dnDU varchar(40) null, dnFR varchar(40) null, dnSP varchar(40) null, dnIT varchar(40) null, dText varchar(2000) null, dtNL varchar(2000) null, dtDU varchar(2000) null, dtFR varchar(2000) null, dtSP varchar(2000) null, dtIT varchar(2000) null, dCode varchar(10) NULL, dHint01 varchar(40) NULL, dHint02 varchar(40) NULL, dHint03 varchar(40) NULL, dHint04 varchar(40) NULL, dHint05 varchar(40) NULL, dImgAantal smallint NULL)

SELECT s105.dLat,s105.dLng FROM s105 JOIN s105k ON (s105.dID = s105k.dID) WHERE s105k.ken2dID=3

update s102,s102k set s102.dStraal = SQRT(s102k.ken2dID/3.14159265) where s102.dID=s102k.dID

MOD(x, y) is zals %; ABS(x); SIGN(x) maakt -1,0,+1; POWER(x,y) x tot de yde; SQRT(x) wortel; ROUND(x) and ROUND(x,y) y is aantal decimalen; FLOOR(x); CEILING(x); TAN(x), SIN(x) and COS(x);

table newSpul (dNaam,aID,aNaam,aIP,sID,dID,dLat,dLng,plaatsNaam,plaatsSID,plaatsDID,dStraal,dJaar,dDuur,dBeginDate,dEindDate,dMarge,dWaar);