| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> hmm i'll give it a go
<1> ph8: 2005-12-12 is just representation, it is stored not as string ofcoruse :)
<0> awesome cheers
<0> of course
<1> nooo problem
<2> Is there any way to automatically apply a modification to a field when inserting or updating? Like if I insert a p***word into a p***word field then automatically to sha1_sum() it before insertion?
<1> yes
<1> no
<1> wait
<1> i'm on mysql, ok, thought i was in django
<1> :)
<2> heh
<1> Narada: triggers I guess
<3> Can i do like this: UPDATE mytable SET xp=xp+52000, race=race4 WHERE playerid='nice'";
<2> Kemurii: yeah
<2> DEFAULT values only come into play when NOT NULL is set right?
<4> Default values work even if the column does accept null values. It's possible to want to set the column to null and not the default.
<1> Narada: DEFAULT value is used when you don't specify a value for the field, but it can not contain functions
<1> free_one: yes?
<2> I see.
<3> good.
<5> On a linux system, I heard that I could back up all my databases by just backing up one file (I think in /lib). If so, what file is that?
<6> you heard wrong
<7> john_doe: mysqldump
<5> frank-: thanks
<7> np
<8> hi guys
<8> if i have a database and i want it to spit out a SQL query to recreate it, what can i do?
<9> mysqldump
<8> say for example i have a table and i want a SQL query that will recreate the query
<8> DShadow, thx
<8> DShadow, and what if i don't have shell access to the database server?
<10> Hello.... I need a query that selects some indexes from one table, then it has to order these by a field in another table where the id rows are identical to one another. But I cant seem to figure out how to formulate it..... anyone with a hint??
<10> I tried with an AS or INTERSECT or UNION, but cant get either to function correctly. Please help.
<11> where can i find a concat_ws that skips empty strings?
<11> the default behaviour really pisses me off
<10> Can someone help me with SQL query?
<12> When I use the mysql.server.sh script from support-files it comes back with and error: /etc/init.d/mysql: line 1: @HOSTNAME@: command not found
<12> How do I fix it?
<6> select tab1.ind1, tab1.ind2, tab1.ind3 from tab1 LEFT JOIN tab2 on ind2 order by ind2.sortcol;
<6> if tab2 is large, it will be _slow_
<6> why is it returning too many rows? this is disturbing
<6> I must have screwed up something, don't use that
<13> hello http://rafb.net/paste/results/nhzVUy67.html , you see there some tables.. when someone opens a page i know the klantID.. what i want is to display all bedrijf ID in select boxes, but echo SELECTED in the relations, for example i
<13> n the case of klantID select the checkboxes 1,3,4 ... but display all bedrijfID
<13> can someone please say how to do this
<13> i thought a query within a query..... but im confused.
<6> oops, ON tab1.ind2=tab2.ind2 ... I was thinking USING
<14> how do i get a row INSERT to return the primary key where it was put (column is auto_increment)
<15> hex: last_insert_id()
<15> in sql, or mysql_insert_id or whatever call is in client apis
<14> thanks. i didn't know whether it was possible or not
<16> how do i get delete field in table, because i ry code like this DELETE FROM student WHERE kodsubjek1= "1023";
<16> the whole data in m table student will delete
<16> hem.. any suggestion
<16> http://pastebin.com/621899
<15> Fedoracore6: poor guy
<17> morning
<15> it won't be all deleted.
<15> unless all kodsubjek1's are same
<15> hello my friend!
<1> :'|
<15> what?
<15> why the sad face?
<1> I feeeelllll loonneellyyy tooonniighht
<15> I had lots of walks outside, it's just -1C outside, WARM!
<15> aaah
<1> lets see how my old club in Frankfurt is doing
<15> you're going to Fra now?
<15> heheh, I'm waiting for next weekend
<1> in a few hours
<15> going to...
<15> London!!!!!
<17> find yourself a girl Kemurii
<1> had usergroup meeting yesterday in Frankfurt
<1> domas: meeuuh, lucky you
<15> blobaugh: hey!
<1> blobaugh: I need headhunters
<12> Where does mysql store its' logs?
<17> heh
<18> var log mysql?
<17> erf: lilnux or windows?
<12> linux
<17> /var/log
<1> erf: in Datadir, or in a alternate location,
<15> ergh, erf. was nickname of one of my colleagues
<1> erf: depending on your config, check my.cnf, for log_error
<12> Kemurii, not mentioned.
<15> erf: then in datadir
<1> erf: SHOW VARIABLES LIKE 'datadir', there
<17> Kemurii: in linux it defaults to /var/log
<15> mysqld --help --verbose | grep datadir
<12> blobaugh, my error is I cant start mysql.
<15> blobaugh: that depends who and how compiled it
<16> domas its my table problem right
<1> echo "Where mysql logs???" | mail -s "Clueless! Help!!!" sysadmin@yourcompany.com
<15> I've seen zillions different locations, but the first one I'd look in is datadir
<17> domas: default....
<15> blobaugh: default is in datadir.
<12> I am the sysadmin...
<1> erf: oei, endless loop ;)
<15> erf: /var/lib/mysql/ ?
<15> erf: /usr/local/mysql/{var|data}/ ?
<12> domas, not there.
<1> blobaugh: it is not /var/log at all, /var/log/mysql/ maybe
<1> blobaugh: mysql as server running as user mysql can't write in /var/log/
<17> Kemurii: thats in /var/log right?
<17> got /var/log and you will see mysql
<17> unless you tell it to go somewhere else
<15> erf: mysqld --help --verbose | grep datadir
<1> erf: what log file you after anyway?
<12> error log.
<15> blobaugh: it depends on rpm package, and every distribution may do it in different way
<12> When I use the mysql.server script to start mysql it just errors.
<10> Hello.... I need a query that selects some indexes from one table, then it has to order these by a field in another table where the id rows are identical to one another. But I cant seem to figure out how to formulate it..... anyone with a hint??
<1> erf: what error?
<17> domas: well an rpm wouldnt be a default install per se would it?
<17> thats someone else's install
<12> Kemurii.... Starting mysql............ ERROR!
<1> :)
<1> erf: run mysqld_safe &
<12> I found the problem, mysql doesnt have permision to make a pid file
<15> blobaugh: well, obviously he's running rpm or deb install
<19> quad_: Your question was answered long ago.
<12> Im not actually, I built from source.
<17> erf: what distro
<10> Xgc, it was?
<17> domas: when did he say that/
<12> blobaugh, debian.
<15> blobaugh: in ".... ERROR'
<10> Xgc, which line? - I wasent highlighted, so I figured nothing was said to me.
<1> erf: download binaries
<12> I found the problem, just correcting it now.
<1> damn it
<17> erf: then look in /var/log
<19> quad_: Check the irc log. You don't need the LEFT JOIN. It can be an inner join.
<15> he already corrected it
<12> Kemuriim I prefere source
<15> hey, I've had some port
<17> Kemurii: debian does it right
<12> And /var/log doesnt contain the log.
<15> and still see what he's doing
<1> no, debian doesn't do it right
<1> there is a bug, but ok, go compile with bloody debian :P
<1> and the fix in debian didn't help
<20> Hi, Can someone help me insert a field and data into mysql table ? through shell
<17> ive not had any issues with mysql on any of the debian boxes ive used it on
<21> I have
Return to
#mysql
or
Go to some related
logs:
#css
howto cat recursivly
#web
#ubuntu
cannot create installation source yast
#php
preempt_voluntary
#linuxhelp
#centos
ob_flush crash eaccelerator
|
|