June 8, 2010
by Mohan Cheema
0 comments
Blobbing Data With PHP and MySQL
Databases can be used for storing large amounts of binary data, known as BLOB’s. These BLOB’s can store just about any type of data imaginable, including MS Word documents, GIF/JPEG images, PDF files, MP3′s, etc. In this article we will see how to create a binary file repository using PHP and MySQL that can store and retrieve several different file types.
May 6, 2010
by Mohan Cheema
0 comments
I continuously forget the syntax for this (doesn’t help that it’s different in every database engine):
select table_name from user_tables;
Shows all user tables. You can also do:
select owner,table_name from all_tables;
which shows all tables.
To see what a particular table looks like, you can do: