|Zombie||Anyone here use phpMyAdmin?|
|seekwill||Xgc must use phpMyAdmin.|
|Zombie||Is there a less Back Assward way of creating Views?|
|Xgc||seekwill: Sometimes it's funny to watch people wait for answers to non-questions.|
|Zombie||Currently, I've been expressing my views as Select commands, then manually adding the CREATE VIEW on the front end.|
Zombie: That's how a VIEW is created.
|Zombie||Are there more efficient ways,|
of doing that?
|Xgc||Zombie: That's the way most every database does it. It's similar to the SQL standard.|
|seekwill||Xgc: Well, it is a question... just not a very useful one.|
Xgc: And what do you mean by "sometimes". It's always funny
Zombie: How is it not efficient?
|Jonathan25||what's the mysql command line to make results from a column all unique.|
|seekwill||SELECT DISTINCT will make MySQL only return distictive rows.|
|Xgc||seekwill: It doesn't ask the real question. Pretty much like asking if anyone knows how to do a SELECT?|
|raymond||Jonathan25: DISTINCT just as it is with all other SQL engines.|
|seekwill||Xgc: Still a question... :)|
|Xgc||Just not *the real* question.|
|seekwill||Hmm... I have some time to spare. I shall make a wiki page to address Jonathan25's question...|
just wondering if someone can help me turn on remote access to my mysql server i am running mysql5.0 on debian etch
|the_wench||remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306|
|NormanAthol||i have already changed the bind address to my local ip but from what i can tell you mean just remove it completly|
|NormanAthol||there is no skip networking it says the default is to now only accept connections on local host|
|Jonathan25||is this correct:|
ALTER TABLE blabla ADD UNIQUE email varchar(320) / correct ?
ALTER TABLE foo ADD email VARCHAR( 65 ) NOT NULL, ADD UNIQUE INDEX idx_email ( email );
probably even better would be:
ALTER TABLE foo ADD email VARCHAR( 65 ) NOT NULL, ADD UNIQUE INDEX idx_email ( email( 8 ) );
|NormanAthol||i must be doing something wrong somewhere it dosent seem to be working for me|
i commented out bind-address in mysql.cnf
|chadmaynard||did you restart mysql?|
to add the users i doen this