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

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_

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

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

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 --

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

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: 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: 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: 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: 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: 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

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: 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...

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.

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: 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

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: 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.

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

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

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

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

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: 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

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

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

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

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

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]