10,932 Topics

Member Avatar for
Member Avatar for sibotho

Hi all Can someone tell me how to connect to msql database using c# 2003. can you please show me the steps to take. i have tried many times without success. Are they compatile? Thanks sibotho

Member Avatar for hollystyles
0
94
Member Avatar for mulesy

Hi there, I am relatively new to MYSQL and i have to design a database for stock for a dvd firm, this database has to link up to a website, the website is a DVD firm so the only things that needs to recorded in the database is how much …

Member Avatar for sibotho
0
177
Member Avatar for bhuvan83

is there any way through which we can generate reports in mysql. not using any s/w but coding. if yes plz tell me Thanks

Member Avatar for jbennet
0
88
Member Avatar for heliumgas

Hello I´m trying to make a function that give-me data from a data base mysql at time there is no problem but i would like to now how i can make that funcion to be called from x hover x seconds, the ideia is just to se if there is …

Member Avatar for tavox
0
133
Member Avatar for heliumgas

hello, i need help!!!!! i would like to know how i can make a backup and restore of my db mysql from one form???

0
78
Member Avatar for bhuvan83

hi all i m making a project using jsp as my front end and mysql as my back end. i had to change backend from oracle to mysql bcoz of clients request. now there is 1 problem i m facing. there a password change option. person enters its old password …

Member Avatar for peter_budo
0
104
Member Avatar for sam1

hi, it is giving me headache to write data from a php file to mysql( i can read from the table but cant write) here is my connect.php which connects to mysql: [CODE]<?php $mysql_host = "localhost"; $mysql_user = "sam"; $mysql_pass = "123456"; $mysql_data = "website"; $mysql_table = "shoutbox"; mysql_connect($mysql_host,$mysql_user,$mysql_pass) or …

Member Avatar for niceboy
0
277
Member Avatar for EnderX

Does anyone know the name of the MySQL library package? I'm working with a server that recently had an upgrade from PHP 4 to PHP 5, and apparently PHP no longer provides built-in library files for MySQL. The system in question should have the libraries from PHP4 on it somewhere, …

Member Avatar for mmxx66
0
76
Member Avatar for Anaa

I hav calculated a value(years).Now i want 2 merge it with an attribute of a table.So i want 2 merge ml_y and 2.then i want to find the value of ml_y2 frm a table....plzzzzzzzz help me .can i do somthing like this in MY SQL???

Member Avatar for mmxx66
0
121
Member Avatar for webbyboy

[B]When i try to access this page: it shows this: Warning: mysql_query(): 2 is not a valid MySQL-Link resource in /user/langlab/wwwhome/signup/signup_adm.html on line 28 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /user/langlab/wwwhome/signup/signup_adm.html on line 29 Warning: mysql_query(): 2 is not a valid MySQL-Link resource in …

Member Avatar for mmxx66
0
94
Member Avatar for bhuvan83

i m exporting my table from one system to another. when i do shell# mysql databasename<file.txt i get the error given above. the table i create is -> CREATE TABLE entrytab ( uname varchar(10) default NULL, enterDate date default NULL, status varchar(10) default NULL, productName varchar(15) default NULL, featureName varchar(20) …

0
82
Member Avatar for bhuvan83

hi every1 i m using jbuilder9 to develop my website and mysql as its back end when i use mysql with simple java program it runs as i store the jconnector in jdk1.3/lib/ext. but when i stor the jconnector in jbuilder/jdk1.3/lib/ext it does not work. can any 1 plz tell …

Member Avatar for bhuvan83
0
72
Member Avatar for bhuvan83

hi every1 i hv created my database in mysql now i have to run the s/w on my clients system. can any 1 plz tell me the steps to export the mysql database and then to import it on my clients computer. thanks in adv

Member Avatar for bhuvan83
0
85
Member Avatar for srj

Is there a free Host in the Net ... which host ASP and MySQL do anyone of u know..please post if u know.....

Member Avatar for jbennet
0
166
Member Avatar for Tales
Member Avatar for Ancient Dragon
0
94
Member Avatar for veeyen

Hi I am very new to MySql. I want to use Navicat along with MySql server to develop and maintain very simle database in future. Up to this point it is OK. I want to develop and maintain a small customer database. My question is do I need a GUI …

Member Avatar for jbennet
0
90
Member Avatar for dami06

Hi, Can someone please give me examples or teach me how to design and implement in MySQL a normalised database for any case study they have in mind.. Please help me out as it would really help understand a lot better or if you can give me a link to …

Member Avatar for katharnakh
0
81
Member Avatar for tech291083

Hi, I am trying to get my head around the whole database theme by learning MySQL on my own with the help of a couple of easy to use books and some online forums including this one. Is this is the right choice in terms of learning the database related …

0
57
Member Avatar for dami06

Hi, I am trying to understand MySQL as i am new to this and i have a few queries I am having problems with and I was wondering if anyone can help me with it.. How would you solve this problem using the Select, from, where etc commands. For example …

Member Avatar for dami06
0
137
Member Avatar for Dhanapal

[COLOR=midnightblue]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_Forum_yaf_Category". The conflict occurred in database "yafnet", table "dbo.yaf_Category", column 'CategoryID'. The statement has been terminated. How to solve this error...........[/COLOR]

0
64
Member Avatar for nickclarson

I have a db full of articles that have a category field. Is there anyway to select and display just the different categories?

Member Avatar for nickclarson
0
82
Member Avatar for dangutm

how can i retrive data from database (mysql)and make it a drop down menu on a html form using php .and also if an iteam is selected from a fist dropdown before the next well become active.

Member Avatar for csscart
0
182
Member Avatar for bucwyld
Member Avatar for GTHD
0
237
Member Avatar for mbacon

SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296') After I run this the server has an intense lag and needs to be restarted or timeoutes occur.

Member Avatar for peter_budo
0
113
Member Avatar for hkBattousai

Hello, I am going to study MySQL on my web server. I would like to ask if there is a useful GUI tool for MySQL to create/delete tables and browse entries on my database.

Member Avatar for pty
0
133
Member Avatar for bobby08

Hello, I heard SELECT COUNT(*) can take a lot of resources if your counting a table with lots and lots of rows (hundred thousands, millions). What if you add A WHERE clause to it? So something like: SELECT COUNT(*) FROM table WHERE pid = ? (pid is a index too …

Member Avatar for Raposo
0
131
Member Avatar for tech291083

Hi, I am using Fedora Core 5 32+bit as my os but not using a particular development tool as of now and just sticking to the normal text editor called the KWrite. I am learning C++ and MySQL on my own and want to know if the connection between the …

Member Avatar for Ancient Dragon
0
84
Member Avatar for Lost in Code...

I have a school problem, I'm not going to try and hide it. This is for Oracle9i: SQL class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. …

Member Avatar for nikkiH
0
297
Member Avatar for nschessnerd

Hey, so I get a Driver error when I try to connect to my local mysql db. My code is in a servlet as follows [code] Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con=null; Statement smt=null; con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sql?user=webusr&password=pass"); [/code] Thanks M

Member Avatar for nschessnerd
0
119
Member Avatar for steve.p

Can some one help me to set up a database in mysql. I need more of a logical help.

Member Avatar for peter_budo
0
58

The End.