Hello
I have a database with variable-size fields, some of them may be
modified/deleted during the usage and administration, so my doubt is: how can
I compact the records to remove those blank spaces and save space, lets
say "defragment" the database file so data is continuous and contiguous?
Hello
How can I send a query that retrieves only the first 'N' rows that match a
condition? As far as I know you must call mysql_fetch_row() until the last
row has been processed or the resources allocated won't be free.
Am creating a program in PHP that should retrieve only 'N' records each ti
Hello list
I have doubt on TEXT data types... Checking my notes I see these ones:
TINYTEXT/TINYBLOB (2^8) 255 chars
TEXT/BLOB (2^16) 64K chars
MEDIUMTEXT/MEDIUMBLOB (2^24) 16M chars
LONGTEXT/LONGBLOB (2^32) chars
Well, my doubt consist on this... are these FIXED lengths for the text fields
or t
Hello list
I have a large database of contacts, but since not all fields are used I
decided to separate all information in 3 tables to save space like this:
DB_ADDRESS
id int
address char(128)
... three columns more ...
DB_COMPANY
id int
company char(64)
DB_LISTS
id int
list char(16)
Not all