#mysql
04 October 2007
Total 23 pages. You are browsing page 23/23.
First :: Prev :: [...] [19] [20] [21] [22] [23] :: Next :: Last
23:14 <****> what exactly is have_cvs ?
23:15 <****> the manual says YES if mysqld supports CSV tables, NO if not., but what is that..?
23:23 <****> !man csv engine
23:23 <****> Sorry - I have no idea what function you're talking about! but try http://dev.mysql.com/csv engine
23:23 <****> How do I select every 2nd 3rd or nth row from a table?
23:23 <****> i have a DB in v3 that has a ton of foreign characters.. I need to move it to a v5 server.. if i do a mysqldump it seems to break the character encoding on the v5.. is there any trick to doing it?
23:23 <****> !man csv storage engine
23:23 <****> see http://dev.mysql.com/doc/refman/5.0/en/csv-storage-engine.html
23:23 <****> majmun: ---^
23:23 <****> adam300, tables don't have a natural order. what do you mean by "every nth?"
23:24 <****> thank you
23:24 <****> if I order the table but a key and then get every 10th value
23:24 <****> or nth value
23:24 <****> order on a key I mean
23:24 <****> is that engine marked as obsolete..?
23:25 <****> DELETE FROM your_tab WHERE id % n = 0;
23:25 <****> majmun: Read the link?
23:25 <****> i just did
23:25 <****> majmun: Why do you think it is marked as obsolete?
23:26 <****> because i wonder that cvs is really used as a storage engine...i can't imagine that one can store a high amount of data efficiently in such an engine
23:30 <****> majmun: Maybe for your uses.
23:33 <****> How do I select every 2nd 3rd or nth row from a table?
23:34 <****> WHERE ... AND ((@a:=@a+1) mod 3) = 0
23:35 <****> something like that could work
23:35 <****> i will give it a shot
23:35 <****> thank you
23:39 <****> It would seem easier to just do it in your application...
23:42 <****> hello, i have a problem with mysql - it consumes 80% of the cpu although there are no queries
23:43 <****> stef_: show processlist();
23:43 <****> errr
23:43 <****> i looked at the processes using phpmyadmin, there are no queries except show processlist
23:44 <****> if i strace the process, i see this:
23:44 <****> setsockopt(73, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
23:46 <****> What process is using 80%?
23:46 <****> mysqld?
23:47 <****> Reboot!
23:47 <****> i tried :)) doesnt fix it
23:51 <****> hi
23:52 <****> what is the difference between name like 'pepe' and name='pepe' please?
23:53 <****> wfq: check http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html
23:53 <****> if u use like, you look for pepe inside the string. you have to do it like this: name like '%pepe%'
23:53 <****> "Per the SQL standard, LIKE performs matching on a per-character basis, thus it can produce results different from the = comparison operator:"
23:54 <****> if you use =, it checks if pepe = the string
23:54 <****> What is the simplest way to copy rows from one table to another of identical structure?
23:54 <****> I have a mysqldump --no-create-info, but I'd like the other table to be in the same database (not have to have the same table name)
23:54 <****> prolific, insert into t1 select * from t2;
23:54 <****> I did mysql_dump -A, and now I need to restore one of my databases. Not all, so, using head and tail commands I put the sql of the database in different script. The problem is that the file have special charts, like tildes (tíldes). And when I restore its seen like à and ejército..
23:55 <****> prolific: insert into table2 select * from table1;
23:55 <****> Well shucks. Thanks guys
23:55 <****> damn, should have used abbreviations :)
23:57 <****> for the past week my MySQLd has been hanging on a query. How might I track down what the query is?
23:57 <****> are you logging slow queries?
23:59 <****> pbro, I can not see the difference yet.
23:59 <****> can one turn a LEFT JOIN into a DELETE? The multi-table delete syntax doesn't appear to support this
23:59 <****> wfq: usually there wouldn't be any difference
--- Log closed Fri Oct 05 00:00:08 2007
Total 23 pages. You are browsing page 23/23.
First :: Prev :: [...] [19] [20] [21] [22] [23] :: Next :: Last