I'm working currently on the project where we need
to make a decision what engine would be our main
production database engine.
Could you please help me and shed a light on what
pros and cons MySQL vs Ingres: features, performance,
support, portability among Wintel and Unix based
Hi,
How do we insert arbitary sized texts into MYSQL Text
fields?? Is there any way to split the text into chunks and then
append those chunks to the field???
___
Art meets Army ; Swapna Weds Capt. Rajsekhar.
Rediff Matchmaker strikes another
Hi all,
I am using Mysql-4.0.12 on my 7.1 redhat. every thing is
working fine but when i give command
#ps -ae
it shows various process including mysqld_safe and mysql . the mysqld
process are eleven in number with respective pids on my machine . I want to
know why there are large
Joseph Maxwell wrote:
Hello,
Could someone recommend a decent php script that could be used for
database[MySQL]::Web interfacing and management. Preferably open source,
freeware or otherwise [I'll just have to grin bare it]
phpMyAdmin - www.phpmyadmin.net
--
Sebastian Mendel
For arbitrary sizes of text, try the MEDIUMTEXT or LONGTEXT column
types. Data is then stored as a BLOB.
Check out the docs at http://www.mysql.com/doc/en/BLOB.html
-Original Message-
From: Sreesekhar Palaparthy [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 9:28 AM
To:
Welcome to the world of Linux!
You see, even though I love Linux to death, LinuxThreads are a bit
inferior to what everyone else has in their
OS of choice (If Xavier reads this, please don't kill me or submit some
kernel patch that will get even with me. :-) ).
LinuxThreads essentially are
Hi,
I'm having a bit of trouble with a full text search in mysql 3.23.25. I
have the following table with the following entries:
| id | document_id |document_text
=
| 19 | 1 | Konekta
| 20 | 2 | Cuentas actualizadas|
| 21 | 3 |
I wud like to rephrase my problemactually i want some
method to insert large text/binary text values into BLOB fields in
chunks , instead of inserting the values at once in entireity. So
for that , i want to know how do i append text to a field. (I can
tune server parameter
Dear MySQL users,
Is it possible to configure MySQL in such a way that the function dayname()
will return the name of the day my local language. (In my case polish).
thank you very much for help,
regards,
Lukasz
Hi,
I am currently using MySQL 4.0.14-standard along with PHP 4.3.2 in Apache
1.3.28.
I have written following code to upload some data from the hosting
directory to database table. But LOAD DATA statement always fails. I have
checked the same SQL using Sql-Front. It is showing Access denied.
I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have Query1, which returns set Result1. Inside this loop,
I run an UPDATE query which
On Thu, 28 Aug 2003 08:54:54 -0400
Mark Richards [EMAIL PROTECTED] wrote:
I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have
Hi,
I have a question. I need to store documents (100.000) and the word
containing in them.
They are two way to do the job :
1°) The documents are stored in a table 'docs' and identified by an 'docid'.
The words are then stored in a table 'docsbywords' where each pair (docid,
word) is stored.
[EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am currently using MySQL 4.0.14-standard along with PHP 4.3.2 in Apache
1.3.28.
I have written following code to upload some data from the hosting
directory to database table. But LOAD DATA statement always fails. I have
checked the same SQL
I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have Query1, which returns set Result1. Inside this loop,
I run an UPDATE query
mysql select
- 0x+0 AS '18446744073423220462',
- 0x7fff+0 AS '9223372036568444654 ',
- 0x8fff+0 AS '10376293541175291630' ;
+--+--+--+
| 18446744073423220462 |
Mark,
On Thu, Aug 28, 2003 at 09:59:18AM -0400, Mark Richards wrote:
I am still quite new to MySQL and have a basic question. I am using PHP, so
forgive me if this is more a PHP issue.
I want to perform an update to a specific record based on a condition. In
the outer loop, I have Query1,
On Thu, 28 Aug 2003 16:23:35 +0200
Fred van Engen [EMAIL PROTECTED] wrote:
You need to make a separate connection to MySQL for the outer query to
prevent the inner query from messing up the outer query's result set.
See the PHP manual for obtaining the connection id's from mysql_connect
and
Hello MySQL programmers,
suppose we have an Enhanced ER diagram,
with entities as classes/ subclasses connected through
some IS-A relationship.
How can this be Coded in MySQL Please?
My prerequisites are the basic database texts from
http://www-db.stanford.edu/~ullman/dscb.html
Antony,
On Thu, Aug 28, 2003 at 06:29:54PM +0400, Antony Dovgal wrote:
On Thu, 28 Aug 2003 16:23:35 +0200
Fred van Engen [EMAIL PROTECTED] wrote:
You need to make a separate connection to MySQL for the outer query to
prevent the inner query from messing up the outer query's result set.
Rob [EMAIL PROTECTED] wrote:
Hi,
I'm having a bit of trouble with a full text search in mysql 3.23.25. I
have the following table with the following entries:
| id | document_id |document_text
=
| 19 | 1 | Konekta
| 20 | 2 |
On Thu, 28 Aug 2003 16:37:41 +0200
Fred van Engen [EMAIL PROTECTED] wrote:
Please elaborate.
I've already answered:
On Thu, 28 Aug 2003 17:07:19 +0400
Antony Dovgal [EMAIL PROTECTED] wrote:
You don't need execute UPDATE's in the loop in this case.
Try smthing like that:
?
.
$ids =
Yes, that advice worked perfectly. Now I understand.
This is one very nice data storage system. It's fast, and it can deal with
multiple pointers - separate sessions - into the same table without
conflict. I guess it's up to the programmer to make certain that one
connection doesn't change
Antony,
On Thu, Aug 28, 2003 at 06:45:27PM +0400, Antony Dovgal wrote:
On Thu, 28 Aug 2003 16:37:41 +0200
Fred van Engen [EMAIL PROTECTED] wrote:
Please elaborate.
I've already answered:
On the list I just saw your 'bad advice' message without explanation.
On Thu, 28 Aug 2003
* Pascal Francq
I have a question. I need to store documents (100.000) and the word
containing in them.
They are two way to do the job :
1°) The documents are stored in a table 'docs' and identified by
an 'docid'. The words are then stored in a table 'docsbywords'
where each pair (docid,
Hello everyone,
I use Valgrind to check my programs and this last found leaks in
libmysqlclient.so.
My code is simple:
char * requete = SELECT * FROM NOM_TABLE_1;
MYSQL * mysql = mysql_init((MYSQL *)NULL);
MYSQL_RES * mysql_resultat;
MYSQL_ROW mysql_ligne;
if(mysql == NULL)
{
On Thursday, August 28, 2003, at 07:09 AM, Sreesekhar Palaparthy wrote:
I wud like to rephrase my problemactually i want some method
to insert large text/binary text values into BLOB fields in chunks ,
instead of inserting the values at once in entireity. So for that , i
want to know
We are currently running production on ver 3.23. We have two db servers
that are in need of hardware upgrade. DB1 replicates to DB2.
I plan on taking DB2 offline, upgrading RAM and Processors, installing
latest RH OS and MySQL 4.0. Then replace DB1 with the upgraded DB2
making it the new DB1
Hello MySQL programmers,
suppose we have an Enhanced ER diagram,
with entities as classes/ subclasses connected through
some IS-A relationship.
How can this be Coded in MySQL Please?
My prerequisites are the basic database texts from
http://www-db.stanford.edu/~ullman/dscb.html
* Harald Fuchs
[...]
4) The documents are stored in a table 'docs' and identified by a 'docid'.
The words are found by a FULLTEXT index.
The FULLTEXT feature is usefull if you don't need to search fast on 'words'
like C++, TCP/IP, IBM, XP, WIN, W2K etc. What these 'words' have in common,
is
.
You can find mysql error log here.
Re: 2.6.0-test2-mm3 and mysql
And here is another one InnoDB crash I've just got with 2.6.0-test4.
http://sysadminday.org.ru/linux-2.6.0-test4_InnoDB_crash-20030828
No messages in kernel log :((
It's a development server, so this isn't a big problem.
I do
-2.6.0-test4_InnoDB_crash-20030828
No messages in kernel log :((
It's a development server, so this isn't a big problem.
I do understand that this can easily be a hardware problem,
but the kernel silence is really sad in such case.
Memory is fine (at least according to memtest 3.0).
Any hints
Andreï V. FOMITCHEV wrote:
Hello everyone,
I use Valgrind to check my programs and this last found leaks in
libmysqlclient.so.
My code is simple:
char * requete = SELECT * FROM NOM_TABLE_1;
Looks like a misplaced '' .
MYSQL * mysql = mysql_init((MYSQL *)NULL);
MYSQL_RES * mysql_resultat;
Chris,
please send your messages to [EMAIL PROTECTED] The newsgroup
mailing.database.mysql is only a mirror.
- Original Message -
From: Chris [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, August 28, 2003 5:00 PM
Subject: Repeateable read isolation level question
All,
I'm looking for opinions/suggestions on a backup procedure I plan on
implementing.
All databases (DBXX) will be MySQL ver 4.0
All our applications work with DB01.
DB01 replicates to DB02.
Once a day I will Stop the slave on DB02, lock the tables, flush the
logs and perform a mysqldump of
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a
search for a common word it is very slow, for example:
select count(*) from resources where match title,keywords
against('common word');
might take over a minute if there are a 5,000 or so rows that match.
I'm looking for a way
Hi Team,
I am unable to start the mysql service at my red hat 8, below is the
error. What it is all about ?
/usr/sbin/mysqld: ERROR: unknown option '--log-bin # required
for re
plication'
030829 01:01:37 mysqld ended
Thanks in advance
Suresh A.
--
MySQL General Mailing List
Hello,
I am attempting to get MySQL to listen on a TCP socket on Solaris 8.
From what I've seen in the documentation, and my experience with MySQL
on Linux this should happen automatically. I've tried 4.0.14 from
source and binaries as well as 3.23.57 binaries without success.
If I compile with
I am running the binary installation of MySQL 4.0.14 on FreeBSD 4.8, all
MyISAM tables, and after alittle while mysqld will jump to 100% of my
CPU and go crazy. I've investigated SHOW INNODB STATUS, and as you can
see below, there is nothing happening with Innodb. Infact my Innodb
files have not
Hello-
I'm trying to get random information out of my table and the query I'm using keeps
returning the same row every time. In the table I have 3 rows and I want to choose at
random in the sql which row to return. Here's an example query I have.
SELECT * FROM banner ORDER BY rand() asc
Do you have
skip-networking
in your /etc/my.cnf file?
Scott Barron wrote:
Hello,
I am attempting to get MySQL to listen on a TCP socket on Solaris 8.
From what I've seen in the documentation, and my experience with MySQL
on Linux this should happen automatically. I've tried 4.0.14 from
source
Dear All.
I hope all is well with you.
A projects requires that for the 1st time ever for me, install a bugzilla system with
MySQL and Apache
IWhat would you recommend when it comes to installing, designing, or tips about My
SQL? perhaps stuff I should know no matter what.
I am reading
I have a table with a UNIQUE compound index, Cust_Primary that is composed
of 4 columns: Cust_Type, Area, Join_Date, Join_Time.
This index should allow for only unique entries, but it doesn't. If
Join_Time is NULL then it allows for duplicates. Why?
CREATE TABLE `CustHistory2` (
`Cust_Id`
Mark wrote:
Why don't you just always put a limit 1000 on it, do you ever need more
than that?
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a
search for a common word it is very slow, for example:
select count(*) from resources where match title,keywords
against('common
Hi Nick,
This is due (so I am told) to a problem in FreeBSD threads. I have
this happen once in a while also. There have been some threads
changes for 4.9 but I am not sure there is any change in this.
The common suggestion is to compile with LINUXTHREADS option using the
ports tree. This
Ken,
Thanks for the response. I really wish MySQL AB would compile FreeBSD
binaries with LinuxThreads. It's really a pain when you find a bug, the
first thing they ask is have you compiled this yourself when in this
case you have no choice but to compile it yourself.
Maybe Jeremy could
In the last episode (Aug 28), mos said:
Example. Join_Time is usually NULL (but not always). I've discovered that
if Join_Time is NULL, MySQL allows for duplicate rows! !
Data:
Cust_Type, Area, Join_Date, Join_Time
'BIG', 'N', '2003-01-01',NULL
'BIG', 'N', '2003-01-01',NULL
'BIG', 'N',
Because his query only returns one record. A limit wouldn't make any
difference.
John Larsen wrote:
Mark wrote:
Why don't you just always put a limit 1000 on it, do you ever need
more than that?
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a
search for a common word it
Hey y'all - I have been at this too long today - this is driving me nuts!
Table:
Date (y-m-d),amount (decimal),dealercode
I am looking for a query that will give me the sum of each of the distinct
dealercodes for a specific date range.
Something to the effect of:
Select (distinct
Hi Jay,
There seemed to be a problem with the first use of RAND() on new
connections (is this in a script?). It was supposed to be fixed in a
recent version of MySQL (I think in 3.23.56 and 4.0.10). Anyway, the
workaround I discovered to work is to just call RAND() at least once
before using it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pascal, et al --
...and then Pascal Francq said...
%
% Hi,
Hi!
% I have a question. I need to store documents (100.000) and the word
% containing in them.
%
% They are two way to do the job :
[snip]
What about a third way? One table for the
Hi,
I have a table with a date field (called myDate for example) formatted like
-xx-xx.
I want to do a query searching for all dates with the month of August, for
example.
How would I do that?
Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL
Mike Morton said:
Hey y'all - I have been at this too long today - this is driving me
nuts!
Table:
Date (y-m-d),amount (decimal),dealercode
I am looking for a query that will give me the sum of each of the
distinct dealercodes for a specific date range.
Something to the effect of:
Thanks to everyone that replied on and off list - off to the group by docs
;)
On 8/28/03 5:09 PM, William R. Mussatto [EMAIL PROTECTED] wrote:
Mike Morton said:
Hey y'all - I have been at this too long today - this is driving me
nuts!
Table:
Date (y-m-d),amount (decimal),dealercode
I
At 03:30 PM 8/28/2003, you wrote:
In the last episode (Aug 28), mos said:
Example. Join_Time is usually NULL (but not always). I've discovered that
if Join_Time is NULL, MySQL allows for duplicate rows! !
Data:
Cust_Type, Area, Join_Date, Join_Time
'BIG', 'N', '2003-01-01',NULL
'BIG', 'N',
On Thu, Aug 28, 2003 at 03:02:20PM -0500, gerald_clark wrote:
Do you have
skip-networking
in your /etc/my.cnf file?
Well, you can call me an idiot. Yes. I was trying to put a second test
installation of 4.0.x on while we are still running a 3.x series and I
forgot that we had added that
Hi,
no - adding a limit doesn't really help.
thanks,
- Mark
On Thu, 28 Aug 2003 16:12:41 -0400, John Larsen wrote:
Mark wrote:
Why don't you just always put a limit 1000 on it, do you ever need
more
than that?
Hi,
I have a fulltext index on a table with 80,000 rows. when I do a
search for a
I'm building a program calendar describing each Year's courses. I have a
field for a semester and it's current courses in one cell separated by a
,. When I go to print this out I create an array out of the cell than do
it's sorting.
Or
Should I just take the time and create a new table and
* Creative Solutions New Media
I have a table with a date field (called myDate for example)
formatted like -xx-xx.
I want to do a query searching for all dates with the month of
August, for example.
How would I do that?
SELECT datecol FROM mytable WHERE MONTHNAME(datecol)=August;
59 matches
Mail list logo