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 |