I purchased a book entitled PHP3 programming browser-based Applications it
came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux
distribution. Anyhow, I am having problems installing the software on my SuSe
7.1 linux box. Basically, there are eleven steps that the author
I purchased a book entitled PHP3 programming browser-based Applications it
came with a cd that contained a copy of MySql-3.22.16a-gamma for any linux
distribution. Anyhow, I am having problems installing the software on my SuSe
7.1 linux box. Basically, there are eleven steps that the author
Hello,
I have simple question.I have installed on my computer WinNT 4.0, Apache 1.3.14, PHP4
(4.0.4pl1), MySQL MAX 4.0.1. There's problem with char set win1250. I don't know how
can I link this char set. Script with this row $spojeni = MySQL_Connect(localhost);
sends an error Warning: MySQL
Nick,
Tuesday, April 09, 2002, 5:21:00 PM, you wrote:
NS Is there a way to store files in MySQL? Looking to store somthing like a
NS zip file in the databaseand be able to retrieve/download it from something like
ASP.
Yes, you can store files in the BLOB fields. You can find some info
about
hi,
i've just started work with MySQL. Does anybody know how can i
use stored procedures with MySQL? Is this capability supported?
Thanks
John Dimos
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Scott,
Tuesday, April 9, 2002, 6:20:38 PM, you wrote:
SA I been using mysqlimport for a long time with no problems.
SA But today when I try (as root)
SA mysqlimport admin /usr/local/systems/admin/data/person.txt -p
SA I get
SA mysqlimport: Error: Can't get stat of
SA
Jianping,
Tuesday, April 09, 2002, 5:55:08 PM, you wrote:
JZ I have a redhat 7.1 server, I want to get rid of the installed mysql
JZ server. How can check which version is installed and how to get rid of it?
You can indicate MySQL server version using SELECT VERSION()
statement or run mysqld
Yiannis,
Wednesday, April 10, 2002, 10:17:03 AM, you wrote:
YD i've just started work with MySQL. Does anybody know how can i
YD use stored procedures with MySQL? Is this capability supported?
MySQL doesn't have stored procedures yet, but it is in our plans to
support them, look at:
Aravind NagaVenkata Gorthy repeated himself:
Dear All
Could any one tell me what all the chages I have to make in
order
to make my existing (english version) of MySQL database
compatable
to the Japanese language.
So I repeat myself:
Boy. That's a tough one. I'm really not sure what you
Hi, cannot seem to sucessfully make a simply link between Sage Line 50 and
MySQL. When accessing the tables the damn thing throws up errors and can
import structure but fails to import data. I am using MySQL-Front to do
this.
Anyone have any idea where i am going wrong or something to try. BTW
Hello ,
i've just started work with MySQL. Does anybody know how can i
use transaction with MySQL? Is this capability supported?
I write web-shop... Sory my eng is bed...
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
How about if master crashes?...is there anyway to recover?...aside from
copying all stuff from slave to master...
R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)
-Original Message-
From: Davide Giunchi [SMTP:[EMAIL PROTECTED]]
On Wed, 10 Apr 2002 13:27:30 +0300
maxim [EMAIL PROTECTED] wrote:
Hello ,
i've just started work with MySQL. Does anybody know how can i
use transaction with MySQL? Is this capability supported?
I write web-shop... Sory my eng is bed...
what term do you mean with transaction ?
if
On Tue, 9 Apr 2002, David BORDAS wrote:
Sent: Tuesday, April 09, 2002 2:14 PM
Subject: Re: TIMESTAMP(14) or Bigint ??
TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference
per 5 Millions records = a 20 MB bigger table ...
David
If storage space is an issue you may want to
On Wed, 10 Apr 2002, maxim wrote:
Hello ,
i've just started work with MySQL. Does anybody know how can i
use transaction with MySQL? Is this capability supported?
I write web-shop... Sory my eng is bed...
Maxim,
MySQL supports different table types. Some of them (BDB and InnoDB)
support
Hello Dicky,
Wednesday, April 10, 2002, 1:42:00 PM, you wrote:
DWP On Wed, 10 Apr 2002 13:27:30 +0300
DWP maxim [EMAIL PROTECTED] wrote:
Hello ,
i've just started work with MySQL. Does anybody know how can i
use transaction with MySQL? Is this capability supported?
I write
- Original Message -
From: Chris Lamrock [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]
Sent: Tuesday, April 09, 2002 10:21 AM
Subject: Re: mysql_install_db still locking :-(
Egor,
I'm running :
Red Hat Linux release 7.0 (Guinness)
on a Pentium III 450 with 128 meg of Ram.
Hi all!
Problem. How to ensure(supply) reservation MySQL in
a context of creation the Internet shop to raise(increase)
his(its) reliability.
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
-
respected sir/madam,
i installed the client and server files (rpm)
of MYSql for linux , but failed to get the gui working.
could you please help me in this regards.
thanking you
hitesh patel
On Wed, 10 Apr 2002 [EMAIL PROTECTED] wrote :
Your message cannot be posted because it
Aman,
Tuesday, April 09, 2002, 5:24:49 PM, you wrote:
AR Hello everyone
AR I want to alter 50 tables, and for each the names start with the string
AR 'mak'
AR Is there an SQL query, so that I can do the change in one command.
AR I have tried using wildcards - they don't seem to work in SQL.
Hello sean,
Wednesday, April 10, 2002, 2:37:34 PM, you wrote:
sosi Hi maxim,
sosi I'm not sure what you mean, given your earlier posts you seem
sosi to be talking about transactions in mysql. if thats the case
sosi i recommend you take a look at innodb. its a table type for
sosi mysql that
Hello Victoria,
Wednesday, April 10, 2002, 3:07:01 PM, you wrote:
VR Hello maxim,
VR Wednesday, April 10, 2002, 2:14:54 PM, you wrote:
m ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache ..
m ÷ÏÐÒÏÓ: ÇÄÅ ÍÏÖÎÏ ÎÁÊÔÉ ÐÏÄÒÏÂÎÕÀ ÄÏËÕÍÅÎÔÁÃÉÀ Ï ÏÓÏÂÅÎÎÏÓÔÑÈ
m ÉÐÏÌØÚÏ×ÁÎÉÉ SQL × MySQL .. É
Very interesting conversation, ...
íÙ ÎÅ ÇÏ×ÏÒÉÍ ÐÏ ÒÕÓÓÊÉ :-)
Adib.
maxim wrote:
Hello Victoria,
Wednesday, April 10, 2002, 3:07:01 PM, you wrote:
VR Hello maxim,
VR Wednesday, April 10, 2002, 2:14:54 PM, you wrote:
m ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache ..
m
Two of my co-workers attended the MySQL training in San Francisco last
month. We have successfully installed 4.01 on a SUN Ultra 250 running
Solaris 2.8. Four myisam tables were created and populated. When we tried
to install the same software on a SUN Sparc 20 running Solaris 2.6 errors
were
Hello All,
I am sorry for Russian. I shall mean.
The question remains open. How to reach(achieve) a high degree
of reliability of system the Internet of commerce on a basis MySQL.
At the expense of that it is possible to raise(increase) reliability
of system?
--
Best regards,
maxim
Egor, I'm using the following:
Red Hat Linux release 7.0 (Guinness)
on a Pentium III 450 with 128 meg of Ram.
Are you thinking I may need to run an older version of Mysql?
Thanks for the reply!
Chris
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Thank you for your help, but I know that I must compile kernel (mysqld) with this char
set. But, this I can do with Unix (or Linux, etc.). What can I do with kernel for
Win32? Is any mysqld with char set win1250 compiled in? Or must I download any other
version of MySQL? And which version
At 07:55 10-04-02 -0500, Lee, Tom J wrote:
When we tried
to install the same software on a SUN Sparc 20 running Solaris 2.6 errors
were encountered. Something about a missing file 'librt.so.1'. We thought
the OS version was 2.7. Not correct! I downloaded the binary MySQL version
3.22.32 from
Today I have used MM.MySQL-2.0.12 and noticed, that German umlauts are
represented as ?. In MM.MySQL-2.0.7 everything was all right there.
Volker
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi again...
When I felt proud because last week I had asked about how to use NOW(), and
get answer that got me working, but now I have a strange problem. It listing
dates, but it not listing like it should, when the web page is create it
going 9, 8, 5, 10 on the dates. Here is the SQL statement
Hi everyone,
When is it appropriate to use Char instead of Varchar and vice versa?
Thanks
Luke
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
Ely Van Kenobi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
[EMAIL PROTECTED] wrote:
When is it appropriate to use Char instead of Varchar and vice versa?
Use char when you expect the length of the field to always be the same.
Use varchar when you're not sure.
Basically, when you're using varchar you're assigning a limit to the size
of the string
Hi Luke,
When is it appropriate to use Char instead of Varchar and vice versa?
Use CHAR for when you know in advance how many characters are going to be in
that field. A good example is for MD5 hashes: they are always 32 characters
long, so you can use CHAR(32).
Use VARCHAR for when you don't
At 16:41 +0200 4/10/02, Elyasin Shaladi wrote:
Hi
How can i deinstall the mysqld as a service?
Thx for help
Shut down the server, then issue this command:
mysqld --remove
mfg
Ely Van Kenobi
-
Before posting, please check:
Luke,
Wednesday, April 10, 2002, 4:18:48 PM, you wrote:
LvB When is it appropriate to use Char instead of Varchar and vice versa?
CHAR column type has fixed length, VARCHAR is variable-length string.
CHAR column type appropriate to use when you have data with the same
length. Don't forget that
HITESH,
Wednesday, April 10, 2002, 2:29:23 PM, you wrote:
HP i installed the client and server files (rpm)
HP of MYSql for linux , but failed to get the gui working.
HP could you please help me in this regards.
What exactly doesn't work?
Is it a failure to start MySQLGUI or to connect
Chris,
Wednesday, April 10, 2002, 2:01:05 PM, you wrote:
Egor,
I'm running :
Red Hat Linux release 7.0 (Guinness)
on a Pentium III 450 with 128 meg of Ram.
Are you thinking I may need to run an older version of Mysql?
Well, this looks very weird to me. The configuation is plain and
i have been working on getting this query as fast as possible and figured
it was time to come to the mailing list.
the below table currently holds about 43 thousand records with potential to
grow to around 1,000,000 records.
CREATE TABLE `RADPOOL` (
`id` int(11) NOT NULL auto_increment,
It depends on who you talk to and what you want to do. varchar will use
less disk space, but char is faster to access (except for InnoDB tables,
where varchar has the advantage). The benefit is using char is that the
rows have a fixed length so MySQL knows exactly where each row starts and
Hi again...
Hi,
When I felt proud because last week I had asked about how to
use NOW(), and
get answer that got me working, but now I have a strange
problem. It listing
dates, but it not listing like it should, when the web page
is create it
going 9, 8, 5, 10 on the dates. Here is
Your alias and column name are the same.
Which one do you think is being tested?
Also DATE is a reserved word.
Chuck \PUP\ Payne wrote:
Hi again...
When I felt proud because last week I had asked about how to use NOW(), and
get answer that got me working, but now I have a strange problem. It
also, note that char is changed to varchar in some cases, such as when there
is a text field in the table.
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 10:40 AM
To: 'Luke van Blerk'; [EMAIL PROTECTED]
Subject: RE: Char vs Varchar field
(one should not mess up strg and shift :-/)
Hi again...
Hi,
When I felt proud because last week I had asked about how to
use NOW(), and
get answer that got me working, but now I have a strange
problem. It listing
dates, but it not listing like it should, when the web page
is create
i made the change, but it looks like it didn't speed the query up at all.
here are the results from the first explain:
mysql explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and
POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1;
Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t
»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 :
going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using...
That's because your DATE which you've made with DATE_FORMAT is treated
as string. To fix it, I'd write:
SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title,
Hello,
where can I find a simple php to generate a default html table from a MySql table ?
thanks
Luigi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I am new to MySQL and I have a test database that I am playing with. Through
an accident while playing around, I ended up with two identicle records in
the database. I did a filter to try and change just one of them but both
would come up, so I couldn't see how I was supposed to delete just one
Hello-
I am a Sybase user with a mysql question. Does mysql do bulk copy (bcp)?
Bulk copy allows a mass copy from a file a database and vice versa. I know
there is mysqldump but, i am not sure if that is what i am looking for. Can
anyone explain?
thanks,
brian
Hi,
I'm trying to use the old MS Visio Modeler with mysql. I have
downloaded and installed the myODBC driver and set up a DNS. But I keep
getting this connection error:
Can't connect to MySQL server on 'www.jsicorp.com'(10060)
I set the username and password the same as what works with
Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t
mysqld --remove
use
mysqld --help
for more info.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:41 PM
To: MySQL-Mailingliste
Subject: Mysqld as service
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
You are 100% correct.
Since MySQL does not support cursors, I always put an auto_increment
column in my tables for just this purpose.
(This is what other DBMS' do, they just do it behind your back)
Unfortunately, the way MySQL really handles result sets doesn't lend itself
to simply adding a
Try
mysqld --remove
From the MySQL\bin directory.
I assume you mean a service on NT
Alternatively you can just stop the service in MMC and set it to manual
so it never starts. But I'm guessing this isn't what you want
Let me know
-Original Message-
From: [EMAIL PROTECTED]
You are 100% correct.
Since MySQL does not support cursors, I always
put an auto_increment column in my tables for just
this purpose.
(This is what other DBMS' do, they just do it behind
your back)
You're right. I use DBase IV at work and every record has an internal record
number.
Can anyone comment on the stability of the current 4.x MySQL release.
I'd be using MyISAM tables and only features which are currently
available in the 3.23.x series.
--
do svidaniya,
~mitch
-
Before posting, please
Katen
The manual has a section on optimization. If you have done
deletes on this table, the table may not be optimized.
Try: OPTIMIZE TABLE RADPOOL1
It does lock the table while doing it.
Other than that, I don't know what else to do.
David
-Original Message-
From: Steve Katen
I'm trying to connect to mysql using lasso but no success.
The message I get is that there are no databases found.
Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5
What do I need to do to connect to mysql from lasso?
Also, how do I start a deamon at boot?
Thanks
Juan M.
Description:
I have downloaded a binary version of mysql, perform all installations steps
from the manual. As soon as I started to execute safe_mysqld --user=mysql
I got a core dump and the program exited. Please help
How-To-Repeat:
Fix:
Submitter-Id:
Hi Nick,
I am seeing some rather strange problem here with mysqldump, after
trying very hard to reproduce the problem on a test server, I gave
up. Do the options make any difference when you run it? Can you send
a trace of the actual dump? I was seeing mysqldump terminate in my
case, now
I have started using MySQL because I want to learn about something new and
to keep a database of my growing comic book collection, which would be handy
should something should ever happen to them. In doing this, I have started
to think of other ways to use MySQL, such as managing my CD collection
On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote:
Perhaps having a column in my
database with a serialized, unique record number would be a way to prevent
this in the future?
That would allow you to delete just one of the duplicates (which you
also do with LIMIT 1 on your DELETE query), but
On Wed, Apr 10, 2002 at 01:41:30PM -0400, Jeffrey Flowers wrote:
I have started using MySQL because I want to learn about something new and
to keep a database of my growing comic book collection, which would be handy
should something should ever happen to them. In doing this, I have started
On Wed, Apr 10, 2002 at 10:06:47AM -0700, [EMAIL PROTECTED] wrote:
Can anyone comment on the stability of the current 4.x MySQL
release.
I'd be using MyISAM tables and only features which are currently
available in the 3.23.x series.
For my purposes, the 4.0.x builds I've used are just
Hi,
I'm using MySQL version 3.23.37 which works fine. However I am
currently trying to convert a MS Access database to MySQL and some of
the column names have embedded spaces i.e. First Name. Now according
to the manual MySQL supports quoting of identifiers (for the above
reason), I
Hi.
Well, your are right, indexes are not used at all, so ignore
everything about key_buffer and indexes I said, regarding this issue
(but key_buffer=16MG seems small with 1GB anyhow ;-)
Depending on how often you need the query, and how much columns are
involved, you may want to consider to
I guess
make install prefix=/home/turner/mysql/test
just isn't an option. How would I request this functionality be provided
in the make file?
Thanks, Dave Turner
On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote:
Thanks, but what I need to do is have
make install install
ANSI92 states that quoted identifiers are delimited by double quotes
-Original Message-
From: Nicholas A Read [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 10 Apr 2002 19:39:52 +0100
Subject: Mysql and Quoted Identifiers
Hi,
I'm using MySQL version 3.23.37 which works
Hi.
(I am replying to the wrong mail, because I already delete the one
from Steve...)
The slow part is probably the using filesort. I am not sure, if it
will work, but try a key over all used column, i.e.
INDEX ( POOL, STATE, TIMESTAMP )
If it works (i.e. if MySQL correctly sees that it can
http://www.php.net/links.php
Mike
- Original Message -
From: Luigi Stefano Sona [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 12:12 PM
Subject: a little help for a beginner
Hello,
where can I find a simple php to generate a default html table from a
MySql
ben,
I did that about three minutes after I got Davids email. Things seem to be
working a lot faster now, and the using filesort is gone. i am assuming
there isn't much more i can do to make this thing faster, but anything else
i can do would be awesome!
heres is the explain:
mysql explain
Hi.
You have to use backticks (`) instead of single quotes (') as in
CREATE TABLE TEST (`ID` INTEGER)
When MySQL has been started with --ansi, double quotes () will have
the same meaning. See http://www.mysql.com/doc/L/e/Legal_names.html
for more info.
Bye,
Benjamin.
On Wed, Apr
Hi,
I downloaded mysql Ver 3.23.49 binary to
a local directory. other than (/usr/local)
I changed ./bin/mysqlaccess for MySQL location, etc.
but for some reason it dies as sooon as starts.
I notice that some scripts and files in bin directory
Hi,
If I have two MYSQL tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is query only those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that
they had intel based offerings.
I thought they were all RISC chip based.
That probably explains why I86 binaries won;t install..
If they don't have a binary for Cobalt Cube/RaQ systems, it's compile
Hi.
As I said, or at least, tried to say, a key over all used columns
should help. Adding the column from ORDER BY avoids the using
filesort. Adding YIADDR (which I simply overlooked last time) should
add using index, as I mentioned. This means, that the data file is
not touched at all, but only
Hi,
If I have two mysql tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is only query those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
Hi,
We want to use only MYSQL4.0 for our production database. Please let us know when the
Beta release is scheduled.
Regards
See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp
At 10:17 AM -0700 4/10/02, Juan M. Quiroz wrote:
I'm trying to connect to mysql using lasso but no success.
The message I get is that there are no databases found.
Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5
What do I need to do to connect to mysql from lasso?
Hi Juan:
I
Hello,
I probably installed a PHP script that created a table with a - in its name.
I can't figure out how to even touch this table. If I try:
mysql describe A-14c;
ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1
This table exists for sure though:
| Tables_in_blesysdb
Hi,
We are developing a webbased serch application on MYSQL and PHP. I am sure most of you
must have already implemented
such application. Could you share with me the logic of such application. We were
planning to keep a keyword search
and my people feel that that will require additional
Try enclosing it:
describe `A-14c`;
nickg
-Original Message-
From: David Chen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:05 PM
To: [EMAIL PROTECTED]
Subject: - character in table name
Hello,
I probably installed a PHP script that created a table with a - in its
Have you tried delimiting the table name with some form of quotes?
-Original Message-
From: David Chen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 4:05 PM
To: [EMAIL PROTECTED]
Subject: - character in table name
Hello,
I probably installed a PHP script that
mysql describe 'A-14c';
ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1
It's not working...
- Original Message -
From: nickg [EMAIL PROTECTED]
To: David Chen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, April 10, 2002 2:13 PM
Subject: RE: - character
Hi
Installation packages for the Raq range can be found at
http://pkgmaster.com/packages/raq/
From the main control panel go to 'Control Panel' and 'Install Software'
MySql for Raq2 is not there, though it is for Raq3 and above, so perhaps
worth a try.
I installed it and it was almost
Hello,
This is an announcement of a new product that will interest some of you.
I have completed work for the first Beta release of a native ADO.NET
provider to MySQL.
You can find the details at http://www.mattculbreth.com/eidmysql.
Thank you,
Matt Culbreth
I'm trying to compile my program using libmysqlclient_r
--enable-thread-safe-client.
Would using mysql.h suffice or is there any specific header file to be
included.
I'm asking this because mysql_thread_init() call is not being recognized
when I'm trying to compile the program
regards
Hi,
I have written the following test case in which I'm trying to access
the database using differant threads each thread calls this function
test2(), access to which is protected by a pthread_mutex_lock() at the
beginning of the test and pthread_mutex_unlock() at the end of the test.
The same
Hi
We are in the process of developing Ultra High Availability ecommerce sites
based on php and MySql.
1. The software itself is well tested
2. The site is duplicated on two or more servers in separate data centres,
with live replication.
3. Nameservers for the domain are on the
Hi,
I've been trying to find some info on running a select statement that would
return a few rows and leave out one specific row.
Here is my select statement:
$result = mysql_query(SELECT
ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM
stns,images INNER JOIN ent_nws
Try building libmysqlclient_r with your local pthreads, the same ones
you're using in the application it self.
ie --with-pthraed=-pthread or --with-pthread=-lpthread
Shivam K Shah wrote:
Hi,
I have written the following test case in which I'm trying to access
the database using
On 10 Apr 2002, at 17:23, Mike wrote:
$result = mysql_query(SELECT
ent_nws_id,img_path,substring_index(ent_body, \.\ ,1) AS ent_body FROM
stns,images INNER JOIN ent_nws ON stns.stns_id=ent_nws.stns_id and
images.img_id=ent_nws.img_id WHERE stns.stns_id=1,$db);
I'd like to leave out
Hi
Change your WHERE statement
to
WHERE stns.stns_id=1
AND table.ent_nws_id 3 '
HTH
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel.
Many thanks for any assistance:
I have data (classified ads) in a text file that I would like to load
into a table. The problem is that, as classifieds, they are broken down
by class and sub-class. For instance:
0031 - Announcements
- Notices
One ad
Two ad
-
In MySQL it says that adding the following to a where clause:
like %$somestring%;
should select matches that contain $somestring in them anywhere.
However when I use it I find that if e.g. I have an entry dog in the
database, if I search for dogs, it doesn't come up. Also if I search for
Does anyone know how Innobase would handle this query? If it would lock all
of the rows within the table, or attempt to find all of the rows within the
table instead of just finding the first X in my LIMIT and locking those and
updating those? I have a table with 1 million rows as my example
At 1:08 PM -0700 4/10/02, va ku wrote:
We are developing a webbased serch application on MYSQL and PHP. I
am sure most of you must have already implemented
such application. Could you share with me the logic of such
application. We were planning to keep a keyword search
and my people feel
On Wed, Apr 10, 2002 at 11:18:14AM -0500, Henning, Brian wrote:
Hello-
I am a Sybase user with a mysql question. Does mysql do bulk copy
(bcp)? Bulk copy allows a mass copy from a file a database and vice
versa. I know there is mysqldump but, i am not sure if that is what
i am looking for.
You are searching for the word dogs...that word is not contained in
the word 'dog' or the phrase 'dog house.'
If you searched for '%dog%' you would get both of those results.
The wildcard character allows any other character in it's place...hence
'%dog%' finds 'mydog', 'mydogs', etc, etc...it
1 - 100 of 119 matches
Mail list logo
