Skip to content

Instantly share code, notes, and snippets.

View w87's full-sized avatar
πŸ˜„
Have a great day!

Walerian Walawski ➜ w87.eu w87

πŸ˜„
Have a great day!
View GitHub Profile
@w87
w87 / list-columns-names-in-table.sql
Created April 7, 2026 20:00
[SQL / MySQL] List columns names in a DB table
SELECT REPLACE((SELECT group_concat(COLUMN_NAME)
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = '<database-name>' AND TABLE_NAME = '<table-name>'), ',', '`, `');
@w87
w87 / wpdb-query-error-pre.php
Last active April 7, 2026 20:06
[WordPress / WPDB] wpdb-query-error-pre
// [WP] wpdb-query-error-pre ------------------------------------
echo '<pre>QUERY: '.var_export($wpdb->last_query, true).'</pre>'
.'<pre>ERROR: '.var_export($wpdb->last_error, true).'</pre>';
// @TODO: remove after debug!
// --------------------------------------------------------------