I would suggest turning logging on ('log' entry in my.cnf under mysqld)
do a search and look to see what the actual SELECT parsed by the mysqld
server was. My hunch is that it is only seeing '%' and not '123456789123%'
as expected.
OK, so I now look at your code. It will be looking for '$input{
HI!
Thanks for your Help! I´ve tried this, but when inserting the % now all
my selections seem to be valid or successful, even if there is no match!
What is wrong? My table for testing has the following entries:
Pin: 123456789123 msisdn:+491231234567knd:test
PIN: 123456789012 msi
Hi,
Wondering if anyone might be able to help me with a
slight problem. I downloaded the static version of
the mysqlgui and I can't seem to get it working.
I gunzip and try to execute and it complains that it
can't find a library of some sort. I looked at the
readme file in the source distribu
>
> Hi,
>
> mysqld is single-process/multi-thread.
> What you see are 4 threads, ps on Linux doen not differenciate between
> threads and processes.
> For more details on these threads, you can look at the manual:
> http://www.mysql.com/doc/M/y/MySQL_threads.html
>
when i ps on freebsd 4.4 i saw
Hi Heikki,
There is 4.xx version available. why upgrade to 3.xx version?
-- Prabhu
On Fri, 4 Jan 2002, Heikki Tuuri wrote:
> Date: Fri, 4 Jan 2002 16:55:29 +0200
> From: Heikki Tuuri <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: Mysql, innodb, linux problems
>
> Bernard,
>
>
At Sun, 06 Jan 2002 14:55:53 +0200, [EMAIL PROTECTED] wrote...
:
: Hi!
:
: > "fil" == fil krohnengold <[EMAIL PROTECTED]> writes:
:
: fil> [gcc version 2.95.2; mysql 3.23.47]
:
:
: fil> ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
: fil> rm -fr .libs/libmysqlclient.la .libs/lib
Hi,
I have developed an application in PHP/MySQL in Linux
environment. I need to burn it in a CD and give it to
the client. I need to do one thing - that is when the
client insert that CD automatically my setup should
run. How to do that...?
what sort of coding i need to do ..? is it that i need
Hi,
The below mentioned query,
select eventartists.eaDnID,djnames.dnName,eventartists.eaDn2ID from
eventartists,djnames where djnames.dnID = eventartists.eaDnID;
gives the following result.
+++-+
| eaDnID | dnName | eaDn2ID |
+++-+
| 1 | dj
>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:
Hello
I have a question about the REPLACE string function, not the REPLACE SQL
command.
According to the documentation, REPLACE works as follows:
==
REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str
replaced by the string to_str
mysql>
Hello,
I'm back to the list after two weeks off.
I have a little problem, the email may seem long but it's clearly explained
step by step what I've done...
I have a table that have artists playing at events. It's called
eventartists. One artist can play alone, or with another artist. Because the
> Hi all
>
> What is the maximum records can hold in a single table in mysql.
>
> I am doing a file upload from text file to a table.
>
> The records are seperated using year,month,date. I have 2 years of data to
> be uploaded.
> After I did 2 months where in my single table recordcount was
Dear List,
I was installed mysql-3.23.47 in my Linux box with PHP. I could shown
version correctly with mysql command line or any windows client tools. It
still shown in phpinfo with version 3.23.37 (old version before
upgrade). What wrong?
SF
-
Hi all
What is the maximum records can hold in a single table in mysql.
I am doing a file upload from text file to a table.
The records are seperated using year,month,date. I have 2 years of data to
be uploaded.
After I did 10mb of file (2 months) where in my single table recordcount
was reac
Yes it is, at $139 I think it is a supper apps, if you are not sure try the
evaluation version
-Original Message-
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 15:37
To: Norman Khine; Stan Lester
Cc: Mysql
Subject: Re: SQL Server 2000
You can't try http://www.
I have apache running on a windows 98 machine and I
just installed mysql on it. Also I use perl 5.6.
However this is for local testing.
I need to go online with my website soon.
I was wondering if it is possible to use this setup to
get a mysql db driven website going, then send it to a
linux
Put double quotes around % so that foo@"%"
On Sun, 6 Jan 2002 18:31:00 -0500, Christian J Hedemark wrote:
>mysql> grant all privileges on *.* to foo@% identified by 'foobar' with
>grant option;
>ERROR 1064: You have an error in your SQL syntax near '% identified by
>'foobar' with grant option' a
> GRANT ALL PRIVILEGES ON *.* TO tue@"%" IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
Ah but that doesn't work this is what worries me because I have a book
on mysql that uses syntax like this and it generates an error on my system.
This is a Red Hat 7.2 system, stock with Red Hat distribute
On Mon, 7 Jan 2002 00:03:20 +0100, Tue Hellstern wrote:
>I cant connect to a MySql Database form a Windows PC, I get Host ... is
>not allowed to connect to this MySQL server and in the MySql manual I
>found the following solution but I dont know how to do it. I am an
>novice in MySql.
>If anyo
I went ahead and did the Bitkeeper thing.
Again, the documentation was not very exacting:
shell> bk clone bk://work.mysql.com:7001 mysql-4.0
do rather: bk clone bk://work.mysql.com:7001 mysql-max-4.0
shell> cd mysql
Hi,
I cant connect to a MySql Database form a Windows PC, I get Host ... is
not allowed to connect to this MySQL server and in the MySql manual I
found the following solution but I dont know how to do it. I am an
novice in MySql.
If anyone can make tell me the commands I will be very happy.
>
SELECT COUNT(DISTINCT ip), COUNT(*), CONCAT(shref,href) FROM hit
GROUP BY 3
It is work, result is table with many record.
SELECT COUNT(*), CONCAT(shref, href) FROM hit
GROUP BY 2
But this query don't work.
#
# Table structure for table 'hit'
#
Hi!
I have the following script to be executed via post from a web-form; the
var. Pin, msisd and knd are given by the form but however, the script is
not working. I always get no results as if there are no matches, but
this isnt right! This is regardless which entries i submit with the
form!
Any
What do I do to get libmysqlclient.so for my binary distribution of Mysql
max 4.0.1 ?
Install bitkeeper, get the source, build it ???
It's not included in any download already ?
( Not the one I got, I just have a libmysqlclient.a )
-AEF
--
"When I took off my space suit helmet, I l
hi!
i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k
to config innodb, i edited the my.ini (with some help from heikki...thanks!)
and learned on win my.cnf and my.ini cannot co-exist.
now i'm ready to install mysqlgui to set up my admin, users, etc...
my question is: can i add the included my
Sebastian Grewe wrote:
>
> I have a problem with my Website. I want to list only 25 results of a db query. When
>the user klicks on "Second Page" he should see the next 25 results and so on.
>
> How can I do that?
>
> Thx for replies.
>
> Sebastian
>
> ---
I have a problem with my Website. I want to list only 25 results of a db query. When
the user klicks on "Second Page" he should see the next 25 results and so on.
How can I do that?
Thx for replies.
Sebastian
-
Before pos
this is a perfect explination, I was concerned about the same webserver
(split into virtual) accessing different databases.
Out of interest can anyone think of ANY problems this virtual setup may
cause ? ie memory, transaction time, dns even, just anything at all so I am
trying to evaluate possib
At 17:36 + 1/6/02, David Ayliffe wrote:
>I have a file (data.txt) which contains the data:
>
>ELITEô85.ôQô4 DaysôLilleshallôChris
>IMPô75.ôQôTues&FriôLilleshallôSue
>LEFTô0.ôôôLeftô
>PRESCô24.ôTôOne DayôWrekinôArleen
>RECô27.ôQôTuesôWrekinôTony
>
>I use the "LOAD DATA" DDL
Yeah useful but that still doesn't solve my problem
-Original Message-
From: Maciek Dobrzanski [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 17:43
To: David Ayliffe; 'MySQL'
Subject: Re: Strange LOAD DATA problem
> Also I use the field delimiter ô (ALT+147) because the data MAY
> c
HI all,
I would be extremely appreciative with solution
suggestions to the problem I am having.
I really could use some help right now !!
I am trying to get a database driven website up and
running that has some amount of security on it (which
i intend to make progresively better). It needs
us
I have a file (data.txt) which contains the data:
ELITEô85.ôQô4 DaysôLilleshallôChris
IMPô75.ôQôTues&FriôLilleshallôSue
LEFTô0.ôôôLeftô
PRESCô24.ôTôOne DayôWrekinôArleen
RECô27.ôQôTuesôWrekinôTony
I use the "LOAD DATA" DDL statement:
LOAD DATA LOCAL INFILE "data.txt" INTO TA
Sorry, I forwarded this worng the first time...
--Brian
-Original Message-
From: Brian E. Beck [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 06, 2002 8:17 AM
To: j.urban
Subject: RE: Using MYSQL and PHP With Vitual Apache Servers ?
In fact, I run 30 virtual servers, and 10 of them h
Why not just create separate databases for each virtual server? It sounds
like a perfect situation to create multiple databases, as databases do
provide data separation...
mysql> create database Virtual1;
mysql> create database Virtual2;
mysql> create database Virtual3;
mysql> create database Vi
You can't try http://www.appsolute.nl/heraut/ ... it is a restricted site.
Must be a commercial package or subscription service.
Gerald Jensen
- Original Message -
From: "Norman Khine" <[EMAIL PROTECTED]>
To: "Stan Lester" <[EMAIL PROTECTED]>
Cc: "Mysql" <[EMAIL PROTECTED]>
Sent: Sunda
* Matthew Darcy
> I have a redhat server, running apache 1.3.20. The server is running a
> couple of virtual servers for different websites. I now wish to add a few
> new virtual servers/domains to the machine. However (here is the twist)
> these sites will need to use a different mysql schema eac
Matthew:
There is no 'twist' here ... once your Apache server is configured to
support MySQL and PHP, just design the appropriate schema for each website
and create a database for each site requiring MySQL support.
I would suggest you pick up one (or more) of the books available on MySQL
and PHP
Hi
If you want to change port from eg 3306 to 3308 then edit the [mysqld]
section in the my.ini file in \winnt to :
[mysqld]
port=3308
Save the file, then restart the service.
To check if the port opened succesfully do "netstat -a" in the command
prompt.
If that doesn't work, then email me ba
Hi John
I've been using 3.x for over 18 months now, i upgrade my dev. system to the
latest release as soon as it's available.
However, i deploy projects to many different servers usually running old
versions of 3.x and i've been caught out a couple of times; it's not a
pleasant feeling when you
Sergey Potapov a écrit :
>
> Hello,
>
> I have a small Linux server on my company (Pentium-133 with 16 RAM)
> and recently i installed mysql-3.23.37 for collect statistics from
> proxy. But then i look at ps out, i saw this:
> ps -axl|grep mysql
> VSZ RSS
> ... 17840 116453 SW ?
Hi
I implemented replication in my databases, and I can see a security problem.
When you configure the slave you must write the replication user password in
the my.cnf file. If somebody access this file will see the password and the
user name, so if he can and want he will get access to the maste
Hello,
I have a small Linux server on my company (Pentium-133 with 16 RAM)
and recently i installed mysql-3.23.37 for collect statistics from
proxy. But then i look at ps out, i saw this:
ps -axl|grep mysql
VSZ RSS
... 17840 116453 SW ? 0:00 [safe_mysql
... 10324 4300 12d
Hi,
I have a redhat server, running apache 1.3.20. The server is running a
couple of virtual servers for different websites. I now wish to add a few
new virtual servers/domains to the machine. However (here is the twist)
these sites will need to use a different mysql schema each and have some of
Hi!
> "fil" == fil krohnengold <[EMAIL PROTECTED]> writes:
fil> [gcc version 2.95.2; mysql 3.23.47]
fil> ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
fil> rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.*
fil> .libs/libmysqlclient.*
fil>
fil> ... then I'm stuck there
Hello Heikki,
Saturday, January 05, 2002, 11:55:02 PM, you wrote:
>>Hello mysql,
>>
>> I'm using mysql 3.23.47 with Innodb and trying to play around with
>> replication. The replication options are default.
>>
>> I got one table content occasionally deleted on slave, and note what
HT> Who
try http://www.appsolute.nl/heraut/
you can use importerscript to run db_dump.sql from you M$ SQL Server into
dezign and then change the db type to mysql.
hth
Norman
-Original Message-
From: Stan Lester [mailto:[EMAIL PROTECTED]]
Sent: 05 January 2002 18:35
To: [EMAIL PROTECTED]
Subjec
Erv,
> Does MySQL have anything functionally equivalent to the data dictionary
> views of Oracle? I am thinking particularly of retrieving, via a SQL
> SELECT statement, a list of all my tables, or a list of all the columns of
> a particular table along with the columns' attributes.
Installed a
47 matches
Mail list logo