|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
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?|
|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||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|
|action||archivist imagines broken mirrors|
|archivist||imagines broken mirrors|
Buggy display driver
Anyway, can anyone reproduce my problem? :-P
|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?"
|SoulBlink||ya I know|
|seekwill||So do it|