Archives: database

Postgresql cheatsheat 5/5 (1)

Connecting to MySQL:  mysql -u user_name -p Connecting to PostgreSQL: sudo -u postgres psql Description MySQL command PostgreSQL equivalent Show databases SHOW DATABASES; \l[ist] Use/Connect to a database named ‘some_database’ USE some_database; \c some_database Show tables/relations within one database SHOW TABLES; \dt Show table details (columns, types) DESCRIBE some_table; \d+ some_table Show indices of some_table (in • Read More »

MySQL Binary field how to insert, search No ratings yet. e.g: CREATE TABLE `Test` ( `myhash` binary(16) DEFAULT NULL ) Insert 10E8400E29B11D4A716446655440000 as HEX representation of some chars Insert into `Test` values ( UNHEX(“110E8400E29B11D4A716446655440000”) ); MySQL standard is to use this notation to denote the string as binary… X’9fad5e9eefdfb449′ insertinto assignedresource values(X’9fad5e9eefdfb449′); Search select hex(myhash) from Test where myhash=UNHEX(“110E8400E29B11D4A716446655440001”); Please rate this • Read More »