Try this:
SELECT * FROM content, address WHERE content.msg_id = address.msg_id
If I understand what your asking for, you want a JOIN. If I don't
understand, forgive me, it's late... :)
Tyrone
-Original Message-
From: matteo [mailto:matt@web]On Behalf Of Matthieu Paindavoine
Sent: Thurs
I'm using MySQL under Win2K.
How i can regulate number ot threads in MySQL server?
May be better allow server use dynamic value or use big fixed value.
And one comment, on my server machine 2 processors (you can read more then
one CPU :)
Is any special config properties that I must to use?
WBR,
Hello,
I am relatively new with MySQL (and SQL for that matter) and I couldn't
find much reference to my problem in earlier posts.
Let's say I have 2 tables,
CONTENT: msg_id, msg_text
ADDRESS: msg_id, address
and I receive the msg "Hello World" addressed to the twins Foo and Bar.
now my table
Can connect using MyODBC.
- Original Message -
From: "Andrew" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 13:52
Subject: RE: MySQL on VB
>
> I need some help.
>
> I would like to know if VB can interface directly with MySQL.
> If possible, then how shall I go
I need some help.
I would like to know if VB can interface directly with MySQL.
If possible, then how shall I go about on it.
Thanks.
Andrew.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Van wrote:
>
> Greetings:
>
> Working on a shell based application that does an insert when a shell is started,
> and, needs to update that record on exit.
>
> You can't set an environment value back to the parent process, so would a fork()
> make the most sense?
>
> This currently works in a
Brian,
When you run the mysql_install_db bit, a root user is created (username =
root...imagine that!)
But, there is no password for this root user. You have to set this password yourself.
Here's how to do it:
1. $ bin/mysqladmin -u root -p password 'enter_new_password_here'
Then, try this:
On 14-Jun-01 Russell King wrote:
> From: Don Read <[EMAIL PROTECTED]>
>> On 14-Jun-01 Kenneth Johansen wrote:
>> >
>> > temp = (int) row[0];
>> >
>> > this might not (strictly) be a mysql question.
>> > but IMHO i dont think a C forum is the right place either.
>>
>> No it's not; & yes, it would.
Thanks Simon
When I typed Step 1, I got the same error messages, but proceeded on and
when I did step 2, I finally got a mysql prompt after entering the password
I set in Step 1. So I think things are all set.
If not, I'm sure I'll be asking questions again :)
Thanks
-Original Message
Hey Everybody,
I noticed that a lot of people experience problems when they try to start the mysql
server by
typing this:
$ bin/safe_mysqld --user=mysql &
In the Mysql/msql O'Reilly book, it says to type this to start the daemon:
bin/safe_mysqld --log &
I ran into problems with the first co
Yes.. I know.. But that's not my design.
That will be change in a few month..
My job now is: dump all of them out.
- Original Message -
> Wow! What kind of database would have 10,000 tables? Wouldn't you think
> the database design had a serious flaw in the first place?
>
> Seung-woo Na
Wow! What kind of database would have 10,000 tables? Wouldn't you think
the database design had a serious flaw in the first place?
Seung-woo Nam
SDiZ Cheng wrote:
>When i use mysqldump,
>seems that MySQL will open all the tables in the database.
>But, what i have is: a database will over 10,00
Now that the mess with starting the server is over, I cannot access it.
After installing the rpm files, I initialize the grant tables with
mysql_install_db.
Then I type:
mysql -u root mysql
The result is: ERROR 1045: Access denied for user: 'root@localhost' (Using
password: NO)
Typing mysql -u
When i use mysqldump,
seems that MySQL will open all the tables in the database.
But, what i have is: a database will over 10,000 tables ..
I get a "Too much opened file" error on this..
I think increasing open_file_limit is not possible,
because of the limit of the OS itself..
Can anyone sugges
Changes in release 3.23.39
--
* Fixed problem with shutdown when `INSERT DELAYED' was waiting for
a `LOCK TABLE'.
* Running `myisamchk --fast --force' will no longer repair tables
that only had the open count wrong.
--
THANK YOU! Y
Well, that isn't much to go on. I suggest you put a few print statements to
find out what's happening and also try the sql statement in the mysql prompt
to see if the sql statement does what it is suppose to. Remember, if you're
printing this in a table, error messages and results may not always
Sorry. It doesn't do anything.
Oh and btw, I made it so it DOES call on the function.
It would help if we knew what the error or problem was?
- Original Message -
From: "Vladimir Kravtsov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 13:13
Subject: What
On Thu, Jun 14, 2001 at 12:43:41PM -0400, Robin Senior wrote:
> On Thu, 14 Jun 2001, Jeremy Zawodny wrote:
> > I have a few comments and questions:
> >
> > (1) Is this a unique index? If not, consider doing a partial index
> > on the column. Index the first 32 characters or so. I'll save
");
echo(" "."$choice_percentage"."\%");
}
}
}
?>
Please help :)
Greetings:
Working ona shell based application that does an insert when a shell is started,
and, needs to update that record on exit.
You can't set an environment value back to the parent process, so would a fork()
make the most sense?
This currently works in a bash shell .profile implementatio
I need help on testing the database for errors. Basically im writing a perl
script to operate my database. When i open the database, i need it to return
an error code if successful. steps such as:
open database
check for error (did database open?)
if error print error message
else print successfu
It would help if we knew what the error or problem was?
- Original Message -
From: "Vladimir Kravtsov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 13:13
Subject: What's wrong here?
");
echo(" "."$choice_percentage"."\%");
}
}
}
?>
Pl
At 12:04 PM +1000 6/15/01, M Felipe wrote:
>I need help on testing the database for errors. Basically im writing a perl
>script to operate my database. When i open the database, i need it to return
>an error code if successful. steps such as:
Try running:
perldoc DBI
and reading the inf
Hello all,
Without explicitly creating foreign keys, what is the most common method to
create a truly relational database that enforces referential integrity?
Any responses to this question are greatly appreciated!
Sincerely,
N. Silverwise
--
If you are really after referential integrity then perhaps you should
consider another database or you could always modify the code.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 8:32
Subject: Relationships???
> Hello all,
>
> Without
>Description:
In testing a script that I want to put in a cron, the mysqld keeps crashing eachtime I
run the script to test it. I've tried substituting in raw numbers for the variables
in the script, but to no avail. In attempting to troubleshoot, I logged onto the
monitor and could duplicat
At 3:33 PM -0700 6/14/01, Mike Jimenez wrote:
>I installed MYSQL in Redhat Linux 6.2 and where are the include files?
>If your include files are not in /usr/include/mysql or
>/usr/local/include/mysql,
>
>I cannot find the include files and I installed from RPM
>MySQL-3.23.38-1.i386.rpm
>MySQL-clie
At 1:36 AM +0200 6/15/01, Sven Huster wrote:
>Hi there
>
>can i somehow easily recreate the auto_increment col if is was not
>correctly set?
>i just recognized that most rows contain "1" cause the primary key was
>set
>on the auto_increment col + another one.
>so mysql only creates a entry > 1 if
On 14-Jun-01, Daniel Vignes said something totally profound about Install help for x86
Solaris 8 that made me ponder...
DV> Hi,
DV>
DV> I hope someone out there has an answer to this problem I'm having.
DV> I'm trying to get mysql installed on a x86 Solaris 8 box, the
DV> version I'm trying to
From: Dvoøáèek Michal <[EMAIL PROTECTED]>
> Hi there,
>
> little problem. I have program (like phorums) and there is command
> mark all posts as readed. On one board is about 4000 posts, and if is
> new user and want mark all posts as readed - it's problem (big).
>
> All is written in ANSI C (usin
Hi,
I have mySQL installed under Conectiva Linux 4.2 and I'm not able to find
mysqladmin ...
Is there something to start to use mySQL?
TIA,
Juan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi there
can i somehow easily recreate the auto_increment col if is was not
correctly set?
i just recognized that most rows contain "1" cause the primary key was
set
on the auto_increment col + another one.
so mysql only creates a entry > 1 if the other field was equal to
another row.
thanks
reg
I installed MYSQL in Redhat Linux 6.2 and where are the include files?
If your include files are not in /usr/include/mysql or
/usr/local/include/mysql,
I cannot find the include files and I installed from RPM
MySQL-3.23.38-1.i386.rpm
MySQL-client-3.23.38-1.i386.rpm
Thanks
MIke
-
Hello,
can you tell me about error 22 from table handler or where can I
get some information about it, it denies me grant table level privileges
for my users.
Thanks,
Cesar A. Cabrera E.
-
'http://www.utp.edu.co/Linc
From: ryc <[EMAIL PROTECTED]>
> I am aware that currently innobase tables can not have abritararly large
> text/varchar fields and support for this will be released sometime in the
> month of June. The application I am working with requires text fields
> (usually less than 64k), and I desperatly
Perl's Spreadsheet::ParseExcel and Spreadsheet::WriteExcel are great for
this purpose. Find them on a CPAN site near you.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of Don Read
> Sent: Thursday, June 14, 2001 3:43 PM
> To: Terminal Velocity
Hello,
can you tell me about error 22 from table handler or where can I
get some information about it, it denies me grant table level privileges
for my users.
Thanks,
Cesar A. Cabrera E.
-
'http://www.utp.edu.co/Lin
> On 14-Jun-01 Terminal Velocity wrote:
> > I would like to use MySQL to manage my company data, but my clients want
> > all their information sent to them in an Excel spreadsheet. Presently I
> > use Access, and export a SELECT statement into Excel, and then make a
> > couple changes to the Excel
From: Don Read <[EMAIL PROTECTED]>
> On 14-Jun-01 Kenneth Johansen wrote:
> > hi all, ive got a small problem (again).
> > i have a table with an entry "foo" which is an int(3).
> >
> > my problem is that whenever i collect the values in my c program.
> > they are returned as characters with mysql
Well, I dont know why, when I do that , it tries to
look in /usr/local/mysql, so i just put a symbolic
link there and everything seems to be OK.
Thanks all
--- Gerald Clark <[EMAIL PROTECTED]>
wrote:
> You forgot the
> mysql_install_db --user=mysql
>
> Mark Vann wrote:
>
> > Hey gang, I got th
> >Thank you all for your original suggestions, but I'm still having problems.
> >I copied this verbatim from the MySQL docs and tried it on two seperate
> >servers:
> >
> >mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%"
> > ->IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
> >ERROR
Is something run from cron deleting the socket?
The second error is just because your PHP script did not check for the
first error.
David Addison wrote:
> I use MySQL with PHP on a BSD server. For the last week or so I've been
> getting errors. My problem is that I'm not sure how to read the
Caveat: I'm not a seasoned Borland C++ builder programmer so this may very
well be just plain stupidity on my part (I'm not even a really good C
programmer either !).
However, givem some code that looks similar to this:
int state;
MYSQL_RES *result;
MYSQL_ROW row;
char sql[250];
spr
You forgot the
mysql_install_db --user=mysql
Mark Vann wrote:
> Hey gang, I got the configure script to run with no
> errors and got it installed in the /opt directory by
> using the following.
>
> ../configure --with-named-z-libs=no --without-debug
> --with-mysqld-user=mysql --prefix=/opt/mysq
Hello and thanks,
can you tell me where can I get information about the errors
presented by MySQL? I have that kind of trouble each time the server (the
machine) crash and it's no solved after myisamchk with any option.
thanks again,
Cesar A. Cabrera E.
On 14-Jun-01 Kenneth Johansen wrote:
> hi all, ive got a small problem (again).
> i have a table with an entry "foo" which is an int(3).
>
> my problem is that whenever i collect the values in my c program.
> they are returned as characters with mysql_fetch_row. (which is ok)
> but i cant seem t
On 14-Jun-01 Terminal Velocity wrote:
> I would like to use MySQL to manage my company data, but my clients want
> all their information sent to them in an Excel spreadsheet. Presently I
> use Access, and export a SELECT statement into Excel, and then make a
> couple changes to the Excel file (I
Hello
Does anybody know how to get MySQL build on HPPA architecture?
bye,
-christian-
--
Real men don't take backups.
They put their source on a public FTP-server and let the world mirror it.
-- Linus Torvalds
Package: mysql
Version: 3.23.39-1
Complete tutorial on installing Mysql, PHP and Apache can be found on
www.devshed.com
Have fun.
B.
At 11:12 14-6-01 -0700, Mark Vann wrote:
>Hey gang, I got the configure script to run with no
>errors and got it installed in the /opt directory by
>using the following.
>
>./configure --with-
On 14-Jun-01 brainheap wrote:
> hi ppl!
>
> I have two consequent queries
>
> "select @g1=user from user_space where connects>10"
> and
> "select connect_time from connects where user=@g1"
>
What if there are more than 1 user(s) where connects >10, or none ?
> To prevent misunderstanding I
I see you're mailing the ODBC lists as well, that may very well be your
answer. Mind you I'm not familiar with Mac Programming, however, why not
open a odbc connnection to your DB. You can do it with MS Access on windows
easy enough, why not on a Mac?
Matt "Trollboy" Wiseman
www.shoggoth.net/tr
On the internet specifically I'd say try http://www.mysql.com/manual.php ,
it's one of the better manuals I've come across (Free Software or
Commercial). If you want an excellent book, get MySQL by Paul DuBois. Also
'The Practical SQL Handbook' is good, although not MySQL specific.
Best of luck!
I was indeed trying to test a remote connection to mysql server. I am
actually trying to get JDBC working from a client that does not have MySQL
installed, and was just trying to use telnet to see if the connection
worked. I have discovered that I must install a JDBC driver of some kind on
the s
Hey gang, I got the configure script to run with no
errors and got it installed in the /opt directory by
using the following.
./configure --with-named-z-libs=no --without-debug
--with-mysqld-user=mysql --prefix=/opt/mysql
But after the make install ( and I saw no errors )
there is no /opt/mysql
I believe that i've seen this on the list before.
Read the php docs before compiling, don't use the builtin mysql support,
specify --with-mysql=/path/to/mysqllibs
HTH
Greg wrote:
> I'm trying to have mod_perl and php running in the same apache server,
> accessing the same mysql database.
>
>
If I understand you correctly, you probably want to look into "left
joins". I.e.
select a.field, b.field from table1 a left join table2 b on
a.id=b.tbl1.id
vs
select a.field, b.field from table1a, table2 b where
a.id=b.tbl1.id
The first will show matching rows from table1 even
Still doesn't work, I've even tried:
HAVING
( Avg_Xmit = 12345 ) AND ( Samples >= 25 )
19000 rows returned, none equalling 12345, but all have Samples >= 25.
It's almost as if this became an OR.
Cliff
Gerald Clark <[EMAIL PROTECTED]> writes:
> Have you tried:
> HAVING
> ( Avg_Xmit
I have just checked bugs.debian.org .
Debian Bug report logs - #81181
gcc: sig 11, reproducible and not machine-specific
Somebody have file the same problem, with imapd.
not mysql's bug =)
--
Cheng Yuk Pong (SDiZ)
4096/1024 DH/DSS 0xA4C6FAD3
FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FA
> On Thursday 14 June 2001 08:19, SDiZ Cheng wrote:
> > Thanks all..
> > It's up and running now..
> > Seems that is a bug in Debian's CVS version gcc.
> > I can't get older version of kernel compile on it too.
> > I will move this to debian's mailing list =)
>
> Trying to run MySQL 3.23.35 is tro
On Thursday 14 June 2001 08:19, SDiZ Cheng wrote:
> Thanks all..
> It's up and running now..
> Seems that is a bug in Debian's CVS version gcc.
> I can't get older version of kernel compile on it too.
> I will move this to debian's mailing list =)
Trying to run MySQL 3.23.35 is trouble (that is w
On Thu, 14 Jun 2001 13:50:43 -0300, Nasir Ali <[EMAIL PROTECTED]> wrote:
Well as they say, "...if all else fails, RTFM.." :) Or pick up Paul Dubois's
book on MySQL.
>>Can somebody please point me to the good resourse of learning mysql's
>>SELECT command on the Internet?
>>
>>Thanks,
>>
>>
Daniel Vignes wrote:
>
> Hi,
>
> I hope someone out there has an answer to this problem I'm having.
> I'm trying to get mysql installed on a x86 Solaris 8 box, the
> version I'm trying to install is 3.23.39. The configure script goes
> through fine, when then try to make it dies out giving me
I can't use "mysqlcheck -m -A" and "mysqlcheck -e -A"
It returns with a syntax error..
But i can run "mysqlcheck -A" with no error.
It that a known problem?
--
Cheng Yuk Pong (SDiZ)
4096/1024 DH/DSS 0xA4C6FAD3
FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3
-
Hey all,
This is actually more of a theory question than anything else.
I have most of my databases built to 4th normal form. So that means I am have
tons of foreign keys to primary keys and what-not. Almost every table is
linked to another table. The only problem I can forsee is when you decide t
Hi,
I have a database with 14 million rows which contains 3 indexes. I am
trying to drop two of these indexes and create another one. However each
operation takes about 12 hours. Is there anyway I can make this a lot faster
by changing runtime variables and similar things.
Thanks in advance,
The only thing I could suggest is that the version of MYSQL you have is not
compatible with something else that is running, like PHP perhaps, or even
the version of Linux/Kernel/C-libraries. You are experiencing very strange
problems, and these types of things are typically caused by incompati
>Description:
create table ... with a select statement at the end seems to think
there are duplicate entries:
>How-To-Repeat:
mysql> create table nr_current (id int unsigned not null primary key) TYPE=HEAP
> select distinct protein_id from nr where current = 1;
ERROR 1062: Duplicate entry
Mysql version 8.0, distrib 3.22.32
select (1 < 5 < 3) = 1
select ((1<5) < 3) = 1
select (1< (5 < 3)) = 0
In this version, apparently left to right.
Regards,
Rich
At 05:16 PM 6/14/01 +0100, Jon Haworth wrote:
> > And why do you think it should return 0 ?
> >
> > ( 1 < 5 ) returns 1.
> > ( 1 < 3
Can somebody please point me to the good resourse of learning mysql's
SELECT command on the Internet?
Thanks,
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Thu, 14 Jun 2001, Jeremy Zawodny wrote:
> I have a few comments and questions:
>
> (1) Is this a unique index? If not, consider doing a partial index
> on the column. Index the first 32 characters or so. I'll save a
> lot of disk I/O, memory, and CPU time but still yeild pretty
Hi,
I hope someone out there has an answer to this problem I'm having.
I'm trying to get mysql installed on a x86 Solaris 8 box, the
version I'm trying to install is 3.23.39. The configure script goes
through fine, when then try to make it dies out giving me this
E_RWLOCK_T -c my_error.c -f
Hey all,
This is actually more of a theory question than anything else.
I have most of my databases built to 4th normal form. So that means I am have tons of
foreign keys to primary keys and what-not. Almost every table is linked to another
table. The only problem I can forsee is when you decide
And there are about 27000 records in agency_location...thouh I hope the
number of records isn't the problem.
Thanks for the suggestions. I am doing them now.
Thanks!
Jeremy
-Original Message-
From: Hise, Jeremy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 12:13 PM
To: Mysql
On Thu, Jun 14, 2001 at 08:16:01AM +0100, Dvoøáèek Michal wrote:
> Hi there,
>
> little problem. I have program (like phorums) and there is command
> mark all posts as readed. On one board is about 4000 posts, and if
> is new user and want mark all posts as readed - it's problem (big).
>
> All i
> And why do you think it should return 0 ?
>
> ( 1 < 5 ) returns 1.
> ( 1 < 3 ) returns 1.
> ( 1 < 5 < 3 ) should then return 1.
>
> Or am I missing something?
>
I think probably becuse ( 5 < 3 ) returns 0.
Depends how you read it, either as "1 is less than 5 and less than 3" or "1
is less t
hi all, ive got a small problem (again).
i have a table with an entry "foo" which is an int(3).
my problem is that whenever i collect the values in my c program.
they are returned as characters with mysql_fetch_row. (which is ok)
but i cant seem to convert them into int,
using something like
tem
On Thu, Jun 14, 2001 at 11:31:32AM -0400, Robin Senior wrote:
>
> Just kidding! But it seems that way...
>
> Indexing a 7 million row VARCHAR(255) table took ~12 minutes on my Athlon
> 1.33Ghz w/512MB.
> Indexing a 77 million row VARCHAR(255) table has taken 9 DAYS, and still
> hasn't finished.
>
Yes. I actually forgot to specify that. We thought maybe the ODBC/CR was
causing some overhead problems. So we did go straight to the monitor. But we
got the same problem.
-Original Message-
From: Huntress Gary B NPRI [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 14, 2001 12:12 PM
To: '
What happens when you run this with the OPTIMIZE command?
Simon
-Original Message-
From: Hise, Jeremy [mailto:[EMAIL PROTECTED]]
Sent: 14 June 2001 17:03
To: Mysql (E-mail)
Subject: Crazy Query
Hi:
We have a set-up that consists of mySQL running on Linux (rh6.2) with
Crystal Reports
I am using the MySQL offical binary. It's okay now..
Just curious.. what distro and gcc/glibc version MySQL team
use to compile their linux binary?
--
Cheng Yuk Pong (SDiZ)
4096/1024 DH/DSS 0xA4C6FAD3
FE28 E6D4 AD21 5D4F F07B EEA6 3C88 5DBB A4C6 FAD3
---
Hi:
We have a set-up that consists of mySQL running on Linux (rh6.2) with
Crystal Reports running reports on another machine. Everytime the report is
ran and CR grabs it's data through the query listed below, it ties up mySQL
(top reports processor % used is 90%+) and never seems to end. We've e
Hello,
I'm trying to set up replication, but I cant get any further than this
message on the slave.
Error reading packet from server: log event entry exceeded
max_allowed_packet
My max allowed packet size is 512M which I've gradually reached while trying
to stop the above error message.
Just kidding! But it seems that way...
Indexing a 7 million row VARCHAR(255) table took ~12 minutes on my Athlon
1.33Ghz w/512MB.
Indexing a 77 million row VARCHAR(255) table has taken 9 DAYS, and still
hasn't finished.
Obviously this isn't a linearly scaling operation, but it is seeming
dang ne
I use MySQL with PHP on a BSD server. For the last week or so I've been
getting errors. My problem is that I'm not sure how to read the error code:
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock' (61) in
/usr/home/thebookc/usr/local/et
---Reply to mail from Sinisa Milivojevic about Multiple CPU's in Freebsd
> Ken Menzel writes:
>> Hi Sinisa,
>>Since matt hasn't responded yet, I'll let you know, its not the
>> version of FreeBSD, but the ports collection. The ports collections
>> does not have a version number, people sh
Hi,
I'm looking to get a mySQL client on a PPC LynxOS board talking to a MySQL Server on
PPC Linux.
The server is up and running, but I now need to get the LynxOS client, and am cross
compiling from Solaris to Lynx with the Lynuxworks toolkit v3.1 and unfortunately not
getting very far.
So f
Hi. Our clients are asking for AND searches in fulltext fields. The manual
says it's already implemented in the 4.0 tree. Can anyone tell me when we
will see a public version of MySQL featuring AND searches in fulltext fields?
=
D
CHANGELOG:
- Fixed ResultSet.getBlob() ArrayIndex out-of-bounds
- Fixed ResultSetMetaData.getColumnTypeName for TEXT/BLOB
- Fixed ArrayIndexOutOfBounds when sending large BLOB queries (Max size
packet was not being set)
- Added ISOLATION level support to Connection.setIsolationLevel()
- Fixed NP
On Wed, Jun 13, 2001 at 06:02:52PM -, [EMAIL PROTECTED] wrote:
> database,sql,query,table
[Hint to list maintainer: add "3.23" as a string that gets a message through
- even better, collect a copy of the next 100 legitimate messages you
bounce, and collect keywords from them sufficient to ge
Ken Menzel writes:
> Hi Sinisa,
>Since matt hasn't responded yet, I'll let you know, its not the
> version of FreeBSD, but the ports collection. The ports collections
> does not have a version number, people should just fetch latest
> (using cvsup) however you can fetch by date. A packa
I'm trying to have mod_perl and php running in the same apache server,
accessing the same mysql database.
At runtime, when the first request is issued from perl, I get the
following error:
dyld: /Local/Server/Apache/sbin/httpd multiple definitions of symbol
__dig_vec
/Local/Server/Apache/sbin
Hi Sinisa,
Since matt hasn't responded yet, I'll let you know, its not the
version of FreeBSD, but the ports collection. The ports collections
does not have a version number, people should just fetch latest
(using cvsup) however you can fetch by date. A package in the ports
collection ma
nsabbi wrote:
> mysql> select (1 < 5 < 3);
> +-+
> | (1 < 5 < 3) |
> +-+
> | 1 |
> +-+
> 1 row in set (0.00 sec)
>
>
> mysql> select (1 < 5 and 5 < 3);
> ++
> | (1 < 5 and 5 < 3) |
> ++
> | 0
Have you tried:
HAVING
( Avg_Xmit < 28800 )
AND ( Samples >= 10 )
?
Cliff Daniel wrote:
> I'm having some difficulting on 3.23.38, linux x86... When I write
> the following query the HAVING clause is only listening to the 'AND
> Samples >= 10' and displas all Avg_Xmit regardless if it's le
I would like to use MySQL to manage my company data, but my clients want
all their information sent to them in an Excel spreadsheet. Presently I
use Access, and export a SELECT statement into Excel, and then make a
couple changes to the Excel file (I just high-lite the updated data).
I want to ch
Goodday
This is exactly what I have had problems with, and in the manual it tells
you that autoincrement fields are not supported in circular replication. I
posted a MSG on this group asking for feedback from the developers but got
nothing.
You have to dump he autoincrement, and do it manually i
My replies seem to never send to the mysql-list
but to the ppl who sent a request only, so
I am forwarding this again.
Maybe it will help other ppl as well :)
Nessi
>Date: Wed, 13 Jun 2001 11:36:41 +0100
>To: "Ute Hoffmann" <[EMAIL PROTECTED]>
>From: Nessi <[EMAIL PROTECTED]>
>Subject: Re: Acce
Try link is with -L/path to your library -lmysqlclient
You need library libmysqlclient which is currently in
instaldir/lib/mysql/...
---
Dvoøáèek Michal mailto:[EMAIL PROTECTED]
-
Before posting, pl
Hello!
I have two databases that i want to replicate: each database should contain
the same information. That's why i have set a circular replication relation.
All works fine, except that one of the table is filled in real-time; this
table has a primary key with autoinc type. When a new record is
mysql> select (1 < 5 < 3);
+-+
| (1 < 5 < 3) |
+-+
| 1 |
+-+
1 row in set (0.00 sec)
mysql> select (1 < 5 and 5 < 3);
++
| (1 < 5 and 5 < 3) |
++
| 0 |
++
1 row in set (0.0
1 - 100 of 115 matches
Mail list logo
