Hi, I have to try out a master-master replication for a database of four tables. Both the master can write at once, but they would not be updating the same rows of a table and the insertions will also be collision free. The replication should be asynchronous Is this behaviour possible to implement? If so, do I have to write my own code ...
How do you do so that when you search for "alien vs predator" you also get results with the string "alienS vs predator" with the "S" example http://www.torrentz.com/search?q=alien+vs+predator how have they implemented this? is this advanced search engine stuff? ...
Hi. I'd like to write the following as a MySQL SELECT statement to cut down on the number of queries required to get the information, but I'm not sure how to write it. I have two tables - tags and books_tags (a many-to-many relationship junction table). The final output I want would print as follows: <label for="formFiltertag1"><input ...
I have a database that I had imported and accidentally created some tables as using latin1 by default. I've altered the tables and the database, but the columns are still latin1. I don't really have any reason to use latin1, so is there any way to just change all columns to use utf8? This is a development database, so it doesn't neces...
Hi, I'm looking for a way of making simple event log for my tables. I have few tables that can be changed by various users, and I want to keep track on: - who made the change - when - what was before update - what is the new value - which table and which record & column somthing like will be great: 20:00:00 | john | update | produc...
I want to do this query: SELECT * FROM mail WHERE tag_draft = 0 AND (target_id = 2 OR source_id = 2) GROUP BY created DESC` ...but it returns no rows. Now, if I do this query: SELECT * FROM mail WHERE tag_draft = 0 AND target_id = 2 GROUP BY created DESC ...then it works fine - every row with a ...
I have a personnel database of 10,000 individuals. I am developing a PHP CMS to manage and search these individuals. One of the complaints about the old system was that you had to search for names by their exact spelling, else no results would return. The old system was using MySQL LIKE statements, which are too exact (and I do not wa...
Hello, Let's suppose that we have multi-site CMS and every website in this CMS having 2 options: preview_width and preview_height. We know that every option should have default value if isn't defined by user. Also we know that list of options will be extented in near future. What is the best practice to store such options in MySQL table...
I'm using MySQL, but I think this is a basic SQL question. I don't know how else to ask but to give an example. Say I have this data in my table: id date_time foreign_key key value 1 2010-01-01 00:00:00 1 'temperature' 84 2 2010-01-01 00:00:01 1 'humidity' 34 3 ...
Ok at this point, I am pretty confused on how to construct my pagination system in an efficient manner. The problem is that the system is not typical and does not go in regular intervals such as 10 per page. The problem is, messages can have replies and thus share the same reply_chunk_id (reply_id). I do not want messages to get cut off ...
Do you know a good payment gateway with "purchase credits" to integrate in a php+mysql website? If is not clear i mean those system where you can buy 50 credits (ala Facebook) and you can spend them playing games or accessing any website restricted content? is that something that has to be done on my side or the company who sells the ga...
Navicat does not show primary keys which are also foreign key on table report as foreign keys. Why? I gave the image explaining the situation: ...
I have a .sql database with which i interact using Django . The database in the beginning is filled with public data that can be accessed from anynone. Multiple individual users can add rows into a table(private data). How can a user see only the changes he made in the database(private data)? ...
I want to run queries on my MySQL server through a C++ program that will be released to the public for free, but not under the GPL or any other open-source license. My first question is if I can use the MySQL Connector/C++ library in my application. If not, then what alternatives are there for me to use? ...
how to export table records as insert in mysql using mysql query browser? is there any other tool that can do it? ...
while($row = mysql_fetch_array($result)){ echo $row['id'];} If I use the above code two times consecutively, the row does not get printed twice. How to reset it? ...
Dear all, I'd like to find the car_id's of the cars that have 'FORD' AND 'SILVER' AND the user input value of '200' in the value column: table_cars +----+--------+----------+-----------+ | id | car_id | name | value | +----+--------+----------+-----------+ | 1 | 1 | MAKE | FORD | | 2 | 1 ...
How can I add a salt to my current hash password when a user registers. And how should I store to my password in My MySQL database? Here is my PHP code so far. if ($_POST['password1'] == $_POST['password2']) { $sha512 = hash('sha512', $_POST['password1']); $password = mysqli_real_escape_string($mysqli, $purifier->purify(strip_t...
Hi, I have these mysql dates in a table of my database, 2010-07-16 20:09:06 2010-08-16 20:19:43 2010-10-18 16:57:19 2009-09-18 16:57:42 2009-10-18 16:57:55 2009-12-24 14:59:21 How can I sort them into the result below so that I can have the end user browses monthly results? <h2>2010</h2> <ul> <li><a href="#">October</a></li> <li>...
I have a mysql table with these columns: id, text, keywords. ID is an id. Text is a title. Keywords is a list of tags in this format: tag1 tag2 tag3. How would I go about getting a list of the most used keywords in the column? Eg. if I wanted to build a tag cloud from all the items in the table. ...