Verified. this is a bug
empty table or 1 record returns expected result, insert one more record and
the result of now() is empty.
mysql> select now(), count(*) from t where a in (2);
| now() | count(*) |
| 2001-04-21 08:12:03 |0 |
1 row in set (0.00 sec)
mysql> inser
I wrote:
>This USED to work, then all of a sudden for no apparent reason it has suddenly
>decided not to:
Notwithstanding it used to work, it would _appear_ that calling mysql_free_result()
willy-nilly was the cause:
mysql_query(&mysql, theSql);
res1 = mysql_store_result(&mysql);
if(res1)
{
Hi:
There are several scripts available at mysql download site that convert
access database to an sql dump which you can import into mysql. the sql
dump should contain sql for creating tables so you don't have to create
tables by yourself. You need to create a database if you want to import
the ta
At 9:55 PM -0400 4/20/01, Jason Lam wrote:
>Hello!
>
>Let's say I have a DATE field and in the dataset, I got some dates such as
>
>2000-01-01
>2001-02-01
>2001-02-05
>2001-02-06
>
>How would I be able to just select all the 2001-02 entries?
>Obviously, the month and the year are the same, but t
Hello!
Let's say I have a DATE field and in the dataset, I got some dates such as
2000-01-01
2001-02-01
2001-02-05
2001-02-06
How would I be able to just select all the 2001-02 entries? Obviously, the month and
the year are the same, but the date is not, is there a mysql function to do this?
Dear Sir,
I have a great problem to install the mysql database. I follow the
instruction at the below :
1. tar -xvzf mysql-3.23.37.tar.gz
2. ./configure ¡Vprefix=/usr/local/mysql
3. make
4. make install
5. echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
6.
> Date: Thu, 19 Apr 2001 20:41:17 -0700
> From: Van <[EMAIL PROTECTED]>
>
> I might be partly responsible for this since MySQL didn't show up in the
> slackware distribution until I built one for the DEC Alpha. It's running great
> on my Alpha at version 3.23.33 and I'm staying there until the 3
G'day,
This USED to work, then all of a sudden for no apparent reason it has suddenly decided
not to:
if I change the code thus:
if(*row1[2] == 'l')
{
;
}
else if(*row1[2] == 'e')
etc.
the cgi programme completes, so I don't think the problem is elsewhere.
Is there something fundam
Larry, if you haven't resolved this yet - you might want to install from the
sources, like I do. I am also running FreeBSD 4.2, here is what I did, and
it seems to work like a champ.
1) get the source from
www.mysql.com/Downloads/MySQL-3.23/mysql-3.23.37.tar.gz
2) put this file in some directory
You need to change the "maxrows" on the table. It is in the documentation, I
dont remember the exact syntax something like "alter table tablename set
maxrows=1" for tables larger than 2gigs.
ryan
> I've got tables in ISAM format whose indexes are way over 64 MB. However,
> when I try to
Hello all
I have a simple question. I have a database in (ms) accesss that I would like to
transport into mysql database.
First of all ,do i have to create the database plus tables. then import the data .
or
could i just grab the whole database and tables with all the data inside and import
On Thu, Apr 19, 2001 at 11:37:14AM -0700, Larry Caragay wrote:
> Would anyone out there have the installation instruction for Mysql for a
> FreeBSD 4.2 box???
I've built it several times under FreeBSD 4.2. WHat problem are
you seeing?
> Larry
>
> P.S. Thanks in advance...
--
Brian 'you Basta
> -Original Message-
> From: Jeff Brewer [mailto:[EMAIL PROTECTED]]
> Sent: viernes, 20 de abril de 2001 18:24
> To: MySQL Mail List
> Subject: 64MB Limit on MyISAM indexes?
>
>
> I've got tables in ISAM format whose indexes are way over 64
> MB. However,
> when I try to create a MyISA
ews+1 where pageID='104' and
logdate='20010420';
# at 165791659
#010420 15:11:34 server id 1 Querythread_id=590431exec_time=0
error_code=0
use pollit;
SET TIMESTAMP=987804694;
UPDATE pollit.sitelog set views=views+1 where pageID='325' and
logdate='20
What's the largest possible timestamp value before it rolls over?
I'm trying to figure out what's the best way to do the following. I
have a table that has these three fields in it:
priority int(3)
end_time timestamp(14)
start_time timestamp(14)
NOTE: only start_time gets i
I have had the same problem on a Redhat 7.0 box w/2.4.1 kernel with
mysql versions 3.23.32 thru 3.23.37
The tables and databases are there and are usable, but 'show databases'
and 'show tables' return nothing. We've installed this version on
another machine and it works fine. Must be a library
Siomara Pantarotto ([EMAIL PROTECTED]) writes:
> Hi all,
>
> I am getting this error
>
> mysql> create table Product (
> -> productID numeric(10),
> -> name varchar(30),
> -> primary key(productID)
> -> );
> ERROR 1046: No Database Selected
> mysql>
>
> How do
Hi all,
I am getting this error
mysql> create table Product (
-> productID numeric(10),
-> name varchar(30),
-> primary key(productID)
-> );
ERROR 1046: No Database Selected
mysql>
How do I fix that please???
siomara
Sergei,
I wanted to say thanks so much for your help with this. I went through the
bitkeeper install, downloaded mysql 4.0, compiled under solaris 2.7, and the
process of creating the big index that took days under 3.23 took 15 minutes.
So thanks very much!
Obviously I might have tweaked some th
On Fri, Apr 20, 2001 at 03:09:32PM -0600, Jeff Shipman - SysProg wrote:
> }
> } You don't need to create another column, just use:
> }
> } ORDER BY category = 'other', category
> }
>
> Are you sure this works? My query is:
>
> select category,subcategory from categories ORDER BY
> category = 'ot
>Description:
tough one to describe. the step by step example shows all
basicly once a table gets more than 1 row and doing a select with no
result will yield a blank date... gah please see the example =)
>How-To-Repeat:
create database tmpdb;
use tmpdb;
create table test (foo int);
ins
This does not work for me. It returns syntax
errors.
Jeff Shipman E-Mail: [EMAIL PROTECTED]
Systems Programmer Phone: (505) 835-5748
NMIMT Computer Center http://www.nmt.edu/~jeff
On Fri, 20 Apr 2001, Braxton Robbason wrote:
} you want a function that prepends the letter a to the
}
} You don't need to create another column, just use:
}
} ORDER BY category = 'other', category
}
Are you sure this works? My query is:
select category,subcategory from categories ORDER BY
category = 'other', category;
And I get:
ERROR 1064: You have an error in your SQL syntax
near '= 'other
Hi,
Any round about way of achieving CHECK CONSTRAINT
FEATURE in MySQL before inserting a data into
database?
REgards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at h
Hi everybody,
Can someone help me to ungently connect to a mySQL database via java.
All I need is a code as example to look at the sintax.
I am pretty familiar with Oracle but I need to implement something this
weekend in Mysql as back end
Thks a lot
Siomara
__
Andrew Warner wrote:
>
> how do you query on a TIMESTAMP column to return all records of date today?
>
> I've been using "where date >= 20010418 AND date < 20010419" syntax
> and changing the dates as necessary, but I'd like to replace this
> with some kind of today() function.
>
> Andrew
Use
how do you query on a TIMESTAMP column to return all records of date today?
I've been using "where date >= 20010418 AND date < 20010419" syntax
and changing the dates as necessary, but I'd like to replace this
with some kind of today() function.
Andrew
On Fri, Apr 20, 2001 at 03:39:59PM -0400, Steve Werby wrote:
> "Jeff Shipman - SysProg" <[EMAIL PROTECTED]> wrote:
> > I would like to do something similar to an ORDER BY
> > in one of my select statements, but I'mt not sure
> > how to do something as complicated as this:
> >
> > I have two column
"Martin E. Koss" <[EMAIL PROTECTED]> wrote:
> I started a table with a varchar filed of 11 characters for a column that
> would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc
> I wasn't sure if a 'number' field would work. Now I want to list the
values
> in this column and they do not list
"Jeff Shipman - SysProg" <[EMAIL PROTECTED]> wrote:
> I would like to do something similar to an ORDER BY
> in one of my select statements, but I'mt not sure
> how to do something as complicated as this:
>
> I have two columns, category and subcategory, that
> I am retrieving. I would like categor
Does anyone know exactly where to put the mysql.server file? is it in /etc? When I
run it I get these
./mysql.server: @HOSTNAME@: command not found
./mysql.server: my_print_defaults: command not found
Which leads me to believe I'm doing somthing wrong.
you want a function that prepends the letter a to the category/subcategory
names that are not other. then you order by that function, but do not
display it.
select category,subcategory from foo2
order by if(category=
'other','zz',concat('a',category));
i.e. everything except other begins with an
Hi,
I started a table with a varchar filed of 11 characters for a column that
would hold data such as 0.27; 11; 0.6; 1; 5; 7.5; 11.2; etc
I wasn't sure if a 'number' field would work. Now I want to list the values
in this column and they do not list numerically, for example: if we had
0.27; 0.6; 1
>Description:
empty show tables
>How-To-Repeat:
show tables;
>Submitter-Id:
>Originator:[EMAIL PROTECTED]
>Organization:
poelzi.org
>MySQL support: none
>Synopsis: show tables return nothing. show databases too.
>Severity: serious
>Priority: high
>Ca
I would like to do something similar to an ORDER BY
in one of my select statements, but I'mt not sure
how to do something as complicated as this:
I have two columns, category and subcategory, that
I am retrieving. I would like category and subcategory
to be sorted alphabetically. This is easy wit
On Friday 20 April 2001 16:25, you wrote:
> Hi,
> I am using several mysql servers as a support for a high traffic site. The
> problem is that from time to time, and during last few days daily :,
> mysql hangs. It hangs so bad that even kill -9 can't kill it, the process
> is still there. :(
>
You may freely distribute Myodbc.dll.
I got this information from Mysql Devepolment Team.
You may include myodbc.dll in your distributing project.
For more information :
http://www.avukatpro.com/mysql.hmtl
First question's answer is : (not sure 100%)
I think you have to distibute mysql director
All,
I have several scripts (downloaded) - that have a similar error
for example..
.
perl -w enter_bug.cgi
[Fri Apr 20 07:22:48 2001] enter_bug.cgi: defined(%hash) is deprecated
at CGI.pl line 121.
[Fri Apr 20 07:22:48 2001] enter_bug.cgi: (Maybe you should just
omit the defined()?)
C
Hello,
I would recomend getting a good book that covers "Database Normalization,"
this has to do with database design theories, etc.
Or just look for a good book on "Database Design".
- Original Message -
From: SED <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001
On Wednesday, April 18, 2001, at 07:29 AM, B. van Ouwerkerk wrote:
>
>> I'm trying to install mysql onto a uniz environment.
>> I've already unzipped and untarred, and I've created
>> the mysql - version directory, but when I type
>> configure, I get a grant table failed error. I cant
>> find a
FWIW:
It also appears to me that negative one (-1) plus one (1) is ZERO (0)
which may be why you are having trouble...?
in ignorance,
haiku
On Wednesday, April 18, 2001, at 01:09 AM, Milo Stefani wrote:
> As Far as I can remember it is explicitly said in the Manual that
> inserting
> a negat
We are using a shopping cart / front end called WebCatalog
and it needs ODBC.
I know there are other solutions, but if we can get ODBC working
then there is no code change for WebCatalog
- Jim
>why are you using ODBC if you're trying to connect from one linux box to
>a MySQL database housed
Hi,
I'm designing a database and I was wandering which one is better:
A) 1000 tables (e.g. 10,000 rows each) in one database
or
B) One table with (e.g. 10,000,000 rows) and each group with special ID (in
one extra column)
And if I need to have many tables in one database, is any li
Thankx,
That did the trick! So simple yet so. well... simple!
- Original Message -
From: Gerald Clark <[EMAIL PROTECTED]>
To: Sean Strycker <[EMAIL PROTECTED]>
Cc: MySQL <[EMAIL PROTECTED]>
Sent: Friday, April 20, 2001 6:27 AM
Subject: Re: Mysqld running as root.
> add use
G'day,
This USED to work, then all of a sudden for no apparent reason it has
suddenly decided not to:
if I change the code thus:
if(*row1[2] == 'l')
{
;
}
else if(*row1[2] == 'e')
It completes, but of course this isn't any good.
Is there something fundamentally wrong with using the same co
Hi,
I am setting up MyODBC and iODBC on RedHat 6.2.
I have not found any good linux docs. Everyone talks about Windows.
Question, what directory does . iodbc.ini go so an app running as
user 'nobody' will use it.
/root ?
/usr/local/etc/ ?
One doc talked about restarting the driver when .
Has anyone ever bothered to make a front-end API to MySQL that does maintain
referential integrity and/or allow function calls on events? It might make
an interesting library to write for RDBMS migrators ...
- Original Message -
From: "Christopher R. Jones" <[EMAIL PROTECTED]>
> No, My
Except, leave out the space bhetween the -p and the password, or put the
userid
and the password in your .my.cnf file.
Robert Vetter wrote:
>
> Fabio Galarraga wrote:
> >
> > Hi to all:
> > I have a linux script and I need it can execute some mysql commands.
> > Is it possible? If possible, how?
Hello,
Could someone show me how to restore a database from the bin logs? I've
tried several times and get errors like "server id not set", etc. Is this
only for replication? I want to use logging to restore the database in
case of another crash, but I can't figure out how to restore from th
I've got tables in ISAM format whose indexes are way over 64 MB. However,
when I try to create a MyISAM table with an index that big I get errors and
confirming that with myisamchk I get:
myisamchk: warning: Keyfile is almost full, 67107839 of 67107839 used
Which is essentially 64MB. Are M
Hi there,
I'm using mysql 3.22.27 and get error when trying to run this select statement:
SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect,
FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl,
custmls.municname,custmls.state,custmls.zipcd,custmls.salesassoc,
ip
yes absolutely...look into mysqlbackup
(http://www.ocsny.com/main/index.ocs?url=osl ) for an example.
Cheers,
Miekl
Fabio Galarraga wrote:
> Hi to all:
> I have a linux script and I need it can execute some mysql commands.
> Is it possible? If possible, how?
>
> Best regards,
> Fabio Galarraga
Hello,
Could someone show me how to restore a database from the bin logs? I've
tried several times and get errors like "server id not set", etc. Is this
only for replication? I want to use logging to restore the database in
case of another crash, but I can't figure out how to restore from the
Fabio Galarraga wrote:
>
> Hi to all:
> I have a linux script and I need it can execute some mysql commands.
> Is it possible? If possible, how?
Simply put the SQL commands in a text file. To execute them in the bash
script you use the mysql client program:
mysql -u user -p password the_datab
Fabio Galarraga wrote:
>
> Hi to all:
> I have a linux script and I need it can execute some mysql commands.
> Is it possible? If possible, how?
>
> Best regards,
> Fabio Galarraga
> [EMAIL PROTECTED]
see
mysql --help
you probably want
mysql -e ""
-
Hi,
I am using several mysql servers as a support for a high traffic site. The
problem is that from time to time, and during last few days daily :,
mysql hangs. It hangs so bad that even kill -9 can't kill it, the process is
still there. :(
Now, a little info about my setup:
# gcc -v
Read
Is there any way to limit connections to
MySQL server on a per-host basis?
There are the:
max_connections and max_user_connections
options for mysqld on the command-line,
but I cannot see any way of limiting them
on a per-host basis?
Is there any way?
Thanks,
Ollie
--
Oliver CookSystems
For example i have 3 tables (really i have to make it with 6 tables, but...)
So 3 tables:
Table1
uid| name
1user1
2user2
3user3
Table2
iduidc
1150
2123
3142
4223
52303
Table3
idctxt
123'twenty-three'
242'the
I have mySQL threads that are sleeping with LONG times from a PHP app. What
kind of PHP call could sleep that long w/o dying?
Hunter
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://li
On 20 Apr 2001, at 14:16, yogi wrote:
> errors mySQL throws are not captured by the Perl CGI using mySQL, but
> are thrown regardless, meaning that a CGI that provokes an error in
> mySQL will produce an unspecified "Internal Server Error", which is
> not very helpful for debugging purposes. It l
Dear Yogi -
yogi writes:
> I've got a problem on one of my clients' servers, which is, that the
> errors mySQL throws are not captured by the Perl CGI using mySQL, but are
> thrown regardless, meaning that a CGI that provokes an error in mySQL
> will produce an unspecified "Internal Server E
Hello.
I wrote a few days ago when I was having trouble with too many connections
to my server.
Since then I upgraded to 3.23.36 to see if that would help...
Basically I have a PHP (4.0.4pl1) application that does both SELECTS and
INSERTS against mySQL and is very active. It's my understanding
Hi to all:
I have a linux script and I need it can execute some mysql commands.
Is it possible? If possible, how?
Best regards,
Fabio Galarraga
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php
"Andis Grasis" <[EMAIL PROTECTED]> wrote:
> Is it's possible to make some kind of relationships between tables
> as it's realised in MsAccess. In MsAccess databases it's called
> "Enforce referential integerity" and it's have some subchoises:
MySQL does not have referential integrity. Though it'
Hi,
Has anyone used any of the external business intelligence tool with
Mysql? Which are those? What was the outcome? Does this external tool support
Mysql fully?
Has anyone used Crystal Report with Mysql?
Appreciate for your response.
Regards,
John Ding
No, MySQL does not help in enforcing referential integrity. You need to do
that with your application. In some people's opinion (not mine), it is one
of the major drawbacks to using MySQL.
>Is it's possible to make some kind of relationships between tables as it's
>realised in MsAccess. In
"William Goedicke" <[EMAIL PROTECTED]> wrote:
> The broader feature set of Postgres over MySQL doesn't get a lot of
> intelligent rebuttal.
True. Fortunately, many web projects don't need triggers, subselects, etc.
(and PostgreSQL is IMHO a little more difficult to manage). In those cases
speed
Hello,
I wanted to compile mysql to the Compaq iPAQ handheld computer which
runs Linux. I hardly manage to compile the sql_yacc.o, and finally
compiled, but I realized that the mysqld binary is very-very huge
for a handheld, it is 2M (stripped).
Does anyone has idea how to shrink t
"Tom Beidler" <[EMAIL PROTECTED]> wrote:
> I'm running into more and more clients that would like to connect to
another
> database. Say there inventory tracking software. I was wondering if there
> was a good book out there or a web site that might have some info that I
can
> use to start thinking
Is it possible to enable compression between replicating database servers?
I'm assuming that there is already compression code in place, because of
the need to link with the compression libraries on the client end
sometimes.
Compressing the replication connection has certain advantages where the
Gerald's recommendation worked peachily
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 20, 2001 8:31 AM
To: Rolf Hopkins
Cc: Steve Tuckner; [EMAIL PROTECTED]
Subject: Re: Newbie Linux 7 installation question
No, it can't find the file because the my
<[EMAIL PROTECTED]> wrote:
> i have a question regarding the handling of the count()
> option in a sql-statement.
> i have the following statement:
> select distinct(ip), count(*) from log group by ip
> This gives me a table with 2 columns and i want to
> it sorted by the count(*) column. How woul
Ben,
the relation of databases and OS's is a question also mentioned in
Jim Gray's and Andreas Reuter's bool Transaction processing.
I have written the InnoDB table handler (= storage engine) under
MySQL. Let me think how operating systems could make database
implementation easier.
- Log-based f
Is it's possible to make some kind of relationships between tables as it's realised in
MsAccess. In MsAccess databases it's called "Enforce referential integerity" and it's
have some subchoises: 1)cascade update related fields and 2)cascade delete related
records. Is MySQL realize such things a
No, it can't find the file because the mysql database directory is owned
by root.
Rolf Hopkins wrote:
>
> More like it has already started. Do "ps -ef | grep mysql" to find out.
>
> - Original Message -
> From: "Gerald Clark" <[EMAIL PROTECTED]>
> To: "Steve Tuckner" <[EMAIL PROTECTED]
Hi,
On Fri, Apr 20, 2001 at 03:01:25PM +0200, [EMAIL PROTECTED] wrote:
> i have a question regarding the handling of the count()
> option in a sql-statement.
> i have the following statement:
> select distinct(ip), count(*) from log group by ip
> This gives me a table with 2 columns and i want to
add user=mysql to the [mysqld] section of /etc/my.cnf
EX:
[mysqld]
user=mysql
Sean Strycker wrote:
>
> Hello,
>
> I'm a newbe to Linux and MySQL, but I'm finding it very interesting.
>
> I'll cut right to the chase - I've followed the directions in the manual for the
>binary install on Linux
Hi,
On Fri, Apr 20, 2001 at 01:41:15PM +0100, Basil Hussain wrote:
> >> I think I may have come up against a slight niggling omission concerning
> >> Merge tables. How does one find out what physical tables are mapped, other
> >> than by looking at the contents of the .MRG file?
> >>
> >> Surely
You did not get an answer because you did not follow directions in how
to post a problem report.
We don't know what kernel you are running , and what compiler you are
using.
How did you install it?
If from sources, and assuming the mysqlprefix was /usr/local/mysql:
Make sure you have a mysql us
- Original Message -
From: "Matteo" <[EMAIL PROTECTED]>
Subject: MySQL and MyODBC
> i'm developing a software in V.b.6 based on MySql d.b.
> Early i'll need to create a package in order to install this software.
> So, i need to know if i must to include, into the packege, only d.b.
>
Hi Folks,
i have a question regarding the handling of the count()
option in a sql-statement.
i have the following statement:
select distinct(ip), count(*) from log group by ip
This gives me a table with 2 columns and i want to
it sorted by the count(*) column. How would i do that??
...order by co
Hi!
Andrey is right, if I understood correctly. MySQL should notice that
the index with two columns (color, randomkey) is the best because we
have an equality condition on the first column color (= "black")
and an inequality condition on the second column randomkey (> 30).
Then MySQL can sta
Hi,
>> I think I may have come up against a slight niggling omission concerning
>> Merge tables. How does one find out what physical tables are mapped, other
>> than by looking at the contents of the .MRG file?
>>
>> Surely this information should be displayed either when you do SHOW TABLE
>> ST
Hi,
I looked into the archive and I coun't find anything that looks like my
problem.
I was using mysql 3.22.x without no problems, but I needed the replication
feature, so I upgraded it to 3.23.36. Where was my scenario :
http server. apache 1.3.19 + mod_perl 2.
Hello to all,
i'm developing a software in V.b.6 based on MySql d.b.
Early i'll need to create a package in order to install this software.
So, i need to know if i must to include, into the packege, only d.b.
files and the ODBC or i must the install the complete version of
MySQL.
Another lit
Hi,
We were running 3.23.21, which had the problem where the index file could
only go to 64MB.
So I shutdown the db, move the mysql directory(/usr/local/mysql) and
installed 3.23.36, and moved the database directories into the new version's
directory. I then repaired the radacct table.
My proble
Hello,
the mysql-documentation says, that CONCAT or CONCAT_WS is not a function to
use with GROUP BY, but I tried this in version 3.22 and it worked. Why
doesn't it work with the latest version?
Example:
SELECT * FROM bids;
++---+-+
| id | comment | project |
++---
Hi,
I've got a problem on one of my clients' servers, which is, that the
errors mySQL throws are not captured by the Perl CGI using mySQL, but are
thrown regardless, meaning that a CGI that provokes an error in mySQL
will produce an unspecified "Internal Server Error", which is not very
helpful fo
Steve Newell writes:
> I tried using the sql_create_N macros, but my compiler crashes with an
> "INTERNAL COMPILER ERROR". I'm using VC++ 6.0 sp5. I spent several days
> trying to work around that and finally went back to the sql_create_basic_N.
>
> Steve
Yes, I am afraid that VC++ can not ch
Dear Tom -
(Please bear with me for a philosophical prolog.)
Tom Beidler writes:
> I'm running into more and more clients that would like to connect to
> another database. Say there inventory tracking software. I was
> wondering if there was a good book out there or a web site that
> might hav
Hi All,
I have a products table with usual id and price fields etc.
The site uses prepay, in that you have a balance (eg £500)
and I'm trying to make an add to basket query where, in one
shot, I want something like
SELECT sum(value)-(SELECT price FROM p_products WHERE seq_id = 88) as
balance FROM
Edwin Zhang writes:
> Hi, Dear Sir or Madam,
>
> I like mySQL very much and today I tried to use mySQLGUI (win32 static binary
>1.7.4-2), but I found edit table and create table in commands/tables menu have no
>functions. is there any problem?
>
> Sincerely
>
> Edwin Zhang
Hi!
Edit tables
Magnus Larsson (EUS) writes:
> Hello,
>
> When I am trying to install mySQL on a Solaris8 server I get the
> following error:
>
> # ./configure
> .
> .
> .
> checking return type of sprintf... configure: error: can not run test
> program while cross compiling
>
> Any idea what I need to do?
>
>From my reading of the manual it seems that
for every time a new slave it to be added, the
master will need to be locked while the snapshot
is taken.
Is this really necessary? Can another slave be
somehow setup by taking the data from another
slave instead, thereby avoiding downtime on the
maste
hi ,
would any one suggest me a downloading site to download complete set of
MySQL windows 32bit.
Shall i have to register at any place to have the complete MySQL package.
Please help me.
thank you
Peri
_
Get Your Private,
Dear Kevin -
Kevin Pratt writes:
>
> "IMO - mysql is just a disaster you are inviting on yourself.
Isn't there some line about everyone having an opinion...
> you should see the responses to some recent bug reports ...
>
> We have run load tests ourselves, and postgres performs much the
Hello again!
Thanks to everyone that helped me yesterday with the MySQL crash and how to
restart the server. But now I have another problem, the MySQL 3.22.32 server
is crashing every now and then.
Looking at the .err file, it says
010420 1:48:51 Warning: setrlimit couldn't increase number of
Hi,
On Fri, Apr 20, 2001 at 10:47:57AM +0100, Basil Hussain wrote:
> I think I may have come up against a slight niggling omission concerning
> Merge tables. How does one find out what physical tables are mapped, other
> than by looking at the contents of the .MRG file?
>
> Surely this informati
Hi all,
I think I may have come up against a slight niggling omission concerning
Merge tables. How does one find out what physical tables are mapped, other
than by looking at the contents of the .MRG file?
Surely this information should be displayed either when you do SHOW TABLE
STATUS or by som
Hi everybody,
sorry in advance if this question has been posted many times before.
We are running MYSQL 3.22 on SUSE Linux and planning an update
to the latest 3.23-Release.My question now is, if there is a special
update-procedure which keeps files like my.cnf or the privilege-tables
untouched,
100 matches
Mail list logo
