MySQL Database Forum

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...

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

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...

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

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.

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"

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

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 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...

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

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

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

I'm trying to look for day of week (i.e. 'Mondays') in a given description of a course which resides in field 'date' and place that day ('Mondays') in a new field 'day'. In such a way we can easily check for conflicts. But I keep getting error. UPDATE wint14 SET day = 'Tuesdays' WHERE date = '%Tuesdays%' I'm a total amateur but I don't...

The following code works fine select concat( case t1.testColumn when 'value1' then t1.column1 when 'value2' then t1.column2 when 'value3' then t1.column3 else t1.column4 end

when i try to connect php script to MySQL for creating & inserting values in a table i get an error msg: Error creating database: Can't create database 'mi_db'; database existsAccess denied for user ''@'localhost' to database 'mi_db'. I am running the php via a wamp server...root directory - www and my database name is mi_db. Please suggest...

CREATE TABLE `norm`.`sphone` ( `sid` INT NOT NULL, `phone` VARCHAR(45) NOT NULL, PRIMARY KEY (`sid`, `phone`), CONSTRAINT `sid` FOREIGN KEY () REFERENCES `norm`.`staff` () ON DELETE RESTRICT ON UPDATE RESTRICT);

when i am trying to back up the TE(Application)config file and TE database back (MySql 5.6)i got this error message C:\Program Files\Tripwire\TE\Server\bin>tetool backup --passphrase 'pass' C:\TE_Backup_20140127\TEconfig.bak C:\TE_DB_20140127\TEdb.bak Error message:mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using...

i can't find the relation view tab in phpMyAdmin account any help?

is there any online database server that allow me to insert data like MySQL and also let me able to connect it to java NetBeans ?

if i want to make new line in one of columns of the schema how can i make it? ex.: he is good boy if i want to insert this line in the column as : he is good boy how can i do that ?

Is it possible to migrate products from one drupal site to another? Help me please :) Thanks

how to solve this error : BLOB/TEXT column 'xxx' used in key specification without a key length given that xxx is a primary key and its type is text

INSERT INTO table VALUES (bytes Is A good site); Does this line makes me get data from database with new line or does it prints the sentence concatenated? In other words Does the returned data is as follows : bytes is a good site Or as follows : bytes Is A good site ??

input city1 city2 Achterom Groningen Achterdijk Madurai output city Achterom Achterdijk Groningen