MySQL Database Forum

Anyone know an easy way to display charts of mysql data?

Server: Suse 9.2 DB: MySQL 4.0.21 Error: Driver Failed to set the internal dynamic result I am writing an app in VB.Net. I get the above error whenever i try to update the recordset using RS.Update. I can retrieve and read records fine.

My client decided that all project personnel must be certified in MySQL. It was a contractual agreement between my client and his client. So: - I went to www.vue.com and signed up for the CORE test in MySQL - I took 160 hours to study using the "MySQL Certification Study Guide" - Many questions were not even covered in the study guide - I...

Hi all, I'm working with: MySql: Database server: mysql-4.1.7-essential-win ODBC driver: MyODBC-3.51.10-x86-win-32bit Administrator: mysql-administrator-1.0.14-win Query browser: mysql-query-browser-1.1.2-win

Could someone please help to explain why the following query isn't using the index... explain select id from kbm where state = 'MA' table type possible_keys key key_len ref rows Extra kbm ALL State NULL NULL NULL 1000000 Using where The field 'State' is Char(2). It has an index.

You could perform a search for the given value. If it is found, return a message that it already exists, else write a new line.... (Hope this is clear)

Hi I thought that working with swedish characters would be easy, but since I'm working with MySQL 4.1 that's not the case any more. First thing I noticed (emditly) was an application that I've written in Qt showd rubbish in the QDataTable where there should be swedish characters. So I took a look in the database using the 'mysql' client app,...

Is there a way to execute a JOIN, and have the result of the JOIN populate a new permanent table? I would like to execute a complex join and have the results of the join, end up as records in a new permanet table. thx

greeting, In short, I have a database data directory, 2 Mysql daemon are running parallel over it through different port and sock. Now I found a problem that for daemon "A" its read and write are performing well, but for daemon "B", its read operation is fine, but when I issue "insert" statement with "B", the new record is cache: 1, from...

I have a table with 2 records: ========== TABLE: users ========== name_id (INT) name (varchar) code (int)

Hello to all: I have been searching the web for examples on how to determine a median value in a mySQL table. I have reviewed the article at http://mysql.progen.com.tr/doc/en/Group_by_functions.html. I am an experienced VB programmer that has recently moved to PHP/mySQL. My employer has a text file outputted from a vendor specific...

Any assistance would be greatly appreciated. I'm relatively new to working with MySQL. I exported my DB with phpMyAdmin 2.6.0-pl3 running MySQL 4.1.7 I'm trying to import it with phpMyAdmin 2.5.7-pl1 running MySQL 4.0.20 Is this possible? I seem to be getting this error: MySQL said:

I got an "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='" but when I do a 'show create table', I see that my two tables are in default charset latin1. 'show variables like '%colla%'' gives me : | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | |...

I'm running MySQL version 4.1.7-nt. When I submit the following query: SELECT DISTINCT pet from pets; I get: dog cat lama

I'm having a problem passing SESSION variables from page to page. Right now, I have this code at the top of my page: if(!$_SESSION) include "login.php"; This is the code for the login form: if($submit != "") { $login_results = loginCheck($email, $password); if($login_results) { session_start();

Hi, I'm trying to do an insert with the following statement: INSERT INTO user VALUES ( 'ag@ag.com','ag','Aaron','Chandler','','','La Mirada','CA',90638,714,'',''); and I'm getting the error message "Column count doesn't match value count at row 1".

Hi everyone, I have two tables one for 'users' information and one for their 'profiles'. After a user fills his registration and profile information form, I would like to insert those information into the previously mentioned tables and keep the relation between the records. Ex.

hi there, I am quite interested in making the move from Access to MySQL. I have grabbed all the software that is needed (MySQL, MySQL Control Center, MaxDB, etc.) and have installed it all without a hitch, everything is running smoothly, so far. My only concern is that I am still trying to look at everything from a Access point of view;...

Imagine 25.000.000 records in a database with a table like this: TABLE SUBJECTS table_id (INT) subject (VARCHAR(200)) date_added (TIMESTAMP) The SUBJECT field is a long string. Something like these:

I looked everywhere (Google, manual, etc.) but can't find an answer to this question. If I do a "INSERT IGNORE INTO" query into a UNIQUE field and the word I'm trying to insert already exists, can I get the ID of that existing record returned so I can use it in the rest of the query?

I am getting: #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT max( yearmonth ) FROM periods ) ORDER BY mr.currentra With this query:

I have a table, table1, with the field 'areacodeplustelephone'. This field is of length 10. I created an index called 'areacode' that only uses the first three characters. Can I use this index in my select statement? I tried this: select name from table1 where areacodeplustelephone = 330' -- no results I tried this: select name from...

Is it possible to append text to the end of an existing record I know of UPDATE sysntax but i want to be able to add additional text to a record eg column text = "hello" amended ist time = "hello world" amended 2nd time "hello world - how are you?"

Hi, I just installed PHP 4.3.9, MySQL 4.0.2 and PHPMyAdmin 2.6.0-pl3 on our intranet server (Win2k3 running IIS). I also have a similar setup on my local machine (http://localhost/phpmyadmin). Everything seems normal when I work on the server machine (also known as web-nt with IP xxx.xxx.xx.xx), but when I try connecting to the MySQL...

Hi all. In the process of trying to figure this thing out, I've been doing the old "stand around in the store and read as much as possible before you look like a derelict" thing. This time, with the O'Reilly "Managing and Using SQL" (I think that's it). Anyway, I was looking at a chapter discussing database design (without any direct...