| |
| |
| |
|
Page: 1 2
Comments:
<0> if to see data
<0> last inserted
<1> I only want to see the last inserted record
<1> mysql_affected_row sounds like a php function, eh?
<0> yes
<0> mysql php
<0> see the ref
<1> ok, thanx
<1> I read about mysql_affected_rows but will it show the result even if I last inserted two months ago?
<0> dunno
<0> so use desc with select command
<0> it will sho you the last one and so on
<0> like record 200 199 188...
<1> I see, and use php code to show the last one recorded
<0> :)
<2> Anyone know of a good Database Design application for Linux
<3> kate and vim
<3> what I use anyways
<4> Hey.. I'm having alot of trouble with a mysqldump.. On my old server (debian woody, mysql 3.23.49) i try doing a databasedump. When i import it to my new server (debian sarge, mysql 4.0.24) all my danish characters are totally ruined. Looks like they're somehow converted to UTF8 or something.. Any ideas?
<3> and the charset and collation used is?
<3> long story short, rtfm
<4> K_F: the character_set is set to latin1 on both servers. I've tried --default-character-set=latin1 with my mysqldump, but still no luck
<3> mysql> SHOW VARIABLES LIKE 'character_set_system';
<4> Empty on both servers
<4> only character_set
<3> http://dev.mysql.com/doc/refman/4.1/en/charset.html anyways
<3> how is it stored in the file?
<4> looks like it's just fine in the file.. latin1
<5> uh oh! mysqld-nt.exe is crashing when the service is started and in the log files i'm getting this stuff: InnoDB: is in the future! Current system log sequence number 0 1156108. InnoDB: Your database may be corrupt.
<5> looking online and finding no solutions, i think i'm royally ****ed :P
<3> you're using windows after all
<3> only expected to have a few data corruptions, you can even use fat32 for all I know
<5> hehe
<6> what type of mysql column to use for inserting a data that is more then 10mbytes and then to use that data with fulltext match ?
<3> rtfm come to mind..
<6> ?
<6> I don't have manual here :(
<3> arrrgh
<6> is LONGTEXT okay to be used?
<3> you must be an imbecile
<6> no, I am not
<6> will you help me please?
<3> I beg the differ
<3> http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html
<3> now get lost
<6> K_F, if you want to help people do it in a kind and a gentle way
<6> thanks !
<6> bye
<7> i have a databases with a bunch of customer names, how can i find out where duplicated are, like select all rows where customer name appears twice?
<3> group by , count having http://www.kfwebs.net/links/6 for SQL
<3> can't someone for once ask a question that isn't sql 101?
<8> When trying to get your form"www" to connect too your mysql database.. how can you find out what the addy/ip is?
<3> for crying out loud
<3> arrrrrrrrrrgh
<9> morning all
<3> can't someone with an IQ greater than 100 ever join here?
<3> oh, great, now oceanBlue got here as well
<3> :p
<3> heya oceanBlue
<9> :)
<9> heya kristian
<9> who else got here ? :p
<10> hey K_F what collation should i use for multi lingual pages with raw unencoded chars?
<3> akira___ and instinctx
<3> Eldritch: "raw unencoded chars"? use UTF-8
<10> utf-8 uses multi byte chars right?
<8> K_F: my question.. do you know the exact name of the config file im looking for?
<3> Eldritch: theorethically up till 6 bytes
<3> instinctx: get a brain implant
<8> wish i could
<10> so im going to have to convert them in and out
<3> Eldritch: not really following, display it as UTF as well
<3> I use UTF-8 for everything, including IRC
<3> http://en.wikipedia.org/wiki/Utf-8
<3> instinctx: at least don't bug me
<8> ---can mysql work with anything else besides php, like cgi?
<3> you really are stupid, are you not?
<3> and whom are to say you don't run PHP as CGI?
<10> bugger it latin1_general_ci will do
<3> do you have any idea what CGI is?
<3> please, do us all a favour and stfu
<3> Eldritch: your question is somewhat interesting though
<10> how kind :0
<8> Sorry mate.. im starting school for all this trying to get an understanding before i start :p
<10> its my search engine, and i have a ferw multilingual pages, latin1_general_ci works for all but greek,russian and i dont care to much about them
<3> yeah, you would want utf-8 for that
<3> ><8B5@AB25==>9 >?0A=>AB8
<3> does mIRC support utf-8 now?
<3> http://www3.kfwebs.net/utf.png
<10> nope it was all garbage
<10> thats why i have avoided utf9 on web pages support
<10> i could convert to and from for the SE, but for 10 pages out of 2000 i dont think i care enough
<3> anyways, it says Committee for State Security
<3> I'm sure you know what that is..
<3> Komitet Gosudarstvennoy Bezopasnosti
<11> hello people
<11> what's the thing in mysql to insert the contents of a file?
<11> some rotard in #php want's to stuff 5 megs of text into a form field
<11> but I don't know much mysql, and as a result, can't help him much
<11> er db field, not form field
<6> is there any limit for mysql_query() string buffer size?
Return to
#mysql
or
Go to some related
logs:
MARA SHUNA
Gay Jogja
setinterval crash FireFox
#c++
What food got its name from the way it hung in bunches like grapes ?
#php
+dmx +kde
#chatzone
SE7500CW2 MVB
#linuxhelp
|
|
