How to Insert Multiple Rows in MySQL: A Comprehensive Guide
INSERT INTO target_table (column1, column2, column3) SELECT source_column1, source_column2, source_column3 FROM source_table WHERE condition;
Sorted Tables for Faster Range-Scans
Rows can be stored in a table already sorted instead of the time of their insertion. Some queries will be significantly faster this way when the data size excee...
UUIDs to prevent Enumeration Attacks
In most applications, resources are addressed in the URL by numeric incremental ids. An attacker can quickly increment the id to enumerate all records scraping...
Function-Based Indexes
An expression like WHERE LOWER(email) won't use an index created for the email column. By creating a function-based index (functional index) you can use this co...
Recursive sql query
Recursive queries are a straightforward solution to querying hierarchical trees. However, one loop in the relationship references results in a failing or never...
Sql queries
Hogyan gyorsitsunk lekerdezeseinken
NoSql
Mi is a NoSql es mire jo
Database design
Webshop adatbazisahoz minta
Junior vs Senior
Programozasrol altalanossagban
Gyujto oldalak
Egy oldal ami osszeszed tobb oldalt ahol jo programozos cikkek szerepelnek. Az informatikusleszek egyelore nincs koztuk :(
Adatbazis tervezes
Tervezesi minta webshophoz
Eloquent ORM
Pár jó trükk Laravelhez
Sql join
https://m.facebook.com/codek.tv/photos/a.789900751077258/5260604047340217/?type=3&source=57&__tn__=EH-R
Egy jó kis blog
Patternek meg minden
SQL
Hogyan irjunk jobb sql kodot
SQL join
sql