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
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
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
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 I
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
What is
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
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
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:
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 with:
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
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 query
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.
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:
Doing so
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
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
Rather
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
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
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 PROTECTED]
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 |
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. 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
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
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:
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,
Hi.
You forgot around temp example:
mysqlselect 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 bellow.
I have a (probably dumb) question.
My table temperatura has two fields described bellow.
snip
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
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? Roughly 10^9.
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 describe
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 data
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
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 ?
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
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 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 suggest
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 date
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 of
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
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
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
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.
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:01
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
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
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, is
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
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,
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
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,
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 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
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
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:
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]
* ICQ:
Satish:
You can see how much space is used (among other things) with a query
like:
show table status from database 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
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
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
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
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
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
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
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
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 created
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
63 matches
Mail list logo