MySQL Database Forum

Hi Is there any way I can add my excel data to my existing MySql with tables and data?

why i have this problem, that when i write the project statement it gives a syntax error in the project word, it doesn't take it as a reserved word and it even doesn't turn into blue color i need a help plz, its urgent

why i have this problem, that when i write the project statement it gives a syntax error in the project word, it doesn't take it as a reserved word and it even doesn't turn into blue color i need a help plz, its urgent in the sql server 2000

I need to have database that can be filled by users entering data on a web page. I'm an excel user and I know a little about Access but nothing about SQL databases. Through some web research I realise that trying to do anything with Excel will be pointless, even though this is the program I am comfiest using. Any help or suggestions would be...

Hi guys I have 4 tables which are (flight, model, airplane, pilot) Flight: fid, pid, aid, plannedDeparture, actualDeparture, passengerCount, destination Model: mid, name, usefulLoad, pilotCount Airplane: aid, mid, oid, hid, dateAqu Pilot: pid, hireDate and I need to generate a report (query) for overloaded flights. Assuming the...

i have downloaded MySQL from here http://dev.mysql.com/downloads/file.php?id=414392 and extracted the folder but i can't find the icon of installing the program

I am a not an expert in MySQL world and looking for a solution like I have a table for example: issue_table ============= id, issue_from, details 1, machine1, "some details" 2, machine1, "some details again" 3, machine2, "some details"

dear sir, please reply me my question step by step. I once again repeat my question. The drive or network connection that the shortcut " refers to is unavailable. Make sure that the disk is properly inserted or the network resource is available, hope and faith you must do best early and give me reply very urgent.

Hi Friend, Category: MySQL Form 1: Quick Signup Username: password: conform password: country:

I have received the error State:21000, Native Code: FFFFFCD5 when attempting to run the following SQL Query to update column using the data from another DB2 Table column. UPDATE db2prod.arts_case_research SET agent_ID =(SELECT db2prod.arts_case_research_AUDIT.agent_ID FROM db2prod.arts_case_research_AUDIT WHERE...

I have a field like "6330052PQKLRE01" and "201310PQKLRE-2null" in 2 different tables would like to keep only PQKLRE. Thanks for your help,

Our company uses a nifty MySQL database to import/store data that is FTP'd to us. It runs QUICKLY to import the data (like... nanoseconds)! However, being a slightly more advanced than a beginner, I've been told "don't touch!" and build queries in MS Access (Office 2010) using ODBC. This works, but at times the queries seem to crank on...

The requirement for creating single TT on multiple alarms is : • User to select multiple alarms and clicks create TT from right click menu. • The single TT has to be created in TSRM for alarm for the oldest alarm i.e alarm which has last occurrence greater than other alarms. • TT details to be updated for the same master alarm and other...

I'm having problem in executing non query sql statement. Bear in mind, I'm still new to .NET framework and MySQL. Here is my code. private void Binding() { string connStr = "datasource=localhost;port=3306;username=root;password=root;"; conn = new MySqlConnection(connStr); MySqlCommand command =...

I have this Report that displays information based on someone selecting a Start Date and End Date. The Table is: MSys_obj These are its fields: Incoming/Outgoing,Date,Worker,Caller,Sex, Time,Duration,Location,Reason,Satisfaction,A,B,C,D,E,Outcome And this is its Query (Usysqry_Smiley): PARAMETERS DateTime, DateTime; SELECT...

I have three tables with schema as below: Please check sqlfiddle:

I'm using Adventure Works 2005 as my sample database, and I'm trying to find the count of times the scheduled start date does not equal the actual start date divided by the total number of rows in the table to give me a percentage. So far I have this. select count (*) from . where ScheduledStartDate!=ActualStartDate I want to divide...

If you only have .frm files,how you can get table structure.

This question was removed by the op

Good day dear friends, I have been trying to search the internet but I've not found an answer to my question. I'll be glad if I get a good response here. I am a java programmer, and I just started learning web programming also. Now I need to install xampp and I also need mysql for my java database programs. Do I have to install mysql first...

Looking to find a way to only pull the latest results if there happens to be duplicate. When searching a container in our system, if it doesn't have a dupe I want it to pull that information. But if there is a dupe I want the latest one entered. Is there a way to look at the created day date time to pull the last one created?

trying to upload a older .sql to myphpadmin and keep getting this any help would be nice... Table structure for table `addedrequests` -- CREATE TABLE IF NOT EXISTS `addedrequests` ( `id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT , `requestid` int( 10 ) unsigned NOT NULL default '0', `userid` int( 10 ) unsigned NOT NULL default '0',...

Hello! Considering a two column table ------------------------- | DOB | Age | ------------------------- |yyyy-mm-dd | Xy-Yd-Zd | ------------------------- | | | Using a UDF, I would like to force calculate Age every time the record is accessed.

name jan feb a 20 10 b 30 20 c 40 30 i have this data and i need this as name jan feb total a 20 10 30 b 30 20 50 c 40 30 70 total 90 60 150

1 How to connect MySQL to the command prompt 2 Where do you Wright the File path to the command prompt 3 I am using Windows 8 4 Every time I try to run MySQL in command prompt it just says MySQL is not recognized, 6 I need to connect to the command prompt using the File path in Environmental variables system Files. Then open command prompt...