MySQL Database Forum

Hi all I have been using MS Access for some time and want to convert/move to mysql I should like to import the tables rather than re entering all the data can anyone point me in the right direction or where I can find a good intro to MYSQL?

I have 2 tables: Table1 contains (among other things): ID Data1 Data2 Data3 1 aaa bbb ccc 2 ddd eee fff 3 ggg hhh iii Table2 contains (among other things:

I've been working on a project for awhile now and can't seem to get it working the way I want. What I've got is a database with different category's and products below them. The thing I'm having trouble with is the products all have different sizes and colors, and each (different) product has it's own id and quantity. My first idea was to...

We have a complex statement created from a web application which does not work correctly. During analysis, we could reduce this statement to the following: SELECT * FROM table WHERE ((row1>=0 AND row1<=2 AND 1) OR 0) AND row2=1; "row2=1" is not being computed, we also get results with row2<>1; When we swap the values of our last "AND"...

MySQL v 3.23.56 for pc-linux-gnu on i686 How do I know what database I am 'using' ? I launch mysql from the command line. Type 'show databases', then pick a database to use by typing 'use databasename'. I am now using that database but have no visual cue. How do I include the username, database name, etc in the 'mysql>' prompt?

Hi all, i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun box running solaris with eighteen 36Gb drives. The situation is that i have a bunch of databases on one server that can all be classified as...

Updating from Mysql4.0 to 4.1.1, pb with phpMyAdmin 2.6.0-alpha1 and phpAds 2.0 Environment: Sun servers running solaris 2.8 Php 4.3.6 Apache 1.3.29 Mysql 4.1.1

Im trying to build a graph of values from a counterTable. (Eg - get a list of how many times a page was requested in a week period with each y value being a day). If the table looks like this... counterTable +-----+------------+ | id | date |

--============_-1151307064==_ma============ Content-Type: text/plain; charset="us-ascii" ; format="flowed" Is it possible to basically do a conditional within a join (or perhaps this is where a subquery is needed)? I have a workorder table that I'm doing a join with. Each Client may be a different client type and thus needs to be joined...

1.2Ghz Pentium, with 1/2Gig of ram, 4.0.14MySQL, RedHat9.0 I have about 20K records that result from the following query. Front end for the database is ACCESS97 and pulling up 20K records makes a huge performance hit. For the form in question I am using PASSTHROUGH type query (the one that just passes everything straight to server without...

I installed Red hat linux 9 and then i installed mysql. When i tried to to start mysql using safe_mysqld & the daemon got started and then ended in a sudden. Got a message "030828 mysql ended ". What may be the problem. Please help! Thnax in advance Lincy

Hello, I hope this is a much easier problem than I thought: I am doing a query to find the word "mad" in the studios.studio column and in the artists.artist column. I basically only want to have a count of how often the word is found, however, the resulting ids should be counted unique. select studios.id, artists.studio_id from studios,...

Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help? TIA, Wade

Hi. I've got an exported database from an external system. It's in the format of MYI, MYD and frm extension files. However, one table in this database has book.frm, book.MYD, book.MYI _AND_ book.TMD. When I've created a database in phpmyadmin/mysql, moved all the files into the proper directory, every table can be looked at and selected but...

SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: moyc To: mysql@lists.mysql.com Subject: Installation challenges - mysqld >Description:

Hi, It is noted in the MySQL manual that unsigned integers bigger than 9223372036854775807 (63 bits) shouldn't be used itnarithmetic operations since signed BIGINT/DOUBLE is used in arithmetic functions. Can we somehow tell MySQL (probably during compilation) to use unsigned BIGINT/DOUBLE for arithmetic functions? (I know MySQL wouldn't...

A question to MySQL users: Do MySQL has its own ERD tool or tools? If not what ERD tool - if any - can be used when working with MySQL? Regards Marek Kotowski Warsaw

I am about to put up a new site using a MySQL database, and am looking for a good, reliable hosting provider that will not break the bank. Any suggestions? Also, would be interested in any advice since this is new territory for me -- my experience has only been with Access so far, and for situations where only I could modify the database. ...

Hi I want to do a query where I make totals of colums , and insert these totals into another table. for example : SELECT sum(val1) AS tot_1, sum( val2 ) AS tot_2 FROM tableA ;

has anyone here been successful creating a DSN for MySQL on Citrix Metaframe and Windows 2000? aslo - what MDAC version of MySQL ODBC driver is version 3.51? thanks, mcnews

Retracing my problem leads me to believe I never successfully created fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL manual and was able - or so I thought - to create them, however, my fulltext search queries fail in 3.23.58 but the exact queries (with same data) work perfectly in 4.0.10. --...

I have 2 tables related by an id 1) id bigint(20) unsigned url text 2) site bigint(20) unsigned word text

8Zcc ----uMyItidGBFcIxNvn7Ubo Content-Type: text/html; Content-Transfer-Encoding: quoted-printable <html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE= : 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar= ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE= CORATION:...

Sunday August 03 2003 15:47, =3D?iso-8859-1?Q?Kevin_=3DD8stmark?=3D wrote to All: is> Does newer versions MySQL support words with Scandinavian letters is> like is> =91, =9B, =86, =94, =84 etc in full-text searches? Those have nothing to do with ANSI.

I have these 3 errors and below are lines 17-19. Any suggestions what I am forgetting? Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/---/public_html/----/register2.php on line 17 Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in...