MySQL Database Forum

I am trying to restore a sql file and get the following error message. SQL query: -- phpMyAdmin SQL Dump -- version 2.11.6 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 05, 2012 at 02:50 PM

This query is taking 3 minutes to execute it. pls healp me to make it faster. select histpric.timetick, stcurr.externalid, stcurr.assetid,stcurr.asset_name,bsnshistpr.bse_price, bsnshistpr.nse_price, histpric.eod_price from bse_current as stcurr join Stock_Hist_Price_2013 as histpric on stcurr.assetid = histpric.assetid join...

Can we store multiple values or range of values in a single cell, something like 1111-1115 i.e a single cell in the table should store the values 1111,1112,1113,1114,1115? If yes, then how do we do it? and what is the query for that?

Can any one help me to find out any report generator tool for wamp( i am using windows 7)....

everytime i load the data to datagrid the previous data is added wid the recent data? how erase the previously loaded data in datagird? my code is.. cnString = "server=localhost;User Id=root;database=aries_project" 'sqlQRY = "Select * from employees_info" sqlQRY = "SELECT...

for example, i want to get a data from my table "example" then the data from table "example" will be pass to variable or textbox. Thank You. I badly neede it. I'm still learning Visual Studio Ultimate 2012.

Hi friends, I have a site freefblike to promote every pages of your website on Facebook Google, Twitter and LinkedIn. Can you tell me how to add low coin notification script so any member with less points say x is auto automatically mailed or notified. Thanks!

hi i m vimit i making a project using j form. i wan to know that how to add a image in mysql and retrieve image from database using front end. i make this project in netbean

i can't copy my previously created database to my laptop grom the PC.My miss give me a dump sql file. how can i convert this dump to mysql database?

I want to connect wamp:phpmyAdmin: mysql database with my netbeans java project. i wrote all connection code and also connect "mysql-connector-java-5.1.11-bin" and there is no error but when i'm running program that time it dose not working. I want to Select and update data from wamp... tell me how can i do this.....................

Hi all, While installing Mysql i m getting error like " Could not connect ti the service Control Manager error:0" Thanks Parvati

how to count value of record in the database using asp.net

I have following code snippet to implement a multilingual website. Idea is to, depending on user's language i need to translate word "Man" to "Hombre" My Question: Will it be valid to use $user_language instead of hard coded column name "Spanish" here. code: //$user_language is passed from his profile after log in to the site SELECT...

I am currently trying to build a crud application to load name, address and picture data for members of an organization. I have the database set up, but when I run the application I get a null converter error for the blob data. What do I need do to get the application to work. I can send or post the application if more information is needed.

First am glad that there are people like you who really know stuff. im a newb in php but need some help here. Error in Query3Duplicate entry '127.0.0.1' for key 'lastupdateipaddress' am trying to log on to the system with a different user name. how can i succeed? Thx

Hi all once again!! I have two tables in MYSQL, tblLogin and tblCustomers with the following Columns: tblLogin{LoginID as Primary_Key, UserName, Password} and tblCustomer{Customer_ID as Primary_Key, Customer_FullName, OrderID, OrderDetails, submission_date, Customer_LoginID as Foreign_key}. What I want is to let customers to view their own...

I'm trying to open a command prompt window to my MySQL server. From reading online, I should be able to use /usr/local/mysql/bin/mysql -h hostname ...other options... However, I don't have MySQL on my laptop, so it doesn't recognise the MySQL command. Is there a way to connect, or do I have to install MySQL on my laptop so that I have the proper...

i am working on basic msi installshield12 , i want to connect with MySQL Server using msi instsllshield , i choose SQLScript , and check MySQL option and uncheck other two options but , i couldn't find Mysql server in drop down of server selection dialog Any body help me please .

Database name : bd1 Table Name : schedule Fields : associate_name, Category, Aux, Time Raj ABC Login, 9:00:00 Raj ABC Logout 6:00:00 i want the below output associate_name, Category, Aux, Login Time, Logout Time Raj ABC Login 9:00:00 6:00:00

I'd like to create a trigger to export to csv the new data added to the table. I've written: delimiter | create trigger trg_customer_csv after insert on customers for each row begin select new.account_code into outfile 'e:/trigfile.csv' fields terminated by ';' lines terminated by '\n' from customers;

Hi, Can someone check my code below? The second UPDATE fails because there is no GNameX column but the first UPDATE gets written to the db anyway. I have done a trace and it definitely executes the trans.rollback. Any help would be appreciated. MySqlConnection conn = new MySqlConnection(DefaultSettings.ConnString); ...

Hi, I want to transfer a user record from one database to another database. I want to do that within a single transaction to maintain data integrity, ie INSERT record to db1 and DELETE record (same data) from db2. Can someone help me with the code? I am using c#. Thanks in advance If I have two databases, doesn't it means I have two...

Hi all I've connected Base to mySQL, I can read the data from the DB with a query. But I cannot seem to be able to add a Record to the BB via a Form in Base, Is there sum thing I'm missing or is there a primition that I need to add

I have come across the words called active server and passive server can somebody help me out in understanding what they actually mean

I need to display the customer or business name as "Customer" & combine the following into 1 query: SELECT a.account_id, a.cust_id, a.last_activity_date, a.open_emp_id, CONCAT(e.fname, ' ', e.lname) AS opened_by, a.avail_balance FROM account a INNER JOIN employee e ON a.open_emp_id = e. emp_id WHERE NOT EXISTS (SELECT 1 FROM...