how to select the record with one sql statement?
helle, I have a table, like this: pigId dayweigt pig1 2018-1-121 pig2 2018-1-131 pig3 2018-1-141 pig1 2018-1-222 pig2 2018-1-231 pig3 2018-1-240 pig1 2018-1-323 pig2 2018-1-330 pig3 2018-1-341 . only the pig1'weight increase continuously for 3 days. Giving the input: num_of_day(weight increasing continuously for num_of_day); expecting the output: certain_day, pigId;from certain_day, pigId'weight increasing continuously for num_of_day. How to select the records in one sql statement? thanks
errors
Hi, I downloaded mysql and i try to install it now (on slackware) It's unpacked, i did everything as root. But ./configure ends with mysql ended and ./bin/mysqld ends also because it can't write to a file (or more). Now i understand when programs need to write to files etc that permissions must be set, but how do i have to set them ? What user etc... This is the output in the error file when i run ./configure 021108 10:47:42 mysqld started Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add to the [mysqld] section, for example, innodb_data_file_path = ibdata1:10M:autoextend But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 athttp://www.innodb.com/ibman.html 021108 10:47:42 /usr/local/mysql-max-3.23.53a-pc-linux-gnu-i686/bin/mysqld: Can't create/write to file '/usr/local/mysql-max-3.23.53a-pc-linux-gnu-i686/data/slacke.pid' (Errcode: 13) 021108 10:47:42 /usr/local/mysql-max-3.23.53a-pc-linux-gnu-i686/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021108 10:47:42 /usr/local/mysql-max-3.23.53a-pc-linux-gnu-i686/bin/mysqld: Error on delete of '/usr/local/mysql-max-3.23.53a-pc-linux-gnu-i686/data/slacke.pid' (Errcode: 13) 021108 10:47:42 mysqld ended Thnx philippe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Client on windows SLOOOOOOOOOOOOOOOOOW
Hi all, I am a beginning user of mysql I installed the server, no problems there. Did some tests and it really looks nice to learn, I am a very beginning user so i tested a query on the server Select user,host,password from user; This works fine and fast but i installed the GUI on an winXP computer, added a user with all priveleges and when i ask the sam query, i takes about 20-30 seconds before i get the results. Server and client are connected via a switch, so i really don't know what the problem could be. Any ideas ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BINARY and JDBC
Hi, I ported to MySQL a database that has BINARY(n) columns. MySQL silently changed them to VARCHAR(n) BINARY. And now the ResultSetMetaData.getColumnType() returns type 12=VARCHAR. Can I in some way access the attribute BINARY?! Valentin --- Valentin Todorov Ericsson Austria AG Pottendorferstrasse 25-27 A-1121 Vienna email: mailto:[EMAIL PROTECTED] Telefon: +43 1 811 00 5569 Telefax: +43 1 81100 11 5569 --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php