pultneytooner
25-Aug-06, 13:23
Okay... I've got a question about the SET datatype. Say I've run the following code:
<?php
mysql_connect("localhost", "mysql_username", "mysql_password");
mysql_select_db("mysql");
$sql = 'CREATE TABLE test(testset SET(\'a\',\'b\',\'c\'))';
mysql_query($sql);
?>
Is there a query I can run to get all the possible values of `testset`, and/or one that I can run to add and delete values from `testset`?
For instance, I want to add the possible value 'd' to the set, how would I do it? Also, if I want to echo every possible value of the set into the html, how would I do that
<?php
mysql_connect("localhost", "mysql_username", "mysql_password");
mysql_select_db("mysql");
$sql = 'CREATE TABLE test(testset SET(\'a\',\'b\',\'c\'))';
mysql_query($sql);
?>
Is there a query I can run to get all the possible values of `testset`, and/or one that I can run to add and delete values from `testset`?
For instance, I want to add the possible value 'd' to the set, how would I do it? Also, if I want to echo every possible value of the set into the html, how would I do that