Re: ON UPDATE CASCADE fails

I forgot to mention that I am using mysql 4.0.14-nt on Windows 2000. --Fraser -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

reindexing

I just did a major insert of new data and now all my selects have slowed down. The table is innodb. Is there a way to reindex everything without having to drop anything. Otherwise, I suppose I will have to drop the indexes and remake them. -- MySQL General Mailing List For list archives: http

Mysql won't install (crashes) on Red Hat Enterprise Linux 3 Beta 1 (Taroon)

When installing the rpms (or the tar file) onto Red Hat Enteprise Linux AS Beta 1 (Taroon), we get the follwing error: Installing all prepared tables /usr/bin/mysql_install_db: line 1: 7690 Segmentation fault /usr/sbin/mysqld --bootstrap --skip-grant-tables --basedir=/ --datadir=/var/lib/mysq

ON UPDATE CASCADE fails

Hello, I have a table which has a foreign key relationship with itself. I want and expect my updates to cascade (deletes definitely cascade as expected) but instead I just get error 1217: foriegn key error. I have written example code to use in reproducing the problem: # Create the table drop

RE: basic SQL question

>> How I can get the right one? Depending on your goal, which was not given here. I recall in my earlier career, in the computing center there was a banner saying: "I wish they could sell this computer: It never does what I want it to do, only what I tell it to do." The result you got was intrins

Re: storing large integers properly

* Eben Goodman > I am storing book isbn numbers in a table. isbn numbers are 10 digit > numbers and many start with 0. The data type of the field I am storing > this info in is a bigint(16) unsigned. Why not use "BIGINT(10) UNSIGNED ZEROFILL"? > It appears that isbns that start > with 0 are goi

storing large integers properly

I am storing book isbn numbers in a table. isbn numbers are 10 digit numbers and many start with 0. The data type of the field I am storing this info in is a bigint(16) unsigned. It appears that isbns that start with 0 are going in as 9 digit numbers, the 0 is being ignored or stripped. I h

RE: Load data infile issue

On 5 Aug 2003 at 11:16, "Montagna,Dan" <[EMAIL PROTECTED]> wrote: > Thanks Keith, that got me past the first two queries but I'm now > getting an " Invalid DATA LOAD query" . Someone told me that the > "load data infile option is not always on by default. Is there a > piece of code I need to in

column privilege problem--Solved

I solved the problem--I needed ( ) around the column list. I think the manual should make that more clear. Original Message Subject: column privilege problem Date: Tue, 05 Aug 2003 15:39:54 -0700 From: Tiffany Wilkes <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Hi, I am having

load data infile problem

Hello, I'm a very new mysql/php user and am trying to use the load data infile command without luck. I'd like to replace a table using a text file but can't get it to work. I set up a test table with no records using a telnet console. I'm trying to write a php page that takes the file on the se

Library database help

Hi all. I am trying to build a small simple database for a lending library. Basically, I have a table of resources to be lended out, and a table that will store a user's name and what they have borrowed. My problem is that we may have more than one copy of a given resource say a book. So I thou

Re: Lowering the ft_min_word_len

At 10:30 -0700 8/5/03, Justin Hopper wrote: Hello, I have a table with a FULLTEXT index on a column of type 'text'. Searches on this table using MATCH() AGAINST() work fine for most words. However, I needed to match against a 3 letter word. So I lowered the ft_min_word_len to 3 in /etc/my.cnf.

RE: win200 - lost root privilege - cannot shutdown - need help

thanks. I wanted a confirmation. I did it and moving on installing v4.0.14 -Original Message- From: Frank Tanner III [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 1:19 PM To: [EMAIL PROTECTED] Subject: Re: win200 - lost root privilege - cannot shutdown - need help Right click

Re: Load data infile issue

On 5 Aug 2003 at 9:37, Montagna, Dan wrote: > $result = mysql_db_query('$sql_id',"DELETE FROM tablename") or die > ("Invalid DELETE query"); It's helpful to print mysql_error() when you have an error, so you get a message more specific than "Invalid DELETE query". In this case, you're trying t

Multiple table joins in a select

Ver. 3.23 How do I write a select query to join more than two tables? Table A relates to table B and table B relates to Table C. I need to return fields from Table A and C that are related.. Thanks, Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: replication w/o stopping the master

See the command LOAD DATA FROM MASTER ( http://www.mysql.com/doc/en/LOAD_DATA_FROM_MASTER.html ). This should do what you want - it does it for me. As I understand it, this puts a read lock on each table as it copies it. This provides some interruption to service, but nothing like a stop/start.

Re: load data infile problem

I'm using some default table names and such here...my actual code has the appropriate table, server, un, pw etc...

table size in mysql

hello. how many records can i put in a mysql table. i need a table with more than 50,000,000 records (just 4 short fields, it's basically a log with id,action,date,result). What do you think? thanks in advance!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: table size in mysql

* NEWMEDIAPLAN > how many records can i put in a mysql table. As many as you like, pretty much. The total file size could be delimited by your OS, but this can be dealt with using MERGE tables (splitting a single table in multiple files) or InnoDB tables (with multiple table spaces). > i need a t

Re: alter date

On Tue, 5 Aug 2003 11:41:21 -0300 Fabio Bernardo <[EMAIL PROTECTED]> wrote: > Hi there, > Do you know a sql command which I can write to obtain the last date that I > updated a table > SHOW TABLE STATUS LIKE 'yourtable'; fabrizio -- MySQL General Mailing List For list archives: http://lis

Re: Searching on Two Keys with OR?

On Tue, 5 Aug 2003, Alexander Keremidarski wrote: > MySQL will never use any index for small tables. With just few rows using index > adds overhead only. Table scan is faster in such cases. This is docummented > behaviour. is 100,000 rows small? my simple OR queries take longer than a second. my

Re: load data infile problem

Montagna, Dan wrote: Hello, I'm a very new mysql/php user and am trying to use the load data infile command without luck. I'd like to replace a table using a text file but can't get it to work. I set up a test table with no records using a telnet console. I'm trying to write a php page that ta

Re: storing large integers properly

How about BIGINT(10) ZEROFILL ? Eben Goodman wrote: I am storing book isbn numbers in a table. isbn numbers are 10 digit numbers and many start with 0. The data type of the field I am storing this info in is a bigint(16) unsigned. It appears that isbns that start with 0 are going in as 9 di

Re: Searching on Two Keys with OR?

You are ORing on two different fields. The index cannot be used to check the value of z for an OR. Why are you cross posting? Joshua Spoerri wrote: On Tue, 5 Aug 2003, Alexander Keremidarski wrote: MySQL will never use any index for small tables. With just few rows using index adds overhead

Re: mysql 4.0.1-alpha

"Morten Gulbrandsen" <[EMAIL PROTECTED]> wrote: > 7.5.5.2 Foreign Key Constraints > > Hi programmers, > > I try to code this > > CREATE TABLE EMPLOYEE > ( > FNAME VARCHAR(15) NOT NULL, > MINIT CHAR, > LNAME VARCHAR(15) NOT NULL, > SSN

Replication question

I have connect my web server (master) to my local server (slave) through dial-up and replicate 2 databases. a) Is there a log file describing the replications that happend (if any)? b) how do I know when to stop the dial-up so not to stop any data transfer through repliication? Thanx Nikos --

mysql 4.0.1-alpha

7.5.5.2 Foreign Key Constraints Hi programmers, I try to code this CREATE TABLE EMPLOYEE ( FNAME VARCHAR(15) NOT NULL, MINIT CHAR, LNAME VARCHAR(15) NOT NULL, SSN CHAR(9) NOT NULL, BDATE DATE, ADDRESS VARCHAR(30), SE

RE: Problems with spatial extensions

Enrique, Your English is great so don't apologise! Looking on the web site at http://www.mysql.com/doc/en/Spatial_extensions_in_MySQL.html , it appears that this feature was introduced in server version 4.1, so I'm afraid you'll have to upgrade your server. Best regards, Andy > -Original M

data type matching / composite key / index name

I have a problem that has raised a couple of questions. SITUATION: I have a table called pr_persona that has a composite key comprising pr_persona_db CHAR(2) pr_persona_id INT(11) auto increment On a separate table, rv_reservation, I have a foreign key that links to pr_persona as follows rv_

Problems with spatial extensions

Hi, I would like to have a column of a table of the type GeometryCollection, but when I try to type a simple example like the ones in the manual, I get this: mysql> CREATE TABLE geom (g GEOMETRY); ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL se