#mysql
08 October 2007
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:47 <****> gynterk: the key on the server is ok, I use require ssl, is that client side no need the cert any key? just need ca certs?
03:48 <****> 0x504f4920 etc.. to ascii, needs a script... in another language...
03:48 <****> Is client don't need the cert and key?
03:48 <****> mySQL v4.1
03:49 <****> !m darkblueB string functions
03:49 <****> darkblueB see http://dev.mysql.com/doc/refman/5.0/en/string-functions.html
03:49 <****> there is a hex() and an unhex() function
03:49 <****> aha
03:50 <****> sensez: I have no idea then...
03:50 <****>ascii converters available on DaTubes: http://www.google.com.au/search?q=convert+hex+to+ascii&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
03:51 <****> is there any particular differnce of defining a foreign key as a index key than foreign key with references to the table where it comes fmor?
03:51 <****> fmor
03:51 <****> from
03:53 <****> select unhex(`myWKT`) as txt from `borders2` where 1 ... returns nulls ??
03:55 <****> myWKT is not a hex string...
03:55 <****> ToeBee: is a TEXT
03:56 <****> blob
03:56 <****> oh, export did something to convert it to Hex.. I'm lost
03:56 <****> unhex takes a hex string and convertes it to to a character string
03:56 <****> hex is 0-9 and A-F
03:57 <****> something in string functions that will show TEXT field as ASCII
03:58 <****> AsText() or somethin
03:59 <****> hex is a base 16 expression of something
03:59 <****> insert into test (id ,date ) VALUES (1,'0000-00-00 10:20:00');
03:59 <****> ERROR 1292 (22007): Incorrect datetime value: '0000-00-00 10:20:00' for column '
03:59 <****> date' at row 1
03:59 <****> date is a DATETIME
04:01 <****> !m vbabiy-Laptop date and time
04:01 <****> vbabiy-Laptop see http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
04:01 <****> specifically str_to_date()
04:02 <****> ToeBee: you mean you can't just pass a string?
04:03 <****> ToeBee: so thats wrong because its a string
04:05 <****> ... looks like a custom function might do it, but dang, this is too much.. back to varchar for now
04:06 <****> vbabiy-Laptop: try passsing 1900-01-01
04:06 <****> instead of 0000-00-00
04:07 <****> thumbs: that work is there a way to allow 0000-00-00 date in to mysql
04:08 <****> not with a datetime field, no.
04:09 <****> a datetime field requires a valid date.
04:09 <****> http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
04:09 <****> ok thanks
04:09 <****> is it possible to put mysql authenticate via ldab?
04:09 <****> ldap *
04:43 <****> Anyone know if REPLACE INTO causes an index rewrite if only non-indexed columns are different ?
04:50 <****> not much u
04:51 <****> Nom-: Since it's effectively a DELETE/INSERT, yes, most likely.
04:51 <****> bsckdq: try not using the amsg command.
04:57 <****> Nom-, insert .. on duplicate key update may help you better
04:57 <****> dumbasses
04:57 <****> bsckdq--
05:03 <****> Anyone know of a good coldfusion file uploader which will let users upload an unlimited amount of files and will keep creating the right amount of colums in mysql?
05:06 <****> normalize
05:06 <****> normalize, or feel the wrath of the table scans
05:06 * thumbs smashes chadmaynard
05:07 <****> WHY!
05:07 <****> ?
05:07 <****> why not?
05:07 <****> it's a form of kindness, from me.
05:07 <****> hehe
05:08 * chadmaynard smashes thumbs back
05:08 <****> thank you.
05:09 * chadmaynard doesn
05:09 <****> whoops
05:10 * chadmaynard doesn't like the normalize factoid
05:10 <****> me neither.
05:11 <****> Should I erase it?
05:11 <****> i think so
05:13 <****> jks2222: btw that was pointed at you
05:13 <****> lol
05:13 <****> I wasn't sure
05:13 <****> haha
05:13 <****> I didn't know what any of that meant
05:15 <****> create a table called file uplods with user_id and the file_upload columns and you can create a row in that table every time a user uploads something. Creates rows instead of columns. Mucho bettero
05:15 <****> Ahh
05:15 <****> nice :)
05:15 <****> thx
05:24 <****> when I start mysql I see this "Checking for corrupt, not cleanly closed and upgrade needing tables.." how do I fix this issue ?
05:24 <****> what issue? does it find corrupt tables every time?
05:25 <****> ToeBee I am a newby at databases but when I run /etc/init.d/mysql restart I see the message above I am also not sure which log files to look at to see if tables are corrupt or not
05:26 <****> or is there a command to check and see if all is ok with my databases and tables ?
05:26 <****> well what makes you think that messagae indicates a problem?
05:27 <****> cause my application mythv-backend is behaving weird and locks up complaining that It can't communicate with the database but I am able to type
05:27 <****> mysql -u root -p and login to the database
05:31 <****> well I'm pretty sure that message is just an informative note, not an error message. See if you can get more details on the error from mythv
05:33 <****> okie dokie
05:36 <****> logs are usually in /var/log/
05:42 <****> is there any reason someone would choose default '' vs default NULL in a db definition? (/me has inherited a db and I'm trying to establish a good set of defaults)
05:46 <****> kados: The two values are quite different.
05:46 <****> yes, one is null value and one is empty value
05:47 <****> kados: You'd choose '' when you want '' and null when you want null.
05:47 <****> :-)
05:47 * kados has trouble imagining when that distinction is useful
05:48 <****>.
05:48 <****> or <.
05:49 <****> kados: You could have SQL that needs to match in those cases.
05:49 <****> kados: For those rows.
05:49 <****> but empty string does?
05:49 <****> is this in the sql-92 spec?
05:50 <****> kados: Correct. NOT 'a' = field will match '' but not null.
05:50 <****> kados: It's standard, yes.
05:50 <****> thanks, that makes sense
Total 24 pages. You are browsing page 4/24.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last