alvin alexander
Nodes for the term “sql”
MySQL “show users”: How to show/list the users in a MySQL database
Read more
How to perform a SQL query for fields that are null (or not null)
Read more
A Scala JDBC connection and SQL SELECT example
Read more
How to use SQL SELECT, GROUP BY, ORDER BY, and COUNT (all in one)
Read more
A Java MySQL SELECT example
Read more
MySQL error: Expression of SELECT list is not in GROUP BY clause, nonaggregated column
Read more
Scala: A ScalikeJdbc example (including SQL SELECT and UPDATE statements)
Read more
A ScalikeJdbc SQL SELECT “service” example
Read more
Play Framework: Anorm SQL query syntax and examples
Read more
Flutter, sqflite, and escaping quotes with SQL INSERT and UPDATE statements
Read more
Creating a PHP date in the format for a SQL Timestamp insert
Read more
A Java MySQL UPDATE example
Read more
A Java MySQL INSERT example (using PreparedStatement)
Read more
A Java MySQL INSERT example (using Statement)
Read more
A Java MySQL DELETE example
Read more
A simple Java JDBC example that shows SQL insert, update, delete, and select
Read more
SQL joins as Venn diagrams
Read more
Example MySQL database design: A Nagios MySQL database design
Read more
Java “current date” example - How to create a Java Date to represent the current time
Read more
Java PreparedStatement: A SQL INSERT example
Read more
A Drupal 7 SQL cheat sheet
Read more
A Play Framework Anorm insert method that returns the database auto-insert ID
Read more
Case insensitive SQL SELECT query examples
Read more
Database-driven version of United States dropdown data
Read more
Java programming best practices - Create interfaces for your Dao classes
Read more
Spring JDBC Dao SQL ‘SELECT’ statement examples
Read more
A Drupal 7 db_insert query (SQL INSERT statement)
Read more
Handling Drupal SQL exceptions (db_insert, db_update, db_delete)
Read more
A MySQL PHP update query example
Read more
PHP Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
Read more
A PHP "select from where in" query example
Read more
Update MySQL timestamp on update
Read more
A CakePHP SQL UPDATE example
Read more
How to run a Drupal 7 query outside of Drupal
Read more
Drupal 6 SQL insert examples (and syntax)
Read more
A Drupal theme table example
Read more
CakePHP SQL query - How to run a SQL database query in CakePHP
Read more
CakePHP find - a SQL limit query example (SQL select with limit clause)
Read more
Use the PHP addslashes function to fix SQL INSERT problems
Read more
A Drupal 7 SQL DELETE example
Read more
Spring Dao: a Spring JDBC DELETE example
Read more
Spring Dao - Spring JDBC DELETE examples
Read more
JDBC Timestamp - How to select a Java Timestamp field from a database timestamp column
Read more
Spring Dao - a Spring JDBC update example
Read more
CakePHP find distinct - SELECT DISTINCT syntax for the CakePHP find method
Read more
Debug hibernate - how to see the SQL being run by Hibernate
Read more
Java PreparedStatement - a SQL UPDATE example
Read more