J'ai eu le même besoins que How to remove html tags except <br> from mysql data?, Remove HTML tags from record et SQL - Remove all HTML tags in a string
Mot-clé - sql
Data Types SQL langages de programmation INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
Quels sont les types SQL et des langages de programmation JAVA, PHP, Javascript, ...
Node.js
Node.js JavaScript runtime
- API reference documentation
- Guides
- Versions : Node.js Release et Releases
Android SQlite
Android SQlite
SQL "matching found rows" vs "affected rows"
Lors de modifications (UPDATE, DELETE) comment différencier le nombre d'enregistrement qui matche au critère WHERE et le nombre d'enregistrement réellement modifiés par la requête ?
- "found (matched) rows" le nombre d'enregistrements trouvés (potentiellement modifiable)
- "affected (changed) rows" le nombre d'enregistrements véritablement changés parmi les trouvés
MariaDB variables
Accès aux variables de status, système, session, globales, utilisateur.
Réplication MariaDB
Petites notes sur la réplication avec MariaDB
MariaDB DEFAULT column VALUE
How to retrieve default column value ? Simply using the miscellaneous DEFAULT(col_name) function.
Android SQlite affectedRows
Les INSERT/DELETE/UPDATE retourne the number of rows affected, mais pas les bons ! Pour résumer il retourne le nombre de row matching au critère WHERE.
REPLACE INTO vs ON DUPLICATE KEY UPDATE
Which (non-standard) statement is better faster?
- REPLACE INTO ...
- INSERT INTO ... ON DUPLICATE KEY UPDATE ...
MariaDB Connector/Java You need to set exactly 1 parameters on the prepared statement
Exception in thread "main" java.sql.SQLException: You need to set exactly 1 parameters on the prepared statement
Query is : INSERT INTO my_table (my_col) VALUES ('m_val')null;
Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: You need to set exactly 1 parameters on the prepared statement
Query is : INSERT INTO my_table (my_col) VALUES ('m_val')null;
sql occurence char count
Comment compter le nombre d’occurrence d'un caractère dans une colonne ?
SET @string = "Bonjour ""Mr Vinal""; il fait beau l'été, l'automne et l'hivers, n'est ce pas ?"; SELECT SUM( LENGTH(@string ) ) AS total_length, SUM( LENGTH(@string) - LENGTH(replace(@string, ',', '')) ) AS coma_virgule, SUM( LENGTH(@string) - LENGTH(replace(@string, '''', '')) ) AS quote_cote, SUM( LENGTH(@string) - LENGTH(replace(@string, '"', '')) ) AS double_quote_cote, SUM( LENGTH(@string) - LENGTH(replace(@string, ';', '')) ) AS semicolon_point_virgule ; /* +--------------+--------------+------------+-------------------+-------------------------+ | total_length | coma_virgule | quote_cote | double_quote_cote | semicolon_point_virgule | +--------------+--------------+------------+-------------------+-------------------------+ | 79 | 2 | 4 | 2 | 1 | +--------------+--------------+------------+-------------------+-------------------------+ */
MariaDB fonctions de date et de temps
Comment gérer ses dates avec MariaDB, soustraire des dates, ajouter des intervalles de temps, ...
... extraire les secondes, minutes, jours, semaines, mois, ans...
The last packet successfully received from the server was X milliseconds ago. The last packet sent successfully to the server was Y milliseconds ago.
The last packet successfully received from the server was X milliseconds ago. The last packet sent successfully to the server was Y milliseconds ago.
MySQL server has gone away
android.database.Cursor moveToFirst or getCount
moveToFirst vs getCount ? Wich is faster on android.database.Cursor ?
sql_log.sh
Petit script pour activer les logs des requêtes SQL (MariaDB, MySQL).
Usage :
./sql_log.sh OFF
./sql_log.sh ON
tail -f /var/lib/mysql/hostname.log
MySQL create command SELECT/INSERT/UPDATE
Commandes SQL pour générer des statements SELECT, INSERT, REPLACE, UPDATE de vos tables, dans le but d'avoir les requêtes déjà prêtes avec la liste de vos champs.
MariaDB
Deadlock MySQL
Exception : Deadlock found when trying to get lock; try restarting transaction com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
Exception::getMessage: SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction
group http user agent sql
MySQL statement to know distinct browser version previoulsy stored in a table from User-Agent header ($_SERVER['HTTP_USER_AGENT'] with PHP for example).