Hi there,
I'm cleaning up MySQL permissions on one of my servers, and I see that in the
mysql.host table, there are 8 rows. All 8 rows contain specific hosts in the 'Host'
column (i.e. no wildcards) and specific databases in the 'Db' column. Further, all
rows in all privilege columns in the hos
On Thu, 9 Jan 2003 22:56:04 +0200
"Gelu Gogancea" <[EMAIL PROTECTED]> wrote:
> > All this is very interesting, BUT i have two binary builds (4.0.7 &
> 4.0.8),
> Ha,Hayou are gentle.
>
> > (load avg 10-60 Query/sec), and 4.0.8 crash (in some
> > hardware/software) after 2 seconds work :(
>
Colaluca, Brian wrote:
I have come to a brick wall on one facet of my design, however. I've come
to understand that having a lot of NULLs in your database may be a sign of a
poor design. And yet I'm having a problem reconciling this with the wildly
un-uniform world of wines from around the worl
Blend will be a cross reference with a one to many relationship
This is very simplified but an example of your data could be:
Select * from Wine;
++--+
| WineID | WineName |
++--+
| 1 | XYZ |
++--+
Select * from Grape;
+-+
On Thu, 9 Jan 2003, Dmitry V. Sokolov wrote:
> Good day,
> could you help me to solve this problem?
>
> MySQL server segmentation faults when remote mysql client
> tries to connect on source and binary distributions. Local
> client connect does not cause any problems whatsoever.
The server dies
On Thu, Jan 09, 2003 at 01:51:20PM -0300, Maximo Migliari wrote:
>
> What were the main benefits that you noticed straight away before
> adapting your code to use the new features that MySQL 4 offers?
Replication is faster in 4.0. That's a big win for us, as we use
replication pretty heavily.
>
Thanks, Gerald,
I'm trying to install the MySQL. Apache & Php in Windows 2000 Professional. A
book telling me that I should install them in the above sequence. Actually the
error message is before the installation of Apache, is it the root cause?
Should I try again after I start the server?
Hello,
I am a new user to MySQL. I need innoDB's transaction and row locking
feature in MySQL. Could someone clarify whether the latest 3.23.54a of
MySQL fully supports innoDB transaction and row locking or do I have to use
beta/gamma version of MySQL 4.0.x. Thanks in advance.
R.T.
-
Ah, I see. Was unaware of this new feature, and thanks for the
explanation.
-Nick
On Thu, 2003-01-09 at 17:20, Stefan Hinz, iConnect (Berlin) wrote:
> Nick,
>
> > CREATE DATABASE LookAtMe;
> > the database is created but as:
> > lookatme
>
> This is not a bug, but a feature. By default, MySQL 4
Rick Tucker wrote:
This is the code I'm using. I'm pretty new to PHP, so there may be a simple
solution within PHP of which I'm unaware. I just thought it could be done
from the MySQL side of things.
I think the point is more that there's no reason to have MySQL do it at
all since the logic
There are a few solutions out there for you. I recommend you check out
RRDTOOL,
and associated packages at
http://people.ee.ethgz.ch/~oetiker/webtools/rrdtool/ and also look for a
took called cactus, it absolutely rules. THere are others, but rrdtool,
has a myriad of contributed packages it can w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christopher E. Brown wrote:
Description:
MySQL 4.0.8, both compiled my me and the official release version
crashes whenever receiving a network connection from a system without a DNS
entry. Connecting from a system that resolves on reverse (eithor f
I'm currently using Red Hat 7.1. I have loaded the apache, php, and mysql
rpm. I seem to be having trouble starting MySQL. It gives me the following
error: Can not connect to localhost MySQL server through socket
/var/lib/mysql/mysql.sock (111). Can some help me, please?
__
mysql:ÄúºÃ!
±±¾©Èݳ½×¯Ô°ÆÏÌѾÆÓÐÏÞ¹«Ë¾ÀÏ°å¶Îº£ÈÝÏÈÉú£ºÄúÊÇÃÀ¹ú»ªÒá´óÀϰ壬ÄúÊÇÉí¼Û¹ýÒڵĴ󸻺À£¬ÄúÊDz»»áÔÚºõ¶ÔÄúÀ´ËµÇøÇø¼¸ÍòÔªµÄÇ·¿î
µÄ£»È»¶ø£¬ÕâЩǮ¶ÔÓÚÑÛÏÂΪÖβ¡ÒÑÇîÀ§Áʵ¹ÓÖÉí»¼°©Ö¢µÄÑîÏÈÉúËûÃÇÀ´Ëµ£¬¼ÈÊÇËûÃǵÄѪº¹Ç®£¬¸üÊÇËûÃǵľÈÃüÇ®¡£Äú²»Êdz£Ëµ£º×öÉúÒâÒ»¶¨
ÒªÏÈѧ»á×öÈËÂï¡£ÇëÇóÄú·¢·¢´È±¯£¬·
Hello ,
GG> Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If
GG> this functions didn't find an entry for the client, will be crashed.
GG> I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i
GG> don't see nothing about it.
#> uname -a
Linux gap 2
Hi :
I am trying to calculate the time span of listing a large table database in mysql and
I run into trouble where I am trying to use curtime() - value stored in startime.But I
do not know how to get the stored value out from startime.Does anybody knows how I can
get value out from startime wh
At 10:29 -0600 1/9/03, Meena Vyavahare wrote:
Here is my query-
Select col1, col2, count(*) as total, count(col3 < col4) as violations
from table1
Where condn
group by col1, col2
The result of this query shows same values at both the columns for total
and violations.
The count(expr) does not wor
Maybe if we knew what . . . . . . . . . . means, we could answer.
[EMAIL PROTECTED] wrote:
Hey all;
I am trying to work on a query that has SELECT DISTINCT * ..
This does not work. While there is no error, the where clause causes repeats. I
do not really expect this to work, as DIST
Hey guys,
I've just installed mysql from source 4.23.54a
But after
./configure --prefix=/usr/local/mysql
make
make install
I makes an error that there's no mysql user .. so I created one !
And I changed the owner of /usr/local/mysql/var/ and recursively to
mysql:mysql . now it gives me
On Thu, Jan 09, 2003 at 08:55:36AM +, mysql list wrote:
> Hi,
>
> I was wondering if anybody has built MySQL 3.23 from source that can
> handle a high number of connections & threads. I've have tried MySQL
> binaries in the past (not RPMs), but these have had stability/load
> problems. When bu
Paul,
>> Personally, I regard this security
>> "improvement" rather a bug than a feature.
> The implementation certainly is problematic, but the underlying
> issues that it tries to address is definitely real and not to be
ignored.
> People who say otherwise generally don't understand what those
automake: strings/Makefile.am: Assembler source seen but `CCAS' not defined
in `configure.in'
automake: strings/Makefile.am: Assembler source seen but `CCASFLAGS' not
defined in `configure.in'
error: Bad exit status from /var/tmp/rpm-tmp.37688 (%build)
RPM build errors:
Bad exit status from /
Dear Readers,
Over the last week there have been a series of messages posted to this
list that were off-topic, inflammatory and often offensive.
Our list manager contacted the offending parties and requested that they
stop their abuse of the mailing list. When this failed to stop the
postings, th
Rafal,
> alter table rezerwacje add foreign key (nip_h,nrpok_p) references
> pokoje(nip_h,nrpok_p);
> ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150)
Most probably, you are using MySQL >= 4.0.1 but < 4.0.5. I had these
kind of problems with ALTER TABLE with 4.0.1 and 4.0.4, b
Dmitry,
> MySQL server segmentation faults when remote mysql client
> tries to connect on source and binary distributions. Local
> client connect does not cause any problems whatsoever.
I had the same sort of problem with MySQL 3.23.5x servers on SuSE Linux
8.0/8.1, and some newsgroup postings re
Nick,
> CREATE DATABASE LookAtMe;
> the database is created but as:
> lookatme
This is not a bug, but a feature. By default, MySQL 4.0.x has
lower_case_table_names set to 1. If you want to change this behaviour,
put this in the [mysqld] section of your c:\my.cnf or c:\winnt\my.ini
file, and resta
Jennifer,
> Why would they have to do that? The file does not need to be in that
> directory. In order to use LOAD DATA INFILE without LOCAL the file
just
> needs to be somewhere on the server that mysqld is running on
Exactly this is the point. Most ISPs (at least all the big ones who
offer MyS
Paul,
>>It's a rather old book, which deals with MySQL 3.23, and not with
MySQL
>>4.x.
>Actually, he's talking about MySQL Cookbook (p549). Which is a new
book,
>which is why I said *may* reset the counter rather than *will*
>reset the counter as was true in older versions of MySQL.
Oops. Sorry
Frank,
> Since I have limited command line access (ISP hosted database), I will
> probably have to use phpMyAdmin.
> Part of my logic was to copy my MySql database to another MySql
database,
> so that I can use the second database for QA purposes.
> When I perform the Export as above, does that ma
Rafal,
I tested also with the `hotele`, and it worked ok.
Please provide your my.cnf and MySQL version number. And test if you can
repeat the error.
Regards,
Heikki
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.8-gamma-standard-
Hi all,
I'm trying to figure out a way to select a group of maximums from a set
such that each value pair's greatest value is in the result set. For
example, let's say I have this table Value_Pairs:
Name | Value
Bob1
Joe7
Bob2
Don3
Don4
Bob6
The result I wan
cacti?
cheers
David Ziggy Lubowa
Network Engineer
One2net (U)
web: www.one2net.co.ug
Tel: +256 41 345466
-Original Message-
From: Shon Stephens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 8:55 PM
To: '[EMAIL PROTECTED]'
Subject: mysql monitoring?
is there an snmp mib o
On 9 Jan 2003, at 10:29, Meena Vyavahare wrote:
> Select col1, col2, count(*) as total, count(col3 < col4) as violations
> from table1
> Where condn
> group by col1, col2
>
> The result of this query shows same values at both the columns for total
> and violations.
> The count(expr) does not work
Rafal,
- Original Message -
From: "Rafal Jank" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, January 09, 2003 6:18 PM
Subject: Bug in foreign keys
> Hi!
> I have two tables:
> CREATE TABLE `pokoje` (
> `nrpok_p` char(10) NOT NULL default '',
> `nip_h` int(10)
> All this is very interesting, BUT i have two binary builds (4.0.7 &
4.0.8),
Ha,Hayou are gentle.
> (load avg 10-60 Query/sec), and 4.0.8 crash (in some
> hardware/software) after 2 seconds work :(
If i understand well it crashed even if no one is connected ?
Regards,
Gelu
___
I am in the midst of designing a personal database for keeping track of
wines. After perusing through several beginner books on MySQL and PHP, I
have decided that my next step would be to embark upon database design.
My design is almost complete and normalized, although I do expect to be
making
On Thu, 9 Jan 2003, Paul DuBois wrote:
> Date: Thu, 9 Jan 2003 11:29:03 -0600
> From: Paul DuBois <[EMAIL PROTECTED]>
> To: Maximo Migliari <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Version 4 "safe" to use?
>
> At 13:51 -0300 1/9/03, Maximo Migliari wrote:
> >What were the main benefi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dmitry V. Sokolov wrote:
Good day,
could you help me to solve this problem?
This is a known issue that is already fixed in the BK source for 4.0.x,
and will be in 4.0.9, which is currently being built.
-Mark
- --
MySQL 2003 Users Conference -
Hello Gelu,
>> No, the glibc gethostby* will walk the tree defined in hosts.conf,
>> normally files,dns. A non-find in /etc/hosts followed by a >NXDOMAIN
GG> If you said soanyhow gethostby* is used by DNS and no reverse.
GG> The Name Server(named) use this both functions depending by the ord
Hi,
Start mysql daemon with options "--skip-name-resolve"
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Dmitry
sql,query,queries,smallint
> No, the glibc gethostby* will walk the tree defined in hosts.conf,
> normally files,dns. A non-find in /etc/hosts followed by a >NXDOMAIN
If you said soanyhow gethostby* is used by DNS and no reverse.
The Name Server(named) use this both functions depending by the
On Thu, Jan 09, 2003 at 10:48:18AM -0800, [EMAIL PROTECTED] wrote:
> It seems odd to me that the data type "Year", should only allow the limited
> range of 1901-2155.
> i understand that this is so that it will store in 1 byte, but whats the
> point?
> i wanted to use a year field for historical da
Hello David,
DL> is there an snmp mib or something available for snmp to monitor mysql
DL> server? or, does anyone have a script that they would like to share that
DL> they use to monitor and gather statistics about mysql?
MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS us
Hello
I have a fixed width csv file. To import it I use the
following statement -
load data local infile 'F:/Documents and
Settings/Insane/Desktop/test.csv'
into table `insane`.`user_details_copy` fields escaped
by '\\' enclosed by
'' terminated by '' lines terminated by \n' IGNORE 1
LINES ( id,
On Thu, 9 Jan 2003, Gelu Gogancea wrote:
>
> Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If
> this functions didn't find an entry for the client, will be crashed.
> I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i
> don't see nothing about i
If you have a CGI script with 700 permissions, that script cannot be
accessed by the Apache server unless that server is running Apache SUID,
meaning that your own account runs the web server.
In most cases Apache is run by its own account.
In this case, if you will set the permissions for the fil
I've written an article on using Ruby to write programs that
access MySQL databases. The article is available here:
http://www.kitebird.com/articles/
I'd be interested in feedback, especially corrections if there
are errors.
-
I have downloaded the ODBC driver and while I am fumbling [still
reading] about that the reference it makes if for *.MDB similar
extensions. I have cruised through the on-line manual and still
have no idea how to create one of those type extensions with a
MySql database.
I am sure it is in
Functions gethostby* ,from glibc, work directly with the /etc/hosts file.If
this functions didn't find an entry for the client, will be crashed.
I try to find in the Andrew e-mail if he has installed the glibc 2.2.x but i
don't see nothing about it.What i see is, he use 2.95.x which is declared by
All the test I've made shows that the first query is faster .
I can't believe my eyes.
Andrea
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
On Thu, 9 Jan 2003, Gelu Gogancea wrote:
> Hi,
> This is a glibc problem.In this case you can start mysql daemon with option
> "--skip-name-resolve" and in this situation is no need to add the IP address
> of every client in hosts file.The disadvantage is that the client can not
> connect to the s
Thanks everyone for your input.
Stefan,
> >From, within phpMyAdmin?
1. In the left frame, choose the database you want to backup / copy.
2. Click the EXPORT tab in the right frame.
3. Choose the tables in the database you want to backup.
4. Choose "Structure and data".
5. Check "Enclose table an
I'm not shure, but i think that at least your read_buffer_size and
sort_buffer_size values are too high!
> key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3415663 K
> bytes of memory
How much memory does that machine have ?
You can modify those values in your mysql confi
At 7:54 -0800 1/9/03, [EMAIL PROTECTED] wrote:
Hey all;
I am trying to work on a query that has SELECT DISTINCT * ..
This does not work. While there is no error, the where clause causes
repeats. I
do not really expect this to work, as DISTINCT needs a column to work with.
No, it doesn'
Hi,
This is a glibc problem.In this case you can start mysql daemon with option
"--skip-name-resolve" and in this situation is no need to add the IP address
of every client in hosts file.The disadvantage is that the client can not
connect to the server using host alias.
Regards,
Gelu
_
Your mysql server does not seem to be running...
Did you execute safe_mysqld ?
Check the "Post installation setup" chapter from the manual.
http://www.mysql.com/doc/en/Post-installation.html
On Thu, 2003-01-09 at 01:16, [EMAIL PROTECTED] wrote:
> Dear Editor,
>
> After installed the MySQL versi
At 13:51 -0300 1/9/03, Maximo Migliari wrote:
What were the main benefits that you noticed straight away before
adapting your code to use the new features that MySQL 4 offers?
Does the query cache make a big difference?
Oh, yes. It does. :-)
Do you have any benchmarks, even off your head?
the example will connect to the local mySQL server and create a new
database named 'dbname"
#!/usr/bin/perl -w
use DBI;
$dbh = DBI->connect( "dbi:mysql:", 'user', 'password', {
PrintError => 0 } ) or die "Can\"t connect to database:
$DBI::errstr\n";
$dbh->do("create database dbname");
$dbh->dis
Am Donnerstag, 9. Januar 2003 15:28 schrieb Csongor Fagyal:
> Hi,
>
> Sorry if this had been asked on this list previously.
>
> If you had an auto_increment field in a table (let's name it "id"),
> previously (in 3.23.x, 4.0.x) the following (legal) SQL statement
> resulted in a "duplicate key" err
Good day,
could you help me to solve this problem?
MySQL server segmentation faults when remote mysql client
tries to connect on source and binary distributions. Local
client connect does not cause any problems whatsoever.
-
Bef
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe s
> At 16:11 +0100 1/9/03, Rafal Jank wrote:
> >Hi!
> >I have two tables:
> >CREATE TABLE `pokoje` (
> > `nrpok_p` char(10) NOT NULL default '',
> > `nip_h` int(10) NOT NULL default '0',
> > `lozka_p` char(2) default NULL,
> > `tv_p` char(1) default NULL,
> > `lazienka_p` char(1) default N
Hi,
I recently upgraded from 4.0.4 to 4.0.7 .
I keep getting the following error message when a executing a query:
ERROR 1104 at line xx : The SELECT would examine too many records and
probably take a long time. Check your WHERE and use SET OPTION
SQL_BIG_SELECTS=1 if the SELECT is ok.
The proble
It seems odd to me that the data type "Year", should only allow the limited
range of 1901-2155.
i understand that this is so that it will store in 1 byte, but whats the
point?
i wanted to use a year field for historical data, such as the year famous
people were born, such
as abe lincoln - 1809, but
At 16:11 +0100 1/9/03, Rafal Jank wrote:
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p` int(10) default
On Thu, 9 Jan 2003, Gelu Gogancea wrote:
> Hi,
> What OS you use ?
>
> Regards,
>
> Gelu
> _
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
> [EMAIL PROTECTED]
> - Original
Ha ha, thank you for "page 558" but I am blind and I am reading the
electronic version of the book.
However, I think I've reached to page 558 because I've seen how to do it.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "Paul DuBois" <[EMA
I've read more messages from Apache users list and the Apache experts say
that if the web server is run by your own account this can create more
security problems.
I don't know what problems and I would also like to know but if someone
wants to know, you can subscribe to that list.
... or if someo
Yes I know that Apache can be set to run using your own account, but most
hosts don't do that because I heard that this can create other security
problems.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From: "William R. Mussatto" <[EMAIL PROTECT
Here is my query-
Select col1, col2, count(*) as total, count(col3 < col4) as violations
from table1
Where condn
group by col1, col2
The result of this query shows same values at both the columns for total
and violations.
The count(expr) does not work
Thanks
Meena
---
Hi,
Try to start mysql daemon with "--skip-innodb" and see if the problem
persist.I suppose is something wrong with your my.cnf configuration.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
You can do the same thing in Win32 using a vb script. Just use the Run
command of the shell object to run mysqldump.
This is the way I back up our database to text files that get burnt into a
CD.
HTH
JFernando
** sql **
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent
At 13:18 +0200 1/9/03, Putte Koivisto wrote:
Is there any easy way to delete records from database, wich logs user
activity at website? I mean, if there is somekind of limit for rows in
table. And if limit is exceeded, older rows will be automaticly deleted, or
even better, moved to another table.
At 15:28 +0100 1/9/03, Csongor Fagyal wrote:
Hi,
Sorry if this had been asked on this list previously.
If you had an auto_increment field in a table (let's name it "id"),
previously (in 3.23.x, 4.0.x) the following (legal) SQL statement
resulted in a "duplicate key" error:
UPDATE whatevertable
Hello Gelu,
GG> Hi Andrew,
GG> I can not reproduce your case.For me work good.The only difference is that i
GG> use source distribution and you use a binary distribution.
GG> Please take a look in mysql log and tell me what you see there.
GG> Regards,
030108 20:12:09 mysqld started
030108 20:12:
Hey all;
I am trying to work on a query that has SELECT DISTINCT * ..
This does not work. While there is no error, the where clause causes repeats. I
do not really expect this to work, as DISTINCT needs a column to work with. I
am trying to avoid the workaround of putting in every colum
What were the main benefits that you noticed straight away before adapting
your code to use the new features that MySQL 4 offers?
Does the query cache make a big difference? Do you have any benchmarks,
even off your head?
Maximo.
At 09:47 8/1/2003 -0800, you wrote:
On Wed, Jan 08, 2003 at 09:0
Hello,
Can someone give me a some overview information regarding using SSL with
MySQL version 4? I want to setup a 128bit SSL connection between our website
hosted at an ISP and our MySQL (on FreeBSD) server which is hosted in our
office. Basically I want the same level of security that we curren
Cute =)
(MySQL sql query queries smallint =)
Aaron Krowne
On Thu, Jan 09, 2003 at 04:36:12PM +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 w
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p` int(10) default NULL,
`zaliczka_p` int(10) default NULL
On Thursday 09 January 2003 09:32, Sal wrote:
> Thaks 4 ur info. Where can I get MySQL 4.1.0.
You can compile it from development source tree:
http://www.mysql.com/doc/en/Installing_source_tree.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This emai
On Thursday 09 January 2003 13:18, Putte Koivisto wrote:
> Is there any easy way to delete records from database, wich logs user
> activity at website? I mean, if there is somekind of limit for rows in
> table. And if limit is exceeded, older rows will be automaticly deleted, or
> even better, mov
On Thursday 09 January 2003 03:16, seed dot chan at citicorp dot com wrote:
> After installed the MySQL version 3.23.53, I tried to test the MySQL by
> typing the following command, relevant error message appears, please advise
> how to fix.
>
> Command: Display Error Message:
>
>
Using Linux Slackware and gcc 3.2.1.
Here is the compiler report:
make[4]: Entering directory `/home/local/src/mysql-4.0.8-gamma/sql'
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DHAVE_CONFIG_H -
EMS HiTech company is announcing the next version (1.96) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
We're also announcing a special offer! If you purch
USE substring_index function
Example:
mysql> select substring_index(name,' ',3),name from test1;
+-+---+
| substring_index(name,' ',3) | name |
+-+---+
| a b c | a b c d e |
| a b c
Hi,
Sorry if this had been asked on this list previously.
If you had an auto_increment field in a table (let's name it "id"),
previously (in 3.23.x, 4.0.x) the following (legal) SQL statement
resulted in a "duplicate key" error:
UPDATE whatevertable SET id = id +1;
Will this be fixed in 4.1.x?
I answered this yesterday.
Your FROM must precede your WHERE.
Terence Ng wrote:
How do I correct this SQL code:
2 tables there,
lcopen: id, bank, unit_price_us, order_cbm
lcreceive: id, amount_us, due_date
#this condition :lcreceive.due_date < current_date
#only affect to : SUM(lcreceive.amou
What OS are you running?
Did you start the server?
What is in the error logs?
[EMAIL PROTECTED] wrote:
Dear Editor,
After installed the MySQL version 3.23.53, I tried to test the MySQL by
typing the following command, relevant error message appears, please advise
how to fix.
Command:
Hello,
I set up a replication architecture with MySql
everything works fine.
Now I concentrate on log-bin file and I have a question
I have understood (I hope... )
-that I can set a max_binlog_size,
-that a new file (extension n+1) will be used while reaching max_binlog_size,
-that the slave
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Larry, et al --
...and then Larry Brown said...
%
% I appreciate that the guy wants to build traffic on his list, but I have to
Except that it isn't a list :-) But, yeah, I do as well.
% say that I enjoy having this list as busy as it is. People
On Wed, 08 Jan 2003 09:09:02 -0700
Mariella Di Giacomo <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>
> I would like to ask three questions related to MySQL and MERGE tables.
>
Hi!
This list is dedicated to the internal functioning of MySQL server.
For the questions like above, please write to
Hi,
What OS you use ?
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Andrew Sitnikov" <[EMAIL PROTECTED]>
To: <
Normalisation was not the right word. Each row has only two columns - "id" INT
and "description" VARCHAR. So the rows did not, indeed could not, contain data
relating to more than one entity.
It was the /table/ which contained mixed data. The description column had data
for two different cat
Is there any easy way to delete records from database, wich logs user
activity at website? I mean, if there is somekind of limit for rows in
table. And if limit is exceeded, older rows will be automaticly deleted, or
even better, moved to another table.
Is there any query to make this happen?
Sinc
Hi Paul,
MYSQL AB maybe have already done something to diffuse this situation but
without to get involved this very-mega-ultra public MYSQL LIST.
And i think also is a duty of every member of this list to make all to "keep
clean" this list but without any implication of it.
I feel frustration also,
Hello,
I want to know whether the mysql depot (mysql-3.23.54a) works on
HP-UX PA_RISC2.0 or it works only on PA_RISC1.0.
If it doesn't work on PA_RISC2.0, where can I find a mysql depot
that works on PA_RISC2.0?
A quick reply will be greatly appreciated.
Thank You,
Chaitanya Atreya.
Hi,
I just want to confirm MySQL 4.0.8 seems to be broken too. However MySQL
4.1 is working fine with this testcase.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 6:32 AM
Subject: non-unique indicies in HEAP tab
Hi,
I was wondering if anybody has built MySQL 3.23 from source that can handle
a high number of connections & threads. I've have tried MySQL binaries in
the past (not RPMs), but these have had stability/load problems. When
building from source I don't have those issues, but I am limited by the
Believe that a respondent sent an email which appears to have been
bounced & deleted before I got a chance to view it. If you are the
person, please resend your response! Thank you.
===
Very complex Grouping and counting challenge
Can anyone offer guid
1 - 100 of 116 matches
Mail list logo