Hi,
> -Original Message-
> From: Guido Sohne [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 6:54 AM
> To: [EMAIL PROTECTED]
> Subject: MyODBC BDE invalid configuration error (BDE Error 12550)
>
>
> We're running a MySQL 3.23.47 server on Windows 98, and when trying to
> c
On Fri, Feb 08, 2002 at 06:10:34PM -, DL Neil wrote:
> There are some RDBMS-es that implement SQL to the point of apparently setting up a
>construct that links tables -
> foreign key based data integrity being the first example that springs to (my) mind.
>However relational logic
> suggests
Hi, Fellows!
Sorry for my poor english. Thats why I can explain myself properly.
:- )
What I really want is a calculate column with consecutive numbers from to
, where can be any number, and depending on the result of the WHERE
clause. I need to print pay orders for students, this pay order
I have the below query that returns the correct records but the
POINTFUND.description field is all NULL while it has values in the table.
Any idea why? Thanks.
SELECT
RACES.RACE_ID,
RACES.sequence,
TYPES.typelong,
SCHEDULE.event,
SCHEDULE.date,
PARTY.lname,
POINTFUND.description
FROM
TYPES LE
Hi,
If you have a table with at least the number of rows that you want in your
series
you can do this.
Set @Colnum := 0;
Select @Colnum := @colnum+1 as colnum from tablename limit (number of rows
required);
set @column := 0;
If you want a series starting from a value other than 1, initialize
On Friday 08 February 2002 16:32, Gurupartap Davis wrote:
> Yes, I saw that before...My filesize was limited to 2GB before, but now
> with a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB
> data file now, right?
>
> So something's wrong... as I said before, I have successfully crea
Our backup software can run a shell script before it starts the
backups (and another script when they're finished); I use a script
that shuts mysql down and runs myisamchk. Originally it was using
myisamchk --safe-recover */*.MYI
Then I was eyeballing the online documentation for myisamchk an
Yes, I saw that before...My filesize was limited to 2GB before, but now with
a 2.4 kernel and reiserfs I _should_ be allowed to create a 20GB data file
now, right?
So something's wrong... as I said before, I have successfully created a 9GB
file on this machine before, so the filesystem isn't to b
Hi,
I am using MySql 3.23.47 for nt (W2000).
The number of rows of my table on an NTFS file system is estimated to become
around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295
with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60;
Following this, SHOW TABLE STATUS st
Can't connect to local MySQl server through port 111
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMA
>Description:
When loading initial data from a text file, mysql looks for
libncurses.so.4, doesn't find it and quits the command with
an error. This happens under Red Hat Linux 7.2, because it
has libncurses.so.5.x.
>How-To-Repeat:
This must be done on a sy
At 15:08 -0600 2/8/02, José Angel Blanco Linares wrote:
>Hi, everybody
>
>How can I get a numeric column from a SQL SELECT statement?
>I mean, with a SELECT get something like this
>
>ColNum or ColNum
> 1 10
> 2 11
> 3 12
> 4 13
> 5
John Ericson <[EMAIL PROTECTED]> writes:
> I've a compiled MySQL and I need to know if it support unixODBC (Is
> configured with --with-unixODBC=...). Is there anyway I can see which
> configure options that was used to produce the binary?
Look for MyODBC - there is a link at the MySQL web page
Satish:
You can see how much space is used (among other things) with a query
like:
show table status from like 'Syslog';
Increasing the maximum table size is a little more complicated and
depends on what OS and table type you're using.
Eric
> -Original Message-
> From: Satish Santhak
On Feb 08 23:40, John Ericson wrote:
> Hi,
>
> I've a compiled MySQL and I need to know if it support unixODBC (Is
> configured with --with-unixODBC=...). Is there anyway I can see which
> configure options that was used to produce the binary?
>
>
> --
> * John Ericson [EMAIL PROTECTED]
> * IC
Hi,
I've a compiled MySQL and I need to know if it support unixODBC (Is
configured with --with-unixODBC=...). Is there anyway I can see which
configure options that was used to produce the binary?
--
* John Ericson [EMAIL PROTECTED]
* ICQ: 7325429 JID: [EMAIL PROTECTED]
* web: http://john.pp.s
I'm brand new to the list so forgive me if this has been covered (didn't
see it in the archives). Have recently installed V 3.21 onto a Windows 2k
Pro system with no web services running and Outpost Firewall v1.0.1220.2238
.. Last night I notices that MySQL-nt.exe was sending data out over por
According to the manual it should in fact be possible to enforce foreign key
constraint in MySql if both the referreing and referred tables are of type InnoDB. But
I haven't been able to, make the foreign keys work, they did'nt blok any insertions.
Are foreign keys still only for compability, o
Hi guys,
I am not able to insert into the MySQL database
anymore. I think it has reached the table size. How do
i check the size to see if it has reached the table
size? Also let me know how to increase the table size
in case it is reached the limit.
Thanks,
Satish
=
The only person in the
hi all,
This question is a little like the suse update.
But perhaps I could find answer.
I have a mandrake distrib with rpm support, u know that mandrake is derive
from redhat.
Can I install a mysql 4.0.1 package on it ?
thanks.
a+.
Hi, everybody
How can I get a numeric column from a SQL SELECT statement?
I mean, with a SELECT get something like this
ColNum or ColNum
1 10
2 11
3 12
4 13
5 14
6 15
... ...
Some time ago, someb
Hello to all,
I'm trying to make a query with only one command but I can't see how to do
it.
Supose that are 2 tables like:
table QA table QB
ref text ref text
--- ---
a1 texta1 b1 textb1
a2 texta2 b2 textb2
a3 texta3 b3 textb3
Depends on the install. The rpm from mysql will install to /var/lib/mysql
The worst of it, most linux default installs, /var is the smallest
Unknowing to myself, I had a database running away, default installs the
both of them (well default then some modifications )
about 2 months later, CRASH!!
Hello,
I hope this isn't too far afield of the list discussions but here goes.
I'm trying to fashion a query against a MySQL database. There are three
tables that are relevant. They are:
listing (ID, OfficeID, CatID, SubID, Visible, Deleted)
category (ID, Name)
subcategory (ID
On Fri, Feb 08, 2002 at 09:09:39PM +0100, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
This 'anti-spam' measure,
I'm trying to figure out the bloody hell you're looking for.
What is date3? Where does it come from?
I think I speak for most folks here when I say...
What is date4? Where does it come from?
What is date4? Where does it come from?
Why is record 2 good, but not record 3?
How does Phase enter i
I am trying to run a query I have a table Records
|Record_ID|
|Phase_ID |
|Record_Date|
I need to find the records that have a record date between date1 and
date 2 but exclude the records with
Hello!
I've been trying to install the binary distribution of MySQL MAX
4.0.1 but have spotted a problem: The directory structure is completely
different to my existing SuSE 7.0 MySQL 3 installation!
Is there any script that would upgrade my old installation to
MySQL MAX 4.0.1 in
At 13:22 -0600 2/8/02, BD wrote:
>At 10:34 AM 2/8/2002 , you wrote:
>
>Quite often I'd like to duplicate an existing table using SQL.
>Normally I'd do a
>
>create table NewTable select * from OldTable;
>
>and if I don't want any data transferred I'll slap on a Limit 0 on the end
>of the statement
At 10:34 AM 2/8/2002 , you wrote:
Quite often I'd like to duplicate an existing table using SQL. Normally I'd
do a
create table NewTable select * from OldTable;
and if I don't want any data transferred I'll slap on a Limit 0 on the end
of the statement.
This works fine except it doesn't creat
Ferreira,
[I have posted this back to the list. There are many others who will be able to help -
some from Portugal. Also
I have noticed questions and comments from many people working on
collections/libraries of CDs, videos, books,
etc]
> Thack for all that knowleg... ( wisdonw )
> pardon my e
Joe,
When you start mysql (presumably with safe_mysqld), you must tell it
where your datafiles are.
Try bin/safe_mysqld --datadir=/var/lib/mysql/mysql
Eric
> -Original Message-
> From: FISHER,JOE (Non-HP-Roseville,ex1)
> [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 11
For the slice servers, you simply assume that if one is lost, you lose X%
of the data until it is revived, which is usually not even noticable by
the end user. For the aggregators, we had four behind a load-balancer.
In practice, we had nearly zero downtime over a roughly 18 month period.
james
It is not platform-specific so much as installation-specific. Typically, it would be in
/usr/local/mysql/data/ but that's again entirely dependant on what install you have. A
quick "locate
mysql | grep data | more" should reveal the locations of all your database files
quickly. If you
didn't alr
I have a crashed computer and need the mysql databases recovered.
What is the default installation directory and default database
directory for mysql on Mandrake 7.2?
Jonas Fornander - System Administrator
Netwood Communications, LLC - www.netwood.net
Find out why we're better - 310-442-1530
Hi Jim,
Welcome to our relatively?relationally happy band.
> This is my first post to the list. I've been working on MySQL now for about a
> week and really like it. I have a question that I can't find in any of the
> books or how-tos.
A whole week and no post...
> When I add a line to my custo
Jim,
What you're asking about is the "timestamp" data type.
Look at : http://www.mysql.com/doc/D/A/DATETIME.html
In a nutshell, if you assign 'null' to a timestamp column it will put in
value of 'NOW()'.
Eric Mayers
Software Engineer
> -Original Message-
> From: Jim Hatridge [mailt
At 17:40 + 2/8/02, André Ferreira wrote:
>Hello ppl.
>I am playing hard with mysql, cause my ultimate objective is to make a big
>databank for a game.
>
>I notice that i cant find a way to make relations beteen tables.
It's called a "join". You'll find information about joins in any
number o
At 18:49 +0100 2/8/02, Jim Hatridge wrote:
>Hi all...
>
>This is my first post to the list. I've been working on MySQL now for about a
>week and really like it. I have a question that I can't find in any of the
>books or how-tos.
>
>When I add a line to my customer's table I need it to put today's
Hello André
> I am playing hard with mysql, cause my ultimate objective is to make a big
> databank for a game.
>
> I notice that i cant find a way to make relations beteen tables.
> Must i do it also with PHP ?
Just to confuse you, the mathematical jargon for table is "relation"...
May I sug
MySQL manual A.5.7 Problems with floating point comparison
=dn
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: 08 February 2002 15:24
Subject: Re: Problems with select
> 15.8 has no exact binary representation, so
Hi all...
This is my first post to the list. I've been working on MySQL now for about a
week and really like it. I have a question that I can't find in any of the
books or how-tos.
When I add a line to my customer's table I need it to put today's date in the
"indate" column. Is there anyway
Hello again,
In reply to all the suggestions made, here it goes one more mail. I hope it
will be helpful.
(André, isto vai em ingles que é para o pessoal perceber ;)
Suggestion 1:
>Float aren't really searchable in Mysql. You may need to do some casting,
>not sure how to do it on top but i re
Hello ppl.
I am playing hard with mysql, cause my ultimate objective is to make a big
databank for a game.
I notice that i cant find a way to make relations beteen tables.
Must i do it also with PHP ?
Thanck for the tips.
And if i am rigth, my dont gays put so relation ?
--
I got mysql-3.23.47-sun-solaris2.8-sparc.tar from
mysql.com, then I untarred
it into /mysql.
Then I enter /mysql and did ls:
# ls
binincludescriptssql-bench
tests
data libshare
support-files
#
What should I do to set it up now? I
Hi,
Is there a way of knowing with wich options mysql was compiled ?
Thanx,
--
Diana Soares
(sql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the l
At 08:12 AM 2/8/2002 , you wrote:
>Hi, sir/madam:
>
>I'm new to MYSQL. I'm now doing my final year project,
>and intend to use mysql as the database system.
>
>I installed the version mysql-3.23.46a-win and
>myodbc-2.50.39-nt on my computer for testing.
>
>I would like to download a MYSQL GUI for
15.8 has no exact binary representation, so a test for equality will fail.
Do not use floating point if you want to test for equality. Try DECIMAL
Miguel Figueiredo wrote:
>Hello all,
>
>I have a (probably dumb) question.
>My table "temperatura" has two fields described bellow.
>
>mysql> descr
Ooops, factual error:
> > If, say, Google, can search 2 trillion web pages, averaging say 70k
> > bytes each, in 1 second, and Mysql can search 22 million records, with
> > an index on 40 bytes each, in 3 seconds (my experience) on a good day,
> > what's the order of magnitude difference? Roughl
> I have a (probably dumb) question.
> My table "temperatura" has two fields described bellow.
>
>
>
> When I try to select rows with floats, the result is an empty set.
This is not a MySQL problem, nor a database one, but a general computer
science one. It is
almost never save to compare two
Hi.
You forgot "" around temp example:
mysql>select datetime,temperatura from temperatura where
datetime="2002-02-08 09:30:00" and temperatura="15.8";
Regards
/PM\
Miguel Figueiredo wrote:
>
> Hello all,
>
> I have a (probably dumb) question.
> My table "temperatura" has two fields described b
Harald,
I tested now with the official Linux binary of 4.0.1 (not -max) and it
worked ok on our dual Xeon Linux-2.4.16-SMP-64GB. I did not define any
InnoDB startup options in my.cnf.
When you recreated the InnoDB data files, did you remember to remove the
.frm files of the InnoDB tables t1, t2,
I might add this bit of information.
What i was trying to do worked with
version 3.23.37
It did NOT work with
version 4.0.1-alpha-nt
Regards
Jostein
- Original Message -
From: "Jostein Solstad" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 3:45 PM
Subject:
We're running a MySQL 3.23.47 server on Windows 98, and when trying to
connect to BDE version 3.0 (bundled with Borland C++ Builder 1) using
MyODBC version 3.51 we get something like
Invalid configuration parameter:
Alias: database_alias
BDE Error 12550 [0x31][0x6]
I've search
Hello. I was adviced to write to you about this from an experiensed mySQL
user, as this might be a bug in 4.0.0
Im trying to do this:
select col1,col2,col3,'text' as name from tabel where blahblah
now, this would add 'text' to all rows in the result, and that works just
fine
but, if i try with '
I want to thank everyone for their contributions on this thread,and
especially Erik for posting the question.
I'm in the middle of the problem, and was about to write excessive code
using Erik's suggestion No.1.
Thank you, thank you to all.
- Original Message -
From: "Erik Price" <[EMAIL
Hello all,
I have a (probably dumb) question.
My table "temperatura" has two fields described bellow.
mysql> describe temperatura;
+-+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+-+--+--+-+
not the exact equivalent but if you are looking at a query like:
select * from mytable where rownum=8;
you can do :
select * from mytable limit 7,1
select query ..
[LIMIT [offset,] rows]
http://www.mysql.com/doc/S/E/SELECT.html
- Original Message -
From: "Ramaraju.R.V" <[EMAIL PROTECTE
Sommai,
Friday, February 08, 2002, 8:28:50 AM, you wrote:
SF> Hi,
SF> I have some text file (10MB per day) might be keep for a year. I have
SF> been keep it in compress format (using WinZip). When I need to see detail
SF> I have been open it and find something I want to see. If I de
Harald,
I tested the below with 3.23.48, and it worked ok.
Could it be that you have not used DROP TABLE or DROP DATABASE to remove
InnoDB tables? Then the internal data dictionary may be out-of-sync from the
.frm files of your tables.
Please use innodb_table_monitor (section 9.1 in
http://www.
On Mon, 4 Feb 2002, Matthew Walker wrote:
> I need to find a text editor for Linux that doesnt load the whole file
> into memory. I need to edit a 1.5 gig text flatfile to add two lines.
> But I dont have enough ram to open it in most programs. Can anyone
> recommend something?
man sed
Rath
On Mon, 28 Jan 2002, David S. Jackson wrote:
> I'm just starting my first MySQL db, and I'm going to want to
> print out reports from it and produce a camera-ready document.
> Has anyone done this before, using, say, Star Office or AbiWord
> or something?
David,
I go this way for high quality o
Surprisingly it is mote than 64 KB! (I count strlen=74KB)
Bravo!!
Makis
> -Original Message-
> From: savaidis [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 08, 2002 9:08 AM
> To: [EMAIL PROTECTED]; 'Nathan'
> Cc: 'MySQL'
> Subject: RE: long query on php
>
>
>
> Just a comment:
Hi!
On Feb 07, Alain Fontaine - Consultant and developer wrote:
>
> <-- snip -->
> select
> BienID
> from
> biens
> where
> MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE)
> <-- snip -->
>
> This does not produce the correct result, whereas this does:
>
> <-- snip -->
Demirchyan,
Thursday, February 07, 2002, 8:39:05 PM, you wrote:
DOA> There used to be a section in mysql documentation, which explained about all the
DOA> entries in my.ini file. Do you know what happened to it?
DOA> There is a part about my.cnf but that's not what I want. There was more.
L
Tshering,
Wednesday, February 06, 2002, 7:29:11 AM, you wrote:
TN> Dear list,
TN> I have a telephone database which has "Name" as one of the fields/columns.
TN> This field contains single name e.g Robert, double names e.g Robert
TN> Downing and more than double names. I want to make a SELECT
Joachim,
Thursday, February 07, 2002, 11:18:43 AM, you wrote:
JH> I am using the following versions of mysql on suse linux 7.2:
JH> frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
JH> server: version 3.23.47
JH> If I try to use the GRANT com
Andre,
Thursday, February 07, 2002, 8:57:51 PM, you wrote:
AS> Ok.
AS> My hardware hangup and i installing a new server.
AS> Howto i restore from tape to a new instalation.
If you did backup using mysqldump, you should use mysql client.
If you did direct backup of data files, you should go wit
Hi,
I seem to be having a problem with a corrupt table.
# myisamchk --fast --silent /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: MyISAM file /var/lib/mysql/HNCandidate/Candidate.MYI
myisamchk: warning: 1 clients is using or hasn't closed the table properly
myisamchk: error: Recordlin
Yesterday, from Brian DeFeyter:
> Has anyone made a suggestion or thought about ways to distribute
> databases which focus on fulltext indexes?
>
> fulltext indexes do a good job of indexing a moderate amount of data,
> but when you get a lot of data to be indexed, the queries slow down
> signifi
Tuesday, from Matt Rudderham:
> Hello, I have two tables in my database as such:
>
> CREATE TABLE `skill_names` (
> `id` bigint(20) NOT NULL auto_increment,
> `name` varchar(30) NOT NULL default '',
> PRIMARY KEY (`id`)
> );
>
> CREATE TABLE `skills` (
> `skills_id` int(11) NOT NULL aut
I said:
> > Why is it that Altavista can index terabytes overnight and return
> > a fulltext boolean for the WHOLE WEB
> > within a second, and Mysql takes so long?
On Friday 08 February 2002 08:56, Vincent Stoessel wrote:
> Apples and oranges.
Yeah, I know. But let's see if we can make some d
Thanks Nathan,
I think I will go with
"SELECT * FROM table_name WHERE Name LIKE
> '%$name%'";
NOBBY
- Original Message -
From: Nathan Bank <[EMAIL PROTECTED]>
To: Tshering Norbu <[EMAIL PROTECTED]>
Sent: Friday, February 08, 2002 12:25 PM
Subject: Re: SELECT query with TRIM and LIKE
>
> Why is it that Altavista can index terabytes overnight and return
> a fulltext boolean for the WHOLE WEB
> within a second, and Mysql takes so long?
I don't know about Altavista, but if you read up on Google, they do indeed
do some sort of
spreading of keywords across multiple machines - last
2 queries with left outer join will do the trick.
select a.id,b.id from a left outer join b on a.id = b.id where b.id is NULL;
this will give a list over all fields that exist in table a but not in table
b
select a.id,b.id from b left outer join a on a.id = b.id where a.id is NULL;
this will giv
hi List
The problem is like this
There are two Tables A and B.
what i want to do is find out all the records where a.id != b.id
Both tables have close to 1 records. so for every a.id it has to
check table b 1 times and that is what is creating problems.
bcos this query takes hell lot
Just a comment:
Doing so it's possible to insert a line between $query.. statements.
(comments ecc) Its very simple to write it with copy+paste and I prefer
this.
Thanks.
PS. I'll check the string limit and I let you know. I think it has to be the
64KB.
I think only Visual Basic has this hig
77 matches
Mail list logo
