| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> sven_GP: if you don't provide a WHERE it'll update every field in the table
<0> sven_GP: but be careful ... make sure that that's what you want to do
<1> ah ok ..
<0> cause you're ****ed if it's not
<1> :-)
<0> there' no undo ;)
<0> actually - backup what yo uhave first :)
<1> yeah Iam shure I want to update the whole DB...
<1> well I could reimport the db if it ****s up ;-)
<0> not the whole db - just the table that you specify
<0> yup :)
<2> how can i select a timestamp in the 5.x format in a 4.x database?
<2> i mean with the yyyy-mm-dd hh:mm:ss
<2> when i select it now, i dont get the - : and space
<1> zoro: hmmm ok but unclear how to change char values Like -> Update db SET ... (every char '%' to 'R' ) forexample
<1> not whole fields, but only characters of that fields
<1> in that fields
<3> !m sven_GP string replace
<4> sven_GP: (The replace String-Replacement Utility) : http://dev.mysql.com/doc/mysql/en/replace_utility.html
<3> no that's not it
<5> zoro: do you already have rows in the table you're trying to alter ?
<3> !m sven_GP string functions
<4> sven_GP: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<3> sven_GP: replace() on that page
<0> zeitoun: yup - 280 of them - that's the problem :)
<5> and the number you're using for auto_increment when you alter is lower than the max already present in the table ?
<0> no - it's one after the max already present
<0> 287 is teh current max. i'm setting the new auto_increment to 288
<0> i'll try setting it to 287
<3> if it's just the next number, why are you setting it?
<0> shabbs: because it's currently floating at the "9" mark :)
<0> which is a considerable distance from 288 :)
<0> i manually inserted alot of data from another database, presuming that the auto_increment would match the maximum uid value i entered
<0> i presumed incorrectly
<6> zorro - it should ahve
<5> sjrussel: maybe not in 3.23.....
<6> I think even in 3.23
<0> sjrussel: well it didnt :p :)
<0> sjrussel: but yeah i thought it would too
<6> zoro - most likely, your index is fuX0red
<6> I've seen flakey behaviour before, it's generally due to index corruption
<0> sjrussel: ah **** sake. i'm not wiping all this now - it's on a bloody live site :/
<6> you probably don't have to wipe it, just fix it
<6> !m zoro repair table
<4> zoro: (REPAIR TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html
<0> sjrussel: won't that reset indices? so all empty spaces between rows are compressed?
<6> it shouldn't
<0> aswell as changing the uid's of users?
<0> hmmm
<7> hi, has anyone seen errors in 5.x like 'MySQL server has gone away' ?
<6> in every version
<6> it means your client connection is gone.. like a broken pipe error in unix
<7> heh, but more in 5.x, i just upgraded and i see errors like that in php and python
<0> sjrussel + zeitoun: you're not going to believe this
<7> maybe it's related to config
<6> you can use ping() to reconnect dormant conneection
<0> but the drupal system that i'm using for this site, ****ing stores the sequences in a separate table
<5> zoro: Ha !! I thought aliens where attacking !
<6> I've seen it mostly with longrunning queries when I have several connections open
<6> zoro - I've actually seen the behaviour you describe happen, though :)
<8> How does mean : "ALTER TABLE `keywords` ADD UNIQUE (
<8> `abr`
<8> )" ?
<6> adding an index
<9> alainlucas: it adds a unique index on the column `abr`
<8> yes, but what's the use of an index ?
<0> sjrussel: :) well i've had no other reasons to believe the repair would be needed. it was needed about 7 months ago on a different database and table, but not since
<0> and the site's working fine in every other way
<0> but **** sake :)
<0> :)
<8> does it mean that there can't be a same value in two rows of the table ?
<8> does it mean that there can't be a same value in two rows of the column of the table ?
<10> yes
<0> yup
<8> yes to me ?
<0> yup
<0> :)
<8> :)
<8> thanks
<0> it means that all abbreviations must be unique
<0> but i'm not sure if that stretches to case sensitivity
<0> ie: "IRL" != "irl" ... even though they mean the same thing
<0> you may want to check that
<8> ok, that's what I wanted but whithout being sure of how to do it
<0> :)
<8> my column is in utf8_general_ci, so i guess it's case insensitive
<11> can make it case sensitive if you want
<8> and case sensitive with utf8_bin
<8> yes, you're right, that would be better...
<2> how can i prevent duplicates from being selected?
<2> ah, distinct
<12> Ok. I've installed mysql on Debian and executed grant privileges *.* to 'denyerec'@'localhost' identified by 'somep***'; and Peppers and capsicums also contain solanine and solanadine, the nicotine compounds that are unique to nightshade plants.
<12> Fking clipboard.
<12> and grant privileges *.* to 'denyerec'@'192.168.123.%' identified by 'somep***';
<12> However I can't get my IDE (operating on a windows machine) to communicate with mysql.
<12> Just tells me it can't connect, even though I've specified the correct IP, Port, Username and p*** :/
<5> Denyerec: check your ide options to see if you can connect throught a socket instead ... OR ... check your my.cnf to see if you don't have the option 'skip-networking'
<12> Shall check my.cnf first
<12> as on Fedora I didn't need to connect through a socket.
<12> I thought IPTables might be blockin 3306 but I don't know how to check in ubuntu :/
<12> Fedora had a useful Firewall GUI but Ubuntu does not :(
<12> Owh
<12> skipnetworking was enabled.
<12> DOH
<5> cl***ic....
<5> :)
<5> it is on most distro... or enabled with bind_address 127.0.0.1
<12> Hehe, yes so I notice.
<12> Thankyou so kindly.
<8> What would it do in mysql if, using php, I do mysql_query("UPDATE mybase.mytable SET mycol = '".$myvar."' WHERE ref = xxx"); where myvar is an array ?
<5> np
<12> Just wondering... bind_address could contain a list of allowable accessing addresses, correct ?
<10> it would set mycol='Array'
<10> but, take those types of questions to ##php or ##php-support
<13> Denyerec: can only hold a single address, can only be listed once
<12> Mmm
<12> So its purpose is to lock mysql to one IP connection only ?
<3> Denyerec: it's supposed to bind it to an interface on your server. ie if you have 2 network cards, you can bind it to only accept connection coming in on one of them
<12> AH
<12> I shall stop asking silly questions and return to the docs.
<12> :)
<12> Thanks for the input chaps!
<14> is there any benefit to using `row` or `table` with php?
<14> as opposed to just using row or table?
<14> ie: SELECT '*' from `my_table` LIMIT 30; as opposed to: SELECT * FROM my_table LIMIT 30; ?
<14> any reason to use one or the other?
<14> 300 people and not one answer?
<14> O.o
<3> Shadowhand: `` is used to explicitly tell mysql that the table/database/field name is a literal
<3> ie if you were to use a reserved word as a database name, you'd want to enclose it in `
<14> shabbs, thanks... so for portabilities sake, i should use quotes and `'s?
<3> enclosing none reserved words in ` helps avoid problems with future upgrades, ie if a word in a future release becomes reserved, you won't have to change aything
<9> !tell Shadowhand about evil
<4> Alrighty.
<14> Darien, i was using 'SELECT *' as an example, but thanks :)
<9> just making sure ;)
<10> however, in many languages `` executes shell commands when used in an interpolative context
<10> you have been warned ;-)
<14> sjrussel, using php :)
<14> thanks for your help all...
<14> Darien, i have to admit, select*isevil was a good read
<9> yeah, it is :)
<14> i'll quit using it now :P
<9> :p
<14> lol
Return to
#mysql
or
Go to some related
logs:
Debian Etch and xserver-xfree86
package.mask madwifi
fix transperent foobar
triple faulting at boot
ap_proxyerror
strconcat php
nm_applet, ip subnet
#css
#gentoo
xpdvd_ff7
|
|