| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> there is way to do it?
<0> !
<0> locate, substring
<1> SUBSTRING(str,pos), SUBSTRING(str FROM pos), SUBSTRING(str,pos,len), SUBSTRING(str FROM pos FOR len)
<1> The forms without a len argument return a substring from string str starting at position pos. The forms with a len argument return a substring len characters long from string str, starting at position pos. The forms that use FROM are standard SQL syntax. It is also possible to use a negative value for pos. In this case, the beginning of the substring is pos characters from the end of the string, rather than the beginning. A negative value may be used for po
<1> mysql> SELECT SUBSTRING('Quadratically',5);
<1> -> 'ratically'
<1> mysql> SELECT SUBSTRING('foobarbar' FROM 4);
<1> -> 'barbar'
<2> ack
<1> mysql> SELECT SUBSTRING('Quadratically',5,6);
<1> -> 'ratica'
<1> mysql> SELECT SUBSTRING('Sakila', -3);
<1> -> 'ila'
<2> Nilesh: that's a BIG nono
<1> mysql> SELECT SUBSTRING('Sakila', -5, 3);
<3> i cant use susbstring() because i have some cases with '12 jadashdkah" and '122212 kjqhadshd'
<3> soo... the number is variable size.
<4> patafurdio: Use a programming language that is good at manipulating strings.
<4> (rather than trying to do all of your manipulation in sql)
<3> well... i could be using PHP...
<5> !php explode
<3> thanks for the idea mandel
<6> explode: http://us3.php.net/manual-lookup.php?pattern=explode&lang=en
<4> If that's the one you know best, there you go. I would do it in Perl because that's what I know best
<3> mendel...
<1> yeah manipulate the string using function & p*** it to query again
<3> PHP is very good to manipulate strings... i'm not very used to perl...
<4> Right, that's what I said. You can choose your own tools :)
<7> PERL is good for manipulating strings
<1> patafurdio: r u familiar with PERL
<7> I think PHP is good for manupulating databasese
<1> PHP is easy
<3> Nilesh, not too much...
<1> how do u learn it? n how much u know
<7> PHP has shoot-yourself-in-the-foot functions
<3> i get used to a language since i develop any project using it...
<8> does anyone has an idea about how to log connexions to the db (successful and failed ones) ? (or if it isnt possibl..)
<3> i dont use to get trained with one language if i not going to use it
<1> ok]
<1> can you tell what was the project and why did u use perl in it
<3> but i think i'm going to need perl in a coming project...
<4> endy: You can't log connections without logging queries, AFAIK.
<8> mendel: ok
<1> what is your learning souce?
<3> and then i'll get used to it finally!
<8> mendel: but logging the queries will log also failed connex ? and connex without any queries ?
<4> Right, in the general query log
<1> any book?
<8> ok mendel
<3> i use to read any documentation like tutorials, or reference docs from the language website
<8> thanks :)
<1> ahh ok
<1> any website u know
<8> (logging all the queries will be a bit painful on a serveur handling 600req/s but well.. let's do it..)
<1> ur fav?
<3> and i'm thinking about using perl for that project because i'm going need to use some Libs
<3> C libs.. and perls can access to them, right?
<4> endy: Alternatively, put a wrapper in front of mysql
<1> C libs for ???
<1> webserver?
<4> Perl can't just magically use C libraries, no.
<8> mendel: ha, you mean i could get the logs directly in the wrapper ?
<8> good thing, i'll have a look
<8> :D
<8> ha no
<8> i understood wrong
<3> well... i need to interact more with the operating system... like... processes... services etc...
<8> :)
<1> ahh ok
<1> ur using them like day to day util right?
<1> small scripts
<3> and Perls i think is good for that!
<1> i think shell script is also good option
<3> i use PHP in a regular basis... nos just for small scripts but for big projects too!
<1> infact it is defacto standard
<1> like bash scripts
<3> soo... PHP and Shell scripting... would be good???
<3> like... to manage services, users etc??
<1> NO
<3> i think perl would be a good choice...
<1> shell script is good
<3> what about ruby???
<1> evrything is good at it place
<1> at OS level its good
<1> perl is good at application level
<3> Nilesh, but i need to use it throug the web... just shell scrpt is good for that??
<1> thats what i just said
<1> [03:09] <1> evrything is good at it place
<1> [03:09] <1> at OS level its good
<1> [03:09] * Questutis (i=clt-6735@user26.satnet.lt) Quit ("What day is it Today ?")
<1> [03:09] <1> perl is good at application level
<3> right!
<1> tell me the example or scnerio
<1> i am the noob
<1> how would utilize perl script for web based scripts
<1> any example?
<1> i want to make u my PERL GURU
<1> :)
<1> patafurdio?
<9> what is the definition of "the directory where the server is located" in the mysql reference manual?
<9> I'm trying to figure out the proper setting for ledir
<9> location of database data files, or location of server binaries?
<9> http://bugs.mysql.com/bug.php?id=3530 has ledir ending in bin/
<3> sorry... i w*** looking at other screen
<3> well..
<3> i need like...
<1> var/lib/mysql
<3> add users to the OS (Linux on this case)..
<3> manage directorys...
<1> patafurdio???
<10> archivist: i added "ORDER BY date LIMIT 10000" to the search word queries... the total execution time was cut by 50% :)
<1> ok
<1> okz bye for todays
<1> thanks patafurdio
<3> Thanks Nilesh...
<3> we can talk better other time...
<1> bye
<3> and sorry my bad english!
<3> i got to go too!
<1> it was quite ok
<1> k
<3> thanks
<11> Shola hai ya bjudiya BAMBAI nagariya :P
<9> nobody here runs mysql out of a non-default directory?
<1> quite (GOODBYE ALL)
<3> well... that was not english for sure!
<3> lol
<3> foi tanto ingles como o ke estou a falar agora :P
<1> lol
<1> yeah it our native english language
<1> Hindi
<1> and it was bollywood song
<3> Nilesh, where are you from??
<1> Bollywood man
<1> dont u know
<3> :X
<3> where's that?
<1> India
<3> oh! i see! :)
<1> it is 2nd biggest industry afetr hollywood
<3> i would looove to vizit india man!
<1> sure patafurdio
<3> i have some friends here, from India...
<1> really
<1> from where?
<3> Toronto, Canada...
<3> from too many places...
<1> ok
<3> I'm from Portugal!
<1> okz
Return to
#mysql
or
Go to some related
logs:
css21 chm
#gentoo
#perl
#python
please insert the disk labeled windows 2000 professional cd-rom into drive A:
#perl
#web
code model not supported in the 32 bit mode
#kde
#linux
|
|