#mysql - Tue 1 May 2007 between 03:24 and 05:02

NY Lost Funds



fooAndyGore: Heya
stickmanlabs_hanyone in here i have a quick question
super easy
how do i return say the 10th-20th result from a set?
CPUnerdadaptr, hehe I got the company to change server.. literally :)
AndyGoreHey foo
I was just going to ask, what command are you using to watch your disk acrtivity
iostat or something ?
stazichhi, can anyone help me with "porting" a stored procedure from SQL to Oracle?
stickmanlabs_hdoes anyone know how to do pagination wit a query, say i have 200 results and i only want results 110-120 how would i do that with LIMIT?
CPUnerdstazich, what's the name of this channel ?
stazichCPUnerd, yeah, mysql. i was just wondering if anyone here could help because in every other channel i have been to, noone replies..
Lathiatstickmanlabs_h: http://dev.mysql.com/doc/refman/5.0/en/select.html
stickmanlabs_h: search for "The LIMIT caluse can be" and you will find the appropriate bit
stickmanlabs_hthanks
figured it out ;)
musyacan anybody direct me to a good tutorial on making logins with php and mysql?
CPUnerdhttp://pear.php.net/LiveUser or http://pear.php.net/Auth
:P
musyaalso i have a question, say i have a login that works, how can it know where to direct each person too? say its a client login, where each client has their own page
CPUnerdby login in and seeing where it goes.
musyawell say client 1 logs in as client1, and it has to go to client1's page for his info, and not client2's page.....
CPUnerdyeah well look at the code and see where it goes..
could be hardcoded, could be in the db, could be a custom built link, whatever..
musyaoh,ok
thanks
blaahi all
how to upgrade mysql 4.0.22 to 4.1
seekwill!man41 upgrade
the_wenchsee http://dev.mysql.com/doc/refman/4.1/en/upgrade.html
mr|venom`is there a way to create a query that will, when executed, increment an integer from the previous one (in a non auto_increment) table?
blaaI want to dump database from mysql 4.0.22 to mysql 5.0.22 .
what should I do ?
and want to set charset to utf-8
and utf-8 do not support on 4.0.22
I got this error ' Specified key was too long; max key length is 1000 bytes
'
help me, please
JZAhi I want to know if how can I use mysql from the command line.
I am using bash, and I think mysqladmin is a cli for mysql

Page: 2 9 16 23 30 37 44 51 

IrcArchive

NY Lost Funds