| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> (Problems with Column Aliases) : http://dev.mysql.com/doc/mysql/en/Problems_with_alias.html
<1> How can I alias something in a database
<1> for example: if I have two names for the same thing: planet & globe
<1> can I have one be an alias of the other?
<2> Cant grasp what you are asking uncled.
<3> Leithal want a laugh
<4> sure
<3> http://www.mysql.com/company/jobs/cert-exam-writer.html
<3> see line Knowledge of and insistence on correct language use (to the point of being an annoyance to those around you ;)
<3> then line To be considered for this position, you must provide an applications with the following:
<3> stab that writer
<4> loll yea
<5> archivist: that's just to prove the point that we need some help ;-)
<3> hehe
<5> btw, we're still searching, so don't forget to tell all your friends ...
<6> hmm, is it possible to COUNT() certain values of IN () twice in the following query? SELECT SUM( price ) AS price FROM product_state WHERE s_id IN ( 1754, 1674 )
<6> Its the total of a shopping cart, but would like some items to be counted more then once because of more then one of a certain product
<7> UltimateB|: Define "some" and you will see the solution :)
<6> hmm
<8> UltimateB|: sum(if(s_id=1754,price,0)) as price1754
<6> ok, im gonna open the manual to see what that means :)
<6> Cool, if expr1 is true, then return 1st expression else return 2nd expression. Should be able to get something to work with that.
<6> Any idea how much that strains the db? ;)
<8> almost nothing, jsut a bit more cpu time, and should be faster than running the query multiple times for different values
<6> :) cool
<4> http://people.csail.mit.edu/rahimi/helmet/
<4> lakez: has your bug been verified yet?
<3> heh saw that some months back linked off GROKLAW
<3> if you ever see cheap test gear like that tell me I collect / use it
<6> lokus, coolest thing learn in mysql in months...
<4> use it for what?
<6> SELECT SUM(if(s_id=1674, price*1000, price)) as price FROM product_state WHERE s_id IN ( 1754,1674 )
<6> learned*
<8> attend mysql training and you will learn a lot more :)
<3> Im sitting here designing an electronic timer and rotator atm
<9> if mysql won't respond to stop .. what signal is the next preferred? killall -15 mysqld won't respond, what signal should i use?
<10> lakez: Do you have physical access to the power cord?
<9> peqe, no
<9> heh
<3> -9 is the same as the power cord
<3> not recomended
<8> lakez: maybe connect to the mysql server and kill those connection that does not end when you try to shutdown the server
<11> heya.. any replication pro:s here?
<11> I'm trying to troubleshoot a running two-way replication-setup, and I simply can't understand why on earth stuff does not work as I expect them to..
<8> mysql does not support 2-way
<11> lokus: it doesn't?
<11> http://dev.mysql.com/doc/refman/4.1/en/replication-faq.html ???
<11> as far as I read, it doesn't support two-way with locking, but DOES support two-way?
<8> ulrik: it doesn't, but if you want to do two 1-way then it can work, I fond this better term for it
<11> *ahh* allright.. :) let's call it two 1-way then.. :)
<8> ulrik: so whats the problem
<11> anyways, my problem is that while replication from B to A works, replication from A to B fails, but does not produce any errors, simply updates the log positions, and says nothing while updating nothing..
<8> ulrik: you check the shoq slave status?
<8> *show slave status
<11> lokus: yeppers.. can't see any errors on the updates, and I do see the master-log-pos updating and staying in sync
<8> ulrik: does the relay-log increses?
<11> lokus: noopers.. :) THAT's interesting.. :)
<12> Hi! Im a real newbie! Im just learning mysql (doing tutorials to learn ) Ive been looking over a lot of stuff and everything points to php to connect to apache. Not good I dont know php, perl, or any other language. What is a good newbie way to learn (or easy way to connect) mysql to a website (apache) Thanks
<12>
<8> ulrik: maybe you have some option like replicate-do* or replicate-ignore*
<11> also, now when looking at the relay-part, I noticed Slave_SQL_running is No.. *-)
<11> lokus: no replicate-do or ignore, no..
<8> ulrik: try to start it, start slave sql thread , not exactly sure of the syntax
<11> hum, isn't only START SLAVE then only command for starting both IO and SQL-threads?
<8> ulrik: correct
<8> ulrik: can also start specific ones
<11> hum, allright..
<13> Hello!
<11> lokus: *ahh* checking the log, it seems something somewhere f*cked up the SQL-thread, making it stop.. after some log reading, I understand the SQL thread stops once an error is discovered?
<8> ulrik: if you look at the show slave status carefully, the last error should be there
<11> lokus: so now after some manual tweaking fixing the errors, it seems my database is up and running again.. :D
<14> how do you create a new user in mysql? what's the mysqladmin command?
<11> lokus: so thanks a LOT for pointing me in the right direction! :D
<11> lokus: I've been struggling with this all day, and had you not pointed me at the relay-log-pos, I propably would still be struggling.. :)
<11> so thanks.. :)
<3> !m oskie adding users
<0> oskie: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<14> thanks. DOH.. I was using mysql 4.0!
<14> no wonder CREATE USER doesn't work..
<6> Can i use CASE in SUM() ?
<6> hmm seems i forgot END
<6> :)
<15> Hi!
<15> Is it possible to have UNIQUE on three different columns?
<12> OK I've been out at the http://dev.mysql.com/doc all morning
<15> like ... I don't want user_id, show_id, season to be duplicated at all in this table?
<12> so many ideals and my brain is killing me
<12> I guess I just need one way of doing thing
<12> I'd like to put my small mysql database on a website
<12> quick and simple
<12> how do I do that
<12> best way
<12> anybody
<16> use php?
<12> OK
<12> php
<12> that is good
<16> php.net
<12> thank
<16> my plesure
<17> pod: should be possible IIRC
<12> When I was looking into setting up a database for my office I was told to look into oracle that it came with a nice web front end already installed does mysql have anything like that or are they looking at adding anything like that??
<15> BartVB, I've been reading, and apparently if I create and index using those columns then it should be unique and not allow me to insert duplicated records?
<17> correct
<17> bonnyman: the defacto standard webfront is phpMyAdmin, it's not very difficult to setup (download, unpack, point it to your DB and setup some security, that's it).
<15> Hmmm ... That didn't work though...
<15> BartVB, do I have to specify unique on the index?
<17> pod: yup
<15> index unique "name"?
<17> or primary, depending on what you want exactly
<15> Excellent, that worked!
<17> allraighty then
<15> If I'm searching on this index, should I make it primary? Then it'll be unique in any case?
<17> primary indices are always unique
<15> what is the syntax to specify that it's primary?
<17> normally you use the primary key for a unique identifier on this table
<15> so primary key (index) for instance?
<17> alter table add primary key 'indexname' (col1, col2, col3)
<17> with the name of the table between 'table' and 'add' ofcourse
<17> but if your table also has an autoincrement ID column then I would only put the ID in the primary key.
<15> no auto_increment
<18> Hi. I'm thinking of a way to get records back from a table. The table has 2 columns, a begin date and a end date. I know have another begin and end date and wanted to get the rows back that have the begin and end date between the given begin and end date.
<18> I was thinking of something with between, but I just can't really think of a way to use it.
<18> So I was checking if a date period overlaps another.
<18> I think I've found some solution.
<19> WHERE begin BETWEEN earliest AND latest AND end BETWEEN earliest AND latest
<19> maybe also: AND begin < end
<20> As Salaam e laikum (means: peace b upon u) .............. http://www.submission.org/ .......... [112:0] In the name of God, Most Gracious, Most Merciful [112:1] Proclaim, "He is the One and only GOD. [112:2] "The Absolute GOD. [112:3] "Never did He beget. Nor was He begotten. [112:4] "None equals Him."
<4> !op
<4> !op Leithal
<21> woo
<19> durka?
<9> Grr, god damn "load data from master" is broken with RBR... why the #@$@ do I use alpha in production. I think it's ... myisam (master) -> slave (heap+btree indexes) that is causing the problem.. haven't done a case to report bug yet but i will
<22> sounds @!$%@%
<23> sounds what/
<9> sounds what lsmith? i had to switch my internet
<22> i was just kidding ..
<22> sorry
<24> Where can i edit my FC4 mysql vars? my.cnf doesnt seem to work, and this only works temporary during running...but reboot resets it: SET GLOBAL wait_timeout=60;
<9> Madsret, you have to set it in my.cnf .. mysql --help
<9> use /etc/my.cnf
<9> it'll be permanent
<25> is there a way to turn logging on without restarting the whole daemon?
<25> hrm doesnt look like it
<26> good morning, as it were
<24> lakez: like this right ? "set-variable = thread_cache_size=40"
<9> Madsret, drop the set-variable
<9> [mysqld]
<9> thread_cache_size=40
Return to
#mysql
or
Go to some related
logs:
emerge help2man fail gettext
#linux
#fedora
clear bios +nc4200 +clear
#ubuntu
e17 bling deb
firefox-bin alsa
#ubuntu
snmpd ifHCOutOctets linux
repository marilat ubuntu
|
|