MySQL Database Forum

I have managed to do this report query. The good news is that it works but the returned query ignores all the other books which do not have sales or gift records for the previous months(10). What I need is for it to show records for all books in the table irrespective of previous month sales or gifted.Any help will be much appreciated SELECT...

Dear sir/madam, I have the following query wich works but now idd like to get the a.title and a.label from a different tabel known as ".$_SESSION." How do i fit this extra query into this one? Do i add an outer join or do i make a union? It eventually fills in a function for a menu. Does anybody have a luminous idea, idd rrrrealy apreciated...

I am getting the following message: Index and length must refer to a location within the string. Parameter name: length It says the error is in Line 68 Line 66: <td align="center" valign="top"> Line 67: <asp:HyperLink runat="server" CssClass="animallink" ID="lnkAnimal" NavigateUrl='<%# "animal_detail.aspx?ID=" &...

I am creating a query that has multiples unions and a GROUP BY. If I remove the GROUP BY, it works, just doesn't provide the results I'm looking for. Can someone provide assistance to help me get this working with the GROUP BY? (SELECT "Software" as saletype, DATE_FORMAT(quotes.original_po_date,"%Y-%m") as m, sum(quotes_cstm.softwaretotal_c)...

How to store table of data into mysql at single query ? please reply me

Hello, I have a mysql database called sensor_data. Every 30 minutes a script inserts the power usage to this database and also the cost depending on the day/night tariff Rec Date Time Reading Usage Cost Tar 2771 2010-12-20 16:00:00 RFXPower 67044.6 0.5 0.09 0.18 What I am looking for is a mysql query that will...

Hi everyone, If anyone could help me with this problem I'd appreciate it greatly. Basically I have a simple table on my database. It is linked with a php form that I created on my site. The php form allows a person to input information on it (firstname, lastname, email) and then it gets stored in the database table. Now on my other server it...

how to take backup of database using java by query itself? please help

I have the following query in PHP and the results are displayed in a table. How can I sort? For example ORDER BY price? # Do the main database query to list the contents $query = "SELECT a.*, c.name AS category, ee.ezcity AS proploc, dd.name AS statename, bb.name AS countryname FROM #__ezrealty as a" . "\n LEFT JOIN...

I have total 3 databases.One is mysql and other 2 are of access type. I have 10 tables in each of the databases. I want to sync 2 tables from both access databases with mysql tables. whatever updates are happening in access databases tables it should come in mysql tables 1. student- table name 2. school - table name both are in...

I have a query.When i try to create a index on one of the table the index gets created but when i take the output it stuill shows "TABLE ACCESS FULL" Please see below what i did QUERY ====== SELECT b.DPT_EVNT_ID, b.DPT_ENTITY_ID, a.EDD_DT, b.DPT_DPT_ID, b.OU_ID,

Hi All, We are developing a test frame work in Microsoft Visual Studio 2008 with C++ language. In that we are trying to save the information in MySql Database Server. We are useing libmysql.lib file and APIs provided by mysql.h. It is working properly in XP.

i have a script which executes several queries for n number of records.How can is set the time in that to know how much time each query took to run

I have 2 links named city nd name. i want to work them as i click on name it gives gridview values order by name and if i click on city it gives gridview values order by city...what to do? plz help

I have three tables that all have "loan" in common. Property Investorloans Loans I used the following statements to pull all the loans for the investorid (03, 04, 06, 10) by matching the loan number(s) from each table. I also want to join the information from the property file to the result set (again, "loan" is the common record match".

In my book build your own database driven web site using php and mysql on page 61 it's covering creating a table. I think I'm typing this in correctly and I'm getting a error. I just don't see what I'm typing in wrong unless it's the : but in the book it almost looks like 2 of those on top of each other. This is what I get.. mysql> CREATE...

hi i have 3 tables in mysql i retrieved the data in xml using php now i want to retrieved the same data in json format but i have some problem in queries. i retrieved data from one table in json but unable to retrieved from three tables any help would be appreciated my code for one table is. $table_first = 'abc'; $query = "SELECT * FROM...

I'm using the Navicat console to run test queries. spssDATAfile' is a field of type blob. This works: mysql> UPDATE jobs SET spssDATAfile = (COMPRESS('999999999999')) WHERE folderName = 'Client_12-02-2010-23-04-42'; Query OK, 1 rows affected (0.00 sec) Yet the uncompress function returns null: mysql> SELECT...

Hi everyone, I am using the following query to retrieve member profile data: SELECT * FROM Members INNER JOIN MemberMartialArts on MemberMartialArts.mma_memberId = '$memberId' INNER JOIN MemberAbilities on MemberAbilities.ma_memberId = '$memberId' WHERE m_id = '$memberId'

I am struggling with this issue right now. I have read in a number of places that you should not store the image itself in the database, but rather only the filepath/filename. I can't seem to find anyone who tells how to do that, though. Maybe I just haven't found the right tutorial. Assuming I want to go this route, HOW do I do it? What I...

I am trying to create a full text search of my database but continue to get an error despite having indexed the TEXT columns (caption and location) under a single index (searches). How do I get the database to use full text searching? A. I have added a SINGLE full text index on the two columns which are both of the TEXT type. B. I have...

hello. i am running mysql5 on mac osx 10.5. i am new to both of these. i have created a sql script file and i am trying to use it with the sql SOURCE command. when i execute the command: SOURCE mySqlScript.txt; i get the error: Failed to open file 'mySqlScript.txt', error: 2. i have placed this file in the /usr/local/mysql/bin directory. i...

Lets say: userinfo table have (empid is Primary key): empid=========name 100 ========= A 101 ========= B 102 ========= C 103 ========= D 104 ========= E <---my problem is here--->

I have the following sql code (a statement which returns from a table only few lines (as a sample) SET @a=(select marime_esantion from j_6_3 where nr=1); SET @b=@a*0.8; SET @c=@a*0.2; PREPARE STMT FROM ' (SELECT * FROM `j_5_1` ORDER BY total_doc DESC LIMIT ?) UNION (SELECT * FROM `j_5_1` ORDER BY RAND() LIMIT 500000) LIMIT ?'; EXECUTE...

I've been working on a project lately that is written in python and I want to incorporate mysql into it. The python code is basically a report writing system in which every report will have it's own number such as 10-0001, 10-0002 and will contain information like first & last names, addresses, phone numbers, etc. There is also a page, if needed,...