Popular Sql Programming Tips
Splitting Strings with MySQL
Franklin Strube
·
0 responses
·
mysql, sql
The //* /*/ //*/ comment toggle trick
Alexander Brevig
·
27 responses
·
arduino, sql, comments, wiring
How to convert string to integer (PHP & MySQL)
Nicolas KEMPF
·
2 responses
·
php, mysql, sql, type conversion
Using Group By LINQ C#
Samuel Diogo
·
2 responses
·
sql, linq, c#
Closure Tables for Browsing Trees in SQL
Shaun McCormick
·
6 responses
·
sql, database, architecture, data structures
Postgres GROUP_CONCAT
Greg Roodt
·
0 responses
·
mysql, sql, postgres
OR queries with arrays as arguments in Rails 4
Rafał Cieślak
·
9 responses
·
rails, activerecord, sql, arel
Delete All Existing WordPress Transients in MySQL Database
Pothi Kalimuthu
·
0 responses
·
mysql, sql, cache, transients
Nested Set Model: the best approach to deal with hierarchical data
Álvaro
·
2 responses
·
ruby, mysql, rails, sql
sqlite substring from right
Miles Matthias
·
0 responses
·
sqlite, sql, substr
How to remove diacritics in SQL Server
Dominic Goulet
·
0 responses
·
sql, sqlserver
.....
Jacob Vidal
·
2 responses
·
sql, databases
Complex database migrations with PHP/MySQL using Phinx
Adrian Imfeld
·
2 responses
·
php, mysql, sql, migration
Quickly setup SQL query logging - django
Jakh Daven
·
0 responses
·
logging, sql, django
SQL to Change WordPress Domain URL
Matthew Hauth
·
2 responses
·
sql, domain, phpmyadmin, wordpress
Deletion in the Django ORM
Zachary Voase
·
0 responses
·
sql, django
Calculating Median in PostgreSQL
Gefei
·
0 responses
·
sql, aggregation, postgresql, median
SQLZOO - Learn and practice SQL
Filly
·
0 responses
·
mysql, sql, oracle, databases
SELECT * FROM DUAL MySQL Equivalent
Julian Lannigan
·
0 responses
·
mysql, oracle, sql, select
Consider subqueries instead of joins
Hannes Georg
·
1 response
·
mysql, sql, postgresql
Preloading scoped has_many :through associations
Alex Popov
·
0 responses
·
rails, activerecord, sql, eager loading
Moving schema from an Oracle database to another
Paolo
·
0 responses
·
sql, oracle
Change owner of multiple tables of a PostgreSQL database
Lars Behnke
·
0 responses
·
sql, postgresql
Nested SQL Injections
Nemo
·
1 response
·
sql, security, sqli, injection
Always include a WHERE clause in conditional UPDATE statements
Justin
·
0 responses
·
mysql, sql, update statements, safe updates
