MySQL Database Forum

I have been using Ms Access database for a long time and I have migrated my data to a MySql database. My data needs to be distributed to various locations and data entry can take place on slave sites or on the master. Is there a way a slave can upload data to a master without using mysql Cluster? Garudzo

hi I am having an issue inserting data into a mysql table. I am getting the following error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '', 2011-11-28 , 2011-11-28 , 2011-11-28 , 'foster.sharon@oig.dol' at line 75 here is the code that is trying...

how to perform case insensitive comparision in mysql?

im making my own php driven website, with next to no previous knowledge. everything im learning is coming from tutorials so i keep hitting brick walls. my latest problem is i want to link two rows in my database (i think im explaining it correctly) basically i have 5 rows so far admin - used to store admin information for back end...

im in doubt about sql because i have choosen c#.net as front end to learn so which backend would be suitable for c#.net ? whether SQL or MYSQL?can anyone clarify my doubt plsss

There are two table from which i want to get value 1. heads 2.subheads The field name in heads table is: id, head_name.

What if I have a large data set and want to insert more than 1 row at time? Is there a way to do it with the INSERT query? or do I have to use another QUERY?

hi all, i have two questions, 1) I have a huge data set, I need to separate them into three different time frame (equally). What is the fastest way to do so. 2) After performing a select statement ( a query from the original database) how can i save the output into a different database with a different name so that i could use the...

Hi Experts, I have written a mysql statement as below: mysqldump –h localhost –u root –password=password –t --tz-utc=false database table2, table3, table4 –w"WhenCreated > LastSynchedDateTime” > filelocation/filename

I have two DB like loanrequest table and student table. plz give me a solution of the above query using group by...urgent please

I am having the dataset which consists of some of the duplicate entries.I have to dump the dataset entries directly to the database tables but i want only unique entries.so i am using DataAdapter.Update() function for this but i am getting all the entries along with duplicates.So how can i get the unique entries.

Hi, currently im using MYSQL workbench to extract some features needed for my project. However im having a problem with this query, select newtime from new_event IF newtime < 80101 than set newtime = 0 elseif newtime > 80000 and newtime < 160101 than set newtime = 1 elseif newtime >160000 than set newtime =...

Hi, I have a table set up using PHPMyAdmin. When I query the table for data I know is there, I get an empty result. I can browse the table in PHPMyAdmin, copy and paste data from the table into the search tab and still get an empty result set. Madness seems close by ... Any assistance gratfully received. Simon

I would like to write a query to identify when an EFT/Direct Deposit transactions bank account details (BSB, AC) change when the identifier (iD) remains the same, ie iD DatePaid AmountPaid BSB AC 1 1/1/2010 $5000 012 4444444 1 2/1/2010 $25000 012 4566657 I would also like to identify when different iDs have the same...

Hi, I have a scenario in which i am stuck with in my custom shopping cart. I have tables of category and product.Each product is against some category. for example Category Table Fields are catid, parentid, catname Data

i have two tables in mysql with address fields i want to compare the first two words of the address fields in both tables. is there a function similar to SPLIT. i.e. Add1= 1023 elm street Add2= 1023 elm St i need a function that would return TRUE upon comparing the first two words. because comparing the whole fields will return False.

Hi Everyone, This one is driving me crazy. I have three tables: purchase_order, purchase_order_bom, and rog_bom. The table purchase_order_bom is a list of parts ordered for the purchase order. The table rog_bom is a list of parts received for the purchase order (ROG stands for receipt of goods). I want to run a query that looks...

i tried using longblob but an error occured and it says: Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1648711 bytes) in D:\wamp\phpmyadmin\tbl_replace.php on line 275 i think the file is too big how can i fix it? someone help me? :(

in my code all field are copied from tipuranibasti to puaranibasti except image(blob one).in table puranibasti it($image field) shows entry as <?php include ("connect.php"); $id=@addslashes($_GET); $image=@mysql_query("select * from tipuranibasti where id = $id"); $image_row=@mysql_fetch_assoc($image); $name=@$image_row;

I just installed Mysql for php and Apache on Windows, Where are the mysql db stored when i create them.

Hello everyone, i have created one database as student now i want to keep the database backup in my E:// drive for project deployment. I m not getting that where my database is storing. Plz tell me what should i do for he backup manually not mysql command line. I have used Java as front end for application.

Hi I am running an update to a database and I keep getting this error: Could not Insert to CB_MAIN (update)Got a packet bigger than 'max_allowed_packet' bytes And it is from this code: $result_upd = mysql_query($sql_upd) or write_error("Could not Insert to CB_MAIN (update)".mysql_error()." \r\n");

Hi, I have table 'patientdata' consisting of patient data in three columns fname, lname and loc. I want to have a query that shows which of these patients were diagnosed in more than one location. Here is sample table: fname lname loc tom hanks mi

how to convert a string say 'k30' into an integer. I just need 30 as an integer. I've done substr('k30',2,3) but that returns a string and I want it in number format. Please help.

Hi Guys, I'm kinda new to mysql and have a question. Say you have a scenario were you have information that needs to be stored, but in groups. So I might be running a business that requires me to keep track of hair appointments. Each appointment is a job. Every job could have multiple services. every service could have multiple...