$db = mysql_connect(
Fatal Error: Call to undefined function: mysql_connect()
1. I found I had a RPM Install of PHP and a compiled version. (Off my book
cdrom)
2. How can you get rid of file that you have gunziped ? in reverse, ie
'remove the following files' instead of 'install the following
Have you run out of sockets ?
Max connections ?
Is the server there ?
Is this the right socket ?
Is the socket locked up ?
Andrew
-Original Message-
From: °í¼ø¹Î [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 2:09 PM
To: [EMAIL PROTECTED]
Subject: Connection Failed.
I made
I am running mysql version 3.23.47 on a RedHat Linux 6.2 box with very
low loading. The Linux is acting as a gateway for my company which
connects to an ISP via ADSL.
The daemon safe-mysqld and mysqld keep shutting down
accasionally,especially when ADSL disconnects.
Hi !
I've made a quite simple program in C using
libmysqlclient. The program runs as daemon
in Solaris 8 (sparc) and checks some values
in the database every 5 minutes.
I have only ONE malloc/realloc call in my code
and this code is called only when needed (when DB check
is signaling it to do
1. I found I had a RPM Install of PHP and a compiled version. (Off my book
cdrom)
:-(( happened to me 2
4. I want to start from scratch but don't want to have to re-format
nah. you've rpm -e'd the rpm. I had to build from scratch to compile mysql +
php in as I couldn't find an off-the-shelf
I can sure that connection didn't overflow. But I don't
know how to check running out of socket and locking.
Can you tell me how I can check that status?
And I think the socket is right. Because the program
has no problem most of time. The problem does not
usually happen, but if happen it is
On Thursday, 25. April 2002 08:17, Andrew Rich wrote:
5. I have determined I was running a copy of PHP that did not have MYSQL
support compiled in.
Yes, looks like this is an an very old version, without mysql-support.
6. Could someone suggest where i could get a PHP copy that supports MYSQL
I've tried to install the current release of MySQL on my Macintosh under OS
X (10.1.4)
and I've got the following error message:
dyld: ./bin/mysqld can't open library: /usr/lib/libpthread.A.dylib (No
such file or directory, errno = 2)
Installation of grant tables failed!
Where can I get this
please amend my e-mail address to:
[EMAIL PROTECTED]
thank-you
From: Michael Widenius [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Pre-release of MySQL 3.23.50
Date: Tue, 23 Apr 2002 10:26:04 +0300
Hi!
3.23.50 is basicly just a bug fix
Hello,
Try this
?
function samp_db_connect()
{
$hostname = localhost;
$username = joe;
$password = user;
$dbName = test;
$link = @mysql_pconnect($hostname, $username, $password);
if ($link mysql_select_db($dbName))
return $link;
return FALSE;
}
samp_db_connect() or
hi
i have downloaded mysql++ on linux.
i didn't find these files
automake
autoconfig
so , i couldn't install mysql++.
help plz
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com
Hi,
MySQL not encode characters.In your .txt file are NON-PRINTABLE characters
which mark the end of line.If you have a HEX editor, you can see in the .txt
file at the end of every line '0Dh' and '0Ah'.This mean ENTER('\r) and NEW
LINE(\n').If you have a C/C++ manual you can find the list of
In mysql i have to copy selected records from one database table to
another database table.
How to do that?
thanx in advance.
--
Regards,
Charitha
-
Before posting, please check:
http://www.mysql.com/manual.php (the
hello,
1) i have a value in a field in the db like
2002-01-02 07:04:19(a date time field)
i cannot declare it as a time datatype as i need date
also be available in the field.
now is the myswl query to get just the time part from
the db?
2) Also if i sum up a field which is of time type from
a
Hi, I'm trying to find out if MySQL is able to handle multiple users
accessing a database at the same time? Can someone tell me what happens when
multiple users try to do an update at the same time? Is it possible at all?
If not, what whould be the best way to enable all users to do an update 'at
Hi,
if they have the same format (fields, etc):
INSERT INTO db1.table1 SELECT (fields) FROM db2.table2 WHERE ...;
Ciao,
Ronald
-Original Message-
From: Charitha [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 10:23
To: [EMAIL PROTECTED]
Subject: Copying records b/w diff
Heya,
one solution could be
select DATE_FORMAT(date_time, '%T') from testtable;
also check out EXTRACT which could help you for your other problem.
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
EG
- Original Message -
From: bob nt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Hi, I have a table in a MySQL database where some fields are declared as
unsigned. Example:
CREATE TABLE cities (
City_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
City_name VARCHAR(50) NOT NULL
}
My problem appears when inside a .xsql file (Oracle XDK), I try to do a
°í¼ø¹Î,
Thursday, April 25, 2002, 7:08:32 AM, you wrote:
° I made program using mysql C api, And every two minute my program
° connects to mysql-server. But from time to time some error occur
° accidently.
° In the mysql.err file, this message was written.
° 020424 15:18:44 Aborted connection
Andrew,
Wednesday, April 24, 2002, 9:13:40 PM, you wrote:
AC Basically these two servers are not connected to each other.
Look at the secon part of Jason's statement:
mysql database name -hhost_name -uuser_name -ppassword
It means that you connect to another MySQL server ...
AC Also I am
Aylwin,
Thursday, April 25, 2002, 12:28:25 PM, you wrote:
AT Hi, I'm trying to find out if MySQL is able to handle multiple users
AT accessing a database at the same time? Can someone tell me what happens when
AT multiple users try to do an update at the same time? Is it possible at all?
AT If
Harpreet,
Thursday, April 25, 2002, 4:04:27 AM, you wrote:
HK How can i set the default values of a datetime field in a mysql table as the
HK current date.
HK I am trying
HK alter table copy_tbl add create_date datetime default now() but it does not
HK work.
It should not work ...
Take a
teck,
Wednesday, April 24, 2002, 9:09:11 PM, you wrote:
tcn To whom it may concern,
tcn Where can i find the documentation for mysqlgui?
Look at the README file and MySQL.help that comes with MySQLGUI.
tcn thanks
tcn bd
--
For technical support contracts, goto https://order.mysql.com/
Charitha,
Thursday, April 25, 2002, 11:23:19 AM, you wrote:
C In mysql i have to copy selected records from one database table to
C another database table.
C How to do that?
What about INSERT ... SELECT statement?
INSERT INTO database1_name.table_name SELECT * FROM
Dear All
I am looking for some reference site or tips for using MySQL with
Windows MFC dialog based game.
I saw some manuals about how to use MySQL++, but no documents or
reference about MySQL for VC++
Would you help me about it?
Best regards.
[EMAIL PROTECTED] writes:
To whom it may concern,
Where can i find the documentation for mysqlgui?
thanks
bd
It comes with a package.
Read MySQL.help , README and readme.* files.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL
adel essafi writes:
hi
i have downloaded mysql++ on linux.
i didn't find these files
automake
autoconfig
so , i couldn't install mysql++.
help plz
On linux, you can skip first two steps and start from configure ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /
Michael:
Then I would think the problem is with the application(s) you are using as opposed to
MySQL.
It doesn't appear you are doing anything wrong.
Gerald Jensen
-Original Message-
From: Michael Grover [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, April 24, 2002 7:51 PM
To:
Hi!
I have this table :
mysql desc cpu;
+-+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
äÏÂÒÙÊ ÄÅÎØ.
Andrey Kotrekhov writes:
Hi!
% g++ -v
Using builtin specs.
gcc version 2.95.3 20010315 (release) [FreeBSD]
And libstdc++ is include in compiller
How can I see version of libstdc++ ?
In /usr/src/contrib/libstdc++/Makefile.in I see
VERSION = 2.10.0
INTERFACE = 3
MySQL,
Thursday, April 25, 2002, 1:40:01 AM, you wrote:
MN i need to have a table column holding multiple numeric values (double, int,
MN float, etc)... I was thinking of using a variant type for this. Does Mysql
MN support this?
Nope.
MySQL supports the following column types, look at:
JW,
Wednesday, April 24, 2002, 11:49:17 PM, you wrote:
J At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and
the new autoextend feature.
J However, the most recent on the download page is 3.23.49a.
J Was .50/.51 not released because of bugs or something?
A few
Nissim,
Wednesday, April 24, 2002, 9:30:36 PM, you wrote:
NL What sql function can I use to examine blob in a table. I need to display
NL part of the blob in hex values. Shouldn't the following sql command work :
NL select hex(substring(col1,1,10)) from table tbl1;
Yes, you can use HEX() and
Nick,
Wednesday, April 24, 2002, 10:52:28 PM, you wrote:
NG Nick Gilliam wrote:
Egor Egorov wrote:
NG I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which
I am NG unable to bet a lock on a table with any userid except root.
NG Here is my environment:
NG Sun 450
NG Solaris 2.8
Alain,
Wednesday, April 24, 2002, 6:18:51 PM, you wrote:
AM I try to install mysql on a sparc 250 / solaris 7.
AM I have problem when I come at the configure step : I don't have a
AM configure program on my computer.
AM With a find, I find one on the /usr/local/share/libtool/libltdl directory
AM
I downloaded the binaries yesterday and installed on my WinXP
laptop. I read the documentation that came with it but couldn't
seem to get it to run. It seemed like any executable I ran, it would
open up a DOS window which would then close very quickly. I
tried everything to get it to work
Description:
Using a SELECT CASE during a CREATE TABLE ... SELECT statement causes an
error 1105 (Unknown error). The CASE contruction works fine in the SELECT
query, and also works fine on 3.23.49a.
How-To-Repeat:
Run this script against a test database:
drop table if exists
Hi Everyone,
I am very new to database programming, and am working on an application
where I need to select all records between yesterday at 7:00am and today at
7:00am. Obviously this can be run at any time or day. This has to be a very
common sql SELECT statement, but for the life of me I can't
Description:
the character '-' in username or hostname is not accepted by the GRANT sql
statement.
How-To-Repeat:
grant all on *.* to [EMAIL PROTECTED];
Fix:
don't use dashes, fixing the SQL parser.
Submitter-Id: submitter ID
Originator:Bas Meijer
Organization:
Ladies and Gentleman of the list,
I have been a member of the list for about two weeks now and I must say that
I have learned a lot. Needless to say I am relatively new to the whole db
scene.
My question is that I installed mySQL onto my linux box (Red Hat 7.2) as
part of the installation. I
At 08:22 25/04/02 -0500, you wrote:
Hi Everyone,
I am very new to database programming, and am working on an application
where I need to select all records between yesterday at 7:00am and today at
7:00am. Obviously this can be run at any time or day. This has to be a very
common sql SELECT
I bet you run those exe files from XP explorer (double clicking...). You
have to use dos prompt instead... type the command and press enter.
I am using it with WinXP and I am fine...
Andrew
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday,
Hi,
Yes, one column is dedicated to date/time for each record. Data type on that
column is MySQL's datetime type.
Don
-Original Message-
From: Gordon Stewart [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 25, 2002 9:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Sql SELECT statement to get
Hi!
äÏÂÒÙÊ ÄÅÎØ.
I think problem is in libmysqlclient_r.so
becouse I compile program which work fine many month with
libmysqlclient_r.
And program died in the same place.
#0 _db_enter_ (_func_=0x28252311 mysql_real_query,
_file_=0x28251d48 libmysql.c, _line_=1784,
On Mon, Oct 22, 2001 at 04:23:10PM +0200, [EMAIL PROTECTED] wrote:
Description:
the character '-' in username or hostname is not accepted by the GRANT sql
statement.
How-To-Repeat:
grant all on *.* to [EMAIL PROTECTED];
Fix:
don't use dashes, fixing the SQL parser.
Or
Hello.
There appears to be a problem when using the JDBC driver on a
foreign database (i.e. not your current database).
MySQL version is : 3.23.49-max-debug
JDBC version is : mm.mysql-2.0.4-bin.jar
Consider the following situation:
use sales;
create table contacts (uid integer, name
On Fri, Feb 22, 2002 at 11:39:55PM -0800, vijay khanna wrote:
We are going into making the final changes to our
production MySQL server.
production server configuration is
Free BSD PIII dual processor 800 mhz, 750 MB RAM.
Are you using MySQL package compiled with linux threads?
Apache
On Thursday, April 25, 2002, at 03:23 AM, Markus Ungersboeck wrote:
I've tried to install the current release of MySQL on my Macintosh
under OS
X (10.1.4)
and I've got the following error message:
dyld: ./bin/mysqld can't open library: /usr/lib/libpthread.A.dylib (No
such file or
bas,
Monday, October 22, 2001, 5:23:10 PM, you wrote:
bDescription:
b the character '-' in username or hostname is not accepted by the GRANT sql
statement.
bHow-To-Repeat:
b grant all on *.* to [EMAIL PROTECTED];
bFix:
b don't use dashes, fixing the SQL parser.
It's not
Chris,
Monday, April 22, 2002, 7:21:58 PM, you wrote:
CJ A test SQL script which duplicates this problem is available via anonymous
CJ FTP at the following location:
CJ Hostname: ftp.visi.com
CJ Directory: /users/chris
CJ Filename: test.sql
CJ Run the script like this to see the error:
CJ
Chris,
Thursday, April 25, 2002, 3:47:22 PM, you wrote:
CB I downloaded the binaries yesterday and installed on my WinXP
CB laptop. I read the documentation that came with it but couldn't
CB seem to get it to run. It seemed like any executable I ran, it would
CB open up a DOS window which
Shaun,
Thursday, April 25, 2002, 4:44:48 PM, you wrote:
SB Ladies and Gentleman of the list,
SB I have been a member of the list for about two weeks now and I must say that
SB I have learned a lot. Needless to say I am relatively new to the whole db
SB scene.
SB My question is that I
I've tried both kinds, the binary package and the source installation. I've
also the Developer Tools 10.3.1 (but a few days ago I've upgraded my OS to
10.1.4) on my computer and I have the libpthread.dylib library in the
/usr/lib/ directory, but not libpthread.A.dylib.
As I'm a complete newbe
Everyone,
I think I've got this licked on my own. Here's what I wound up with. Seems
to work ok.
select nodename, startdate, enddate
from history
where startdate = concat(date_format(date_sub(now(), interval 1 day),
'%y-%m-%d'), ' 07:00:00')
and startdate =
Hi everyone,
I'm using a very simple PHP script with mySQL to load a news feed (url
encoded) into flash. I've got it working but I would like the records to
come out in the opposite order, with the newest one first.
This is the script:
?php
$db = mysql_connect(localhost, root, pass);
On Thu, Apr 25, 2002 at 09:44:48AM -0400, Shaun Bramley wrote:
: Ladies and Gentleman of the list,
:
: I have been a member of the list for about two weeks now and I must say that
: I have learned a lot. Needless to say I am relatively new to the whole db
: scene.
:
: My question is that I
I am having the same problem and cannot find any document which can get
me beyond Access denied...
Could you explain the difference between Linux 'root' user and 'root'
user in MySQL?
Subject: Re: ERROR 1045: Access denied for user: 'root@localhost'
From: Victoria Reznichenko
Date: Tue, 23 Apr
Greetings from Massachusetts (USA),
On Thursday, April 25, 2002, at 11:04 AM, Markus Ungersboeck wrote:
I've tried both kinds, the binary package and the source installation.
I've
also the Developer Tools 10.3.1 (but a few days ago I've upgraded my OS
to
10.1.4) on my computer and I
You should pass the data to be imported into Flash through urlencode().
Flash needs the data to be urlencoded in order for it to be able to read it,
particularly if the inputted data contains HTML, text with spaces, symbols,
etc.
Mike
-Original Message-
From: Phil Clandillon
FYI, concerning my previous email, it's solved. I upgraded the JDBC
drivers to the last ones and now it recognizes the unsigned data types.
Great! :-)
David
On Thu, 25 Apr 2002, David Collados Polidura wrote:
Hi, I have a table in a MySQL database where some fields are declared
Andrey Kotrekhov writes:
Hi!
I am not agree. I take _another program_ which work fine during ~2 year
with previouse mysql version (mysql-3.23.44 for example).
And I send dump from this program.
Why I interested libmysqlclient_r?
I have a program, which try to connect to mysql twice.
Hi Everyone,
This should be an easy sql question for someone. I've got 2 tables that
have a linked field (id) and I need to clean up records that are in table1,
but no matching id in table2. This is how I can select them
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id
Agh... I apologize to all. Did not read the question asked correctly.
As far as order is concerned, you need to add ORDER BY field sort
order, DESC for descending, ASC for ascending
if you have a date field, this would probably be the best to use.
And example might be SELECT field1, field2,
From: Phil Clandillon [EMAIL PROTECTED]
I'm using a very simple PHP script with mySQL to load a news feed (url
encoded) into flash. I've got it working but I would like the records to
come out in the opposite order, with the newest one first.
At the end of your SQL query, simply add an
Thanks Everyone,
That's working now - This is my first time on this list and I have to say
I'm stunned how quickly my question has been answered!
I used Kim's code and it worked a treat!
:-)
Phil Clandillon
--
Graphic and Interactive Design
hello,
i have a doubt and is :
what is the number max of tables that can have a data base MySql?
that so 1.000.000?
and tha number max de conections?
PD.no escribo muy bien el ingles, asi que espero que me
entiendan y me puedan ayudar.
translation
I do not write ingles very well, I
Hiya,
I'm writing a bit of code to add a bit of extra functionality to a basic search on a
web site.
When searching for items in a library, I want to be able to select what I want and
don't want to be searched for, i.e. +linux -beginner searches for all books on Linux,
but doesn't show any
dOMi writes:
However, after only a week the memory usage ocf this process
has been grown to 40 - 50 MB so there's have to leakage somewhere.
What you *may* be seeing is standard memory fragmentation that many
Unix' systems have with the standard allocator.. You don't mention
what platform
At this point, I'd like to solicit tips on how I might get my support
related concern addressed. It seems like people panicking over things that
are actually documented get help quickly on this list, but when issues come
up that are NOT documented (as I've raised twice below), the issues are
Tom,
Thursday, April 25, 2002, 5:40:11 PM, you wrote:
TM I am having the same problem and cannot find any document which can get
TM me beyond Access denied...
TM Could you explain the difference between Linux 'root' user and 'root'
TM user in MySQL?
MySQL user 'root' is usual user, it's a user
Hi,
I just compiled Apache 1.3.24 with PHP 4.1.2 with ./configure'
'--with-mysql' '--with-apache=../apache_1.3.24' '--enable-track-vars'
MySQL was already installed on the system.
The problem, however, is that when I try to connect to a database
from PHP, I get the following error.
MySQL
From: Jonathan David Edwin Wright [EMAIL PROTECTED]
Which turns '+php -perl' into:
SELECT * FROM books WHERE title LIKE '%php%' AND NOT title LIKE '%perl%'
The problem I get is that the query doesn't seam to work. One of the
books in the table is 'Professional PHP Programming', but, while
Shouldn't the NOT be right before the LIKE:
SELECT * FROM books WHERE title LIKE '%php%' AND title NOT LIKE '%perl%'
Duncan
--
Duncan Salada | Titan | www.titan.com/testeval
Email: [EMAIL PROTECTED] | Voice: 301-925-3222x375 | Fax: 301-925-3216
-Original Message-
From: Jonathan David
I am building a forum as part of a site, and the forum is broken into three
tables, a forum table, a thread table, and a post table.
All tables have indexes for common SELECT statements, to increase speed.
Example-
A user posts a new thread: One method would be 3 queries to insert/update
(insert
Hi,
After installation it's necessary to run mysq_install_db.sh.This script have
some routines to resolve the host,create system mySQL tables and write the
default option in this tables.For this reason, if you have some network
configuration problem, it's a good idea to use '-h' option and said
This is a mail list for MySQL users.
If a user knows the answer to your problem, and feels like answering,
you may get a correct,
or incorrect answer.
If you REQUIRE quick response, pony up for a service contract like I did.
Clay Loveless wrote:
At this point, I'd like to solicit tips on how
* kapachov
what is the number max of tables that can have a data base MySql?
Limited by the OS and file system only, maximum number of files in a
directory, and unless you use InnoDb tables you must divide this number by
3.
Maybe you could use multiple databases? You can retrieve data from
Hi kapachov,
The maximum number of tables MySQL DB can have depends on your OS.
The maximum number of connections it can have is stored is max_connections
variable. By default it is set to 100, but you can of course change it .. Do
a SHOW VARIABLES LIKE 'max_%'; to see what it is set to..
See:
Hi !
Thank You for the response !
I wrote in my original message that the program
is running on Solaris 8 (sparc).
And I'm aware of Solaris quite special memory
handling. And if I got It right, Solaris never frees memory
to system but it still frees memory to same process that
originally
Hi Clay Loveless,
As response to your loveless messages, I would like to browse :
http://www.mysql.com/support/index.html .
I have seen many times where people helped others for the matters that were
not documented on this list. Besides, when people are pointing help-seekers
to a documentation
* Kim Cosgrove
This should be an easy sql question for someone. I've got 2 tables that
have a linked field (id) and I need to clean up records that are
in table1,
but no matching id in table2. This is how I can select them
SELECT table1.* FROM table1 LEFT JOIN table2 ON
Hello,
Does anyone have ideas for semi-efficient similar text matching
in SQL queries in mysql that account for human error?
e.g. I may have a record in my database that has the word 'color' in it.
Well, someone types in 'colour'so I make a query like
select * from table where keywords
On the contrary -- I *DO* like the fact that the help on this list is *FREE*
of charge, AND that the support on the list is better than most paid support
services.
I'm just trying to figure out why my carefully and thoughtfully researched
help request has gone unanswered (or even commented on)
How can I use Transation in MySQL with ASP?
I tried %@TRANSATION = Required%, like MSQL, but don't works.
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
My advice is that you adjust your attitude.
Admittedly, the signified meaning behind your requests for help are
completely open to interpretation, and this varies across different
cultures. So you may not even be aware that your first followup
post/request for help carries a certain sneering
First, I would recommend upgrading to the latest release of mm.mysql --
which I think is 2.0.12. You can get the latest from sourceforge:
http://mmmysql.sourceforge.net/
2.0.4 is pretty old now.
--jeff
- Original Message -
From: Alan Jones [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Erik, et. al.--
Thanks for all the helpful advice.
I'll make a note that the MySQL mailing list welcomes messages from people
shrieking HELP!!! even though they clearly haven't bothered to read the
manual, but offers little to those who've actually tried to resolve a
problem on their own BEFORE
MySQL 'root' user has got nothing to do with Unix 'root' user. Quoted from
http://www.mysql.com/doc/C/h/Changing_MySQL_user.html is
Note that accessing MySQL as root, by supplying -u root on the command
line, has nothing to do with MySQL running as the Unix root user, or,
indeed, as another Unix
Hi,
When you connect from command line, you are logging as user@localhost ..
In your example, you said user@mybox thru PHP is not able to log in, I would
say check what hosts are allowed for that user in the user table..
See: http://www.mysql.com/doc/A/c/Access_denied.html
Gurhan
-Original
Good day, everyone, and thank you for your time!
I am not a member of the mailing list (I had to swear them off as
addictive =o) but am posting this question in the hope that some
generous soul will assist me anyway.
I am building a database in which I want to restrict the values in one
column
Incident Information:-
Originator:[EMAIL PROTECTED]
Recipients:[EMAIL PROTECTED]
Subject: mysql Digest 25 Apr 2002 16:26:08 - Issue 1867
Message from [EMAIL PROTECTED] was quarantined because it
contained banned content.
Your query reads: SELECT * FROM books WHERE title LIKE '%php%' AND NOT
title LIKE '%perl%' whereas it has to be ... AND title NOT LIKE '%perl%';
I think you need to make some changes in your PHP code for the in the case
block for - .
Gurhan
-Original Message-
From: Jonathan David
On Thursday, April 25, 2002, at 01:29 PM, Clay Loveless wrote:
I'm just trying to figure out why my carefully and thoughtfully
researched
help request has gone unanswered (or even commented on) for nearly a
week.
Based on the other responses I've seen to what are essentially RTFM
How do I add defaults to a table? In SQL Server I can simply write
columnname bit null constraint defaultname default (0)
when I create the table.
Thanks,
Eddie
-
Before posting, please check:
On Wed, Apr 24, 2002 at 12:45:43PM +0300, Michael Widenius wrote:
I will add to our TODO to add to SHOW OPEN TABLES a list of threads
that has locks on the table (or maybe a SHOW LOCKS command) to
better cover this case in the future.
Could it be SHOW TABLE LOCKS? That way it is not
On Thursday, April 25, 2002, at 01:50 PM, Clay Loveless wrote:
I'll make a note that the MySQL mailing list welcomes messages from
people
shrieking HELP!!! even though they clearly haven't bothered to read
the
manual, but offers little to those who've actually tried to resolve a
Thanks for inspiring me to create a new mail filter!
On Thursday 25 April 2002 01:50 pm, Clay Loveless wrote:
Erik, et. al.--
Thanks for all the helpful advice.
I'll make a note that the MySQL mailing list welcomes messages from people
shrieking HELP!!! even though they clearly haven't
Dear All
I have been trying to find out if there is a way of actually storing
pictures as Blobs in MySql . Eventually i want to upload and download
pictures to/from the database through the use of ASP. I would also welcome
any suggestions that you guys may have regarding how to upload the image
/* Clay Loveless [[EMAIL PROTECTED]] writes: */
I'll make a note that the MySQL mailing list welcomes messages from people
shrieking HELP!!! even though they clearly haven't bothered to read the
Easy questions tend to get lots of answers, because many have read the
manuals and can pop off an
How do I optimize the following query?
SELECT foo.id FROM foo, bar WHERE foo.id = bar.foo_id AND foo.field =
'baz' OR bar.field = 'baz';
Only a small number of records from each table match the query
conditions, but MySQL takes forever to execute it. No wonder, when
EXPLAIN says it needs to
1 - 100 of 141 matches
Mail list logo
