MySQL Database Forum

I have a database design question and wanted to see if folks could lend some advice. For simplicity sake, I'll illustrate using a book (but the hierarchy is the same in the real application - just with extra fields). A book has a title has chapters. A chapter has a title and has pages. A page has a title has pictures. A picture has a...

is it possible to compare acomma separated list aginst another eg comma list 1 => 1,2,3,4,5 comma list 2 => 3,5 can you check that 3 is in both, and 5 is in both, therfore they match??? the comparison is to check that if product a who supplies products 1,2,3,4,5 can be used instead of product b who supplies 3,5 as product a already...

I need to generate a unique no. in the format like yyyymmddxxxxxx (xxxxxx 6-digitl running number) I think of create a table with two columns date value 20050405 120 20050406 99 Everytime, the application will increase the value+1 based on the same

I have a site on a server using ASP and MySQL 3.23.54 (Cobalt Raq server) I have been asked to convert the site to Unicode and need to know: 1) If MySQL 3.23 supports unicode 2) How do I change the existing data to Unicode 3) Any more help or resources would be much appreciated. --

I am currently migrating a db from SQL Server & MySQL and ? (front end yet to be decided upon) As I familiarise myself with MySQL populating tables etc can be quite clumbersome. After reading the MySQL site it appears the "Query Browser" is the correct tool which I've downloaded, extracted and followed the instruction for installing it......

MySQL 4.0.23-standard I run an online movie database with over 80,000 movies and over 500,000 people stored within. We use tables like `movies`, `people`, etc. for storing the actual movie information, a short plot summary, etc. These tables are MyISAM. For information like who directed or produced a movie, we have tables like...

I am setting up a huge database in mysql, and I get the above error in Linux. I believe it is related to the size of one of my tables, which is 4,294,966,772 bytes in size. Can someone help. How can I break that barrier. A google search did not turn up anything useful. -- Posted using the http://www.dbforumz.com interface, at author's...

Sorry ffor the O.T. post here. But, as you can see, its not without some relevance to a large number of you who frequent this excellent forum. I'm new to PHP as I am to MySQL. My hope is that I find sources as knowledgeable in their specialties as I have in this forum.

Does MySQL support GUID and UUID column types? Thanks, Matt

Hi all, I cannot find MySQl performance info at linux "top" command. I already tested on slow MySQL query that took more than 5 minutes (create fulltext index), but during the 5 minutes, i cannot find any mysql process at top command. Below is the system information: Linux version: 2.6.9-1.667smp (Red Hat 3.4.2-6.fc3) MySQL version:...

I'm new to MYSQL, having just finished my website. I have 1 thing left to try and do to make the site experiance as seemless as possable, but to do it I figure I need to do some sort of mysql programming. Following is a post I made elsewhere. "I use phpnuke platinum (asfar as I can tell its phpnuke but with some addons). I am adding the...

I am new to Linux and am migrating a SQL Server DB with an Access front end to MySQL and ? What options are available under Linux for development of a client front end without copious amounts of programming. Without knowledge of PHP can a front end be developed using plugin components with minimal fuss ?

I'm just rewriting some backend management pages, in fact rewriting the whole database too. One of these pages has a simple HTML form to edit existing rows. I don't want to populate the form beforehand with all existing data. I just want to check which of the 20 fields have changed and update the data accordingly. Before (I wrote the script...

Summary (still get coffee) explanation: I have added a new "Sessions" table to a DB because the original design could not handle a scenario where an entity "class" had a number of sessions. Originally there was just one class which would be attended by people, as they got more popular they had to split out classes over different sessions...

Using MS Access, I have attached to MySQL servers in other states and other countries on the other side of my router. But when I use the MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN, the driver tells me it cannot make the connection. Here are the ODBC driver connection parms: Data Source Name: (free field - name my "my...

Hi All, I'd like to develop something which has a concept like the folders-and-files in your PC. A folder can have subfolders and/or files. The subfolders themselves have the same characteristics. This characteristic can also be found in Google Newsgroup, aka Usenet. A group can have many postings and many other groups.

Hi Gurus I am new to mysql. I need to select the lowest number from seven fields where the value is greater than 0. Can someone tell me how to do this. So far, I have Select RF1, RU1, ItemName FROM TABLE UNION Select RF2, RU2, ItemName FROM TABLE UNION Select RF3, RU3, ItemName FROM TABLE UNION

I'm supposed to set a password for the MySQL root user. The output of mysql_install_db instructed me to run the following commands... /usr/bin/mysqladmin -u root -h appserver password mynwewpasswd I did. It did not work. Here's the error: /usr/bin/mysqladmin: connect to server at 'appserver' failed error: 'Host 'appserver.crci.com' is not...

I have a database named credifree. I did it with mysql's create command. Yet, I can find no files on my linux box except for a\ directory and a gif file that have the name credifree. Why? What's the name mysql might have made a database file under? Where is it stored? Just curious. xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx...

Dear all, I have a database in which one column is titled 'force'. Now that this has become a reserved word, virtually no commands will execute, including of course a query to change the column name. Any ideas? Thanks in advance, James Boulter

can anyone share the best way to retrieve from a normalized db? My goal is to get the engines.eng_definition. Here's what I have: thehub: 1N --------- 1)item_no carinfo: 2n ----------

Hi All Found that when I executed my DDL script on a Win32 installation of MySQL (v4.0.18) it converted all of my table names to lowercase. The problem was that after I had filled the newly created DB with content, backed it up and then restored it into my ISP's unix version of MySQL my web app couldn't use any of the tables because I was...

I try to get better performance by implementing this: http://dev.mysql.com/doc/mysql/en/alter-table.html "ORDER BY allows you to create the new table with the rows in a specific order. Note that the table does not remain in this order after inserts and deletes. This option is mainly useful when you know that you are mostly going to query...

I want to use mysql clustering , could suggest which version of mysql server include this function ? 4.0 or 4.1 ? binary version ? thx

I have MySQL server 4.0.12-standard installation. How can I upgrade to 4.1.10-standard version? Of course I can always build a brand new server with a new 4.1.10 install. But other than that final option, is there any other option available to upgrade my database? Thanks, Yasaswi