A foxpro tételek jó részénél használhatjuka már megszokott MySQL szintaxist. Ezenkívül a grafikus felület is segítségünkre lehet.

1.tétel

SELECT Nume, Prenume FROM cititori WHERE Maxim_carti > 2
UPDATE cititori SET maxim_carti = maxim_carti + 1 WHERE data_inreg > {^2020-12-31}

2.tétel

SELECT * FROM livrari WHERE Valoare > 200
UPDATE livrari SET Valoare = Valoare * 0.93 WHERE Data_livrare > {^2023-11-30} AND Data_livrare < {^2024-01-01} 

3.tétel

USE d:\documente\szilard\xiib\foxpro\Alocatii.dbf SHARED
append from d:\documente\szilard\xiib\foxpro\atestat.dbf
DELETE FOR datan <  {^2004-09-07} IN alocatii
pack
select nume, prenume, media from elevi order by nume, prenume

4.tétel

UPDATE elevi SET media = (nota1+nota2)/2.0
DELETE FOR media <  5 IN elevi
pack 
SELECT nume, prenume, medie from elevi order by medie DESC

5.tétel

input 'numele medicamentului' to x
list for denumire_medicament = x
update farmacie set pret = pret + 2 where denumire_medicament = x
pack
list for denumire_medicament = x
select * from farmacie where !compensat order by denumire_medicament

9.tétel

SELECT * FROM STUDENT ORDER BY grupa,nume_stud;
INPUT 'numar legitimatie' to x
UPDATE STUDENT SET nume_stud="Irisz" WHERE nr_legit=x

11.tétel

SELECT nume FROM proprietari ORDER BY data_inmatr DESC
SELECT * from proprietari where AT('SJ',nr_inmatriculare)>0

13.tétel

INPUT "titlu partial carte " to x;
SELECT Autor, Titlu, An_aparitie FROM carti WHERE ATC(x, Titlu)  >0
SELECT Autor, Titlu FROM carti WHERE Nr_exemplare = 1

Megjegyzés: az AT case sensitive, az ATC nem case sensitive, s a helyét téríti vissza a keresendő stringnek, ha előfordul.

14.tétel

SELECT * FROM filme ORDER BY gen, buget
SELECT MAX(buget) FROM filme WHERE an_aparitie = 2022

15.tétel

SELECT * FROM filme WHERE actor_principal = "Richard Gere"
SELECT TOP 1 gen_Film, count(*) as C FROM filme GROUP BY gen_film ORDER BY C DESC

18.tétel

SELECT * FROM AUTO 
SELECT COUNT(*) FROM AUTO WHERE Culoare = "albastru"
input 'numele autoturismului'to x
UPDATE AUTO SET Proprietar = "Pop Ioan" WHERE marca=x
SELECT * FROM AUTO

21.tétel

select * from personal order by nume, prenume
select count(*) from personal where AT("1", cnp) == 1 or AT("5", cnp) == 1
select count(*) from personal where AT("2", cnp) == 1 or AT("6", cnp) == 1

25.tétel

select * from secretar order by an, clasa, nume
select * from secretar where media = (select max(media) from SECRETAR)