I have a db with some data that includes parentheses, for example:
mysql select Artist, Track from tracks where Artist regexp 'Isley Brothers Band';
+-+---+
| Artist | Track |
Hello aToM,
It works if you double escape character, i.e.
select Artist, Track from tracks where Track regexp 'Rumour \\(';
in your case (just tested myself). Looks pretty weird, but seems to
work.
Tom
Sunday, March 10, 2002, 10:48:07 AM, you wrote:
a I have a db with some data that
Hello,
I am transfering from Access to MySQL.
I use it for a bibliograhical database.
In bibliograhical data the \ signs stands for semantische opposition.
My problem is that a query like
select * from term where term=$term$
works with Access but fails in MySQL when a \ character is in
* Vincent Stoessel
Hello, I am trying to convert this weird cobol style number into a
regular integer. I got it from a fixed length text file.
[...]
If the value is negative, the right most column will contain a
special character: ] = -0, j = -1, k = -2, l = -3, m = -4,
n = -5, o
Warning
Unable to process data:
multipart/mixed; boundary=--==_846811060==_
* Vincent Stoessel
Thank you very much. One more thing, would 250k
be the same as 2500 x -3 ? ie -7500
No, I don't think so, but I must add a small disclaimer: I have worked with
cobol many years ago, and your numbers seems familiar, but I don't really
remember, I am only guessing... :)
sql,query
Thank you very much. One more thing, would 250k
be the same as 2500 x -3 ? ie -7500
Thanks again.
On Sun, 10 Mar 2002, Roger Baklund wrote:
* Vincent Stoessel
Hello, I am trying to convert this weird cobol style number into a
regular integer. I got it
see : http://www.mysql.com/doc/U/p/Upgrading-to-arch.html
If you are using MySQL Version 3.23, you can copy the .frm, .MYI, and .MYD
files between different architectures that support the same floating-point
format. (MySQL takes care of any byte swapping issues.)
2 pcs x86 1under windows xp
Hi all,
I got this error message when trying to connect to mysql at the shell
command:
Error 2002:Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock
There is no mysql.sock in the /var/lib/mysql directory. Did I miss some
thing in the mysql installation? Where
After having search in all the doc i see that I have a mysql 4.01 version
...
It was so simple a mysqld restart and all was ok.
Surely mysql have fil descriptor in memorry.
Aie aie aie.
a+.
_
Do You Yahoo!?
Get your free @yahoo.com
What I did was beat my brains out on the same exact problem. In the end I
have no clue what I did to get it actually working. I had re-installed the
mysql from the .tar.gz, I installed all the RPM's several times. Everytime,
I fully rebooted the system, and finally I have to run
safe_mysqld
If mysql.sock doesn't exist, that is because the server is not running.
I fought the same battle as Mark and ultimately downloaded and installed the RPM for
3.23.49a from MySQL in place of
the copy that came with RH. The MySQL RPM installed and came up just like it says in
the book. Saves a
oracle can...but saying that xml is better than sql ... well just opinioins
On Sat, 9 Mar 2002, James Cox wrote:
Date: Sat, 9 Mar 2002 18:35:10 -
From: James Cox [EMAIL PROTECTED]
To: [EMAIL PROTECTED], Jeremy Zawodny [EMAIL PROTECTED]
Cc: Javier Gonzalo Gloria Medina [EMAIL PROTECTED]
XML has one propouse and SQL does have another one, you can integrate
both techs in a soluition depending on the plataform used of course,
what rob says is just right.
On Sat, 9 Mar 2002, Rob wrote:
Date: Sat, 9 Mar 2002 18:40:03 +
From: Rob [EMAIL PROTECTED]
To: Javier Gonzalo
Ok, if never run it then you have to start once, if I remember right undex
Red Hat, you have to go to /etc/rc.d/init.d and do this...
./mysql start that will start it
Then you will need to set it up so it will start later. SuSE you have to
start it once
You will then need to set a password
I found - once again- strange behaviour on some MySQL functions, i.e. with
EXPLAIN command.
I give one very simple query : explain update mytable set field1 =
round(field1,2) where field10
and it shows me an error!
But when I execute it without 'explain', it updates the fields correctly.
Why?
Hey Guys,
I'm trying to get a form to submit to a mysql script and pull different
variables when you select different values from the form, but I can't get it
to work, can someone help me? Here's my code so far:
?php
if ($submit)
// process form
$namequery = mysql_query( SELECT * FROM
Hi Alex,
Try the following:
if ($submit) {
/* process form */
if($namequery = mysql_query(SELECT * FROM rahs WHERE name='$name') {
while($set=mysql_fetch_array($namequery)) {
printf ( Name: %sbr,$set[playername]);
printf ($stat: %s,$set[$stat]);
}
} else {
I am doing a similar thing except I don't want to use a button I want
once you select for it to auto refresh and grab the data, is this
possible.
Kacey!
-Original Message-
Subject: Re: Help with selects
Hi Alex,
Try the following:
if ($submit) {
/* process form */
Even though I don't know how to fix my problem, I know yours is possible
because its just a different form type not any different in the code I'm
using. I hope this helps.
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL
Kacey,
I used this, works great!
http://www.netmechanic.com/news/vol3/javascript_no12.htm
-Original Message-
From: Kacey A. Murphy [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 10, 2002 1:43 PM
To: [EMAIL PROTECTED]
Subject: RE: Help with selects
I am doing a similar thing except I
On Sun, Mar 10, 2002 at 09:59:09AM +0200, Toomas Vendelin wrote:
It doesn't look same way :(. Normally I've read data from a file
on a client's machine using Perl's read function like this
while(read($file, $data, 1024))
{
print TO $data;
}
to write it from $file on client's
Hello
There is a problem with the myslq_read_default_group function!
It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very
latest Debian unstable (I'm the mysql maintainer of Debian).
bye,
-christian-
There is no section ch in /etc/mysql/my.cnf and no ~ch/.my.cnf. The same
I am probably wrong, but my assumption was that EXPLAIN was used to help
optimize SELECT statements, not INSERT/UPDATE statements.
So if I am thinking correctly (this time :-), EXPALAIN is erroring for you
because it only deals with SELECT statements.
Cary
At 12:10 PM 3/9/02, savaidis wrote:
Hi ppl,
I have an application that used to run on ODBC to MS Access, but the
application started slowing down after a period of time. Some of my
friends suggested that it maybe due to the database. Which is why i am
switching to mySQL.
Can Anyone please provide me with the sample codes to
Thanks for the help. I got it working. I could connect to mysql from shell
command. Now I try to connect to mysql using perl. I installed the DBI::DBD
module for perl. I think the DBI::DBD also working since I don't see error
return running the following code:
#!/usr/bin/perl
use DBI;
damn anti-spam: sql sql sql sql sql query query query
Hi I have the same database twice.. I know that I can use replication to let
them copy it in one way... but I would like 2 way replication so you can add
records in both databases...
The databases do not alway have a connection... and
Sorry I don't know perl. I am PHP man. And I am stll trying to learng mysql
so that I can get it working to the way I want.
Chuck Payne
Magi Design and Support
on 3/10/02 7:30 PM, Andy Cheng at [EMAIL PROTECTED] wrote:
Thanks for the help. I got it working. I could connect to mysql from
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP.
So can someone please so me the how.
| Chuck Payne |
| Magi Design and Support |
|
Hi,
How do I configure mysql so that it will accept remote connections because I
get the error message Host 192.168.1.253 is not allowed to connect to this
MySQL Server
Can someone help me with this.
Delz
-
Before posting,
Hello,
I am trying to install and run MySQL on Win XP, the latest release
being: MySQL 3.23.49, Windows 95/98/NT/2000/XP (12M), from
http://www.mysql.com/downloads/mysql-3.23.html. My problem is simply that I
cannot use it after installation! I go into the command prompt, cd
mysql\bin, type
I don't think you need to know DBD::mysql (DBD::mysql is a DBD driver to
mysql). Go and have a look at the man page of DBI. You'll get what you
need.
Andy Cheng wrote:
Thanks for the help. I got it working. I could connect to mysql from shell
command. Now I try to connect to mysql using
Your problem is probably due to not having a grant entrry in the user table
that allows your user name to log in from 192.168.1.253.
Try GRANTing either that IP, or all IP's (%) access with that user name.
This link should help you out.
http://www.mysql.com/doc/G/R/GRANT.html
Cary
At
At 08:24 PM 3/10/02, Chuck \PUP\ Payne wrote:
Hi,
I not a newie but I am not a pro at mysql either. I want to do a query by
letter(a, b, c..ect.). Is there a simple way to do it. I am writing in PHP.
So can someone please so me the how.
I'm not totally sure what your looking for. If you could
I want to sort my a letter in a set colomn. Let say I want to sort the
colomn last_name
http://www.myserver.com/mysort.php?Letter=A
Like to create a link like A then sort only the last name ore what ever I
want to sort by that letter.
I hope that's helps. I can order by, but I can't so a sort
I want to sort by a letter in a colomn. Let say I want to sort the colomn
last_name. I can do order by but I can do just the A's.
http://www.myserver.com/mysort.php?Letter=A
Like to create a link on a web A then sort only the last name are A.
I hope that's helps. I can order by, but I can't
Chuck Pup Payne wrote:
I want to sort by a letter in a colomn. Let say I want to sort the colomn
last_name. I can do order by but I can do just the A's.
http://www.myserver.com/mysort.php?Letter=A
Like to create a link on a web A then sort only the last name are A.
I hope that's
Matt Wagner explained:
However, loading an XML file into your MySQL server (via the C API)
would be a more difficult and tricky task. DTDs would have to be
defined, some software would have to manage these DTDs so that the data
in the XML file could be correctly mapped into your database
You should specify the machine address after @ something like 'localhost' or
specify particular IP / name. I might do this.
grant all on db.bsd
to shadowgrl@localhost
identified by testing123
with grant option;
When you connect remotely, you need to specify host name.
NOBBY
- Original
G'Day ppl,
I am just wondering if the latest stable build of MySQL has support
for Unicode character set so I can use it to store english, chinese and
korean characters. If so please let me know. And also if there is going
to be any problems to perform SELECT statements to search for a
I would think the easiest way would be to use the string functions of MySQL
itself...then you don't have the overhead of the PHP application having to
check each row of data (a wise person on this board once answered a question
similar to this for me).
Somthing like...
$query = SELECT * FROM
hey, i'm running mysql 3.23.49 on winXP pro without any problem. You sure
you have installed and started the service?
- Original Message -
From: Paul Wallace [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 7:18 PM
Subject: MySQL on XP
Hello,
I am trying to
You haven't given anyone any specifics... nor a link to a phps, so I
cannot be any more specific with my advice
You could probably get away with looking through each of the elements in
the array and using something like
if ( substr($element, 0, 1) == $letter ( {
Hello,
We are using MySQL as the database for our software product .
We have downloaded the MYSql Setup program from the site for our testing .
Now we want to distribute the demo copies of our software product .
Can I also put the downloaded setup of MySql on the demo CD of our product
?
Or Do
G'day Daren
$query = SELECT * FROM tbl_name WHERE LEFT(last_name, 1) == '$letter');
NOTE: LEFT() is a special function, I'd consider it a derivative of
SUBSTRING()
Does MySQL have a function that can selectively return words from a column?
What I'm looking for is the equivalent of
Hello,
We are using MySQL as the database for our product . The frontend is in
VC++ .
The environment is as follows :-
1) MYSQL version 3.43.23
2) MySQL ODBC Driver Version 3.51
3) WIN NT Server Version 4.0 SP6
We have observed that if a global connection to the database is kept open
for a long
Prasad,
-Original Message-
From: Prasad Gurav [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 10, 2002 10:37 PM
To: [EMAIL PROTECTED]
Subject: Leaking Handles
Hello,
We are using MySQL as the database for our product . The frontend is in
VC++ .
The environment is as follows :-
Does anyone have an example of a dfb2mysql (contributed software) character conversion
file (-e)?
I need to know which format should be used when specifying the characters (octal, hex,
ascii etc).
Many thanks for any help!
/ Urban A.
48 matches
Mail list logo