Hi!
I have such SQL :
select CompanyName from Company where CompanyName like '%car%'
Really I need in query result all of companys, which contains symbols CAR in any case
(car, Car,CAr, CAR, e.t.c).
I think that I need Case insensitive records search.
Is it's possible and how?
Thanks a lot!
Ciao guys,
I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run
it, and had a 'too many connections' warning. So, I just set the
max_connections variable to 200. And since then, no problem.
Here is the /etc/my.cnf file under the [mysqld] group:
set-variable=key_buffer=1
I'm sure most people on this list aren't interested in your services. You
can start by reading the relevant manuals or you could hire a professional
to create the db for you.
This is a great list for getting help on specific problems provided you've
tried to help yourself first.
Also, if you do
Yes, "host server" means ISP.
I am able to view the logs because he lets me.
I agree with you, I think someone else is shutting down the database, but he
insists that my perl scripts are causing it to crash. The only proof I have
right now is the MySql error log, which lists the "normal shutdow
Greetings:
Full source is at http://az.dedserius.com/main.c
I'll reduce this to one problem at a time and see if I can make some progress,
that way.
With the following code, running with -psecret works, but, --password doesn't.
Anyone ran into this?
struct option long_options[] =
{
{
This doesn't make much sense to me. By "host server" you mean your ISP?
If so how are you able to view the logs? Are you DB admin or something? By
the looks, someone is able to get in and shut it down. This can only happen
with admin rights or mysql server wasn't set up correctly in the first
I can't help with the php...but I do know that insert statement is invalid.
You need something more like
$sql = "insert into sitesats (id, areview, apositive, anegative, arate)
values('$id', '$areview', '$apositive', '$anegative')";
And I assume the update is trying to update the just-inserted
Try echo(mysql_error()); after each call to mysql_query()
> The following code doesn't insert and update info in the db for
> some reason:
(clipped)
> Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/m
http://marc.theaimsgroup.com/?l=mysql&r=1&w=2
> Is there a list archive for this list? I have a few questions which I am
> sure are asked all the time. But For the life of me I can't seem
> to find the
> answer's in the documentation at mysql.com. Thx,
---
Never mind...It would help if I looked just a little harder! I found the
list's archive. Sorry for the post!
h3rb
On Monday 11 June 2001 01:15, h3rb wrote:
> Is there a list archive for this list? I have a few questions which I am
> sure are asked all the time. But For the life of me I can
Greetings !
How can one populate multiple table with a single data in one go in MySQL
Database?
Looking forward to hearing from you.
Warm Regards,
DT
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Is there a list archive for this list? I have a few questions which I am
sure are asked all the time. But For the life of me I can't seem to find the
answer's in the documentation at mysql.com. Thx,
h3rb
-
Before posting, p
The following code doesn't insert and update info in the db for some reason:
It gives me the success message but the db remains untouched. What have I done this
time? :)
Thanks in advance.
On Sun, 10 Jun 2001, Brian Walker wrote:
> [root@www data]# telnet www.sfslsports.com 3306
> Trying 209.15.183.134...
> Connected to www.sfslsports.com.
> Escape character is '^]'.
> (
> 3.23.38)fHv:[?e
>
> Bad handshakeConnection closed by foreign host.
If you can see version number then
Need a little assistance. I've looked through the current MySql manual, but
I can't find any information concerning my questions.
My MySql server keeps crashing, or that's what my host server tells me. He
claims that my scripts are crashing MySql. However, when I look at the
MySql error log, I
Hi,
Yes, I have done it. You need to connect to your MySql database via ODBC.
Setup your ODBC datasource for your database and set the Target Server in
ERwin to ODBC.
Regards,
Michael
> Is it possible to use ERwin from Logic Works (www.logicworks.com) with
> MySQL
> ?
> How ?
> For the sake o
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Scott" <[EMAIL PROTECTED]>
Sent: Sunday, June 10, 2001 10:48 PM
Subject: Re: Why do people post on this list w/o subjects?
> Your message cannot be posted because it appears to be
either spam or
> simply off topic to our filter. To byp
At 09:54 PM 6/10/2001 -0400, Jeffrey L. Fitzgerald wrote:
>Howdy Hi,
>Any word on how to select distinct database records using PHP code?? Thanks in
>advance...
mysql_query("SELECT DISTINCT * FROM BLAH;");
-
Before posting, p
At 06:13 PM 6/10/2001 -0700, John 'TPG' Smith wrote:
>I am interested in learning MySql and cgi.
>
>I want to trade my services for this help.
>
>I want to be able to make custom web based applications.
>
>I am a pornographer.
>
>
>TPG
>
>[EMAIL PROTECTED]
I don't even want to know what services
There's a list of functions in the php manual that allow you to connect,
pass sql statements to and retrieve data from a database.
- Original Message -
From: "Jeffrey L. Fitzgerald" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 9:54
Subject: Re: Selecting Distinc
I presume that is just an example as people's names don't make very good
primary keys.
Something like
SELECT h2.*
FROM hotel h1, hotel h2
WHERE h1.name = 'BILL'
AND h1.room = h2.room
I haven't tried it so you'll have to play around with it a bit.
- Original Message -
From: "Jaime Teng"
The mysql manual contains a list of what's lacking and whether or not these
features will be implemented in the future.
- Original Message -
From: "John Meyer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 10:13
Subject: What things does MySQL lack as of yet
>
Unfortunately not. I devised this method myself. What I did was used php's
random function to first select a length for the string and then select a
random number between 1 and 62. If the number was between 1 and 10, add the
corresponding character between 0 and 9, between 11 and 36, a capital
At 9:54 PM -0400 6/10/01, Jeffrey L. Fitzgerald wrote:
>Howdy Hi,
>Any word on how to select distinct database records using PHP code?? Thanks in
>advance...
Why would PHP have anything to do with it? Isn't it a matter of constructing
the proper SELECT DISTINCT SQL statement?
--
Paul DuBois, [
Hi.
On Mon, Jun 11, 2001 at 04:18:19AM +0200, [EMAIL PROTECTED] wrote:
> Hello.
>
> On Sun, Jun 10, 2001 at 07:13:11PM -0700, [EMAIL PROTECTED] wrote:
> > Hi, I was reading a book on MySQL/PHP, and it was talking about the lack
> > of certain features. My question is, what features does My
I am on 3.27.37. My mysqldump looks something like this:
mysqldump -T
/data/home/pmehta/mysql --no-create-info --fields-enclosed-by='"' --fields-t
erminated-by=',' --opt mydb MyTable
- Original Message -
From: "Ed Carp" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Hello.
On Sun, Jun 10, 2001 at 07:13:11PM -0700, [EMAIL PROTECTED] wrote:
> Hi, I was reading a book on MySQL/PHP, and it was talking about the lack
> of certain features. My question is, what features does MySQL lack yet,
> and are there any plans to include those features?
You may wan
Hello.
On Sun, Jun 10, 2001 at 02:56:45PM +0200, [EMAIL PROTECTED] wrote:
> I've got this php script which has three times now halted with this error
> message:
>
> SELECT * FROM eZSession_Session WHERE Hash=''
> Table 'eZSession_Session' was not locked with LOCK TABLES
Usually, one gets this
On 11-Jun-01 Dawn H wrote:
>>Ahh. 'it doesn't work.'
>>As in: it returns a error ? or doesn't display you what you want ?
>
> Both. I've fiddled with it doing this and that and haven't been able to get
> it to display correctly.
>
do the cut-n-paste thingy & get your query correct first; sweat
On Sun, Jun 10, 2001 at 08:18:52PM -0500, Whit Blauvelt wrote:
>
> > > Doing that, I'm now seeing: "ERROR 2013: Lost connection to MySQL
> > > server during query" after entering the password.
>
> The problem above shouldn't be master.info related.
Right. That was a client error. The server is
Howdy Hi,
Any word on how to select distinct database records using PHP code?? Thanks in
advance...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
On Sun, Jun 10, 2001 at 08:18:08PM -0700, Vladimir Kravtsov wrote:
> Well I fixed that part so now the file looks like this:
> $sql = "select id, siteurl, sitename, from sitesats where validated = '$validated'";
> Warning: Supplied argument is not a valid MySQL result resource in
>c:\inetpub\ww
You have 1 too many commas. Remove the comma before the from clause in your
sql statement.
- Original Message -
From: "Vladimir Kravtsov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 11:18
Subject: PHP Prob contd.
Well I fixed that part so now the file looks
>Ahh. 'it doesn't work.'
>As in: it returns a error ? or doesn't display you what you want ?
Both. I've fiddled with it doing this and that and haven't been able to get
it to display correctly.
>> BEGIN QUOTE-
>> $sth=$dbh->prepare ("SELECT listing.id, pictures.thumb_1,
description
Hi,
I have a single table:
CREATE TABLE hotel (name char(50),room char(20));
name is unique.
but there can be one or more person assigned to any single room.
I would like to perform a query to determine:
who are living with 'BILL'?
currently, i tried using:
1. get the room where BILL is in.
Hi, I was reading a book on MySQL/PHP, and it was talking about the lack
of certain features. My question is, what features does MySQL lack yet,
and are there any plans to include those features?
-
Before posting, ple
I am interested in learning MySql and cgi.
I want to trade my services for this help.
I want to be able to make custom web based applications.
I am a pornographer.
TPG
[EMAIL PROTECTED]
-
Before posting, please check:
Have you tried ismchk/myismchk?
- Original Message -
From: "Artem Krsheminsky" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 2:01
Subject: simpe select return not all rows - and flush
> Hi
>
> i'm newbie and have the problem -
> sometimes after some INSERT and
On 10-Jun-01 Dawn H wrote:
> Here's what I currently have that doesn't work:
>
Ahh. 'it doesn't work.'
As in: it returns a error ? or doesn't display you what you want ?
> BEGIN QUOTE-
> $sth=$dbh->prepare ("SELECT listing.id, pictures.thumb_1,
description.mls,
> listing.p_city,
On Sun, 10 Jun 2001 19:13:01 -0700, "Vladimir Kravtsov" <[EMAIL PROTECTED]>
wrote:
>>
>>
>>
>>>connectdb();
>>mysql_select_db(xtopsites);
>>$validated=1;
>>$sql = "select id, siteurl, sitename, from sitesats where validated = "$validated"";
>//
Well I fixed that part so now the file looks like this:
Now, when I run it I get this error:
Warning: Supplied argument is not a valid MySQL result resource in
c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 11
You have an error in your SQL syntax near 'from sitesats where valid
> > Doing that, I'm now seeing: "ERROR 2013: Lost connection to MySQL
> > server during query" after entering the password.
The problem above shouldn't be master.info related.
> Does the master.info file on the slave contain accurate info?
Removing master.info and restarting the slave server
On Sun, Jun 10, 2001 at 07:13:01PM -0700, Vladimir Kravtsov wrote:
> $sql = "select id, siteurl, sitename, from sitesats where validated = "$validated"";
>// Line 8
Actually, using '$validated' might work better - one or the other.
Whit
-
On Sun, Jun 10, 2001 at 07:13:01PM -0700, Vladimir Kravtsov wrote:
> $sql = "select id, siteurl, sitename, from sitesats where validated = "$validated"";
>// Line 8
> What's wrong here?
Try \"$validated\" - you need to escape the quoted quotes.
Whit
---
On Sun, Jun 10, 2001 at 03:27:44PM -0700, Jeremy Zawodny wrote:
> Does the master.info file on the slave contain accurate info? MySQL
> doesn't compare the contents of the file against your my.cnf. It
> creates the master.info file once and then considers it
> authoritative. This is neither well
On 11-Jun-01 Vladimir Kravtsov wrote:
>
>
>
> connectdb();
> mysql_select_db(xtopsites);
> $validated=1;
> $sql = "select id, siteurl, sitename, from sitesats where validated =
> "$validated""; // Line 8
^ ^ - escape your quotes, \"$validated\";
change to sin
You have a problem with "...
" is reserved word, put \ before it...
try this:
$sql = "select id, siteurl, sitename, from sitesats where validated =
\"$validated\"";
regards,
Augusto
On Sun, 10 Jun 2001, Vladimir Kravtsov wrote:
>
>
>
> connectdb();
> mysql_select_db(xtopsites);
> $valid
When I run this I get: Parse error: parse error in
c:\inetpub\wwwroot/php/X-TopSites/admin/admin.php on line 8
I want it to select the id, siteurl, sitename (in a table called sitesats) of any site
which is not validated (I made it so validated=1 and not validated=2)
What's wrong here?
T
You can use myODBC and Access Option "Get External Data"
Siomara Pantarotto wrote:
> Hi all,
>
> I got my java connection working but now I need to export a MS Access
> database to mysql database.
>
> Does anyone knows the fastest way to do it
>
> My main question is:
>
> Is there a way to e
Here's what I currently have that doesn't work:
BEGIN QUOTE-
$sth=$dbh->prepare ("SELECT listing.id, pictures.thumb_1, description.mls,
listing.p_city, listing.p_state, listing.p_zip, description.price from
listing, description, pictures");
$sth->execute()
or bail_
Greetings:
With the following code, I have 3 problems:
1. ./client -psecret works, but, ./client --password=secret does not;
2. After calling load_defaults, the argument vector is getting parsed,
but, it's not making it into the switch processing. The values
from my gl
Brian Walker ([EMAIL PROTECTED]) writes:
> 010609 14:40:21 Do you already have another mysqld server running on port:
> 3306
> ?
> The manual said to try to telnet in on port 3306 so I did that and got this:
>
> [root@www data]# telnet www.sfslsports.com 3306
> Trying 209.15.183.134...
> Conn
Dawn H ([EMAIL PROTECTED]) writes:
> I have four tables, and I want to use bits of each one to display a list on
> one page. I tried listing what I wanted out of each, but it seems that if
> any one of the fields chosen is null, the whole row with that ID# is left
> out. I thought perhaps a LEFT
All ([EMAIL PROTECTED]) writes:
> Hello mysql,
> I have FreeBSD 4.3, gcc 2.95.3
> I do:
> ./configure
> gmake install
>
> I have error when I try to compile mysql:
>gmake[1]: *** No rule to make target `my_init.c', needed by `my_init.lo'. Stop.
>gmake[1]: Leaving directory `/c
On Sun, Jun 10, 2001 at 03:46:17PM -0500, Whit Blauvelt wrote:
>
> Okay, to get "mysql --port=" to work with a forwarded port it's
> also necessary to specify the host name as the external name rather
> than the assumed "localhost".
>
> Doing that, I'm now seeing: "ERROR 2013: Lost connection
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> Is there a way that I can make mysqldump output a row in a single line ?
> The line is fairly long, and wraps to something like 20 lines or so,
> due to one column that is a clob. Total there are 67K records.
I thought the default was to not wrap
Hello
I am having a terrible time trying to start my MySQL server after it
installed.
My system is a Cobalt RAQ 3, w/ a Linux OS, I installed MySQL version
3.23.38-pc-linux-gnu-i686
The problem comes when I type: './bin/safe_mysqld' I get this:
Starting mysqld daemon with databases from
/usr/l
Hello,
I was wondering if you could help me on a problem I am having with mySQL.
I've installed MySQL (Win32) on F:\mysql. I've placed my.cnf on C:\. This is
the contents of my.cnf:
---
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long
you can use fetch_array:
$data = mysql_query("select * from Categories");
$aux="";
while ($row = mysql_fetch_array($data)) {
$aux.="".$row['Name']."";
}
$aux.="";
echo $aux;
this code will print in html a combobox with the options, in php, the
variable "$catagorie" will have the "id" number o
Hello MySQLers:
Is there a way that I can make mysqldump output a row in a single line ?
The line is fairly long, and wraps to something like 20 lines or so,
due to one column that is a clob. Total there are 67K records.
I am trying to output mysqldump and then import into Oracle using
SQLLoade
Okay, to get "mysql --port=" to work with a forwarded port it's also
necessary to specify the host name as the external name rather than the
assumed "localhost".
Doing that, I'm now seeing: "ERROR 2013: Lost connection to MySQL server during query"
after entering the password.
I'm trying to
I recently downloaded the windows odbc client software such that I would
access mysql server (on linux) from a WinME laptop using Microsoft Access
(or whatever). After running the setup program, I went into Settings and
tried to add MySQL for ODBC sources, per the 'readme'. Well, there was no
en
Hello Don,
I write my own mysql client, and it need some libs.
In ports it doesn't exist or am I wrong?
Best regards,
All [EMAIL PROTECTED]
Sunday, June 10, 2001, 10:58:07 PM, you wrote:
DR> On 10-Jun-01 All wrote:
>> Hello mysql,
>> I have FreeBSD 4.3, gcc 2.95.3
>> I do:
>>
On 10-Jun-01 All wrote:
> Hello mysql,
> I have FreeBSD 4.3, gcc 2.95.3
> I do:
> ./configure
> gmake install
>
> I have error when I try to compile mysql:
>gmake[1]: *** No rule to make target `my_init.c', needed by `my_init.lo'.
> Stop.
>gmake[1]: Leaving directory `/c/mysql-
Leon Mergen wrote:
> I recently read an article at Zend.com, showing that Postgres had
better
> performance than MySQL... Off course, this is a very bad thing to say
in the
> MySQL mailing list, and I'm not really sure about it either, since so
many
> praise MySQL...
>
> http://zend.com/zend/art/
Have a look at the PHP mysql_fetch_array and mysql_fetch_row functions and
associated documentation...
";
}
?>
On Sun, 10 Jun 2001, Vladimir Kravtsov wrote:
> Here is my db hierarchy:
> Database: xtopsites
> Table: Categories
> idName
> 1Name1
> 2Name2
> 3Name3
> 4Name4
>
Hi
i'm newbie and have the problem -
sometimes after some INSERT and also sometimes just from nothing
simple SELECT begin work not properly - it returns not all rows in the table
that must.
in most cases FLUSH TABLES help, but yesterday it won't help - SELECT
continue return empty result, until
Hello mysql,
I have FreeBSD 4.3, gcc 2.95.3
I do:
./configure
gmake install
I have error when I try to compile mysql:
gmake[1]: *** No rule to make target `my_init.c', needed by `my_init.lo'. Stop.
gmake[1]: Leaving directory `/c/mysql-3.23.38/libmysql'
gmake: *** [install-rec
After much searching the net trying to find a solution to the problem
of not being able to get mod_auth_mysql-2.20 to work as a DSO in
Apache 1.3.x (the problem being, on server start, "Cannot load
/usr/local/apache/libexec/mod_auth_mysql.so into server:
/usr/local/apache/libexec/mod_auth_mysq
Here is my db hierarchy:
Database: xtopsites
Table: Categories
idName
1Name1
2Name2
3Name3
4Name4
5Name5
6Name6
I would like the user to get to a sign up form and have all the names of the
categories displayed.is this possible to do using fetch_array? If it i
You need to use the following when you build mysql to use all options.
CC=gcc CXX=gcc ./configure --prefix=/usr/local/mysql --enable-thread-safe-client
--with-berkeley-db=./bdb --with-innodb
Not that CXX is gcc and not the c++ compiler from SCO.
Good Luck,
--
Boyd Gerber <[EMAIL PROTECTED]>
I had this problem the other day, and thought I would post this for the
archives.
Running MySQL 3.23.38 with apache 1.3.39 and PHP 4.05. the versions are
really
irrelevant. MySQL compiled fine, and the daemon was running fine on Linux
7.0. Or
it appeared to be. But when I tried to run mySQL from
I have four tables, and I want to use bits of each one to display a list on
one page. I tried listing what I wanted out of each, but it seems that if
any one of the fields chosen is null, the whole row with that ID# is left
out. I thought perhaps a LEFT JOIN but don't know how to make that work o
Hi!
The Zend article is somewhat outdated, because it says that MySQL does not
support transactions.
The benchmark the Zend article is referring to is the "TPC-C" benchmark
and the AS3AP-IR-select benchmark financed by Great Bridge LLC, a company
selling support for PostgreSQL.
I have written T
Well, if you're using web pages, I've never thought much of passwords being
passed from one page to the next. Too much at risk of being "sniffed" out
each time a page is submitted to the server. I devised a way that creates a
random char string which changes each time a user logs on and that ge
Hi All,
I've got this php script which has three times now halted with this error
message:
SELECT * FROM eZSession_Session WHERE Hash=''
Table 'eZSession_Session' was not locked with LOCK TABLES
After this Apache or MySQL has to be restarted to get contact with the
database.
I do not underst
I have just started to use MySQL and like the ease in which it does it's one way
replication. However I have a situation that has multi-sites that would need to do
local entry to a database and then update the centreal database which could then
update those databases that don't have the changed
I have compiled 3.23.38 without problems. I ran the test suite and mysqld
passed all 117 tests (I think it was 117). mysql client works fine but I
tried to use mysqldump and received a core dump (segmentation violation). I
also receive this if I try and run mysqlshow. As far as I can tell,
everyth
>Description:
When I try and run mysqldump, I get a core dump.
>How-To-Repeat:
it repeats anytime I try and run mysqldump.
>Fix:
I have not found a fix yet.
>Submitter-Id:
>Originator:Phillip Porch
>Organization:
Phillip P. Porch <[EMAIL PROTECTED]> NIC:PP1573 finger for
ht
I used the function password() if that helps but of course you can't
"decode" it.
- Original Message -
From: "Leon Mergen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 09, 2001 22:44
Subject: Re: Password encryption
> Anyone has any idea how much this encryption meth
Hello Rolf,
I need the decoding option, since I need to have a password lookup
function...
Hmmm... offcourse, I *COULD* completely rewrite it, and instead of lookup up
a password, make it so that you can reset your password if you have verified
your email address or something.
However, I wonder
>Hi,
>Thanks for the reply.
>
>The sites (deptsite1 deptsite2) on the department file are the numeric key
>to the actual site file.
>
>The query below works fine (in mysql & php) but how do I reference the
>sitename for the joins that have happened?
>
>Specifying
> $result = mysql_db_query
>I'm having a lot of difficulty trying to figure this out. I have a table
>with a list of projects that I would like to arrange and view as a tree.
>This is my table:
>
>++--+--+-+-++
>| Field | Type | Null | Key | Default | Ext
Wouter de Jong writes:
> Hello,
>
> I'm a database administrator for a hosting provider, and we have currently 2 SMP
>MySQL-database servers. The one that is causing me problems, has at least 900
>databases running on it. That's an dual PIII-550, with 1024MB memory, running RedHat
>6.2, with L
Unfortunatly you can do this only on local databases. It would be very useful to also
request databases on different servers with one statement.
Philip
On Fri, 8 Jun 2001 17:19:34 -0600
"Chris Bolt" <[EMAIL PROTECTED]> wrote:
> Try it =P (just don't forget the WHERE clause)
>
> If you want to
Hi, I use MySQL on a Windows 2000 box and I usually change users and
passwords from the MySQL shell, using:
UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';
I never had a single problem with this.
bye, Bibe
At 15.37 09/06/2001 -0700, you wrote:
>I am getting a error after ins
86 matches
Mail list logo
