#mysql
06 October 2007
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
01:16 <****> he is a big newb lol
01:16 <****> unless he doesn't trust y'all :)
01:16 <****> haha probably
01:22 <****> adapter a budding "be George" there
01:26 <****> Sense of humor mandatory <-- :-d
01:28 <****> I need ot a bit of advice about what would be the quickest way of updateing ever row in a table that may contain 4000+ rows
01:28 <****> should update every row one at a time, or empty it and then fill it again in one massive query?
01:29 <****> just update with no where will cover all rows
01:30 <****> but it would set the same value to every row, which is kind of useless
01:31 <****> well depends what you want to do
01:31 <****> dump an array with 4000 arrays in it in mysql
01:34 <****> n-rated : 4000 rows is nothing. Just do the update :)
01:35 <****> but whould dump and start again be faster?
01:35 <****> what does 'in' mean?
01:38 <****> where in (a set)
01:38 <****> set compares to a set of values
01:40 <****> !man in(
01:40 <****> Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/in(
01:40 <****> !man in
01:40 <****> see http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html
01:40 <****> wrong
01:42 <****> http://www.youtube.com/watch?v=Z4Y4keqTV6w
01:44 <****> what is that tapout?
01:44 <****> funniest vid ever
01:44 <****> all clean too
01:45 <****> old fella steals the show
01:45 <****> had me laughing for like 6 straight minutes, had to pass it on
01:50 <****> Anyone around?
01:50 <****> no
01:50 <****> how can i disable the memory-storage-engine? skip-memory in my.cnf doesn't work..
01:51 <****> When you guys have internal servers behind a firewall, and grant permissions, do you just do: GRANT ... TO replication; and that way you can throw in new servers, or do you create new replication@hostname accounts for each slave?
01:58 <****> Tapout, good video
01:59 <****> it is crazy how someone laughs if you laugh
02:00 <****> that guy had the best laugh ever
02:03 <****> hello: i have one application with two connections (different users) and two SELECT x from t FOR UPDATE - why is this working for the second user, shouldn't the application receive an error for the second lock attempt?
02:06 <****> ... or make the application wate infinitly - no UPDATE is done inbetween?
02:10 <****>dbdump.db
02:11 <****> now im trying to add it to a remote db like this: mysql -h hostname -p rmp < dbdump.db
02:12 <****> it sat there like it was working and returned with no errors but nothing has changed on the remote side
02:12 <****> I'm trying to get mysql to return all results where field 'fs' is distinct, except for when 'fs' = 0 - any ideas on how i'd do that?
02:13 <****> the results would be passed to a PHP script, and I guess I could do it from there if I needed
02:14 <****> Two queries and join them with UNION
02:14 <****> Or just do it twice in PHP :)
02:17 <****> seekwill: how would I do two queries and join them with UNION? (/me has never heard of UNION)
02:17 <****> oh nm looks like it worked after all
02:17 <****> !m chrisjs169 union
02:17 <****> chrisjs169 see http://dev.mysql.com/doc/refman/5.0/en/union.html
02:19 <****> seekwill: ok, thanks. now i need to figure out how to modify "SELECT DISTINCT fs FROM table" to show all fields, not just "fs"
02:19 <****> Ok :)
02:19 <****> *
02:19 <****> evil
02:19 <****> evil is clearly defined at http://www.parseerror.com/sql/select*isevil.html
02:19 <****> Especially in his case
02:19 * jbalint uses the doitanyway principle
02:20 * seekwill uses the doittherightway principle
03:06 <****> can you do comments in mysql?
03:09 <****> can have table comments
03:10 <****> hbx: -- and /*
03:10 <****> !man comments
03:10 <****> see http://dev.mysql.com/doc/refman/5.0/en/comments.html
03:12 <****> how exactly can I copy all columns from a row of tableA to tableB ?
03:13 <****> !man insert select
03:13 <****> see http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
03:13 <****> I'm on that page, just somewhat confused about the syntax. The example given only specifies the `fld_order_id` column, and I need to copy all of the row. Can I do this?
03:14 <****> as many or few cols as you wish
03:15 <****> ok but I have to specify columns? In the interest of future extensibility, I'd prefer "open minded" syntax
03:15 <****> ps: thank you
03:17 <****> what to do to make innodb the default - with my.conf or better with odbc.ini ?
03:42 <****> how do you select with a pause beforehand?
03:42 <****> select with delay or something?
03:50 <****> matthewobrien: why the deuce would you want to do that?!
03:53 <****> matthewobrien: you can always sleep in your application before issuing the select
03:55 <****> Hi. I'm trying to export a query to ".xls" file extension. I'm doing "SELECT * FROM input INTO OUTFILE 'requests.xls'". I can't find the file after system-wide search. When i try to re-run script I get "File requests.xls already exists". How can I be sure the file was made?
04:36 <****> I am having a problem and mysql will not start with debian.
04:38 <****> good story. What do the log files say?
04:40 <****> Oct 5 22:34:24 shell /etc/init.d/mysql[13805]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in Oct 5 22:34:24 shell /etc/init.d/mysql[13805]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
04:40 <****> Oct 5 22:34:24 shell /etc/init.d/mysql[13805]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' Oct 5 22:34:24 shell /etc/init.d/mysql[13805]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
04:40 <****> hello everyone, I want to talk seriously about programming
04:42 <****> anyone alive in here?
04:42 <****> phil: all that says is that mysql isn't running. what about the mysql logs?
04:43 <****> Nothing in the mysql.log
04:43 <****> phil: Have you attempted to start it, or are you relying on that debian's autostarting it ?
04:43 <****> ./etc/init,d.mysql start
04:43 <****> ./etc/init.d.mysql start
04:44 <****> Third time lucky?
04:44 <****> cover_yuri: You'll mostly get PHP folks in here, if you catch my drift ;)
04:45 <****> whatever. im gonna go take a shower before gehi gets here
04:45 <****> Bring forth my notepad!
04:45 <****> alright sensei
04:46 <****> Bedtime now tho
04:46 <****> Can anyone tell me the exact difference between the ENUM and the SET attributre in MySQL
04:47 <****> Where do DBs actually get stored for a Linux PC?
04:48 <****> depends... check the my.cnf file. A lot of times it is /var/lib/mysql/
04:50 <****> ToeBee: ah, there they are, thanks
04:53 <****> Where else can the my.cnf be if I deleted the /etc/mysql please?
04:54 <****> uh
04:54 <****> I deleted the /etc/mysql directory then de-installed mysql and re-installed it.
04:54 <****> Is it possible to USE (open) a database that is not in the database directory (/var/lib/mysql)?? Or do I have to copy the database to this directory?
04:55 <****> how did you install it? via package manager?
04:55 <****> aptitude purge --purge mysql-client mysql-server; aptitude install mysql-client mysql-server
Total 16 pages. You are browsing page 4/16.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last