|stickmanlabs_h||anyone in here i have a quick question|
how do i return say the 10th-20th result from a set?
|CPUnerd||adaptr, hehe I got the company to change server.. literally :)|
I was just going to ask, what command are you using to watch your disk acrtivity
iostat or something ?
|stazich||hi, can anyone help me with "porting" a stored procedure from SQL to Oracle?|
|stickmanlabs_h||does 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?|
|CPUnerd||stazich, what's the name of this channel ?|
|stazich||CPUnerd, yeah, mysql. i was just wondering if anyone here could help because in every other channel i have been to, noone replies..|
stickmanlabs_h: search for "The LIMIT caluse can be" and you will find the appropriate bit
figured it out ;)
|musya||can anybody direct me to a good tutorial on making logins with php and mysql?|
|CPUnerd||http://pear.php.net/LiveUser or http://pear.php.net/Auth|
|musya||also 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|
|CPUnerd||by login in and seeing where it goes.|
|musya||well say client 1 logs in as client1, and it has to go to client1's page for his info, and not client2's page.....|
|CPUnerd||yeah 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..
how to upgrade mysql 4.0.22 to 4.1
|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?|
|blaa||I 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
|JZA||hi 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