MySQL Database Forum

Hi everyone, I am having what I hope is a very simple problem getting started with mySQL. I had the server running earlier this morning and everything seemed fine. But I had to unistall it for some reason (I can't even remember why now!) The problem is, the new installation won't work - the service won't start. It doesnt give any more...

Hi folks, how would you design a 1:1 relation ? I'd like to split an entities's attributes because they won't get equally frequently requested. So I can save memory and disk access time. The integrity of the splitted record should be retained. The key points would be:

MySQL 4.0.13-nt I have a table: CREATE TABLE state_county ( StCo_key bigint(20) NOT NULL auto_increment, State varchar(255) NOT NULL default '', County varchar(255) NOT NULL default '', Territory bigint(20) NOT NULL default '0', Hits bigint(20) NOT NULL default '0', PRIMARY KEY (StCo_key,State),

------=_NextPart_000_4BC8_01C34EFD.A4A62470 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I am trying to report a bug, and I would like to compile mysql with = debugging enabled to provide further information, but I receive compile = errors. I would like to resolve the compile errors...

Hi - I have an application which is essentially 'read-only' - once the database is loaded it is only read from. So, I am trying to implement it with various indices and a table containg some large content in blob columns. I observe the max_allowed_packet setting and 'split' blobs too large among multiple rows. All is fine during testing....

I installed the current stable release of MySQL from RPMs. I used the client and server packages. After installing the server package, the RPM printed a note saying I should run two commands. I only got the first one, which was # ./mysqladmin -u root --password I assume this gave the root user a password. I then downloaded and proceeded...

------=_NextPart_000_0001_01C34D7B.DFBF53C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, =20 I was reading the manual and it said that the subselect is only

Hello, I'm currently porting an application using some other DB to MySQL. The database in question has several tables with foreign key relations. The application is written such that, on table INSERTs, if a foreign key relation is violated, the error message is parsed for the particular relation that is violated. As a simple example, say...

------=_NextPart_000_0008_01C34E11.3CC415C0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Good day list, I hope that this is an easy one for you guys to help me with, I am relatively new to DB design, and I realized that I have left out a few very important Indexing and counting columns.

Is there a way to reference the 'primary key' field of a record you are actually inserting at the moment. Im using an 'int auto increment' field as the primary key. I could reference it with a select statement and adding a 1 to the last record's primary key. However, there must be a better way to do this - what if someone adds a record...

--------------000209050009010900080700 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit how do you make a socket or use unix_socket etc. The basics? -- G Gill <mailto:gurvinder@sikhcom.net>

This is probably easy, but I just can't to put my finger on it. I have a list of numbers (i.e. 1 to 175) and I want to do a select statement to get the highest number. I have tried the limit thing but not getting the right output. Can someone shed some light on this? TIA -- MySQL General Mailing List

------=_NextPart_000_002B_01C34DF8.C34C94F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Assistance required. I have 3 tables:

------=_NextPart_000_002B_01C34DF8.C34C94F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Assistance required. I have 3 tables:

is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I mean a pretty chart type schematic :) Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

I know this is quite a bit off topic, but i was wondering if anyone else out there had any experience with Segue's Silk Performer load testing tools. More specifically, i am trying to compile a test script to allow me to perform some transactional database testing to load test a MySQL 4.0.13 database server running behind some apache...

is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I mean a pretty chart type schematic :) Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw

I know this is quite a bit off topic, but i was wondering if anyone else out there had any experience with Segue's Silk Performer load testing tools. More specifically, i am trying to compile a test script to allow me to perform some transactional database testing to load test a MySQL 4.0.13 database server running behind some apache...

Hi, I'm clear as to what is meant by "The mysql client" in the MySQL core certification revision check list. I understand that the mysql database itself is the "server". Would client then be any program that talks to the server? Perhaps it is referring to mysql, the command line tool? I understand "client side programs", examples being:...

I create a database, foo, then designate a user, pooh, with full privileges, including grant option (pooh is to administer this database, including creating other users): grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant option; Now pooh logs in to the mysql server, and tries to use his grant option

------=_NextPart_000_00E2_01C34DE9.4541BA40 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit Hi, I need a hint how to use myisamchk I use this syntax in a shell but it doesn't work

------=_NextPart_000_004A_01C34E06.17F4DF00 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable this is a test message ------=_NextPart_000_004A_01C34E06.17F4DF00--

Hello, I not sure if this is the right place to ask this... I am using mysql. What I need is a SQL statement that can find what years are in the database that is greater than last year. For example... I have a table full of dates ranging from 2001 to 2005..

By convention, MySQL is installed on the SYS: volume... I know you can move the whole data subdirectory... however can you have the different databases stored on different volumes... windows version uses a "sym" file... is there a similar feature for Netware?

Paul, I just picked up your book today: MySQL Cookbook and I just wanted to comment on how great it is. I've spent hours at the bookstore looking through mySQL books, and by far this is the best one I come across. I strongly recommend it to anybody--Beginners, Intermediate, or Advanced Users.