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

.....

Jacob Vidal

2 responses · sql, databases

sqlite substring from right

Miles Matthias

0 responses · sqlite, sql, substr

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

How to remove diacritics in SQL Server

Dominic Goulet

0 responses · sql, sqlserver

Deletion in the Django ORM

Zachary Voase

0 responses · sql, django

SQL to Change WordPress Domain URL

Matthew Hauth

2 responses · sql, domain, phpmyadmin, wordpress

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

Moving schema from an Oracle database to another

Paolo

0 responses · sql, oracle

Preloading scoped has_many :through associations

Alex Popov

0 responses · rails, activerecord, sql, eager loading

Change owner of multiple tables of a PostgreSQL database

Lars Behnke

0 responses · sql, postgresql

Always include a WHERE clause in conditional UPDATE statements

Justin

0 responses · mysql, sql, update statements, safe updates

Select a range from SQL table using DB2

Thom

0 responses · sql, select, range, db2

Displaying tips 1 - 25 of 190 in total

#native_company#

#native_desc#

Recent Activity

Newest Sql protips

Awesome Jobs

See All Jobs

Post a job for only $299

#native_title# #native_desc#

#native_cta#