Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
I'm currently testing it by doing:
if(abs(left(field,locate(' ', field))>0),'Numeric bit at front', 'Not
Numeric bit at front')
It seems t
Could anyone tell me how to get past this error please? When I 'make
test' some of the tests run but then it dies with.
create [ pass ]
ERROR: /home/tekton/src/mysql-4.0.13/mysql-test/var/run/master.pid was
not created in 30 seconds; Aborting
Or can this
MySQL has posted a very interesting comparison on their website. It appears
to be a reasonably fair evaluation. PostgreSQL was faster than MySQL in some
areas and MySQL was faster than PostgreSQL in most areas.
For speed with all of that functionality, I'd be more inclined to look at DB2
rat
Hi!
First of all, if I decide to benchmark MySQL vs. PostgreSQL with my
application, PostgreSQL will probably be faster. That does not mean that
MySQL is "generally" slower or that I *want* it to look slower. That
just means
1) I have no experience in tuning MySQL
2) My application was built wi
> As a minor side issue, we did some _very limited_ testing with MS SQLServer
> 2000 using unicode v ascii queries. Using unicode, queries tended to run at
> about half the speed compare to using ascii.
> This was client server, so it is likely that the increased network traffic
> is to blame, but
> > If maximum speed is critical.
> >
> > It's easy to lose sight of the fact that speed is not the
> > only criterion
> > in choosing a DBMS. Features, stability, security, and so on can be
> > just as important or more so. No single DBMS is going to win all the
> > prizes; the trick is to
same environment and network conditions, mainly, using IPv6
network protocol.
Robson
- Original Message -
From: "Andy Eastham" <[EMAIL PROTECTED]>
To: "Mysql List" <[EMAIL PROTECTED]>
Sent: Monday, July 14, 2003 2:12 PM
Subject: RE: MySQL vs. PostgreSql -- speed
ubject: Re: MySQL vs. PostgreSQL -- speed test
>
>
> >> >I agree with your opinion in 100%, but in my case I need DBMS with
> >> >features like subselectes/utf-8/stored procedures but the
> >> speed is also
> >> >very important issue.
> >>
4 5 6
-Original Message-
From: Tom Roos [mailto:[EMAIL PROTECTED]
Sent: Montag, 14. Juli 2003 11:48
To: [EMAIL PROTECTED]
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / /
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
>> >I agree with your opinion in 100%, but in my case I need DBMS with
>> >features like subselectes/utf-8/stored procedures but the
>> speed is also
>> >very important issue.
>>
>> You might have to spend money!
>>
>>
>You are saying that there is DBMS with all this features and it is as
>fast as
> >I agree with your opinion in 100%, but in my case I need DBMS with
> >features like subselectes/utf-8/stored procedures but the
> speed is also
> >very important issue.
>
> You might have to spend money!
>
>
You are saying that there is DBMS with all this features and it is as
fast as MySQL
>> If maximum speed is critical.
>>
>> It's easy to lose sight of the fact that speed is not the
>> only criterion
>> in choosing a DBMS. Features, stability, security, and so on can be
>> just as important or more so. No single DBMS is going to win all the
>> prizes; the trick is to find th
Very smart your opinion, I agree at all with you.
-Mensaje original-
De: Bruce Feist [mailto:[EMAIL PROTECTED]
Enviado el: Monday, July 14, 2003 5:37 AM
Para: MySQL List
Asunto: Re: MySQL vs. PostgreSQL -- speed test
Marek Lewczuk wrote:
>For everyone who thinks about moving from My
>
> which PostgreSQL version have you testet? If you want compare
> MySQL and
> PostgreSQL, than you have to use InnoDB tables. Tests with
> MyISAM make no
> sense. Out J2EE Application is working woth PostgreSQL 7.3.3
> and MySQL
> 4.0.13 with InnoDB tables (we need transactions and
> refe
> If maximum speed is critical.
>
> It's easy to lose sight of the fact that speed is not the
> only criterion
> in choosing a DBMS. Features, stability, security, and so on can be
> just as important or more so. No single DBMS is going to win all the
> prizes; the trick is to find the one
Marek Lewczuk wrote:
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth.
That's a bit of an overstatement!
Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought
Hello group,
For everyone who thinks about moving from MySQL to PostgreSQL I have a
realy bad news - It's not worth. Why, You may ask... A few days ago I
have installed and tested PostgreSQL, becouse I realy need UTF-8 support
and subselects. I thought that PostgreSQL will be as good as MySQL but
a
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / / / \/ / /
/_ / /__ / /_ / /_ /
Cell: 083 440 2213
Ph: 021 980 4969
Hey all,
I was trying to compile, test and install MySQL-4.0.13. Compile went
well and it was configured with --with--innodb --enable-assembler
--prefix=/usr and nothing else. However when I make test it goes through
to create, passes that then stops for 30 seconds and give the error that
the
your sleep. During the exam you will not
have a lot of time to make guess work (70 questions in 90 minutes).
Its a lot to read, a lot to think and only a bit to click ;-).
Make sure you put the crosses at the right places ;-)
My summary: Nice, but not easy skill test. The best thing is also when you ca
Hello. Thought I¹d pass this along to whoever cares.
Issue:
error running the mysql-test-run as logged
> Installing Test Databases
> Removing Stale Files
> Installing Master Databases
> mysqld is missing - looked in ../bin
> Error: Could not install master test DBs
Any sugges
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/
I am sorry, I forgot to mention that MySql passed or skipped all tests
up to the
ctype_latin1_de test the message in terminal is
ERROR: /usr/local/stayathome/mysql/mysql-test/var/run/master.pid
was not created in 30 seconds; Aborting
I have tried mysql-test-run --force (times out after 30
From: root <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [mysql-test-run failure Mac OS X 10.2.6]
>Description:
>How-To-Repeat:
< sudo perl mysql-test-run>
>Fix:
< unknown >
>Submitter-Id:
>Originator:System Administrator
>O
I don¹t seem to be getting any messages, this is just a test, mysql query
--
-
Scott HanedaTel: 415.898.2602
http://www.newgeo.com Fax: 313.557.5052
[EMAIL PROTECTED
Dear all
I had installed mysql. Things comes right till i tried to execute " perl
run-all-tests" i got the following error
/usr/local/bin/perl: relocation error:
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBD/mysql/mysql.so:
undefined symbol: mysql_init
Any ideas?
hamid
On Tue, Jun 10, 2003 at 12:33:10PM -0600, Mike Hillyer wrote:
> I think the other thing to remember is that this is only the Core exam,
> and as far as I can tell a fair amount of the content you suggest will
> be part of the Pro exam. I remember once seeing stirrings of a DBA exam
> as well, so I
Carsten Pedersen wrote:
Quick words of introduction before you read on: I'm the MySQL AB
Certification Manager :-)
Glad to meet you!
Balance: A good exam will test both skill AND knowledge -- knowing how
to change the table type from MyISAM to InnoDB is knowledge -- realizing
when and why
Mike Hillyer wrote:
I think the other thing to remember is that this is only the Core exam,
and as far as I can tell a fair amount of the content you suggest will
be part of the Pro exam.
Fair enough. But that leaves the issue of exactly what is appropriate
to test in the Core exam.
The
Jeremy Zawodny wrote:
On Tue, Jun 10, 2003 at 12:50:04PM -0500, Paul DuBois wrote:
At 7:51 -0700 6/10/03, Jeremy Zawodny wrote:
What's the point of such a question? Anyone with access to MySQL can
find out by simply running the query.
You don't have access to MySQL durin
Yes, there are some questions on the practice test that ask "just"
knowledge-based questions rather than testing skills, and while they are
over-represented on the practice test, you will also find a good deal of
these on the actual exam.
As Mike says, it's a trade-off - while low-cost
Some of the best/hardest test I have taken are over at brainbench.com.
They have some free tests and some sample exams that are also free (you
do have to register). The tests are extensive and really test your
breadth of knowledge in a particular area. For instance, I was born and
raised in
n the
market, but the tradeoff is that I count maybe 20-30 locations on their
website that you can take the exam, at a cost of $749 plus travel to the
nearest center.
When I check for a MySQL exam center, I see more test centers in
California alone that RedHat offers in all of north America, and I pay
alid in MySQL?"
> >
> > [some query]
> >
> >What's the point of such a question? Anyone with access to MySQL can
> >find out by simply running the query.
>
> You don't have access to MySQL during the test. You have to know
> whether or not th
Paul DuBois wrote:
At 7:51 -0700 6/10/03, Jeremy Zawodny wrote:
"Is this syntax valid in MySQL?"
[some query]
What's the point of such a question? Anyone with access to MySQL can
find out by simply running the query.
You don't have access to MySQL during the tes
we all get the same questions, but I was disappointed
in some of those I was asked. One was like:
"Is this syntax valid in MySQL?"
[some query]
What's the point of such a question? Anyone with access to MySQL can
find out by simply running the query.
You don't have access
Hi Rich, Jeremy,, Mysql List
2003年 6月 10日 火曜日 23:51、Jeremy Zawodny さんは書きました:
> On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote:
> > Has anyone else tried this? I got 8/10. Going to the exam next week;
> > I suppose that's a good sign :-)
> >
> > http://www.mysql.com/certification/self
On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote:
> Has anyone else tried this? I got 8/10. Going to the exam next week;
> I suppose that's a good sign :-)
>
> http://www.mysql.com/certification/selftest/core/index.php
I don't know if we all get the same questions, but I was disappoin
Has anyone else tried this? I got 8/10. Going to the exam next week;
I suppose that's a good sign :-)
http://www.mysql.com/certification/selftest/core/index.php
- Rich
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
test
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
/cygdrive/g/mysql/mysql-3.23.55-pc-linux-i686/mysql-test
$ mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
../bin/mysqld: 1: Syntax error: "(" unexpected
Error: Could not install master test DBs
What is the cause of this error?
Thank Y
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Aman Raheja wrote:
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQ
Hello friends
A friend of mine is running the current version of MySQL on a Win2k machine,
and using ODBC to connect his VB application. Thinks it is slow !
Is there some free tool available on the net to check the perforamnce of
MySQL on Windows platform or is there a reason why it might be slow o
-user=mysql \
--without-bench --with-innodb
and built with gcc-3.2.2. (I wanted to use --with-openssl, but couldn't
find any combination of options that would make it link correctly
against libssl.) MySQL built cleanly, but ran into the following
problem during make test:
babylon5
>Description:
make test fails on create.
>How-To-Repeat:
make test
output of ./mysql-test-run --local create shown here
-- CUT --
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-defaults --boo
Test
--
Karthikeyan Balasubramanian
[EMAIL PROTECTED]
--
http://www.fastmail.fm - Access your email from home and the web
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: make test fails - strack trace included
>Severity:
My email does not seem to be getting through.
This is a test to confirm whether this problem with
the mysql mailing list has been corrected.
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
http://www.johnsons-w
doc/en/extending_mysqltest.html
* http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
This was an automated response to your email 'Test'.
Final search keyword used to query the manual was 'Test'.
Feedbacks, suggestions and complaints about me should be
di
I'm not getting mail, so I'm seeing if I can send. If you get this,
plesae disregard.
Adam.
sql query
---
Adam Randall http://www.xaren.net/
[EMAIL PROTECTED]
Just a test for the MySQL list.
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
Sorry guys/gals, just a test for the mysql list.
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
Sorry, messages from the sql list seem to have ceased. It's all gone very
quiet.
Steve
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
On Thu, 16 Jan 2003 [EMAIL PROTECTED] wrote:
> sql,query,queries,smallint
--
Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870
Licensed Texas Peace Officer
Computer Crime Investigation Consultant
Director, Software Development
Escapade Server-Side Scripting Engine Deve
Since just before christmas I have not gotten any e-mails from the
mysql-mailing list... so I send this to test my access, can anyone see
it? Please reply in private so that I know if it works or not...
/Christian Andersson
hello, testing first off.
anyone get mysql to work with dreamweaver? =)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
>Description:
I configure with the line shown at the bottom. There are no erros. I make, with the
following command:
make -s -j 2
There are no erros. Some warnings, but docs say those are to be expected.
However, when I run 'make test' I get
> Anybody seen a general page or study guide for the beta test yet? There
> used to be a section on the MySQL site
> (http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now
> and taking the test here in a couple days. Looked around on the site
> but the information
Anybody seen a general page or study guide for the beta test yet? There
used to be a section on the MySQL site
(http://www.mysql.com/training/candguide/sec-core.htm) but its 404 now and
taking the test here in a couple days. Looked around on the site but the
information doesn't seemed to a
>Description:
I just compiled MySQL from source using the default options on my
Slackware 8.1 system. I then ran the test suite (as the document-
ation said i should) and one of the tests failed. I attempted to
force it to resume, but it seems to lock up (or
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMA
I run the mysql-test as root.
-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED]]
Sent: 2002Äê11ÔÂ19ÈÕ 16:25
To: Yu, Jerry; [EMAIL PROTECTED]
Subject: RE: one mysql-test issue
Does it have write permissions for the user running the tests?
M
-Original Message
Does it have write permissions for the user running the tests?
M
-Original Message-
From: Yu, Jerry [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2002 08:03
To: Matthew Smith; Yu, Jerry; [EMAIL PROTECTED]
Subject: RE: one mysql-test issue
Sure, the directory exists. :)
Rgds
--Jerry
Sure, the directory exists. :)
Rgds
--Jerry
-Original Message-
From: Matthew Smith [mailto:[EMAIL PROTECTED]]
Sent: 2002Äê11ÔÂ19ÈÕ 15:51
To: Yu, Jerry; [EMAIL PROTECTED]
Subject: RE: one mysql-test issue
Does the directory /usr/local/mysql/var/run exist?
If not, try creating it
Does the directory /usr/local/mysql/var/run exist?
If not, try creating it!
Regards
Matthew Smith
-Original Message-
From: Yu, Jerry [mailto:[EMAIL PROTECTED]]
Sent: 19 November 2002 07:41
To: [EMAIL PROTECTED]
Subject: one mysql-test issue
> Hi,all
> I built the mysql-4.0.
> Hi,all
> I built the mysql-4.0.3-beta source on redhat7.3 with gcc2.95.3 using only
> one option:
> --prefix=/usr/local/mysql.
> It is built successfully and installed to /usr/local/mysql. But during
> running the mysql-test, it always aborted and reported that
> "/
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
This is a test to the sql list. I sent a message concerning MySQL+NFS
problems and it didn't go through.
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
-
Before posting, please check:
http://www.mysq
Hi,
I have configured a master slave ring architecture. Can anyone suggest
me how to load test this architecture ?
I am using three MySQL servers in the following fashion :
A --> B --> C --> A
where A is the Master to B, B is the Master to C and C is the Master to A.
>Description:
Uneventful download and build of Source Package for 4.0.4 beta. Upon
running the test suite, the program aborts after 30 seconds of waiting for
a master.pid file to be created. truss and error log analysis show this is
due to either: the lack of a valid latin1_de.conf char
Hi,
Using MySQL, perl and DBI, is there a way to test to see if a table is
locked (as in "LOCK table..."). We batch process our updates every 3
hours or so (it's not a set schedule though, it depends when a certain level
of new updates is reached), and our main tables are loc
On 21-Oct-2002 Mailing Lists wrote:
> Hi,
>
> Using MySQL, perl and DBI, is there a way to test to see if a table is
> locked (as in "LOCK table..."). We batch process our updates every 3
> hours or so (it's not a set schedule though, it depends when a cer
>Description:
Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00
>How-To-Repeat:
By compiling mysql 3.32.52 with the options mentioned below a simple "make test" will
show the problem on test "func_time"
>Fix: none
>Submitter-Id: none
>Originat
>Description:
Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00
>How-To-Repeat:
By compiling mysql 3.32.52 with the options mentioned below a simple "make test" will
show the problem on test "func_time"
>Fix: none
>Submitter-Id: none
>Originat
on Tue Sep 3 21:48:10 2002
pine:~/src/Msql-Mysql-modules-1.2219$ cat prep.sh
#!/bin/sh
perl Makefile.PL \
--config \
--static \
--mysql-test-db=tvbarn \
--mysql-test-user=tvbarn \
--mysql-test-pass=X \
--mysql-test-host=pine.he.net \
--v
on Tue Sep 3 21:48:10 2002
pine:~/src/Msql-Mysql-modules-1.2219$ cat prep.sh
#!/bin/sh
perl Makefile.PL \
--config \
--static \
--mysql-test-db=tvbarn \
--mysql-test-user=tvbarn \
--mysql-test-pass=X \
--mysql-test-host=pine.he.net \
--v
on Tue Sep 3 21:48:10 2002
pine:~/src/Msql-Mysql-modules-1.2219$ cat prep.sh
#!/bin/sh
perl Makefile.PL \
--config \
--static \
--mysql-test-db=tvbarn \
--mysql-test-user=tvbarn \
--mysql-test-pass=X \
--mysql-test-host=pine.he.net \
--v
testing mysql list server to see if my posts are recieved
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
you grab the balance , manipulate it by adding or subtracting an amount then
updating it.
Randy
- Original Message -
From: "Tod Harter" <[EMAIL PROTECTED]>
To: "bin cai" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 3:3
shown up there at some point.
> Hi,
> I have completed a web-based application using java
> servlet with mysql as the backend database and tomcat
> as the server. I try to test my application
> performance using a free test tool. i found one called
> Microsoft Web Application Stres
Hi,
I have completed a web-based application using java
servlet with mysql as the backend database and tomcat
as the server. I try to test my application
performance using a free test tool. i found one called
Microsoft Web Application Stress tool) it is free. but
it's test script is used b
I have a database called test
in the mysql database db table it is listed as
"test" and "test\_%"
what is the significance of two record that have all the Y/N entries the same?
.
-
Before posting, p
Hello,
I've tried to install mysql 4.0.1 Alpha.
The configuration did not give me any error's
The "make" also worked just fine.
But when I run "make test" I get the following error:
ERROR: /down/new/mysql-4.0.1-alpha/mysql-test/var/run/master.pid was not
created
Hello,
I've tried to install mysql 4.0.1 Alpha.
The configuration did not give me any error's
The "make" also worked just fine.
But when I run "make test" I get the following error:
ERROR: /down/new/mysql-4.0.1-alpha/mysql-test/var/run/master.pid was not
created
hello,
i'm using mysql 3.23.51-max on windows 98. It worked fine up until the
point where I started using a PHP app that used the command SHOW TABLE
STATUS FROM tablename.
Everytime this is executed Mysql gives me a dialog window that says Test
Signal with an OK button, then I get an illeg
found some
stress test software but they not free. so i am trying
to write a simple testing script.
Any help will be appreciated very much.
bin
__
Movies, Music, Sports, Games! http://entertainment.yah
after running "make test" i received 3 errors relating to rpl01, 4,
and and 7. This error message is displayed:
AT line 6: query 'slave stop' failed: 1199: This operation requires a
running slave, configure slave and do SLAVE START
At line 6: query 'load da
all passed up to rpl01:
At line 6: query 'slave stop' failed: 1199: This operation requires a
running slave, configure slave and do SLAVE START
home/mysql/bin/mysqltest: At line 6: query 'load data infile'
../../std_data/words.dat' into table t1' filed: 1085: The file
../../std_data/words.
At 20:55 -0700 5/10/02, Frederick Shaul wrote:
>I understand what test% might mean, but don't know what test\_% means.
It's a SQL pattern string that matches a literal "test" followed by
a literal "_" followed by anything. "_" in SQL patterns normally
I understand what test% might mean, but don't know what test\_% means.
Following is from a fresh MySQL install ...
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql
On Fri, May 10, 2002 at 05:33:32PM -0600, Matthew Walker wrote:
> I have to say that I disagree. It would be a very good idea to
> recompile the kernel, to get rid of all the fancy sound and graphics
> options. The smaller your kernel, the better. Also, you might want
> to look at the Preemptive
I have to say that I disagree. It would be a very good idea to recompile
the kernel, to get rid of all the fancy sound and graphics options. The
smaller your kernel, the better. Also, you might want to look at the
Preemptive patch for the kernel, to help improve performance further.
Matthew Walke
On Thu, May 09, 2002 at 09:21:12AM -0400, Darrell A. Sullivan, II wrote:
>
> I am considering porting our applications that currently use an
> in-house database schema to MySQL. I need to setup a test system to
> try this out and I am needing a few pointers.
Excellent.
> Firs
hi,
i installed mysql 4.0.1 max for freebsd and
tried running the test as per
http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.html#Po
st-installation
su-2.05# pwd
/usr/local/mysql/sql-bench
su-2.05# ./run-all-tests
Can't locate DBI.pm in @INC (@INC contains: /usr/li
Try
shell> cd YourMysqlInstallationDirectory
shell> bin/safe_mysqld &
shell> mysql -h host -u user -ppassword
Hisseine
- Original Message -
From: "Fei Chen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 18, 2002 10:36 AM
Subject
Dear all,
I don't know where to look for this information... Couldn't find it in the
manual.
How do I test whether a connection has been established so I don't need to
open a new one again? e.g.
MYSQL tmp;
void f1(){
mysql_init(&tmp);
mysql_real_connect(&tmp,...)
}
vo
> Don't you think you should use
>
> select * from test WHERE a=0 ;
>
> not
>
> select * from test where 0;
>
> Isn't the correct usage of WHERE
Well, usually my queries could look like this:
insert into #report (Line)
select isnull(a.Object,
OTECTED]]
> Sent: Tuesday, April 16, 2002 11:07 AM
> To: Mysql List
> Subject: RE: WHERE codition test
>
>
> On 16 Apr 2002, at 10:58, Jon Frisby wrote:
>
> > String literals in a truth test such as you set up are coerced
> to integers.
> > (A la C's '
> Neither I, it seams strange. This value has to be stored in some kind
> of pointer to an object or char * in the program it self. I would first
> assume that the content of the pointer is tested, but that cant be true
> since the content in this case is the number 65.
You're assuming a very low
201 - 300 of 421 matches
Mail list logo