| Zombie | Anyone here use phpMyAdmin? |
| action | Xgc smiles. |
| Xgc | smiles. |
| 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. |
| raymond | Zombie: eh? 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... Xgc: :) |
| NormanAthol | hi just wondering if someone can help me turn on remote access to my mysql server i am running mysql5.0 on debian etch |
| seekwill | external |
| 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 |
| Haris | Hello |
| 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 ? |
| raymond | no 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? |
| NormanAthol | yeah to add the users i doen this |