| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> get all shaky and hyper
<0> limited myself to 3 coffee's a day now when not totally sleepless ;)
<1> lakez: thanks for the idea, but according to the manual: For InnoDB before version 5.0.3, TRUNCATE TABLE is mapped to DELETE, so there is no difference.
<2> drop and recreate
<1> archivist: yup... that's the plan for when rollback will finish ;)
<2> plenty of time to dream up some lame excuses then
<1> archivist: ;)
<1> archivist: I don't need to dream them up ... I have this excellent shell alias: alias why='/usr/games/fortune bofh-excuses -m'
<0> \o/
<3> !man LAST_INSERT_ID()
<4> (Information Functions) : http://dev.mysql.com/doc/mysql/en/Information_functions.html
<5> Morning. Couple question about libmysqlclient, and hangs with mysql_real_connect. Can any one help?
<6> how I would identify the next primary key in case of INSERT?
<6> predict ?
<7> If you create a new record with an autoincrement ID, and you need that ID for immediately making an entry in a junction table to link the record to another record, is the only way to get the value of the ID to do a select query?
<8> !man LAST_INSERT_ID()
<4> (Information Functions) : http://dev.mysql.com/doc/mysql/en/Information_functions.html
<8> that will reliably give you the last autoincrement id you generated
<6> LAST_INSERT_ID() i 1774 but because I delete some numbers and if I insert again I will have a jump to 1885 or 1884 or who knows ?
<6> should I compact somehow first ? I would like to do that
<6> i get up to now with $query = "select max(ID_ART) from art";
<6> I get the ***umed next record with $query = "select max(ID_ART) from art";
<6> but I've noticed that the new article will be an other number
<8> ace_me don't think of it as a serial list of numbers, think of it as a magic opaque label
<9> guys, in what cases can commit() cause a deadlock when working with myisam and innodb tables at the same time? (autocommit=0)
<10> how do i select rows from 3, to the end of the table
<10> Select * from blah LIMIT 3, ??
<11> hi, i have a nested set tree, but i would like to have some nodes, not all, ordered by name instead of by LFT value. Can this be done?
<8> profounded: just reverse your sorting order and do limit 3
<10> fsweetser, great idea, but what if you need it in that order? reverse the code that outputs it?
<10> that seems inefficient
<8> the alternative is to count the number of rows in the table, and base your limit on that
<8> I don't believe there's a way to just say the last three rows, though you could double check the manual for limit
<10> i havent found anything helpful
<10> thank you, i will use one of those options
<12> do the settings in [client] in my.cnf apply to any binding that uses the mysqllib?
<12> anyone know?
<13> do someone use php and adoDB to connect to mysql ?
<6> where do I wrong select max(substr(ADC_NBR,1,len(ADC_NBR)) as max from adc ? ADC_NBR has values like _1234 or _1133 or _16777 and so on
<6> I want to select max from the value only
<6> excepting _
<14> Your substring is pulling the whole string
<6> ?
<14> len(ADC_NBR) - 1 is how you pull the length that you want, and I'm suffering a brain fart as to whether substr's position is 0 or 1 based
<14> len gives you the full length of the string.
<6> I've ***umed that will work
<14> you want len -1
<6> ok
<14> take a look at the documentation for substring
<14> your order of arguments isn't quite right either.
<14> !man substr
<4> (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<15> im managing a box for a client that writes crappy code... is there a way to get mysql to ignore max_connect_errors alltogether?
<16> !man max connect
<4> Nothing found.
<16> !man my.cnf
<4> (Using Option Files) : http://dev.mysql.com/doc/mysql/en/Option_files.html
<16> spd1snd: read that
<17> I have been requested to ban everyone from channel.
<16> i have been requested to beat you
<16> rain: any plans for SA ?
<17> alphablue: SA?
<16> san antonio
<18> spd1snd: That isn't mysql errors, it's connection attempts that get interrupted.
<17> alphablue: No, I'm a Support Engineer now. I don't travel any longer. (well once every few months to CA)
<6> ADC_NBR is _12345 or _12346 or _12347 and I want the maximum value there ! Please advice select max(substring('ADC_NBR',1) as max from adc"
<16> so1d: http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html
<16> rain: ok so come down for a beer
<15> mendel: yep, and although the customer should be writing better code since localhost is getting blocked... im just wondering if there's a way to get mysql to ignore any errors it sees... i can always set the threshold high but i wonder if there's another way to do it
<16> spd1snd: http://dev.mysql.com/doc/refman/5.0/en/blocked-host.html
<18> spd1snd: No, it's not "seeing errors", it's seeing hosts get cut off halfway through the connection or something.
<19> hi
<19> i have a problem
<19> can i ask a question?
<16> mendel: you just did
<16> err nm
<16> thepirate: you just did
<20> lol
<18> spd1snd: I would try to find out what is connecting repeatedly to MySQL but not authenticating or something
<18> Yarr.
<18> spd1snd: Or just make it bigger.
<19> when i try to connect to it it doesnt work
<16> mendel: first he needs to fix the problem, then he can figure out why the problem is there
<18> That's a statement.
<19> can you help me?
<20> when you try to connect to your question ?
<16> lol
<16> breakfast bitches, peace
<6> select max(right(ADC_NBR,len(ADC_NBR)-1) as max from adc
<18> That's technically a question
<19> nah just messing with you :P
<2> spd1snd, stop him from using pconnect
<16> o yea, that to paul, forgot to tell you that
<6> ADC_NBR is like _1234
<7> I'm executing a long PHP CLI script, and I'd like to get some feedback on progress, but when I try to echo a message, it seems to save up all the messages until it finished (or rather, until memory runs out). How can I get real-time feedback?
<21> profounded: See the top user comment at http://dev.mysql.com/doc/refman/5.0/en/union.html
<22> hi y'all
<18> peqe: I'd try #php
<7> mendel: thanks
<22> I can select the tables from a mysql shell but in phpmyadmin I get tables not found
<7> I'm executing a long PHP CLI script to insert data into a MySQL database, and I'd like to get some feedback on progress, but when I try to echo a message, it seems to save up all the messages until it finished (or rather, until memory runs out). How can I get real-time feedback?
<7> whoops, sorry!
<18> Uhm erm
<18> Heh
<22> lol
<18> HASN'T CHANGED
<18> :D
<23> hi, in mysql cluster i can add ndbd nodes hot online?
<22> supposed to be able to I have read
<22> mendel? what you think is wrong w/phpmyadmin in my case?
<18> what where
<18> oh
<21> rado1: You sure it's pointing at the same database?
<19> i try to connect to my mysql 4.1 server using dreamweaver. my host is localhost, my document root is public_html. I get this error when i try to select a
<19> database: 1) there is no testing server running on the hostmachine" 2) the testing-server specified does not map to the http://82.157.27.106/
<19> _mmServerScripts/MMHTTPDB.php URL. Verifie that the URL-prefix map to the root of the site. any briljant ideas anyone?
<22> mysql shell is fine
<18> no clue, never touched phpmyadmin, but my guess is that it's a different user or database
<22> the left side shows the table count but then when you go to work em that no tables found
<22> well thx anyway, mendell
<18> Check your webserver error log, I guess, or wherever php logs errors
<22> kk thx
<19> i try to connect to my mysql 4.1 server using dreamweaver. my host is localhost, my document root is public_html. I get this error when i try to select a
<19> database: 1) there is no testing server running on the hostmachine" 2) the testing-server specified does not map to the http://82.157.27.106/
<19> _mmServerScripts/MMHTTPDB.php URL. Verifie that the URL-prefix map to the root of the site. any briljant ideas anyone?
<2> you have error messages that are plain enough to check out but check if the server is available on that ip
<19> i own the sever
<19> its available
<2> you may own it but have you granted access to it
<2> ?me pushes Therion on the stack
<19> i checked all that
<19> i have all the permissions
<2> wet dream say otherwise
<19> ???
<24> hello will!
<25> woo I'm on the stack, I'm on the stack
<24> wha?
<26> Therion: what service does the bot use for weather info?
<25> it goes to weather.noaa.gov and downloads stuff from there
<25> parses output
<25> presents
<26> ah
<26> !weather kbtl
<4> Current conditions at Battle Creek, Kellogg Airport, MI, United States: It is 15 C (59 F), windspeed is 33.80 km/h, and visibility is 16.09 km. (Information current as of 2006.03.31 1453 UTC).
<27> lo
<27> Is there any significant diffrences between mysql 4 and 5 that could cause table creation to fail under 5 where it works under 4? This is a compiled coded program, so have no access to the actual statements that create the tables.
<26> I'd think reserved words would be the biggest reason
<28> commas, too
<25> sjrussel: No comma-related problems in CREATE TABLE that I can recall. ;)
Return to
#mysql
or
Go to some related
logs:
#osdev
slackware sata_piix
gam_server xubuntu
wine xgl segmentation fault
#lgp
#freedesktop
#oe
#css
my google interview
4 dimensional hash perl
|
|