MySQL Database Forum

I have a VB6 program that connects with a MySQL 4.0.17 through MyOLEDB Provider v3.0. At the begining of the program, when I try to connect with the MySQL server and this one is not running, appears a MyOLEDB window with the connection SetUp titled "MySQL Data Source Name Setup" and with params like: Data source name, MySQL hosts, MySQL...

Hi I'm making a good ol' forum, and i have three tables, users, threads and posts. when i query my threads table with a join, i need to access the users table twice to get the username of the first poster and last poster. But how? I can only figure out how to get one or the other. Is my design bad? eg SELECT TopicID, FirstPostID,...

Hi All Ive just finished my trial with XmlSpy 2004 and I really liked the way the table view worked in that and was wondering if there is another cheaper program out there that also offers a friendly table view of the info in an xml file. I only need to view Xml data not edit or create any so I dont want to pay $400 plus for Xmlspy when I...

mysql v4.0.16: I had been using mysql with innodb and thought that was fine, until i used it for something requiring a few - perhaps slightly involved - joins, and have now seen the performance become totally unacceptable. I have a query that takes over 35 seconds using mysql and innodb, for reasons that are completely a mystery to me, in...

What the best language code to connect MySQL --> C , C++ , php,VB,Delphi ? about ---- Speed ---- Stable ---- Security Can anyone compare C , C++ , php4,php5 ,vb ,delphi to connect to MySQL ? I need to know how about c++ .

Hi. I am using this moment MySql. In my Delphi program, i have a SqlConnection (from palete dbexpress), chossed Mysql, and when i tried to connect i get this message: "Unable to load libmysql.dll." I tried to found this file in the net, and insert to the folder

I installed mySQL and have it running.... but I think I made a mistake somewhere along the line...... I believe I did follow the instructions that were provided with the distribution at: http://dev.mysql.com/downloads/ The database is up. It seems that a test database instance has been created (named "test"). I can see it. However, the...

I am having a strange issue with MySQL. I just installed it on my Zaurus and loaded a few of my databases in it. All very small. When I do a count withoout a where, it hangs. It does this on all my databases I have loaded. Example below. _______________________________________________________________________ mysql Ver 9.38 Distrib...

Does anyone know if it's possible in mySQL to do something like this: SELECT Name,Comment FROM (SHOW TABLE STATUS FROM myDB) I know the above isn't valid, but it gets the idea across. Just curious if there's a way to return only portions of the result set that's returned from metadata queries. Thanks in advance!

hi: i got a very serious problem,i really dont know how can i fix it! it seems my mysqld died after ten hours. system redhat linux as 3+ apache 2.x+tomcat4.x+mysql4.0.20+jsp+ mysql-connector-java-3.0.8-stable-bin.jar $vi /var/log/mysqld.log

Hi All, I've been taking a look at DB Designer 4, and looking through the documentation (http://www.fabforce.net/dbdesigner4/doc/index.html) I am a little unclear on some of their nomenclature: '1:1' - Ok, one to one. Got it. '1:1 generalization' - Don't know this. Obviously different somehow from one to one, but how? '1:n' - One to...

Hello, I have a excel spreadsheet from which I would like to load data into a table in mysql. Can you please give me an example of the above. Thanks in advance Nagsy

Downloaded and installed 4.0.21 on WinXP SP2 system. Started server via Start, Run, c:\mysql\bin\mysqld.exe. From DOS window, mysql.exe starts without complaint, but "show databases;" only reveals "test" and not "mysql", although c:\mysql\data clearly has subdirectories "test" and "mysql" . Why is database "mysql" not shown? Thanks.

I'm trying to get MySQL Connector to work. I'm using the latest version, 3.0.15-ga, and Java 1.4.1. On running this line in my code: con = DriverManager.getConnection("jdbc:mysql://localhost/" + database, "root", ""); I get the following error message:

I have made a MySql database that records values every day from some experiments. The database have x columns across. One with the name of the experiment and the rest with the values. For example: Experiment z21092004 z22092004 z23092004 z24092004 ++ dlk322 2 2 3 7 der42441 5 53 3 ...

Hi there. I am planning a conversion from c-isam to mysql (or possibly postgres) and I am wondering if it would be possible to keep the same directory structure for my db's at the moment - which is to say that we have around 700 separate databases (one for each client) and I have them all separated off into their own little subdirectory. ...

I have been working for a month (on and off) on the following issue: The table contains event data, each event is placed in the table as the event occurs, if there is never an event then there is never an enttry for said event. When a device is down it is status 1 when it comes back up the device becomes status 6. the newest status will have...

MySQL calls 4.1.5 a "Gamma" release. What does that mean?

Dear friend. As you read this, I don't want you to feel sorry for me, because, I believe everyone will die someday.My name is BERMUDA PHILIPOL a merchant in PHILLIPINES,I have been diagnosed with Esophageal cancer .It has defiled all forms of medical treatment, and right now I have only about a

I'm exporting MySQL data using a sql script containing:: SELECT * FROM (database name) INTO OUTFILE (filename) FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; The file is created successfully but line 1 of the file does not contain the column names. Is there an option I need to enable in oder to produce this? Thanks...

Hi , Im new to MySql and i have no idea how to convert a sql server user defined function to MySql. Can any one help me.. CREATE FUNCTION ChildCategories (@categoryId int, @taxId int, @dummyTaxId int) RETURNS @retTable TABLE (path varchar(2048), parent_id int, category_id int,

Hi everybody! I have to evaluate MySQL 5.0 for a new DB-project. Does anyone has a idea how to get a Rowset from a stored procedure on a MySQL-server 5.0 I have tried CREATE PROCEDURE `get_data`()

Hi, Is there a fuction in MySQL to have a clone (on other computer) of the db at all times? I need this for backup and for load balancing, between systems, if there is a burst of selects. I use mostly inserts. In other terms: I would need a system that stays online if one computer with db crashes and that doesn't lose information while...

I'm thinking of embedding MySQL in a .NET application. The application will run on a Windows PC and also on a PocketPC handheld; it's to be a single-user application, holding up to a dozen tables with a few hundred records in each table. If I understand correctly, embedded MySQL doesn't support replication/sychronization (please correct me...

Hello all. Here are my Tables Tickets ------- id Notes -----