MySQL Database Forum

Can anyone help here? I'm stuck at a step in this process, and I'm a little fried from staring at the comp for 8 hours already on this one thing... the two selects below need to be returned as a single table. Can I Concat? Union? Join? Can I somehow join the results of the select statements? and anywhere you see "4" will be a user...

I received #1064 - 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 'WHERE customer_id=1' at line 1 My query is: INSERT INTO customers (mce) VALUES ('I like apples') WHERE customer_id=1 Any ideas?

give me the details about data types in mysql..

Hi am using vs2008 writing asp.net.vb app. My stored proc should return a single name, well in theory at least ALTER PROCEDURE . ( @email varchar , @retvalue nvarchar (10)output ) AS

Hi I am trying to build a search function on php its working fine but as there are lot of records on database from past it runs very slow. is there way to make it so it only looks up from today's date to future dates nothing in past search term i am using is here $query = "SELECT * FROM diary WHERE $searchterm LIKE '%$search%' LIMIT 0, 50 ";...

Write a my sql query to select all username who had nokia purchased handsets "N72" in the year 2008. tables given below: Thanks -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net

Can anyone help me. I don't know if this is a mysql, php or Google Chrome error. I have a login form but for some reason I'm getting an error when I use Google Chrome. It used to work in all browsers (IE, Firefox, Safari, Opera, Google Chrome) but for some reason it has stopped working and Google Chrome. I assume it has something to do with me...

I am trying to transfer output of a query to some file whose name will be available only at the run time. My CODE looks something like this, this code is a part of stored procedure. set FILENAME = uid + (select phone_no from table2 where user_ID = uid); select startstop from table1 INTO OUTFILE FILENAME;

I want to learn how to run trigger into data base. so first i want to know what is trigger and what is it's need.

I need to consistently show seven days of info from my database. I have script that seemed to work great until the end of the month came. I am using the Date(NOW()) function to get today, and DATE(NOW())+1 to get tomorrow and so on up to +6. However, I guess DATE(NOW()) looks for 2010-10-32 instead of 2010-11-01. What do I have to tweak for...

works fine: port = 3306 port = 3306 but once changed to: port = 3307

I have a table of a retail store which has almost 13000 customers. and i want to write a query for this.. Group products based on their sales patterns. Highest, lowest, and median values. Use sale prices as an indicator as well (Do these products sell well only when they are discounted?). it also uses clustering.i dont know what to do ...

hey all i have installed xdebug using php5, ubuntu but when i clicked on debug button in netbeans it dosen't working properly when i checked phpinfo() everything is fine there look at my attach image. any suggestion please

************************************************ This code runs fine with these results With t1 as (Select x.InsurerID, Count(Distinct x.SubaccountID) as 'Total SubAccount',

I had a failed install of WAMP on my Windows 7 machine. After cleaning out everything I could find I tried an install of IIS, PHP, and MySQL through the windows WEB PI. The install fails with a message that the password I am trying to install for MySQL doesn't match. I think there is a file lurking somewhere from the failed install that I...

Hey guys, Sometimes it's the most simplest things in life that drive you insane. I'm no complete MySQL noob and I'm not doing anything fancy by any stretch. My table contains two date-times: 1. original_date 2. begin_date I'd like to select rows where original date is equal to begin date and the date ONLY (not the time). I'd...

hi, if anyone can help me please, i nead to select all the tables in my database in one instruction. all the tables have the same structure. the problem is that i dont know the number of tables neighter their names. i nead a solution like SELECT * from database_name.* thanks

Hi, I have created one database called QueryMgmt in MySql. I want to select all the tables present in that database. When use this query select * from tab; the following error is occurred. ERROR 1146 (42S02): Table 'querymgmt.tab' doesn't exist. Can anyone please help me to fix this problem.As im new to MySql can you explain your answer

Hello hi, just a quick question: is there any sql that i can copy a row in mysql and update some values in it? For example, i have a table like this. Name | School | Year John | ABC School | 2009 Mary | CDE School | 2010

even i am facing the same problem . how did u resolve it ? i am also using microsoft equation 3.0 to write equations in word document. now i want to save this in mysql db . which format would do .

I have a table with 4 columns Table name = products Column name = product_id, product_programname, product_title, model_number When I use GROUP BY with model_number, it alway returns me the info of product (ebay) which comes first in the queue. But i want to get the title from 'argos' if not null else 'buy' if not null etc. The below...

How to fetch the "name" FROM programname = "Buy" and description which has maximum words using GROUP BY?? I have 6 columns with thousands of product entries: Table name : eproducts Columns : product_id, programname, name, description, clean_modelno Ex. Products Entries: product_id : 5001 programname : argos

I have three columns - id, programname, status I wanted to use UPDATE with IF condition something like this: UPDATE elec_products IF(programname ='Argos') ( SET status = 1

UPDATE items i, cartitems c SET stock = (stock-1) WHERE i.id = c.itemid AND c.userid = '7'; Okay so I have a table for 'items' and a table for 'items in a users shopping cart'. I want to decrement the stock field in the items table once for every instance of that same item in the 'items in shopping cart' table. The code above, will...

How can I check the underlying sql behind an already existant mysql view?