I currently have "err-log=/var/log/mysqld.log" under the "[safe_mysqld]" section. I was under the impression that it should be under the "[mysqld]". Am I right about that? Should I move it there to turn it on? Why is it under the [safe_mysqld] section? Also, I noticed that the log file didn't exist at all for me, so I created it with my...
I'm getting results that are hard to understand. I hope that someone will be able to shade some light on the subject. I have a very simple table in mysql: id| text 1 | testA testB testC 2 | testA testB When I run the following query: SELECT id, MATCH (text) AGAINST ('+(+testA testB) +testC' IN BOOLEAN MODE) as score FROM test_full...
Hello, my SAS scripts worked fine when I was in XP, but now that I've upgraded to Windows 7, my access to MySQL has been impaired. I am sure that MySQL is running. If I open a browser then I can send commands.... The issue is with the SAS software itself. Has anyone else had this issue? Know how to fix it? ...
Check the question This SELECT query takes 180 seconds to finish (check the comments on the question itself). The IN get to be compared against only one value, but still the time difference is enormous. Why is it like that? ...
Hey friends I am just a beginner in MySQL, I need to know how much data can be stored in MySQL. I am developing a web crawler, can I store all the data in MySQL, or do I need to use another Database? Which is more faster? What I mean is, which has the highest Writing/Reading Rate? Do I need to reconfigure to add more data? ...
Hi, I'm stuck at the seemingly simple task of connecting remotely to MySQL. I inherited the server, so don't know how it was installed. Took a look at /etc/my.cnf (the only my.cnf on the system as far as I can tell) and found [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password f...
For example: <? function getTitle(){ $query="SELECT title FROM news WHERE author = 'admin' LIMIT 5"; $result = mysql_query($query, $mysql_connection); $data = mysql_fetch_array($result,MYSQL_ASSOC); return $data['title']; } ?> And every time I want to submit a MySql query I must always include config.php inside the fu...
First off, here's my SQL query: SELECT research_cost, tech_name, (SELECT research_cost FROM technologies WHERE research_cost <= USERS_RESEARCH_POINTS_VALUE ORDER BY research_cost DESC LIMIT 1) as research_prev, (SELECT cost FROM technology_costs WHERE id = 18 LIMIT 1) as te...
I have a table called problemTBL, which contains the fields below problem_id Autoincrement,Pk passenger_id, accept duplicate values problem_name, problem description These are sample records: Problem_id passenger_id problem_name 1 22 NO Air condition 2 22 Dirty Seats 3 24 ...
Quick newbie MySQL question. What would be the simplest way to ensure that the minimum value of a given field is 0? Basically, we have a script that runs automatically and subtracts an integer value from the value of a field every 15 minutes--but we want any entry that gets to 0 to stay at 0 and not go negative. This could be simply d...
Hey friends can i use a distributed DB for my WebCrawler,what all are the available Open Source Distributed Databases?? can i use MySQL as my distributed DB? how amount of data can be stored? ...
I have a table with 20 rows and one row have for example: 2,3,5,6,8,22 2,3,5,6,8,22,44,55 etc. How can I select from mysql table rows only unique numbers, not duplicated so results are: 2,3,5,6,8,22,44,55 The table definition: CREATE TABLE IF NOT EXISTS `test` ( `id` int(11) NOT NULL auto_increment, `active` tinyint(1) NOT N...
Hello, What's the correct way to implement the below concept via MySQL and PHP? Say a website has two groups/communities, both of which allow its users to ask Questions, answer Questions, and start Discussions, pertaining to the respective community. A user will choose which community he/she wishes to enter via below code(main.php): <h...
We're currently running MySQL 5.0.36sp1, and I'd like to evaluate whether we would get any kind of performance gain in running a more recent version. Can I safely install a newer version and run it on a different port without affecting my existing instance? Ideally, I'd be able to turn on one instance at a time, and run the same tests o...
Hi, I am having below tables. create table test(int id,int data1); create table test1(int id,int data2); insert into test values(1,1,); insert into test1 values(2,2); insert into test1 values(3,3); insert into test1 values(1,1); Now I want the rows of test, that don't participate in join. i.e I want rows (2,2) and (3,3). I want to ...
Hi there. I've moved database from one host to another. I've used PMA to export and bigdump to import. The whole database have latin2 charset set everywhere where it's possible. However in database, special chars (polish ąęłó, etc.) are broken. When I used SELECT i see "bushes" - "Ä�" insetad of "ą". Then I've set document encoding to ...
I have data that spans multiple months and I want to be able to take the average per day and separate it to the appropriate months. For example, say that one data point is 2/9/2010 - 3/8/2010 and the amount is 1500. Then, the query should return 1071.4 for February 2010 and 428.6 for March. I am hoping there is a MySQL statement that ...
Hi, I use CodeIgniter as my web application framework. I used a simple Try/Catch and I sent a sample value to test it, and it failed! I know I can use $this->db->escape() function to solve my data problem but I just want to know: Why TRY/CATCH can not catch this error! Controler code: $this->load->model('user_model'); $result...
So this is my code: function function() { $isbn = $_REQUEST["isbn"]; $price = $_REQUEST["price"]; $cond = $_REQUEST["cond"]; $con = mysql_connect("localhost","my_usernam", "password"); if (!$con) die('Could not connect:' . mysql_error()); mysql_select_db("my_database",$con); $sql="INSERT INTO 'Books' (isbn, price, condition) VALUES ('...
Hi Guys, i've two tables Table A: a_id,timemarker (datetime) Table B: b_id,start (datetime), stop(datetime), cat(varchar) table A 149|2010-07-19 07:43:45 150|2010-07-19 08:01:34 151|2010-07-19 07:49:12 table B 565447|2010-07-19 07:30:00|2010-07-19 08:00:00 565448|2010-07-19 08:00:00|2010-07-19 08:20:00 i want select all rows f...