Can you replicate a MySQL 5.1 master to 5.0 slaves?
Is it possible to replicate from a MySQL 5.1 master to MySQL 5.0 slaves or are the binary logs not compatible? ...
Is it possible to replicate from a MySQL 5.1 master to MySQL 5.0 slaves or are the binary logs not compatible? ...
I read various post's prior to this. but none of them seemed to work for me. As the title suggests, I am trying to update one column from a column in another table. I don't recall having problems with this before.. 1. Table: user_settings.contact_id, I want to update with contacts.id where (user_settings.account_id == contacts_account...
I want do like this, but for another case that not function. This is my example table: Date Model No Line Range Lot Status 2010-08-01 KD-G435 1 01 1-100 013A accept 2010-08-01 KD-G435 2 01 1-100 013A accept 2010-08-01 KW-TC800 ...
Possible Duplicates: Storing Images in DB - Yea or Nay? Saving images in database mysql I have a site where user can upload profile picture and photo albums. Now i'm starting to wonder was I suppose to save pictures into a database or is file operation still ok as it gets bigger? I'm thinking in a huge scale like social netw...
I'm trying to figure out how I should be reindexing Sphinx. I'm using v 0.9.9, so I don't have the ability to do real-time updates of the index. I think I read somewhere that this can be done using a cron job, and that the index does not need to be entirely rebuilt (so no stopping the daemon). That said, I've never written nor run any c...
What is InnoDB and MyISAM in MySQL ? ...
I made a mysql database for my project. I need to know if what I did is correct or not. I made a master table to store all my movie details and I built some other tables to store the views and ratings. Am I doing wrong by using different tables to store views and ratings, although I can use the master table to store views and rating in ...
hi again every one i would like to ask something about query using mysql i have this table called video_stat, and here's the field CREATE TABLE IF NOT EXISTS `video_stat` ( `id` int(11) NOT NULL AUTO_INCREMENT, `video_id` int(10) NOT NULL, `member_id` int(10) NOT NULL, `counter` int(11) NOT NULL, `daydate` varchar(15) NOT NU...
I already know how to, for instance, get tomorrow's date in a query in SQL; either use ADDDATE(CURDATE(),1) or DATE_ADD(CURDATE(), INTERVAL 1 DAYS) (or something like that). But how would I get a date that is a bit more eccentric, for example the 10th of next month? ...
How can I check if email = '$e' or username = '$e' inside my MySQL query. Here is my MySQL query so far. "SELECT user_id FROM users WHERE (email = '$e' AND pass=SHA1('$p'))" ...
I have created a sign-up and login for my website and all validation works fine for both sign-up and login. After user provides valid credentials he/she is logged into the member area with a welcome message that says Hello first_name last_name.. basically first name and last name is grabbed from database. Any what I want to do is restri...
select TO_CHAR(TRUNC(SYSDATE),'DD MONTH,YYYY'),a.appl_no,a.assigned_to,c.trading_name co_name, ' ' co_name2, d.bank_acct_no credit_acct_no, d.bank_no credit_bank_no, d.bank_branch_no credit_branch_no,a.service_id from newappl a, newappl_hq b, newappl_ret c, newappl_ret_bank d where a.appl_no = c.appl_no and c.ret_id= d.ret_id and a....
I can't find an optimal way to use transactions in a MySql Stored Procedure. I want to rollback if anything fails: BEGIN SET autocommit=0; START TRANSACTION; DELETE FROM customers; INSERT INTO customers VALUES(100); INSERT INTO customers VALUES('wrong type'); COMMIT; END 1) Is autocommit=0 required? 2) If t...
I am working on an application that needs to be able to grab questions from a MySQL database and display them to the user. The user should then be able to answer and submit. At the end of the quiz it should display the user's score. How would this be done? ...
Let me explain what I mean in my title. Let's say, that for example I'm creating a small e-commerce system for one web shop/catalog. There's a possibility for customers to choose, do they wish to receive newsletters or not. If they do, then logically thinking the newsletters should be send immediately as the newsletter is formed and read...
Hi i'm trying to process the mysql_fetch_array query below and simplify the code so only 1 query is ran for both sets, is that possible <select name=[set1]> <?php $set1 = mysql_fetch_array(mysql_query("SELECT `Locale` FROM `language` WHERE `Setting` = '1' ORDER BY FormatSet")); while($row = $set1){ echo "<option value=\"$set1\"...
I'm trying to develop a web based digital asset management application. I'm planning to do it in Codeigniter with mysql as db. This is for a popular regional newspaper. They will have 1000 of entries and TB's of data as daily tons of information will be entered. There will be different content types like Media, Personality, Event, Issu...
I have 2 table first table. employee( empid- primary key ,empname) eg: employee table 1 john 2 martyn 3 davis second table documents(empid,documentname) eg : 1 address.doc 1 worksheet.doc 1 salaryslip.doc 3 address.doc each employee have only one entry in employee table but in document table , zero or more entries...
I have a hosting account at godaddy ruinning Linux. Is has MySQL. I am creating a J2ME application that runs on android and I was wondering if there is any simpler way to connect from j2me application to my MySQL server? Is it required to install anything at my server? which I cannot do because of the shared account. Any way to just op...
hello i would like to add another value to an insert statement, but whatever i do it cause various errors on whatever way i try it. can someone show me the correct way to code this. many thanks my original working code is this: $sql = "INSERT INTO `act` (`department`) VALUES ('". implode("'),('", $dept) . "')"; and i have tried amon...