| |
| |
| |
|
Page: 1 2
Comments:
<0> it's almost like they're trying to use them to keep count or something
<1> yup, but im guilty of tweaking them some times.
<1> usully early on after testing the autoinc could be in the hundreds
<0> ah, i see
<2> any idea why this query would not work
<2> $sql="Select * from residents r, weight w where r.codigo_resident=w.code_resident AND r.facility = '$facility' AND r.status = 'Active' AND w.datado LIKE '$datado___' AND w.month1 <>'' OR w.month3 <>'' OR w.month6 <>'' ORDER BY '$ordem' ";
<2> it returns all records from the tables, instead of the ones that match the criteria
<3> whenever i output my sql tables to html, the date column has the date followed by 00:00:00.00, does anyone know how to remove that?
<4> Hm. Do I need to do anything special in MySQL 5.0.19 to turn on transactions?
<4> On InnoDB tables, yes.
<5> anyone who can help?
<6> if I vanish over the next week.... Telstra stuffed up...
<6> I've had to make 9 phone calls and speak with 17 different people to get this line at my new address on
<7> slaut
<7> salut
<8> i'm trying to install mysql on debian sarge and it keeps crashing
<7> any errors?
<8> i have a log
<8> but before i send it, lemme ask, does linux sql depend on dbi.pm ?
<8> linux mysql*
<7> yes.
<7> i meen in redhat it does.
<7> it depends afaik on perl-DBD-MySQL
<7> which depends on perl-DBI
<8> well i just installed the dbi module *sigh* and its still crashing
<8> maybe i should have just built from the fing source :(
<8> want to see the log ?
<7> just the relevant parts please :)
<7> what do the logs in data say?
<8> it receives signal 11 after innoDB is started...
<8> what is Innodb ?
<7> do you need innodb?
<7> it's a database type
<7> acctualy a db engine.
<7> used for performance/transaction/ref. integrity reasons.
<7> but you can skip it i guess.
<7> you should file a report on debian's bugzilla.
<7> or check for similar problems.
<7> skip = turn it off
<8> actually i'm using the packaged binary from mysql.com
<8> not the debian archive
<7> .. why?
<8> because I want to know how to install it...
<7> umm.. then get the sources.
<9> hey guys
<9> I need some advice
<9> I've got a mysql slave who's hard drive crashed on me
<9> I have a spare scsi drive that I reloaded onto but I'm getting parity errors
<9> the problem is if I use a sata drive
<9> I have to use a different version of the os from the master
<9> which may mean a different version of mysql from the master
<10> hi
<10> I need help, when I try to open the connection with ado I got this message: lost connection to mysql server during query ..
<11> down the corridor, third door on the left, don't mind the DANGER sign
<3> so i have a 'date' column in mysql that is NOT datetime
<3> but when i use cgi to extract the values into html
<3> it comes out with 00:00:00.00
<3> (after the date)
<3> anyone know why this is? and how can i fix it?
<0> what's the data type?
<3> date?
<0> you seem uncertain
<3> well i specified it to be 'date'
<3> not 'datetime'
<3> is that what you are asking
<0> ok, that's what i was asking. it could have been timestamp
<3> what do you mean
<0> some people use other types to store dates too besides a date type
<3> i see
<3> yeah it looks like it is timestamp
<3> but it's not
<0> then the 00:00:00.00 must be inserted outside of mysql
<12> please tell me how to make a mysql databas
<12> i have installed WAMP server
<11> rtf
<11> rtfm
<11> heya beebum
<0> ;)
<11> was in freenode looking for you before
<11> I'm still bored, so thats ok :)
<0> still visiting the family?
<11> jup
<0> cool
<11> http://www.sbm.no/finans/default.asp?cat=454 <- like the first car there?
<0> nice
<0> i'll have to get a new car soon probably
<11> if it weren't for the damn easter holidays around here I might have had it already
<0> 200k+ miles
<0> heh
<11> well, it is 4 years old, so not new
<11> my father was actually the one leasing it from it was new
<11> so can't say I don't know the car :)
<0> that's good
<11> the leasing company hasn't sold it yet, so I get a good price on it
<0> my car is 10yo
<11> so is my current one
<11> a volkswagen polo
<11> smaller than the golf
<0> what type of fuel?
<11> standard unleaded 95
<0> i'm thinking about looking into diesel and alternative fuels when i start looking for a new car
<11> yeah, my father has diesel on his now, great car
<0> it may cost a little more that gas but with the milage, you're better off
<11> actually in norway that is opposite as well
<11> it is generally a lot cheaper
<0> that happens sometimes here but usually gas is less than diesel
<11> remember that gas is USD 2 a liter here
<11> http://www.kfwebs.net/news/233/Gas-prices
<11> would have been 0.6 a liter if it were't for the taxes
<11> so 1.40 USD a liter is pure taxes
<11> ... welcome to Norway
<0> wow
<11> hehe
<11> Oslo is the most expensive city in the world
<13> how can i sha1 from a select query
<13> $getinfo = mysql_query("SELECT username, SHA1(p***word), email, account_type, first_name, last_name, address, address1, address2, city, state, zip, phone, fax, country, membership_type, start_day, start_month, start_year FROM user;");
<11> we beat Tokyo in january
<13> is erroring
<11> 1) this isn't #php
<13> yeah i know, but it is mysql
<13> and this is a mysql error
<11> so use a pure SQL query then
<13> meaning?
<11> http://www.catb.org/~esr/faqs/smart-questions.html might increase your chance of getting a, in your perspective, positive response.
<11> not to mention there are some design decisions you most proabably want to look into
<13> mysql_query("SELECT username, SHA1[p***word], email, account_type, first_name, last_name, address, address1, address2, city, state, zip, phone, fax, country, membership_type, start_day, start_month, start_year FROM user;");
<13> better?
<11> are you high or something?
<13> no
<11> then stop acting like it
<13> im not
<13> ok, here we go, is there a way to sha1 in a select query
<11> 1) which version of mysql?
<13> one second, ill check
<13> MySQL 3.23.58
<11> in which case stop acting like the idiot you most probably are
<11> sha1 was added in 4.0.2...
<11> NEXT!
<13> which i did not know
<13> until now
<11> the manual _would_ have told you
<13> it would of said in 3.23.58 that we do not support sha1
<13> anyways, thanks
<9> narf
<11> huh?
<9> zort?
<9> you ever watch pinky and the brain?
Return to
#mysql
or
Go to some related
logs:
#linux
tske 5
#java
Ashe Powah
meaning of pipz
#linux
#windows
alkkatraz
JDK EM64 DOwnload
videolan alsa capture audio
|
|