Hazem Ben Khalfallah Hazem-Ben-Khalfallah

Software Architect by day, experimenting with code by night. 🚀 All projects here are mine—my employer has their own serious business to handle. 😎

Hazem-Ben-Khalfallah / cast_byte_array_to_text.sql

Created November 15, 2025 06:13

[Cast byte[] to text] #sql #mysql

	SELECT CONVERT(content USING utf8mb4) content
	from svc_messages_instance;

Hazem-Ben-Khalfallah / filter_by_date_interval.sql

Created November 15, 2025 06:12

[Filter by date in Interval] #sql #mysql

	SELECT * FROM source.jag_future_service_interaction
	where createdOn >= now() - interval 3 day;

Hazem-Ben-Khalfallah / find_table_by_name.sql

Created November 15, 2025 06:10

[Find table by name like a pattern] #sql

	SELECT table_name
	FROM information_schema.tables
	WHERE table_schema = 'lisa_dev_test2'
	AND table_name LIKE '%intent%'

Hazem-Ben-Khalfallah / use_schema.sql

Created November 15, 2025 06:08

[Use schema] #sql #mysql

USE `agent-db`;

Hazem-Ben-Khalfallah / jdk-version-compilation.java

Last active May 28, 2021 22:21

[JDK compilation version] Determine Which JDK Version a JAR/Class File Was Compiled With #java

javap -v [path to your class file] | grep 'major version'

Hazem-Ben-Khalfallah / duplicate_rows.sql

Created December 30, 2019 13:51

[Detect duplicate rows] #sql #mysql

	# display duplicate rows
	SELECT
	*
	FROM (
	SELECT
	person_id,
	@rank := IF( @email = email and @firstname = firstname, @rank + 1, 1) AS row_number,
	@email := email as email,
	@firstname := firstname as firstname
	FROM

Hazem-Ben-Khalfallah / show_constraints.sql

Last active December 30, 2019 11:49

[Show all table constraints] #sql

	SELECT TABLE_NAME,
	COLUMN_NAME,
	CONSTRAINT_NAME,
	REFERENCED_TABLE_NAME,
	REFERENCED_COLUMN_NAME
	FROM information_schema.KEY_COLUMN_USAGE
	WHERE TABLE_NAME = "<TABLE_NAME>";

Hazem-Ben-Khalfallah / ssmparameters.sh

Last active July 11, 2019 15:01

[Get ssm parameter] get all parameters from aws ssm and extract their names and descriptions #aws #ssm

aws ssm describe-parameters --query "Parameters[].{Name:Name,Description:Description}" --output text

Hazem-Ben-Khalfallah / schema.sql

Last active July 8, 2019 11:08

[DB schema and privileges] #sql #mysql

	#connect to mysql
	mysql -u root -p

	#list privileges
	select user,host from mysql.user;

	# create new schema
	CREATE SCHEMA `[SCHEMA_NAME]` DEFAULT CHARACTER SET utf8;

	# grant acess on schema to user

Hazem-Ben-Khalfallah / uuid_mysql.sql

Last active November 7, 2019 08:50

[UUID to string in Mysql] #sql #mysql

	#MySQL 8

	#convert uuid binary(16) to String
	SELECT BIN_TO_UUID(uuid) FROM foo

	#convert uuid string to binary(16)
	SELECT UUID_TO_BIN(UUID())


	#MySQL 5,6,7