Duombaze.sql

: For passwords, never store them in plain text; use a VARCHAR(255) to accommodate hashed values. g., e-commerce, library, or medical records)?

-- Insert sample categories INSERT INTO kategorijos (pavadinimas, aprasymas) VALUES ('Elektronika', 'Kompiuteriai, telefonai ir kiti įrenginiai'), ('Biuro reikmenys', 'Popierius, rašikliai ir kita'); -- Insert sample products INSERT INTO prekes (kategorija_id, pavadinimas, kaina, kiekis) VALUES (1, 'Nešiojamas kompiuteris Pro', 1200.50, 5), (1, 'Išmanusis telefonas X', 850.00, 10), (2, 'A4 formato popierius (500 lapų)', 5.99, 100); Use code with caution. Copied to clipboard 4. Basic Query Examples Duombaze.sql

: If building a CMS, you might implement a "draft" system by adding an IsFinal or Status column to your tables to distinguish between published and unpublished entries. : For passwords, never store them in plain

This section ensures the database exists and that you are working within the correct context. Copied to clipboard 4