| Azundris | Funny, that's the same the reason it usually is for me. |
| txmanilat3r | is there special syntax for using environment variables in mysql? im running a script from bash as a mysql cmd and trying to use $1 to insert into whatever table I specify |
| Azundris | ... ENOPARSE echo " select user from mysql.user where user like 'root%';"|mysql -uwhoever -pwhatever echo " select user from mysql.user where user like '$GOOLOOGOOLOO';"|mysql -uwhoever -pwhatever (Yeah, mind the quoting/escaping.) |
| Pennywise | is there any way to create a fulltext index for a joined search? |
| matsur | how do i join on a db that has two columns pointing to the same primary key in another table? |
| Azundris | matsur: ? |
| matsur | table sales has cust_id and seller_id which both map to person_id in people |
| the_wench | I'm *not* a bot! I'm a real buxom wench |
| hapt1K | http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html |
| juxtap | too late |
| hapt1K | or im not as fast as software but at least im sexy in the mirror bbl my sex whats a gf. |
| action | Azundris now goes off imagining assorted fun house mirrors |
| Azundris | now goes off imagining assorted fun house mirrors |
| hapt1K | hehe |
| action | archivist imagines broken mirrors |
| archivist | imagines broken mirrors |
| quotemstr | Gragh. Buggy display driver Anyway, can anyone reproduce my problem? :-P |
| archivist | no |
| dsch04 | hapt1K: Looks like I screwed up the binary copy. Just stopped both DBs and restart replication and it's working now |
| quotemstr | archivist: Is that an "I tried, but it works for me" or a "I don't care"? |
| archivist | quotemstr, no, because I see no problem to try |
| quotemstr | archivist: CREATE FUNCTION foo_s_blah(param varchar(255)) RETURNS INT BEGIN RETURN 42; END. archivist: SELECT foo_s_blah() from the mysql client reports an error. The same query executed with the C client library returns 0 from mysql_query. archivist: and mysql_error and errno both report success. archivist: Nevertheless, no result set is returned. |
| SoulBlink | I just got asked to write a query for the information thats not in the database thats right "can you tell me what isn't entered?" |
| thumbs | .... |
| SoulBlink | ya I know |
| seekwill | So do it |