| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> hahem
<0> ok the string now has A in the middle and A at the end.
<0> right(ca_product_id , 6) in ( '5%','4%')
<1> did not even know mysql did compound IN's
<0> "LIVE0123456789A1210A"
<2> lsmith: because it would be insanity to use that
<2> but yes, syntax is neat
<0> so basically i need to select all that has A in the middle.
<0> can anyone help me wiv this query?
<2> [11:53] CaptainLIKE %A% ?
<0> that won't work coz i have to A and in this field the end constantly have A's
<0> Where as in the middle i hve A, B, C etcc.
<2> LIKE %B%?
<0> wat?
<0> anyone?
<0> isn't there a function a little bit like left() or right() but where i can specify to start from nth character and stop to nth character?
<4> mysql-php can ONLY connect to hosts and not to IP address. how this can be solved?
<1> substring()
<2> idan: it should be able to connect to IPs
<2> idan: what error do you get?
<2> idan: all our code connects to ips
<4> domas: Can't connect to MySQL server on '192.168.1.38' (13)
<2> and if you enter host name of that server, it works?
<4> yes
<2> I don't believe you
<2> 13 is permission denied
<2> therefore error might be returned by firewall
<2> or selinux, or whatever
<4> selinux?
<2> and hostname might be showing you to another ip
<2> :)
<5> hehe
<1> domas: is there something like pgsql's EXPLAIN ANALYZE in mysql?
<2> nope
<2> most near thing is @@last_query_cost
<2> or something like that
<2> :)
<1> should i bother filing a feature request?
<1> lala
<2> on the other hand, our statistics rock!
<2> therefore even predictions are accurate!
<1> "our"
<2> lsmith: you can always do that!
<1> did you join the gang?
<2> lsmith: looong ago
<1> whats your job title?
<5> domas why did you stop showing up in the lighty channel? :)
<2> supastuff: I show up when I'm cooking something
<2> right now I'm in process to start cooking something
<2> lsmith: Sup.E.
<2> lsmith: and 'unofficial maintenance guerilla'
<5> good ;)
<2> lsmith: http://lists.mysql.com/commits/3306 \o/ ;-D
<5> why does mysql decide to put all my new cluster nodes in the same nodegroup and say that they are all masters? :)
<1> domas: filed
<2> supastuff: because you didn't read some docs?!!?!! :)
<5> I do, honest
<5> and did :)
<5> and the docs told me that nodegroup "grouping" is automatic
<2> I'll approach cluster from the other side
<2> API first, administrative stuff later ;-)
<5> what do you mean by API first?
<6> hi there
<6> got a little problem, i cannot connect to mysql with the user i created with the create user command
<6> host, user and p***word are set.
<7> mysql --compatible=mysql40 worked.
<6> ok. flush privileges was missing
<2> supastuff: http://flake.defau.lt/docs/ndbapi/
<5> ah, I don't need performance that high though, or such fine grained control
<5> I'm using it mostly for its HA benefits and fast read-mostly queries ;)
<2> um, it's fast for writes
<5> well sure
<5> but my app is read mostly
<5> I didn't mean to say mysql cluster would be slow on write queries
<5> so no offence :)
<8> hello :)
<8> how can I repair many tables ?
<8> myisamchk -r / is that all ?
<9> Xxaxx for repairing , then yes
<9> but normally, you shouldn't run that
<8> then how?
<9> !man REPAIR TABLE
<10> (REPAIR TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
<9> do you have a disaster :)
<9> You should optimize table, not repair
<9> !man OPTIMIZE TABLE
<10> (OPTIMIZE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html
<8> but my version is 4.0.20
<9> http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html
<8> 4.0 < ? :)
<9> it will work
<8> hm, ok, thanks
<9> Before MySQL 4.1.1, OPTIMIZE TABLE statements are not written to the binary log. As of MySQL 4.1.1, they are written to the binary log unless the optional NO_WRITE_TO_BINLOG keyword(or its alias LOCAL) is used. This is done so that OPTIMIZE TABLE statements used on a MySQL server acting as a replication master will be replicated by default to the replication slave.
<9> You should upgrade to 5
<9> :>
<9> Your living in the iceage
<8> that mean all broken tables is lost?
<9> no
<9> Depending if your depending on the bin-log or not
<2> 5.1!
<9> http://dev.mysql.com/doc/refman/4.1/en/repair-table.html
<2> who's still talking about 5.0?
<9> sorry :)
<9> I am not good with subversions, I say 5 :)
<8> m0: ok, thanks
<8> MyISAM-table './yp/firms.MYI' is usable but should be fixed
<8> that mean I must use REPAIR ?
<11> does mysql 5.0 support nested transactions? which was missing from previous releases
<12> hello
<11> Sal, hello
<12> is there a way to get a number out of a varchar field and return that number + 1 ? i mean if i have a field with these values: "ABC1CDE", "2ABC" or "CDE3", how can i get only the highest number "3" to add 1 to it?
<11> does BDB and NDB support full ACID transactions?
<13> Sal best not store data that way if you want to modify on a regular basis
<12> archivist: i have an id field of the customer field that can be an alphanumeric key
<12> so sometimes they insert numbers and other times letters
<12> but i would like to auto fill the field with a numeric value if they leave it empty
<13> your app then
<12> so i was think of getting the biggest numeric value out of the field and add 1
<12> yep, mine
<13> or have a separate auto increment field that will allways be updated in addition
<12> but in that way i first hace to save data to get the last_id
<12> i want to fill the screen field when the user leaves it
<2> j4v4m4n: yes
<2> j4v4m4n: though, single isolation level on both iirc
<11> domas, second question, right? BDB and NDB
<14> hi dudes
<12> archivist: aint there a way to get only the number part out of a varchar field? something like numeric() or a cast stuff?
<14> i need to store an key from a table called user into a table sessions_work
<11> domas, how about nested transactions?
<14> i need an advice about the structure on session_work
<14> the key that i need to add to session_work is called 'id'
<14> you think that is right to add this field like index but not like primary key ?
<13> Sal you can cast but dunno if it will work woth a mixed chr num field
<14> or i can add a primary key and add this id
<2> j4v4m4n: no nested transactions. InnoDB supports savepoints
<2> j4v4m4n: I would not count on BDB
<2> j4v4m4n: and NDB is for distributed environments
<11> domas, ok, save points same as "named marks"
<15> hi, how is the easiest way to duplicate a line in mysql?
<2> INSERT INTO table SELECT line FROM table
<2> :)
<15> i have a line with an id and many other fields, i need to insert a new line with just one field changed.
<2> INSERT INTO table SELECT field1,field2,value1,value2,field5 FROM table WHERE id=...
<2> :)
<14> about my question any advices
<14> this is an example of the session_work: id, user, lastime, content
Return to
#mysql
or
Go to some related
logs:
#css
debian VITESSE vsc8201RX
#kde
#centos
550 5.7.1 Unable to relay for @aol.com
+at commands +intel 536EP
#gentoo
konverter fc5
bcm43xx-fwcutter 64-bit firmware
MP3 craig CMP1400
|
|