Hi,
No, you can't get both in one query.
Anyway, you probably want to see how many results
would be returned in the first place,
before deciding on sensible LIMIT clause parameters.
And you may want to add an ORDER BY clause to your second query,
so that you can rely on the order in which the r
>Description:
checking return type of sprintf... configure: error: can not run
test program while cross compiling
>How-To-Repeat:
just launch ./configure
>Fix:
?
>Submitter-Id:
>Originator:[EMAIL PROTECTED]
>Organization:
ATCHIK
>MySQL support: none
>Synopsis:
Hi is there anyone on the list fron Pune, India who can lend me a MySql CD
for a while. my installation is not taking off..
Thanks
Mihir
Telephone: 020 5281296
How can I replace MySql 3.22.xx with MySql 3.23.34. Uninstall 3.22.xx ?
Thx.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
let
perl -MCPAN -e shell
be your friend
i /mysql/
will show you all the mysql stuff
or
i /dbi/
even
On Thursday 12 April 2001 01:16, Chris Becker wrote:
> go to perl.com - click CPAN and look for DBI and DBD, and look for docs on
> how to install a perl module. You need to inst
On Tue, 10 Apr 2001, Erik Kabo wrote:
> Date: Tue, 10 Apr 2001 18:37:17 -0400
> From: Erik Kabo <[EMAIL PROTECTED]>
> Reply-To: Erik Kabo <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: client problems
>
> Hi,
>
> I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I install
On 11 Apr 2001, at 18:07, Mohamed Ould wrote:
> > > > > > apache "make" abort with these errors:
> > > > > > usr/local/mysql/lib/libmysqlclient.a(my_compress.o
> > > > > > ): In function `my_uncompress':
> > > > > > my_compress.o(.text+0x9a): undefined reference to
> > > > > > `uncompress'
> > >
In your odbc setup did you give the host name that you defined on the
linux box?
Adrian
On Wed, 11 Apr 2001, Fenn Rider wrote:
> I am trying to get myODBC working on an NT 4.0 ws, sp6a client, connecting
> to a MySQL db running on a linux box. When I try to connect, I get a dialoge
> that says:
On 11 Apr 2001, at 11:16, [EMAIL PROTECTED] wrote:
> Good morning,
> Please,
> I use MySql, I would use INTERSECT/UNION functions and they
> don't work, I need help,
>
> My query is :
>
> select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
> Entreprise E, Mot_Entreprise ME, Mot M, Categorie
Hi.
I use persistent connections opened from php scripts. For what I read
in the manual, when a client try to connect to the same server, same
database , same user, same password, if a persistent connection is
already open, it should use that mysql link, never open another
persistent conn
I want to be able to change menu items on the fly instead of having to modify
the html code manually. Some of the menu item links change a lot or I need to
add additional menus. Keeping the menus in a database allows me to edit/change
the menu items easily from the web page
Thanks
Rolf Hopkins
Bonjour,
We found a bug in INNOBASE tables with col_name(length) indexes.
Here is the table :
create table test (
symbole char(20) not null primary key,
libelle char(100) not null,
index id_lib (libelle(1))
) TYPE=INNOBASE;
For the test I insert one row but there can be many, th
Hi,
Can somebody help me, with changing the default delimiters of MySQL. For Example I
want to change the single quotes that enclose a string in an INSERT statement to #.
How can it be done.
Thanks in advance.
Shambhu kumar Singh.
_
Chat
Hi,
I am running a query using C APIs to insert a large text item into a MySQL table.
The query is as follows
sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
mydata);
where mydata is a C variable containing a large text item
The problem occurs when mydata co
Burkies, Norman writes:
> Hi
>
> We are evaluating various RDBMS for use on within an airborne server
> (Embedded NT4.0) environment.
>
> This environment does not have reliable power. Aircraft are powered cycled
> without regard for delicate OS environments etc.
>
> We like MySql because it is
Jeremy Zawodny writes:
> On Wed, Apr 11, 2001 at 04:58:49PM +0300, Sinisa Milivojevic wrote:
> >
> > This seems to be a problem with threads on FreeBSD, although on
> > which side, yet remains to be seen.
> >
> > It seems to appear that it is surfacing not just under heavy load,
> > but when the
Hi!
I have notice a very weird index selection when execution a query
in 3.23.36.
Here is an example:
The table is:
mysql> describe words;
++--+--+-+
-+---+
| Field | Type | Null | Key | Default
| Extra |
+--
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
> sprintf(szQuery,"Insert into mytable(mycol)values '%s' ",
> mydata);
> where mydata is a C variable containing a large text item
>
> The problem occurs when mydata contains a single quote, then that single
quote is taken as the end of the column value by the MySQL parse
On 11 Apr 2001, at 18:59, David wrote:
> I tried posting this in the PHP newsgroup but received no
> response so thought I would try here since issue involves
> MySQL
>
The easiest solution is to use lists, eg:
Admin
Networking
ping
traceroute
echo
rather than table da
David Beech a écrit :
> On 11 Apr 2001, at 18:07, Mohamed Ould wrote:
> > > > > > > apache "make" abort with these errors:
> > > > > > > usr/local/mysql/lib/libmysqlclient.a(my_compress.o
> > > > > > > ): In function `my_uncompress':
> > > > > > > my_compress.o(.text+0x9a): undefined reference to
Thanks for the patch and the rapid response :)
My application has been running with this patch for 15 hours now - and has
done over 2 million regexp matches without problems :)
Stephen
On Wed, 11 Apr 2001, Michael Widenius wrote:
>
> > "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writ
At 12:30 12/04/2001 +0200, BAUMEISTER Alexandre wrote:
Hi,
Maybe this issue is relative at your compiled version or platform
because I wasn't be able to repeat:
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
c:\mysql\bin>mysql test
Welcome to the MySQL monitor
Artem Koutchine writes:
> Hi!
>
> I have notice a very weird index selection when execution a query
> in 3.23.36.
>
>
> Here is an example:
>
> The table is:
>
> mysql> describe words;
> ++--+--+-+
> -+---+
> | Field | Type
Bonjour,
Sorry I mistyped the version of Mysql with which we have the bug.
It's Mysql-3.23.36 with patch correcting Solaris and other non Linux
Unix problem.
> We found a bug in INNOBASE tables with col_name(length) indexes.
>
> Here is the table :
>
> create table test (
> symbo
> This looks like a perfectly normal mysql truss. Lots of disk I/O,
and
> it looks like you're got a pretty small record length (20-byte
reads?
> although the combo of lseek+read and pread on the same datafile is
> puzzling. Maybe it's a table with a couple of INT/CHAR columns and
a
> BLOB colum
Hello---
I am wondering if anyone has done anything that resembles the following:
I need to take a flat file (currently in excell) and upload it into a MYSQL
database via the web using PHP. This will happen every week so what is the best
way to do this drop the table then re-create it with the
Hi,
I have one problem regarding database creation.
I am using MySQL on FreeBSD unix os.
I have already created two databast in mysql.
Now I want to create new database for same but i forgot my root mysql password.
Please help me.
Thanks in advance.
Sandeep
Hi!
Innobase does not support partial-field indexes. We have to block their
usage in the SQL parser. Miguel's query on Win NT perhaps worked because the
optimizer there chose another access path and did not use the partial-field
index.
But thank you Alex, we have to block them in the parser, and
I would like to know what experience need for development in MySql project,
I read the istructions on the site but it say to send my software, so I want
ask: What languages are required ? What kind of experience ?
-
Before posti
Well, where IS the socket?
If it is not where mysqladmin is looking, then you should add to
/etc/my.cnf:
[client]
socket=/tmp/mysql.sock
Substituting the correct full path/name for the socket.
Make sure /etc/my.cnf is world readable.
Mike Millner wrote:
>
> I've narrowed it down some. I'm no
It is in the manual.
Sandeep Pachpande wrote:
>
> Hi,
>
> I have one problem regarding database creation.
> I am using MySQL on FreeBSD unix os.
> I have already created two databast in mysql.
> Now I want to create new database for same but i forgot my root mysql password.
>
> Please help me.
>Hi
>
>We are evaluating various RDBMS for use on within an airborne server
>(Embedded NT4.0) environment.
>
>This environment does not have reliable power. Aircraft are powered cycled
>without regard for delicate OS environments etc.
Here in south Arlington, Va., the power also cycles without re
>On 11 Apr 2001, at 11:16, [EMAIL PROTECTED] wrote:
>
> > Good morning,
> > Please,
> > I use MySql, I would use INTERSECT/UNION functions and they
> > don't work, I need help,
> >
> > My query is :
> >
> > select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
> > Entreprise E, Mot_Entre
>Now I want to create new database for same but i forgot my root mysql
>password.
Take a look at the manual. It's there, so USE it.
You can also find the answer in this lists archive.
Bye,
B.
-
Before posting, please chec
At 15:13 12.04.2001, Sandeep Pachpande wrote:
>Hi,
>
>I have one problem regarding database creation.
>I am using MySQL on FreeBSD unix os.
>I have already created two databast in mysql.
>Now I want to create new database for same but i forgot my root mysql
>password.
>
>Please help me.
>Thanks i
Heikki,
Could you please tell me (and add in the manual perhaps) if this is
a planned enhancement or not and if it's planned, if it will be
added in a long or a short delay.
Thanks,
Alex.
HT> Innobase does not support partial-field indexes. We have to block their
HT> usage in th
I know that there is some way to give the DOS window a scrollbar, somewhere
in it's properties maybeI can't remember, in which case you can view
what races past your eyes
Scott
At 11:08 PM 4/11/01, you wrote:
>Using ver 8.18 dist 3.23.36 on win98se. It unzipped just fine, installed
>an
Alex,
sorry, but it is not a planned enhancement for a long time. For small
columns it is as good to create an index on the whole column, because
there is at least some 15-byte space overhead for secondary index records
anyway. For large columns the application can add an extra column to the
tabl
At Thursday 4/12/01 08:56 AM, [EMAIL PROTECTED] wrote:
> I need to take a flat file (currently in excell) and upload it into a MYSQL
> database via the web using PHP. This will happen every week so what is the
> best way to do this drop the table then re-create it with the info. from
the
>
I accidentally crashed 1 of my tables. So I deleted everything in the table
and tried to reload the data into the table and now I get this error:
Query OK, 1 row affected (0.02 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 5
I have a total of 1901 records in this txt file. I puts the first reco
http://www.mysql.com/doc/R/e/Resetting_permissions.html
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Sandeep Pachpande" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 12, 2001
Hi everyone;
I have some problem in load a 28 MB LONGTEXT data into mysql database using
"LOAD DATA INFILE ...". At the beginning, server returns me the error
message as below:
ERROR 1030: Got error 139 from table handler
I tried the same command again, then I got another error message:
ERROR
From: [EMAIL PROTECTED]
Date: Thu, 12 Apr 2001 17:12:06 +0200
To: [EMAIL PROTECTED]
Hi there,
Although I am using AIX4.3.1, I tried to install the binary version (which
is built for AIX4.3.3). Most of the time, it does not make any difference,
but when I run:
scripts/mysql_install_db
I get:
To anyone basically familiar with MySQL:
I know nothing about MySQL, and have been instructed to install it on a
RedHat 7.1 Linux system. I went through installing MySQL server, client, and
development RPMs and that worked fine. Now I skipped the installation of the
DataDumper module (because it'
I accidentally forgot the attachment, sorry...
-Original Message-
From: Jaffe, Peter S.
To: '[EMAIL PROTECTED]'
Sent: 4/12/2001 8:34 AM
Subject: MySQL Module Installation Failure
To anyone basically familiar with MySQL:
I know nothing about MySQL, and have been instructed to install it
I do something wrong i testing to use dbtools to
manage mysql, and i wanna to do change something but i miss.
I delete user root :-( i think, now on my database don't
have user root .. but i have a lot of data that i need in this
database
Hi,
we are using an older mysql-version from binary (debian) install - without
problems.
Now we want to use this newer versionm because of replication- and new
table-format-features (myisam).
All Tables are in Format myisam. Not Database (test, mysql, our own
database) is visible via mysqldump or
I had a problem like this when I put together my Apache/PHP/mySQL server
(now keep in mind I didn't use RPM's, I built all from source). Anyway,
there's a line in the Makefile under apache-x.x.x/src that begins with
LIBS1=. At the end of the line, you will probably have to add "-lz"
(that's spac
Hi!
> "Artem" == Artem Koutchine <[EMAIL PROTECTED]> writes:
Artem> Hi!
Artem> I have notice a very weird index selection when execution a query
Artem> in 3.23.36.
Artem> Here is an example:
Artem> The table is:
Artem> Now i want to find a product which contains both 'AMD' and 'DURON'
We had a crash of MySQL this morning for some reason. (Why who
knows!) The real problem was it would not restart until the log.*
files were deleted. It looks like it was trying to perform a recovery
on a dropped database. The server would not start. This is not cool!
We dropped the test datab
Hi
I'm incredibly stuck. I've been through the lists over and over, and manual
is silent on this detail, and have found no solution. The Unix remote host
fails to find the text file to import from my pc, Win2000. The TABLE is
created already. The text file is fine. I've done this via "load da
http://www.mysql.com/doc/R/e/Resetting_permissions.html
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "Mr.Mongkol Phitaksuksanti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 1
What is good clean sql syntax to accomplish the following with MySQL:
SELECT * FROM tablename WHERE value is in array of values
i.e. (psudocode)
Assume I have a field called ID in my table, and that I have 20 Rows (with
ID's 1-20)
myarray = (1,3,4)
I want to return all the fields where ID = 1
"Scott Dunn" <[EMAIL PROTECTED]> wrote:
> I accidentally crashed 1 of my tables. So I deleted everything in the
table
> and tried to reload the data into the table and now I get this error:
> Query OK, 1 row affected (0.02 sec)
> Records: 1 Deleted: 0 Skipped: 0 Warnings: 5
>
> I have a total of 1
select * from blah where fieldname in (1,3,4)
On Thu, 12 Apr 2001, Jim
Zarvis wrote:
> What is good clean sql syntax to accomplish the following with MySQL:
> SELECT * FROM tablename WHERE value is in array of values
>
> i.e. (psudocode)
>
> Assume I have a field called ID in my table, and t
"Jim Zarvis" <[EMAIL PROTECTED]> wrote:
> What is good clean sql syntax to accomplish the following with MySQL:
> SELECT * FROM tablename WHERE value is in array of values
>
> i.e. (psudocode)
>
> Assume I have a field called ID in my table, and that I have 20 Rows (with
> ID's 1-20)
>
> myarray =
On Thursday 12 April 2001 10:49, Ken Menzel wrote:
> We had a crash of MySQL this morning for some reason. (Why who
> knows!) The real problem was it would not restart until the log.*
> files were deleted. It looks like it was trying to perform a recovery
> on a dropped database. The server wo
by the way, that's not a functional example...i was using array syntax, but
this won't work if you try to use it as is...it should be a 'list' or else
contain an even number of elements...not that it's relevant, but i hate
posting code that's inoperable...
-Original Message-
mysql> describe main;
++--+--+-+-+---+
-+
| Field | Type | Null | Key | Default | Extra |
Privileges |
++--+--+-+---
At the first of the month (no changes made to the database; this script is
just running SELECT statements at present) the number of rows returned by
this query dropped noticeably. Is this a bug, is my query just fubar'd,
or...?
SELECT account.username AS account_username, customers.username AS
c
I'm just not understanding what I'm reading in Ch. 7.
I created a table, in my database, now I just want to add 2 more varchar
columns to it. I tried following along with the manual, but, I'm not seeing
it, and I get errors every time in telnet. If someone would be so kind as
to help me, I appr
you try to select the march 87. 2001 ;)
read the manual about date/time conversion and math:
mysql> select current_date(), current_date()-0, current_date()-14;
| current_date() | current_date()-0 | current_date()-14 |
| 2001-04-12 | 20010412 | 20010398 |
1 row in set (0
Hello there list!
I'm having some trouble with my web server running Apache and MySQL.
I'm accessing the DB through the latest DBI:DBD and Perl.
I was running 2.22.32 quite successfully for about a year until usage starting
becoming a problem.
I upgraded to 2.23.36 and the problem stayed the sa
ALTER TABLE tablename ADD COLUMN column_name ;
On 4/12/01 12:04 PM, "Dean MacIsaac Jr." <[EMAIL PROTECTED]> wrote:
> I'm just not understanding what I'm reading in Ch. 7.
>
> I created a table, in my database, now I just want to add 2 more varchar
> columns to it. I tried following along
Hi,
I have had some various similar things happen with other apps since
upgrading to Fbsd4.2stable
What I have learnt to do first before anything else is, reboot and load
a SINGLE CPU compiled kernel to determine at what/where the bug may be.
I had a/still occasionally get a constant waiting
hi.
alter table sometable add column newcol VARCHAR(20) after oldcol;
change sometable, newcol, oldcol and the column definition to what you want.
hth.
-ravi.
-Original Message-
From: Dean MacIsaac Jr. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 12, 2001 3:04 PM
To: [EMAIL PROTECT
I am not sure I am encoutering the following problem
when I try to access the database?
java.sql.SQLException: Server configuration denies
access to data source
java.sql.SQLException: Server configuration denies
access to data source
My java program defines: user and a password and when
I connect
Hello,
Let's say I have a file which contains the following lines:
insert into table_1 values (1,2,3);
insert into table_2 values (4,5,6);
It's called from the command line with mysql -u root -p db_name <
file;
I would like to undo the first operation on table_1 in case the second query (on
t
Hi Sasha,
> Looks like you found two bugs at once. The first one is that someone
mysqld
> segfaults, probably a bug in processing some query or possibly some
OS issue,
> but there is not much we can tell at this point - the only way to
track it
> down would be if you had full logging enabled and
Billy, and friends,
Always helpful info: What have you tried, and what errors are you
getting?
alter table web_guests add column (p1 varchar(15), p2 varchar(15));
Error 1064 You have an error in your sql syntax near '(p1 varchar(15), p2
varchar(15))' at line 1
TIA,
Dean MacIsaac
---
the manual about date/time conversion and math:
mysql> select current_date(), current_date()-0, current_date()-14;
| current_date() | current_date()-0 | current_date()-14 |
| 2001-04-12 | 20010412 | 20010398 |
1 row in set (0.00 sec)
gl
- Original Message -
From: "
You can't with MyISAM and executing from shell prompt.
Either alter the table type to BDB or Innobase
If you stick with MyISAM you can use a higher level language (perl,php) to check the
return value of each insert and handle the flow accordingly. If the 2nd insert fails,
you'll have to compleme
On Thu, Apr 12, 2001 at 02:32:42PM +0800, Leon Harris wrote:
>
> On the client I do a
> ssh -q -n -f -l account -L 3306:mysqlserver.mydomain.com:3306
>
> then mysql -u dbuser --port=3306 -h 127.0.0.1 -p dbname
> and I get an encrypted connection. ( thats what tcpdump shows me) !
> Lovely !
>
>
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thanks!
Either add a timestamp column to your t
Hi,
I want connect mysql databse with ms front page 200.
How?
What do i?
Thanks.
I am running Redhat 7 and mysql and I have tried to install Msql-Mysql DBI
module But I get errors when I do a make.
I have enclosed a screen dump of the output I get. I seams to be getting
stuck with dbimon. I have installed DBI-1-13.tar.gz.
Can any one help
Gordon
[gordon@fido gordon]
On Thursday 12 April 2001 14:03, Ken Menzel wrote:
> Hi Sasha,
>
> > Looks like you found two bugs at once. The first one is that someone
> mysqld
> > segfaults, probably a bug in processing some query or possibly some
> OS issue,
> > but there is not much we can tell at this point - the only way
# perror 139
Error code 139: Unknown error: 19
139 = Too big row (>= 16 M)
This means the 28MB row you tried loading is bigger than the max allowed
packet size. You might want to change the max_allowed_packet variable (ie -O
max_allowed_packet=32M or something similar on the commandline).
The d
What you wrote will work just fine. It is very easy to create a test case
and see if it works, saves you the trouble of posting to the list.
mysql> create table test (a int, b int, c int);
Query OK, 0 rows affected (0.09 sec)
mysql> insert into test values (2,3,5);
Query OK, 1 row affected (0.00
Greetings:
Prelude: We have five tables all sharing a very similar structure (each has
a Customer_ID and Server_ID field for example).
Each table can contain zero to many records with duplicate Server_ID values
allowed.
Need: I need to be able to count the distinct Server_ID's across all of t
I have been offering free hosting of MySQL databases at freesql.org for the
last few weeks. As a result I now have several hundred databases (which I
think is great!), with a subset (perhaps 50) that are in active use. I
would like to implement a policy where I can cull dormant or otherwise
aban
Description:
When compiling mysql-3.23.36, many *.cc files caused a
compilation error that said that __tz has multiple
data definitions in /usr/include/sys/time.h. It first
happens in the client subdirectory, but happens many
times after that as well.
I am using
RH Linux 2.2.16-22smp
gcc version
You should be able to use 'find' on the directory and search by UNIX atime
(atime is updated whenever the database is accessed, be it a read or a
write). `find . -atime ...` man find for more details.
>From there, it's a simple shell script
On Thu, 12 Apr 2001, Gary Huntress wrote:
> I have
Never mind; thanks for the pointers to TFM... =)
The updated, working query looks like this:
TO_DAYS(NOW()) - TO_DAYS(customers.last_mod) > 14
Thanks all!
On Thu, 12 Apr 2001, Chris Harshman wrote:
> At the first of the month (no changes made to the database; this script is
> just running SE
I am trying to install PHP 4.0 on a intel machine running Red Hat Linux 6.2.
I have the MySQL version 3.22.32 installed and works fine. It is located
in: /usr/local/mysql-3.22.32-pc-linux-gnu-i686 When installing the PHP with
the ./configure command I get:
**
I have a table design question, looking for tips, not the exact sql to
create the tables.
I have tried several solutions, and as yet, I don't like what I am
coming up with. So if someone could help me, I would be grateful.
Assumptions:
's have several types, defined by a separate table:
Hello,
Please,
I use MySql, I would use INTERSECT/UNION functions and
they don't work, I need help,
My query is :
select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
Entreprise E, Mot_Entreprise ME, Mot M, Categorie C
where
(E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot
like 'word1%') and
I downloaded the solaris 8 mysql package from
ftp://ftp.sunfreeware.com/pub/freeware/sparc/8/mysql-3.22.26a-sol8-sparc-local.gz and
installed it, but when i try to run /usr/local/mysql/bin/safe_mysqld, it reports the
following error to /usr/local/mysql/var/wakko.err:
mysqld started on Thu Apr
1 - 100 of 140 matches
Mail list logo
