revDAVE wrote:
Newbie question!
I have a list of field names from another database (not mysql) - like:
name
phone1
phone2
street
city
state
zip
info
etc.... (a bunch more fields)
Q: Is there a way I can add these to an existing empty/blank table?
I have phpMyAdmin and If there's a way add tables w / php - maybe that would
work also....
If I can just get all the field names in the table as text fields - that
would be ok for now - then I can individually change the field type by hand
w phpMyAdmin...
BTW: What is the best field type for 'average' text (not large 'BLOBS')
like:
1 - Street address - maybe less than 255 characters
2 - Info field - maybe more than 255 characters
- (let's assume that user might want to search on the fields):
-text?
-char?
-TINYTEXT?
-mediumtext?
-varchar?
-longtext?
Q: Is there a url to read about the types?
I'm looking at these now but not quite sure ...
http://dev.mysql.com/doc/refman/5.1/en/char.html
http://dev.mysql.com/doc/refman/5.1/en/blob.html
Dave,
You really want to take you MySQL questions to a MySQL list.
Also, for using PHPMyAdmin, RTFM as it tells you how to use it with your
table.
Wolf
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
