| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> oops
<1> ...looking
<2> and i have to check it in every row
<0> !man if
<3> (Control Flow Functions) : http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html
<1> knt: http://dev.mysql.com/doc/refman/5.0/en/xa.html
<2> mysql 4.1 :(
<1> knt: there is regular transaction support using "BEGIN" or "START TRANSACTION"
<1> knt: http://dev.mysql.com/doc/refman/5.0/en/commit.html
<2> :D
<2> in 4.1 works also
<2> great :)
<2> thanks
<4> TodoInTX: thanks.
<5> hi, everybody
<5> anybody awake?
<2> hello :)
<5> hi
<0> yo
<5> I have a little problem
<5> with a query
<6> I would have never guessed.
<6> I thought you joined to make fun of us.
<5> SELECT p***word, username,(YEAR(CURDATE())-YEAR(birthdate) ) AS edad_user
<5> FROM users
<5> WHERE uid = '88a9f2546335452aaa3bdb94db4d5b73'
<5> AND active='S'
<7> Wow. Mysql development seems to be on fire these days.
<8> http://forums.mysql.com/read.php?24,74774,74774#msg-74774 any ideas why the query is so slow and how to make it faster with same result ?
<7> 5.0.19 *and* 5.1.7b.
<5> this query returns me "Edad_user" = 2006 if birthdate =null
<7> Can't wait for 5.1.* though. Way too many cool features.
<5> How i can filter this query to execute only if birthdate !=null
<0> AND birthdate <> NULL
<7> birthdate is not null?
<8> not correct
<8> birthdate IS NOT NULL is the correct one
<0> oops, wait
<0> IS NOT NULL
<0> my bad
<8> not the != NULL <> NULL
<7> hehe :)
<5> then only selects the entries with birthdate<> null and I need all of them
<7> Then don't do birthdate is not null.
<5> [Narada_] this is not possible
<5> cause there are a lot of entries
<5> and I can't update them
<5> SELECT p***word, username,(YEAR(CURDATE())-YEAR(birthdate) ) AS edad_user
<5> FROM users
<5> WHERE uid = '88a9f2546335452aaa3bdb94db4d5b73'
<5> AND active='S'
<5> I need this query but if bithdate = null then edad_user=null
<5> maybe with a datediff?
<9> hi, i currently have this : $query = 'SELECT domain FROM domains ORDER BY domain'; and i would like to only select "domain" with a field "pw" set along.. if no pw, it would not select.. how ?
<7> weird; so many questions about conditional selects
<6> SELECT domain FROM domains WHERE pw IS NOT NULL ORDERY BY domain
<6> This may be a generic answer.
<9> thanks
<6> ORDER, even.
<6> But this only ***umes you actually make use of "NULL"
<7> I wonder if you can do WHERE pw != DEFAULT(pw)
<7> !man default
<9> right, it doesn't work
<3> (Miscellaneous Functions) : http://dev.mysql.com/doc/mysql/en/Miscellaneous_functions.html
<9> the pw field is empty on some domains
<6> sw-: Well, you should have said it was "empty" then.
<6> SELECT domain FROM domains WHERE pw != '' ORDER BY domain
<9> sorry :) i'm a noob at mysql
<9> it works ^^ you deserve a hug :)
<6> :)
<10> hi, I am using mysql 4.1, and it seems that replication doesnt work anymore. the last query was a CREATE DATABASE, but there's a db filter on both the master and the slave, the connection is working between the servers, but the logs are not transfered, what can the problem be?
<10> hm actually the conneciton is not made, it is always in the state "Connect" , I cant find any logs saying what's wrong
<11> ERROR at line 1276: Unknown command '\''.
<11> i try to run data.sql
<11> how do i see what is wrong ?
<12> put your query on a pastebin
<12> it's obviously a misplaced \
<11> its too big for a pastebin :>
<12> look for the \ then.
<11> infi: i just grab a part of a mysql table and wront it on vi data.sql and pasted
<11> and tried to run it , so it will make a table n a database and insert values
<12> throwing random stuff in a file and feeding it to mysql is probably not the best idea.
<11> so how can it be done
<12> actually read what you're putting in the file.
<11> it has lots and lots of data
<11> most probably user datafile
<11> of more then 5000 users
<13> hi, is there a awy to convert a DB from innodb to myisam?
<13> way*
<14> kon_: yes
<14> or rather the tables.
<14> ALTER TABLE tablename ENGINE=myisam;
<13> ah as simple as that
<13> and anything else will be kept, relations etc?
<14> BUT! you will loose innodb specific stuff
<13> hm yep
<13> when i checked google i only found myisam to innodb conversion guides
<13> is innodb that better than myisam? i need to check the features of each
<14> kon_: depends on what you are planning to do with your db.
<13> its used for mediawiki
<14> what does mediawiki recomend? :)
<14> if i where you i would read abit about both engines, and see what fit best.
<14> im not the right person to tell you what engine to use.
<15> kon_: innodb inforces constraints, myisam does not
<15> enforces*
<15> other than that, i can't help you :)
<14> i think mysql.com has a good FAQ or so regarding the diffrent engines
<13> the problem is following: we ran a mediawiki with mysql using innodb engine, now we moved this wiki to a new server and there everything else run with myisam and also we got the following error: #1016 - Can't open file: 'mediawiki_archive.InnoDB'. (errno: 1)
<13> and i would like to convert these wiki tables to myisam
<15> innodb needs extra data files, that's probably what's causing the error
<15> you can convert from innodb to myisam with ALTER TABLE, I think
<13> i still have the old dump, so i could 'sed' all Engine=InnoDB to Engine=MyISAM ?
<14> boro_O: yep, you can.
<14> ALTER TABLE tablename ENGINE=myisam;
<15> well, there you go :p
<15> kon_: yes
<15> myisam understands the constraint syntax, it just won't enforce it
<15> just changing the engine would do
<14> if you still have the dump you are safe ;)
<15> hehe :p
<13> thanks for the useful and nice help then! :)
<13> ill give it a try
<14> kon_: good luck.
<14> it should be no problem
<16> what is wrong with this query ...
<16> UPDATE wp_coi_events SET event_ID='1006' event_author='3' event_title='BIGFEET' WHERE event_ID=1006;
<17> you need commas after each field is set
<17> SET field1 = 'bboo', field2='abc', ...
<16> ok, changed
<16> UPDATE wp_coi_events SET event_author=3, event_title='BIGFEET', WHERE event_ID=1006
<16> still not executing
<17> don't need one on the final field
<17> !SQL corndoggie UPDATE
<17> hmm
<16> dont need comma
<17> aye
<16> ?
<18> !man update
<3> (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<17> :)
<17> thx
<19> what package is supposed that mysql_dump comes ?
<20> mysqldump comes with mysql client
<19> arg, i hate this osx
<19> do you suggest me any flag to do the dump from mysql5, to be imported into a mysql4 later ?
<19> IIRC there is a special flag to avoid possible problems
<20> --compatible
<19> thanks
<20> =mysql40
<21> 48% of my temporary tables are disk based
Return to
#mysql
or
Go to some related
logs:
show grants from current_user mysql 3
wget and mythdora
define jebot
unexpected RCODE (REFUSED)
slackware 7 cfdisk
modules.dep+missing+genkernel
#perl
ubuntu mame 686
#linux
having cluse in sql
|
|