MySQL Database Forum

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

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

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

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?

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

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!

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.

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

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

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?

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

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

Hi,I'm trying mysql cluster to use in a project for our customer. The configuration I setted up is the following: Server1 - S.O. Windows 2008 R2 64bit Server2 - S.O. Windows 2008 R2 64bit Client1 - S.O. Windows 7 64bit Client2 - S.O. Windows 7 64bit UserClient - S.O. Windows 7 64bit

I have a table as follows code PB0001AA PB0001AB PB0001AC PX0001AA PX0001AB PX0001AC PX0001AD

Using MySQL 5.0 on a xP platform I have a longtext column in my table. Somehow a character has been inserted (or transformed) into some of the records where the carriage/line return strings should be. I should have in hex format 0D 0A. But instead what I have is AC 0A. Is there a way to search for the AC and replace it with 0D?

Hello, Is it possible to create a function that uses a select statement and displays the results. Any and all help would be greatly appreciated. My table: CREATE TABLE COLOURS

Hi, I have a huge problem and I need help. I have the data folder from the server I had on one computer (containing the schema folders and the ibdata1 file). Now I need the install the mysql server on another computer, and transfer the data - but every time I try, when I move the data folder, it can't start the server. I must have the data,...

I have one clob field 'Class_Data' in my table 'School' and in the clob there is one tag name as '<Fee-Value>' , I want to select the all occurrences of the tag from the clob data. I used the below query in mysql , but it select only the first occurrence of the tag(there are 12 occurrence of the vallue) select substr(Class_Data,...

com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException : column "ID" is cannot null plz help me that how can remove this type error...

im having this same problem .. this is my query .. select title, url,sum(visit_count),microsoft from (select * from data_repository where (username='prasad'and microsoft>0 or title like '%microsoft%')) group by url ,title order by sum(visit_count) desc, microsoft desc; can u tell me how i can fix this problem ?? thanks in advancee

Problem of indexing Country, State , City table. Instead of entering repeated user location for several users who share the same location I am planning to normalize by giving locationID from Locations table to each user in the User table so that I don’t have to enter Country, State, City repeatedly in the User table so I save disk...

HI, I want to merge TESTLINK and BUGZILLA databases into one, even though they have mysql DB but i have installed in different ports(TESTLINK-3306 and BUGZILLA-3307). so with respect to TEST CASE-ID in test link which are failed or blocked or whatever it should raise a defect in the bugzilla automatically. I am unable to understand which...

Hi all!! I have MYSQL server running in one machine (say PC1 with IP 192.168.0.45) and I want to connect to MS-ACCESS in another machine (say PC2) on the same network. How can I go about it? Please help!!!!!!!!!!!

I am having trouble when I go to generate a certificate, when I list the course the name and then hit the generate button it sends me to the page with this message with an arrow pointing to it highlighted in yellow. DoCmd.RunSQL ("Delete * From Temp") Thank you for any assistance anyone can offer me.

hello, i want to do this query $sql = "SELECT * FROM `departement_2`,departement_5,departement_8,departement_12,departement_33,departement_15"; Does anyone have any ideas on what I should do? thanks.