#mysql - Sun 25 Mar 2007 between 20:00 and 21:30

NY Lost Funds



Shaba1sorry other way around the foreign key was int(2) and the primary key in the table was int(3)
just does not seem right to me. you are making the foreign key field smaller then the original key in the original table
Antaeusquick question: does mysqli_stmt_close() closes only the stmt or does it closes the connection also?
anyone could help with an mysqli issue? i create the connection on beguin of script and close it in the end. Use 3 stmt in the midle but once i use mysqli_stmt_close to free the resources of the first stmt connections dies also
according to the manual mysqli_stmt_close should only close the stmt and not the connection itself. anyone?
!tell me about mysqli_stmt_close
the_wenchme
katamiCan somebody help me with inserting information into a table?
I know this should be simple but I'm not getting it
I've done everything according to the tutorials i've found, and when I do it, I don't get any errors, just it doesn't do it?
threnodykatami: paste your insert query and any error messages.
ofer0how do I make a numeric MAX() on a VARCHAR column ?
jefofer0: max(to_number(column))
ofer0jef, thank you.
jefofer0: np
Antaeus: dunno. what problem?
Antaeusall started with getting my connections to max in my mysql box
using mysql 5.0.27 on a fedora 3 box with php 5. using mysqli
i create a connection with mysqli
with that connection i want to use several stmt's by using mysqli->prepare and only close the mysqli connection on the end of script
however, once i call the first stmt->close() the next stmt's all fail
i'll paste it on pastbin to show
KalleDKHey how is it you grab only one name if it exists more than once in a row.. so | ab | ab | ag | au | would become |ab|ag|au|
Antaeusselect distinct
use select distinct colname from table
KalleDKThx looking it up (trying in my database now)
Thx worked as intended :D
malverian_Hi all, is it okay to Ctrl+C a mysqlcheck -cr ?
Also, is it okay to 'kill' a REPAIR statement from the mysql cli?
Or could this cause database corruption?
katamihttp://www.pastebin.ca/409924
malverian_If anyone can help that would be awesome.
demoncorsairhey room
can you compare the curdate to a value in a table and delete if it is older or newer?
katamino help to be found here
demoncorsairy not?
katamiI dunno
demoncorsairthis is a mysql channel right?
katamithey have a nack for ignoring you
demoncorsairoh

Page: 2 9 16 23 30 37 44 

IrcArchive

NY Lost Funds