Grant,
>From my old relational database days we'd create a table of courses and
index this so it could be linked from your semester table. This way, you'd
have a single entry for each course. Should the course change, the
maintenance nightmare is alleviated by only having to change the course
en
I should have mentioned the error:
[kryten2] ERROR 2013: Lost connection to MySQL server during query
- Original Message -
From: "Michael Piko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 29, 2003 9:01 AM
Subject: Querying a Linux machine
> I have mysql on a Linux m
Hi everyone!
My silly questions for today concern the not-silly-at-all InnoDB table
backend.
1. If I do an ALTER TABLE tbl_name TYPE=InnoDB on an InnoDB table,
Heikki has
indicated that a defrag of that table should happen. Does anyone have
any comments regarding the
result of a power failure
I have mysql on a Linux machine and can connect to through 'localhost' and
its real IP/hostname. I cannot connect to it from other machines. Is there
anything I need to do to make this happen?
Michael Piko
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
* 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)="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 sepa
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
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 tha
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',
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),de
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 o
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 PROTECTE
-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 d
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 in
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 dealercode),sum
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 i
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',
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 compi
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 wil
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 w
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` int(
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 on
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 a
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 limit
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 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
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
For
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
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
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 questio
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_resulta
ou 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
and in logs).
>
> I've just got another one InnoDB crash with 2.6.0-test4.
> As in previous case there was no messages in kernel log.
> 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:/
* 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
> 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.h
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
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 h
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)
{
return(-1
* 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 (do
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
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 da
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:
> .
>
>
"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 |
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
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
http://w
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
>
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 Que
mysql> select
-> 0x+0 AS '18446744073423220462',
-> 0x7fff+0 AS '9223372036568444654 ',
-> 0x8fff+0 AS '10376293541175291630' ;
+--+--+--+
| 18446744073423220462 | 9223372036568
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
"[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 th
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.
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
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 r
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.
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
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 max_allow_pa
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 | d
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 proc
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: [EMAIL
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
www.sebastianmend
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 nu
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 i
> 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
63 matches
Mail list logo