MySQL Database Forum

hi, I have an issue that suppose there are two tables say A and B where A table have two column id and title B Table have two column say e_id and metatag so now we want to get all the data from A whose title contain a word say 'paris hilton' or metatag have 'paris hilton' need all those event.

hello, i have this structure mysql> select id,refer,ip,date from logs; +-----+-------------------------------------------+----------------+---------------------+ | id | refer | ip | date | +-----+-------------------------------------------+----------------+---------------------+...

Hello folks, I've got one that seems a little tricky to me. What I want to do is to calculate my cumulative BTU measurements. I'm already storing various information in the database where I can calculate the BTU/Hr production. The formula to calculate Cumulative BTUs is as follows (per minute): (BTU1+BTU2) / 2 * .0167 I calculate the...

When I restore a backup (.sql) file to the same machine where I made the backup, or on any other mySQL server machine, all comments in stored procedures and functions are stripped out. When I open the backup file in a text editor, I can see the comments are there. Restore the db, same schema, another schema, doesn't matter- the comments are...

Change MySQL password for other user : C:\xampp\mysql\bin>mysqladmin -u paru -psan password 'paru'; mysqladmin:connect to server at 'localhost' failed error:'Access denied for user 'paru'@localhost' (using password : YES)' why am i facing this error ? can anyone help me out . In Mysql am always facing Access denied nu

I reciave this messege when i type in my domain name the domain name of my site is <<snipped>> but i am using <<snipped>> to test if everything if is in correct order before i point <<snipped>> to my files at<<snipped>> This is the Database.php that i am editing i need help to make it work sins i dont know anything about this . ...

hii i need to drop a foreign key for a table and create a new foreign key how do i do it ..i tried SHOW TABLE STATUS FROM ratingd LIKE 'fourwheeler_rating';...

hi, i was wondering which type of join should i use to get an empty result set when there is no record in one of the tables i.e : i have two tables : Element and Attribute the table Element has elements in it... Element id | name ---|--------------- 0 | element0

i want to make a column in mysql table which display sum of three columns.is it possible?how? eg a table with column price1 price2 price3 totalprice after inserting 3 prices total price column will get automatically filled

How do I write 2 distinct select queries in one sql statement, and then also divide the results of one by the other? The first query will give me a subset of all the records in the table...the second query will give me a second (larger subset)...and then I want to use those two results to come up with a percentage. Any thoughts?

Hello all. I'm trying to perform a query on my database where I want to grab the most recent information for a specific ID. My current query is as follows: SELECT ewise_slice_msmnt.slice_msmnt_id, ewise_slice_msmnt.msmnt_value, MAX(ewise_slice_msmnt.slice_id) FROM `ewise_slice_msmnt`, ewise_device WHERE msmnt_type_id = '1' and...

Hi, new here Wonder if anyone can help I am learning sql and have searched for the answer for over a day, with no luck. I found this site and it seems you all help each other. I have a database called "listing_photo" In that there is row "photo_listing" (unique property number) & row "photo_caption" (holds the caption for the photo)

I have .myd,.myi and .frm file and i want to create database from these files so please point me to do this

I am trying to convert an Omnis DF1 Data file to anything else (Access ,SQL Ect)

I am currently developing an asp.net website for a college HE Open Day, and i'm just trying to finalize the database design including normalisation. The brief is as follows: **** College is looking to streamline the registration process for the Higher Education (HE) Open Day they hold twice a year. The College advertise ‘taster’ sessions in...

This was taken from a working model. Inside the heredoc (<<<) an asterisk appears at the end of each MySQL statement after the semicolon (lines 4 and 10). The actual script contains several statements and it appears after each one, so it's unlikely it was unintentional. Does anyone know its function or purpose? <?php $sql_file=<<<SQL_FILE...

Hi, I’ve got a table, where I need to sort IDs in a way, that the previous ID is referenced by the next row’s 'Prev_ID' field. (It’d also be possible to use Follow_ID instead of Prev_ID accordingly, if that’s easier) table: ID | Prev_ID ––––+––––––––– 1 | NULL 2 | 10 3 | 17

I've always stored year (like of a vehicles make or a home's built year) as an int. What datatype do you use to store a 4 or 2 digit year? I like int for comparison reasons. Let me know your thoughts. Easy question right? :)

I have Connected to a MySQL Database using a neatbeans editor. Now, I want to use that same database I created earlier on another pc. Can anyone help and tell me how that is done, please? Thank you.

select ABS(ROUND((projectspecs.laborCost+projectspecs.contingencyCost + SUM(materialcost_details.qty*materialcost_details.unitCost))* (billing.accom/100) - (projectspecs.laborCost+projectspecs.contingencyCost + SUM(materialcost_details.qty*materialcost_details.unitCost))* (billing.accom/100) * project.downpayment/100,2)) as billCost from...

I am trying to develope a website for my local churh. I have an Acess database that I want to include but someone told me that access is not good for web based applications. Please advice me on how to convert my database to mysql.

Hii guys, I have a list of products in a table and there is a column called rating which is a value between 1-10 . i need to select top 5 rated products . is there any ways to do this in a single sql statement or any other method to do it .

i have 2 table like these : table 1 : id msg_id status 1 1 pending 2 1 ok 3 2 pending 4 2 sending

Hi all, I'm fairly new to PHP & MySQL. I have a PHP search that I built on my site, but now I'm realizing I need to use full text searching because I have so many tables and entries that will need to be searched from. I have multiple tables joined into my search. At the moment this is what I have to return results: WHERE...

Hello everyone. I have a really strange issue here that I thought maybe someone could give me some insight on. I have a set of stored procedures that to my knowledge worked just fine before. To my knowledge, nothing has changed. Just yesterday I decided to test a source of data that is in the same existing format but shorter. MySQL came back with...