| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> if you're new I suggest using mysql administrator for creating databases, tables and columns
<0> using that myself and it makes it rather easy to set up a database pretty fast.
<0> buggy, but it works :P
<1> hi
<2> _Jay: thanks
<3> is someone can give me a database example of concurrency read (user A edit row 2 of table t1 but I want user B to be able to read row 2 of table t1 but beware that he is in rad only mode)
<4> )
<5> :)
<4> )
<6> archivist my friend
<7> Hi, is there some way that you can delete something from an database when it's used?
<7> That it directly deletes the input from the database when it's used
<8> i have error code 0 while starting server ... ?
<6> NiGHTFiRE^ define "USED"
<8> what can i do about ?
<6> Ildio check the yourHostname.err log
<6> should be somewhere around /var/lib/mysql or so
<7> Well, i'm making an registering script and they use an activation key and i want tat when someone used the activation key it gets deleted from the database
<9> hi
<6> well do that in your scripting language NiGHTFiRE^ ?
<6> the database CANNOT know when something is "used" since it doesn't know what USED is.
<9> what type does struing functions return? does they return utf-8 strings?
<6> cam|2 they can return whatever you want
<9> jax: should I cast?
<7> Okey but how do i do that in my scripting language :S
<6> cam|2 that's up to you. there is always a default collation.
<7> i use php, how can that check if it's used
<6> but if you want to force a certain collation, you can.
<6> NiGHTFiRE^ well how do YOU know it's used in php?
<6> cam|2: http://dev.mysql.com/doc/refman/5.0/en/charset-general.html
<9> jax: the thing is, I can't decide what's the position is set like. I don't get anything with substr (name, 0,1) but I get substr (name, 1,1) though I have strings starting with utf-8 chars, and terminal do not show them
<7> Can mysql delete something after X minutes?
<6> NiGHTFiRE^ NO
<6> but a cronjob could execute a query to delete something.
<6> but that sounds very wrong :D
<6> cam|2 try this
<7> yeah. damn, how should i fix this then
<9> jax: and when I use substr (name, 1,2) I have my utf-8 chars but only one char for them and those ascii ones are two char long
<6> NiGHTFiRE^ hello? what does used mean?
<6> apparently a user has to call a script, to active the product, eh?
<6> in that script just do: if(activationWorked) { mysql_query("DELETE FROM t1 WHERE key='X'"); } else { echo "sorry we couldn't activate"; }
<9> why mysql dump every charset and just stick to utf8 for the programmer's sake ;)
<6> cam|2 well utf-8 chars can be 2 bytes long i guess
<7> yea
<6> but substr should be using by char, and not by byte
<6> let me see
<6> "This function is multi-byte safe"
<6> hm
<7> Oh, thank you very much Jax
<6> cam|2 can you give me the line causing you trouble?
<6> so I can do some tests
<6> NiGHTFiRE^ does that seem logical to you?
<7> yes
<6> good ;)
<9> ips
<7> lol:p
<6> cam|2 what language is that
<9> tr
<9> tr_TR.utf-8 :)
<6> can you show me the word on the inet somewhere ?
<6> (i don't think it displayed right here)
<6> :D
<9> hmm
<9> you cna visit www.hurriyet.com.tr
<9> and grab a text there
<6> ok
<9> which has strange words ;P
<6> and what is your substring query looking like?
<9> select substr(name,0,1) as first_char from table;
<9> maybe it's just the terminal but I really doubt that
<6> what's your connection collation?
<9> utf8_turkish
<5> :)
<10> i have error code 0 while installing the first time : Cannot creat windows service for mysql
<10> anyone ?
<10> i have error code 0 while installing the first time : Cannot creat windows service for mysql
<9> well I got another question
<9> can I have a limit which has step
<9> like I only want to get evey 10th row
<11> Sembiance :)
<6> cam|2 do you have an id or so
<6> or what is "every 10th" row
<9> there's no id
<9> on an ordered query, first row tenth row, twentieth row ..
<6> so you just want a random resultset, and chose every 10th row of tht?
<9> yes
<9> I want a step
<6> one sec
<6> ok think i got something for you cam|2
<4> )
<6> woozy fix your stupid away script >;/
<6> cam|2 you can try something like this: SELECT vorname, IF(ISNULL(@cnt), @cnt:=1, @cnt:=@cnt+1) AS my_count FROM shop_kunden HAVING my_count%10=0;
<6> i just hacked that together... not sure if it'll work
<9> eh
<12> I feel like screwing someone
<9> let me try :P
<12> no, thanks
<10> i have error code 0 while installing the first time : Cannot creat windows service for mysql
<10> what can i do abou it ?
<12> uhm flush it down the drain?
<12> j/k. no windows experience here so I might stfu
<12> me that is
<6> ah there's still some mistake cam|2 but you get the idea
<6> let me see if i can fix it real quick
<9> jax: but there's a one problem. mysql has to handle all rows
<9> that would only save bw
<6> of course
<6> well.. i could have told you from the beginning, there is no way to do it :D
<9> hmm k :)
<9> but still nice trick
<9> glad to see it , ehe
<6> hm
<6> you could create a temporary table
<6> with 0 - num_rows on it and join on that, where virtual_id%10=0
<6> or so
<6> not sure if that would work
<6> i'm sure some others here can come up with something better :D
<13> problem trying to cennect to mysql it says my host is not allowed
<11> neener :P
<14> Hate to ask this, but if a field contains "NULL", is that the actual string "NULL", og is it just dead empty?
<15> Depends if it containts 'NULL' string or actuall NULL
<16> :)
<14> actual NULL.. as in, no data inserted.. :p
<14> damn, think I just answered my own question there...
<16> you did.
<14> Thought so.. Sorry everyone. :)
<17> what does UNSIGNED mean?
<6> DeathCore means it cannot have negative values
<6> on the other hand you can have double the amount of positive values
<17> ah, k
<6> say instead of from -31,32 you can have 0-64
<17> k
<6> ^CodeX^ it's actually dependant of your language if that's what you're asking.
<6> if dealing with NULLs in php is a pain in the ***
<14> Jax: Well, then it's a good thing it's PHP I'm doing.. yay
<17> i never could grasp the meaning of NULL :/
<11> omg DeathCore
<17> :P
<11> I seee youuu CPUnerd :P
<14> isn't there a simple way of checking if a field is empty in php? (or contain null, as discussed earlier..:p )
<17> if ($field == "") { blabla }
<17> very rough :)
<11> use pearl?
<11> :P
<17> pearl habour XD
<14> DeathCore: would that be the same as using the isset function in php ?
<17> isset checks if $field is set...yeh...
Return to
#mysql
or
Go to some related
logs:
totalwallpaper.com
#asm
naked_japanese_stomp
#sdl
#ubuntu
pppoeconf slack package
#perl
aweenet
#debian
#ubuntu
|
|