MySQL Database Forum

I have a created a table 'data' with two columns: id, name. +-------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+---------------+------+-----+---------+----------------+ | id | int(11) | | PRI | NULL | auto_increment | | name |...

Hi, I am trying to help my hosting company figure out how to support my db. I have a huge db, and they did not set up their box to have a large enough temp(?) space for mysql to play in. As such I was getting weird index corruptions. They are telling me that they cannot reorganize their disks, since there are other users on that machine....

Hi all, Very new to MySql so I hope this is not too obvious! I am getting the following error message when I am trying to load a script ‘ERROR 1064 (00000) at line 20: 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 'collate latin1_bin default NULL )...

Hi All, We've only used MySQL in a very cursory way supporting PHP scripts running on a server. We now have a requirement to write an application that shares data using a centralised repository. The application will be written in Java and we may potentially use MySQL as the data store using JDBC drivers to bridge the two. One of the key...

Anyone with any experience with MyODBC 3.51 linking MySQL tables to MS Access 97 please tell me how I can clear the miscellaneous, failed setup attempts from under the Machine Data Source tab on the Select Data Source window? Everytime I clicked "NEW", trying variations of configuration options in hopes of making it work resulted in a new...

Hi there, I need help extracting data from three seperate tables. The Tables look like so: Courses Table: COURSE_ID | SUBJECT_TITLE | DESCRIPTION Scheduled_Courses Table: SCHEDULE_ID | START_DATE | END_DATE | COURSE_ID | INSTRUCTOR_ID

I'm wondering, in the I18N'ized version of our application, if someone is running it, say, on a French system, where certain characters have accent marks, and such characters are saved into a MySQL database from Java Strings that go into Varchar fields, do I need to process those Strings in any fashion before/after they are moved to the...

Is there a MySQL commad to determin what table type existing tables in a database are?

How do i display a date as a new column 7 days after the initial timestamp eg current timestamp = 20050310000000 if i add 7 days to this won't it result in 20050317000000 eg SELECT *, DATE_FORMAT('%d/%m/%Y' , (dateAuthorised+7)) as expiryDate I know this is the wrong approach as the timestamp 20050330000000 would cause an error

TOAD for MySQL

I have a mysql 3.5 server installed on a suse linux 8.1, with address 10.0.0.100. Now I want to access that db from a W2K pc, address 10.0.0.200. I am able to ping 10.0.0.100, but I cannot connect to the db, and get error 2013. I have tried with MySQL Administrator 1.0 and also with ODBC. The db on linux has grant all on *.* to ''@'10.0.0.%'...

I'm running 3.23.54 on Windows 98. I cannot access any tables of a database which previously worked fine and suddenly broke. I get Error 1017 errno: 2 from both mysqlcc 0.9.4 and mysqlc. The system complains that it cannot find any of the .MYD files, although they are clearly there. The file system is perfectly analogous to other databases in...

Can someone help me to define a format of a database, or a table that has a field that will have tables in that field? Please look at the example and explanation below: Table: Roster --------------------------------------------------- |User Name | User ID | Status | Daily Activity Log |...

Ive been asked to write an application that can discern what numbers have been dialed on a telephone. I know nothing of this, except that there is some sort of hardware that can do an INSET to a MySQL database somehow. Has anyone ever heard of such a creature? -Ike

Having my SQL-background in Oracle I'm looking for the MySQL equivalent for: update tableA set column1=(select count(*) from tableB where tableA.key= tableB.key) cannot find anything similar in the manual, but probably overlooking something. TIA

I run a query on a 3 million rows table (avrg row length 2988) as below: SELECT COUNT(*) FROM tbl WHERE MATCH (col) AGAINST ('keyword'); The query above took from 5 - 10 seconds. Below is MySQL (version 4.1.11) configuration: -------------------------------------

Hi Everyone, I wrote a for loop to build several select statements that are combined with a UNION. When I execute one of the queries separately, it works, but when I execute the query with a UNION it returns: ERROR 2013 (HY000): Lost connection to MySQL server during query I am able to run additional queries after I get the error, so the...

Hi, Is there a site that anyone knows of, that shows creating a MySQL database from input through output is concerned? I'd LOVE to see a tutorial that included the interface for input, the usable MySQL database and then the query potential (including query interface). I'm new to MySQL and haven't been able to find much on the internal...

M. Michael DYSON DIRECTEUR-ADJOINT SOCIÉTÉ DE SÉCURITÉ SARL. TEL.00229 20 21 80 Cotonou République du Bénin Email:michaeldyson2005@latinmail.com Bonjour . Je sais que mon message sera d’une grande surprise quand t-il vous parviendra. Donc, je vous présente toutes mes excuses. Je vous écris sincèrement dans le but d’obtenir votre...

----E1580888A67AFBA079 Content-Type: text/plain; charset="US-ASCII " Content-Transfer-Encoding: quoted-printable If it seems to you like most good jobs are not within your reach that's pr= obably because you lack a post -graduate education. We can fix that ;) http://sphinx.bbb999.biz

Hi.. I am new to MySQL and database. I would like to create a database for an online system. May I know are there any GUI tools for database creation? Is MySQL Query Browser suitable as query editor? I m currently using win XP as my OS. Regards,

Hello there, I'm looking for a tool that does for MySQL Db's what Access does for Jet DB's. Therefore provides a nice gui to speedup certain tasks and produce entitiy relationship diagrams. Is there a market leader in this field? Do people have recommendations? I'm actually looking into using Visio for creating my diagrams but it

Homeowners - do you have less-than-perfect credit* We'll quickly match you up with the B.EST provider based on YOUR NEEDS. Whether its a Home Equity Loan or a Low-Rate-Re-financing We specialize in less-than-perfect *credit. We'll help you get the YES! you deserve.

How do you write a query which will stop ans wait for user input? Stan

I have a mysql database with a list of companies who supply specific products tblSuppliers (simplified) sID | sName | goodsRefs 1 | comp name | 1,2,3,4,5 2 | company 2 | 2,4