Parentheses regexp
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 |
+-+---+
| The Isley Brothers Band | Tell Me It's Just A Rumour (inst) |
+-+---+
1 row in set (0.07 sec)
When I try to actually search on the existance of a parentheses I get an
error, thus:
mysql select Artist, Track from tracks where Track regexp 'Rumour (';
ERROR 1139: Got error 'parentheses not balanced' from regexp
mysql select Artist, Track from tracks where Track regexp 'Rumour \(';
ERROR 1139: Got error 'parentheses not balanced' from regexp
Anyone know how I can 'escape' the parentheses?
-aToM
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Parentheses regexp
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 includes parentheses, for example:
mysql select Artist, Track from tracks where Artist regexp 'Isley Brothers Band';
a +-+---+
a | Artist | Track |
a +-+---+
a | The Isley Brothers Band | Tell Me It's Just A Rumour (inst) |
a +-+---+
a 1 row in set (0.07 sec)
a When I try to actually search on the existance of a parentheses I get an
a error, thus:
mysql select Artist, Track from tracks where Track regexp 'Rumour (';
a ERROR 1139: Got error 'parentheses not balanced' from regexp
mysql select Artist, Track from tracks where Track regexp 'Rumour \(';
a ERROR 1139: Got error 'parentheses not balanced' from regexp
a Anyone know how I can 'escape' the parentheses?
a -aToM
a -
a Before posting, please check:
ahttp://www.mysql.com/manual.php (the manual)
ahttp://lists.mysql.com/ (the list archive)
a To request this thread, e-mail [EMAIL PROTECTED]
a To unsubscribe, e-mail [EMAIL PROTECTED]
a Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Best regards,
Toomasmailto:[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Text fields with \ characters and querying
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 the term field
In the manual I read this is of the fact that the \ is used as an escape
sign.
It says one can solve the problem with replacing \ with \\.
My question is how to solve this in the query, because I don't want to
change the values in the term field.
Something like
select replace(term, '\','\\') from term where term=replace('$term$','\','\\
)
I can't get it working.
Does anybody know how to solve this problem.
Niek van Baalen
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help, any convert(legacy) function? in mysql?
* 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 = -6, p = -7, q = -8, and r = -9. example numbers: I have 1500 numbers that look like this! the rest are normal integers. Any help would /really/ be appreciated. TIA. 000125] 20] 25] As ] is -0, these numbers should be -1250, -200 and -250... right? What is the problem? -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb monitor
Warning Unable to process data: multipart/mixed; boundary=--==_846811060==_
RE: Help, any convert(legacy) function? in mysql?
* 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... :) special character: ] = -0, j = -1, k = -2, l = -3, m = -4, n = -5, o = -6, p = -7, q = -8, and r = -9. I think 250k is -2502. The letter (or ] symbol) represent the last digit, and the result is multiplied by -1. -- Roger query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help, any convert(legacy) function? in mysql?
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 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 = -6, p = -7, q = -8, and r = -9. example numbers: I have 1500 numbers that look like this! the rest are normal integers. Any help would /really/ be appreciated. TIA. 000125] 20] 25] As ] is -0, these numbers should be -1250, -200 and -250... right? What is the problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from windows to linux
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 the other under linux mandrake. I have near 50 database or more, the copy of the datadir is the best solution. As i tell I can select ... Butr no inserting ! see my Error: 1036 - Table country is read. If you have a cool solution my 2 mysqld (zindows and linux) are on the same lan ! Thanks. You should use mysqldump[.exe] to export/import, on the respective systems: 4.8.5 mysqldump, Dumping Table Structure and Data http://www.mysql.com/doc/m/y/mysqldump.html C:1 Hi all, I developp a site with some mysql table which are files myd myi n frm under windows x86 arch. I copy my table into a liinux box x86 arch too. Bu when trying to modidy tables I get an Error: 1036 - Table country is read only I manage the rigth of new created tables. I get things like that that I report to my read only tables : 12 -rw-rw1 mysqlmysql8674 jui 15 2001 country.frm 24 -rw-rw1 mysqlmysql 20516 jui 15 2001 country.MYD 4 -rw-rw1 mysqlmysql1024 jui 15 2001 country.MYI 12 -rw-rw1 mysqlmysql8564 mar 9 23:18 TableName.frm 0 -rw-rw1 mysqlmysql 0 mar 9 23:18 TableName.MYD 4 -rw-rw1 mysqlmysql1024 mar 9 23:18 TableName.MYI I make a chown -R mysql.mysql * n chmod 660 * Nothing change. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql installation. Help!
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 could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql from windows to linux - I found
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 address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
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 --user=root I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: Andy Cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! 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 could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
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 lot of hair and dain bramage. If the server process _is_ running, it may be useful to go through the section on binary installation and check those items to see if your RPM set everything up correctly. Don't bet on finding anything, but it doesn't take long to do these checks. http://www.mysql.com/doc/I/n/Installing_binary.html Regards, Doug Perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away. -- Antoine de Saint Exupry On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: 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 --user=root I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: Andy Cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! 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 could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: xml
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] Subject: RE: xml Well, I assume the server can do it too - - i haven't checked the C api lately on that. James -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 09, 2002 5:52 PM To: James Cox Cc: [EMAIL PROTECTED]; Javier Gonzalo Gloria Medina Subject: Re: xml On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: Anyhow, Mysql can return data in XML. The client can, but not the server, right? -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 30 days, processed 1,024,611,977 queries (393/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: xml
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 Gloria Medina [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: xml Frankly, it sounds like this guy understands neither XML nor relational databases. XML is a general-purpose structured data format. The term relational database also connotes a way of storing data, but is usually used to refer more to the way the data is organized and efficient ways for accessing, transforming, and re-organizing that data. SQL, the standard interface to relational databases, is (and let's not debate the subtleties of this statement) a programming language for working with structured data. One aspect of SQL is that you can use it as a format for storing data in files, and in this respect I totally agree with your friend: XML is a better choice in the vast majority of cases. SQL is not designed for this purpose: it's like passing text around by storing it in string constants in C language header files. In fact, we largely have the SQL crowd to thank for XML- it was designed largely as a platform-independent way for databases to exchange data files with one another because there are a lot of problems with using SQL for this. As a result, it is *very* easy to write a bridge for just about any relational database which returns result sets as XML files instead of the traditional row/column format. Many (or most) databases support this out of the box. Further, because XML is a format for storing structured data and databases (both relational and object-oriented) are focused on the storage and manipulation of data, you can write an interface that looks like a database as a method of accessing data in XML files. There are several systems and standards available for doing this to XML. Of course, while storing data in XML is very portable and readable, it is orders of magnitude less efficient in terms of both storage space and access time when compared with the internal formats of true database systems, so patching database interfaces onto XML files is a convenience, not a replacement for databases. If you really cared about efficiency, you'd just load the XML data into a database like mySQL and then access it in the database instead of emulating database functionality on the XML file itself. Finally, in addition to offering a structured data format, XML offers a unified syntax and approach to designing text-based cross-platform standards. Over the years a lot of text-based standards have been developed and it is from their mistakes in terms of awkward or non-standard syntax, portability, and industry adoption that XML has learned. As a result, many of these aging standards are being replaced with variants which are based on the XML syntax. SQL is no exception. Several query-processing XML languages are being developed and deployed, often designed as means of accessing other XML data-sources, but with possible long-term goals of replacing legacy data processing languages like SQL. Regardless of what comes of these languages, they fundamentally affect only the way you access data in a database; they do not change the nature of relational databases. As these languages gain acceptance, I see no substantial barrier to new query interfaces being added to mySQL- whether they come from the mySQL dev team or from other groups who simply write bridge code. And anyone who tells you that any use of joins suggests poor database design clearly doesn't know *anything* about relational database design. On 9/3/02 at 9:21 am, Javier Gonzalo Gloria Medina [EMAIL PROTECTED] wrote: hi everybody: i was talking with a developer and he told the next thing: if you have a database and you need to do joins to make your quaries between tables... your database and tables are not full functional, your tables were created under a bad configuration then he says. the best databases are made with xml, old databases like mysql, oracle and all the others, will not be functionall thanks XML standar. Well, now I¥m cofused. Some one can help me with this is that true, is XML the next generation of creating databases and tables for beast results. THANKs JAVIER GLORIA developer __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble
Re: Mysql installation. Help!
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 for mysql. I hope that helps. | Chuck Payne | | Magi Design and Support | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Fortune for today -- Q: How many Zen masters does it take to screw in a light bulb? A: None. The Universe spins the bulb, and the Zen master stays out of the way. 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 lot of hair and dain bramage. If the server process _is_ running, it may be useful to go through the section on binary installation and check those items to see if your RPM set everything up correctly. Don't bet on finding anything, but it doesn't take long to do these checks. http://www.mysql.com/doc/I/n/Installing_binary.html Regards, Doug Perfection is finally attained not when there is no longer anything to add, but when there is no longer anything to take away. -- Antoine de Saint Exup?ry On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote: 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 --user=root I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: Andy Cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! 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 could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what's wrong with EXPLAIN?
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? (field1 is a real of cource and I tried where field10.0 too with the same error) If I'm not shure 'explain' is working correctly, then how I will trust to use it? To show me errors where they doesn't exist? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help with selects
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 rahs AS playername WHERE (name =
'$name'));
$stats = mysql_query( SELECT $stat FROM rahs AS playerstat WHERE (name =
'$name'));
while($set=mysql_fetch_array($namequery)){
printf ( Name: %sbr,$set[playername]);
}
while($stats2=mysql_fetch_array($stats)):
printf ($stat: %s,$stats2[playerstat]);
endwhile;
} else {
I know this code is only part of it, but its the only part that needs work. I have a
working model here: http://www.3d-unlimited.com/rahslax/test6.php
Can someone help me get it to work?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with selects
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 {
print Failed Query Error message here;
}
} else {
/* other code here */
}
Alex Behrens wrote:
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 rahs AS playername WHERE (name =
'$name'));
$stats = mysql_query( SELECT $stat FROM rahs AS playerstat WHERE (name =
'$name'));
while($set=mysql_fetch_array($namequery)){
printf ( Name: %sbr,$set[playername]);
}
while($stats2=mysql_fetch_array($stats)):
printf ($stat: %s,$stats2[playerstat]);
endwhile;
} else {
I know this code is only part of it, but its the only part that needs work. I have a
working model here: http://www.3d-unlimited.com/rahslax/test6.php
Can someone help me get it to work?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with selects
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 */
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 {
print Failed Query Error message here;
}
} else {
/* other code here */
}
Alex Behrens wrote:
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 rahs AS playername WHERE
(name =
'$name'));
$stats = mysql_query( SELECT $stat FROM rahs AS playerstat WHERE
(name =
'$name'));
while($set=mysql_fetch_array($namequery)){
printf ( Name: %sbr,$set[playername]);
}
while($stats2=mysql_fetch_array($stats)):
printf ($stat: %s,$stats2[playerstat]);
endwhile;
} else {
I know this code is only part of it, but its the only part that needs
work. I have a working model here:
http://www.3d-unlimited.com/rahslax/test6.php
Can someone help me get it to work?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help with selects
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 PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
- Original Message -
From: Kacey A. Murphy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 2:42 PM
Subject: RE: Help with selects
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 */
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 {
print Failed Query Error message here;
}
} else {
/* other code here */
}
Alex Behrens wrote:
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 rahs AS playername WHERE
(name =
'$name'));
$stats = mysql_query( SELECT $stat FROM rahs AS playerstat WHERE
(name =
'$name'));
while($set=mysql_fetch_array($namequery)){
printf ( Name: %sbr,$set[playername]);
}
while($stats2=mysql_fetch_array($stats)):
printf ($stat: %s,$stats2[playerstat]);
endwhile;
} else {
I know this code is only part of it, but its the only part that needs
work. I have a working model here:
http://www.3d-unlimited.com/rahslax/test6.php
Can someone help me get it to work?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help with selects
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 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 */
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 {
print Failed Query Error message here;
}
} else {
/* other code here */
}
Alex Behrens wrote:
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 rahs AS playername WHERE
(name =
'$name'));
$stats = mysql_query( SELECT $stat FROM rahs AS playerstat WHERE
(name =
'$name'));
while($set=mysql_fetch_array($namequery)){
printf ( Name: %sbr,$set[playername]);
}
while($stats2=mysql_fetch_array($stats)):
printf ($stat: %s,$stats2[playerstat]);
endwhile;
} else {
I know this code is only part of it, but its the only part that needs
work. I have a working model here:
http://www.3d-unlimited.com/rahslax/test6.php
Can someone help me get it to work?
Thanks!
-Alex Big Al Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED] (Please be brief!)
Phone: 651-482-8779
Cell: 651-329-4187
Fax: 651-482-1391
ICQ: 3969599
Owner of the 3D-Unlimited Network:
http://www.3d-unlimited.com
Send News:
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to load binary data with Perl DBI?
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 computer to a file associated
with file handle TO.
Now I obviously need to store the data in a variable. Just pushing
$data strings into array and then joining (join('',@array) doesn't
work, because it's not ASCII (file gets corrupted). So, what I do not
understand, is how to open a filehandle to a database field and then
print to it? :).
Start with this:
---snip---
my $data;
open FILE, $filename or die;
{
local($/) = undef;
$data = file;
}
close FILE;
---snip---
Then just create a prepared statement handle with a place holder for
the data and execute it, passing $data along the way. The
Placeholders and Bind Values section of the DBI documentation
explains how to do that.
Jeremy
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 31 days, processed 1,033,853,920 queries (382/sec. avg)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug: segfaults with mysql_read_default_group!
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
problem also occurs in mysqlhotcopy which looks for a section of this name.
$ cat t.pl
#!/usr/bin/perl
use DBI;
$dbh = DBI-connect(dbi:mysql:test:mysql_read_default_group=ch,ch,);
$ ./t.pl
...
open(/etc/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1892, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x40026000
read(3, # You can copy this to one of:\n#..., 4096) = 1892
read(3, , 4096) = 0
close(3)= 0
munmap(0x40026000, 4096)= 0
open(/var/lib/mysql/my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such
file or directory)
open(/home/ch/.my.cnf, O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or
directory)
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: what's wrong with EXPLAIN?
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: 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? (field1 is a real of cource and I tried where field10.0 too with the same error) If I'm not shure 'explain' is working correctly, then how I will trust to use it? To show me errors where they doesn't exist? Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VB Application using myODBC?
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 connection and open the database for mySQL using myODBC?? I have already setup myODBC and tested the data source. It works! :P Please help! Thanks! alvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
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;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{num_of_fields}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect
I don't understand the code. I copy it from a book. I am trying to print out
the records returned from a query. I have a table named client in database
andy. The table has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED], Andy Cheng
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
[EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Mysql installation. Help!
Date: Sun, 10 Mar 2002 14:18:13 -0500
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 for mysql.
I hope that helps.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.
Fortune for today --
Q: How many Zen masters does it take to screw in a light bulb?
A: None. The Universe spins the bulb, and the Zen master stays out
of the way.
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 lot of hair
and dain bramage.
If the server process _is_ running, it may be useful to go through the
section
on binary installation and check those
items to see if your RPM set everything up correctly. Don't bet on
finding
anything, but it doesn't take long to do
these checks.
http://www.mysql.com/doc/I/n/Installing_binary.html
Regards,
Doug
Perfection is finally attained not when there is no longer anything to
add,
but when there is no longer anything to
take away. -- Antoine de Saint Exup?ry
On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
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 --user=root
I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
rebooted the system, then re-ran safe_mysqld --user=root.
Mark
- Original Message -
From: Andy Cheng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 10:01 AM
Subject: Mysql installation. Help!
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 could I find the mysql.sock?
I
install mysql that came with redhat 7.2. Thank for the help.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
-
2 way replication in Mysql???
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 replication must only start when user choose so. Is this possible??? one problem would be to keep the relations ok... can the database handle this? another problem is when two people modify the same record.. two things I though of that could fix this: remember the exact changes, so if one person changes the telephonenumber of record x and another person the streetnaam of that same record x, then merge the changes. And if they modify the same column in the same record, then let one database be superior (possible to choose which one when replication starts? I don't know if my idea's make sense, but I figured that if the database could do all these things it would be possible... if it's not possible I would have to keep a log in the client program...more programming work... grt, Bram - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help
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 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;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{num_of_fields}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect
I don't understand the code. I copy it from a book. I am trying to print out
the records returned from a query. I have a table named client in database
andy. The table has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED], Andy Cheng
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
[EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Mysql installation. Help!
Date: Sun, 10 Mar 2002 14:18:13 -0500
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 for mysql.
I hope that helps.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.
Fortune for today --
Q: How many Zen masters does it take to screw in a light bulb?
A: None. The Universe spins the bulb, and the Zen master stays out
of the way.
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 lot of hair
and dain bramage.
If the server process _is_ running, it may be useful to go through the
section
on binary installation and check those
items to see if your RPM set everything up correctly. Don't bet on
finding
anything, but it doesn't take long to do
these checks.
http://www.mysql.com/doc/I/n/Installing_binary.html
Regards,
Doug
Perfection is finally attained not when there is no longer anything to
add,
but when there is no longer anything to
take away. -- Antoine de Saint Exup?ry
On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
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 --user=root
I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
rebooted the system, then re-ran safe_mysqld --user=root.
Mark
- Original Message -
From: Andy Cheng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 10:01 AM
Subject: Mysql installation. Help!
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 could I find the mysql.sock?
I
install mysql that came with redhat 7.2. Thank for the help.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
A stupid question...
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 | | www.magidesign.com | | [EMAIL PROTECTED] | BeOS, Macintosh 68K, Classic, and OS X, Linux Support. Web Design you can afford. Hartley's Second Law: Never sleep with anyone crazier than yourself. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Remote Connection to Linux MySQL
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, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL on XP
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 mysql and am given a can't connect error. Has anyone had any experience of this / solution? I have it running on Win 2K no problem but need to migrate to XP. Thanks for all input, if not just to quell my cynicism of XP. Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
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 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;
$dbh=DBI-connect('DBI:mysql:andy');
my $query=select * from client;
my $sth=$dbh-prepare($query) or die cann't prepare.$dbh-errstr.\n;
$sth-execute;
my $rows;
while(@row=$sth-fetchrow_array)
{my $i;
for $i (0..($sth-{num_of_fields}-1))
{print [.$row[$i].];}
print(\n);
}
$sth-finish;
$dbh-disconnect
I don't understand the code. I copy it from a book. I am trying to print out
the records returned from a query. I have a table named client in database
andy. The table has 2 records. When I run the above code, I have 2 blank
lines return. Could any one tell me what the problem is? Where could I
find better documentation on DBI::DBD::mysql stuff for beginner? man
DBD::mysql is difficult to understand. Thanks again for the info.
From: Chuck \PUP\ Payne [EMAIL PROTECTED]
To: Doug Thompson [EMAIL PROTECTED], Andy Cheng
[EMAIL PROTECTED], Intrex [EMAIL PROTECTED],
[EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: Mysql installation. Help!
Date: Sun, 10 Mar 2002 14:18:13 -0500
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 for mysql.
I hope that helps.
| Chuck Payne |
| Magi Design and Support |
| www.magidesign.com |
| [EMAIL PROTECTED] |
BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
Web Design you can afford.
Fortune for today --
Q: How many Zen masters does it take to screw in a light bulb?
A: None. The Universe spins the bulb, and the Zen master stays out
of the way.
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 lot of hair
and dain bramage.
If the server process _is_ running, it may be useful to go through the
section
on binary installation and check those
items to see if your RPM set everything up correctly. Don't bet on
finding
anything, but it doesn't take long to do
these checks.
http://www.mysql.com/doc/I/n/Installing_binary.html
Regards,
Doug
Perfection is finally attained not when there is no longer anything to
add,
but when there is no longer anything to
take away. -- Antoine de Saint Exup?ry
On Sun, 10 Mar 2002 10:11:05 -0500, Intrex wrote:
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 --user=root
I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz,
rebooted the system, then re-ran safe_mysqld --user=root.
Mark
- Original Message -
From: Andy Cheng [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 10, 2002 10:01 AM
Subject: Mysql installation. Help!
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 could I find the mysql.sock?
I
install mysql that came with redhat 7.2. Thank for the help.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
Re: Remote Connection to Linux MySQL
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 08:59 PM 3/10/02, delz wrote: 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, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A stupid question...
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 elaborate a little I am sure that one of us could help you out. Cary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: A stupid question...
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 like the example above. Chuck Payne Magi Design and Support on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote: 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 elaborate a little I am sure that one of us could help you out. Cary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: A stupid question...
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 so a sort like the example above. Chuck Payne Magi Design and Support on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote: 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 elaborate a little I am sure that one of us could help you out. Cary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: A stupid question...
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 helps. I can order by, but I can't so a sort like the example above. Chuck Payne Magi Design and Support One of two things to do: When you're inserting the data, figure out the first letter and store that as a separate column (letter perhaps) Second, probably easier to implement in your case with existing data, is to use LIKE. $sql = select * from datatable where last_name like '$letter%'; The % is a wildcard symbol, so if $letter is a then a last name of adams, aames, aston, etc. would all match. I know there's someway to have mysql do a string manipulation to compare just part of a column's data with something, so you could do something similar to a 'substr' in PHP - but it's late and I can't remember off the top of my head. Hope that helps... -- Michael Kimsal http://www.phphelpdesk.com Taking the ? out of ?php 734-480-9961 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
XML Databases (was Re: xml)
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 schema, etc etc. You can't just load any old XML file and expect MySQL to know how to deal with it. There would have to be a DTD (the file that defines the format of your XML file) submitted with the XML file so that things could be interpretted correctly. As an information point, most "XML databases" do require a DTD, although some companies have tools that automatically generate DTDs from documents. A company I used to work for builds a product which stores XML data as a database _without_ DTD. (Yes, this is an expensive product.) If anyone is interested, here's their URL: http://www.mediafusion.co.jp There are some English pages there, as well. I no longer work for them, and they are not connected with my present employer, so please don't ask me questions about it. Joel Rees Alps Giken Kansai Systems Develoment Suita, Osaka - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: adding a user to a 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 Message - From: Michael Sharp [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 6:07 PM Subject: adding a user to a database I'm using MySQL 3.23 on FreeBSD 4.5-STABLE, and I am kinda new to MySQL. I created the database bsd as root. I need a remote user, connecting from any IP and logging in with shadowgrl and giving the password testing123 to have full access to the bsd database only. After making the bsd database, I did this: grant all on db.bsd to shadowgrl@ identified by testing123 with grant option; I know the last option is dangerous, but I trust this user fully, and the server is firewalled to only allow her network in. However, when connecting remotely, shadowgrl is getting error: user has no access to server What am I overlooking? Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unicode support for MySQL
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 particular pattern. Much appreciated. Robin Tay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: A stupid question...
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 tbl_name WHERE LEFT(last_name, 1) == 'A'); Using a variable passed in... $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() -Original Message- From: michael kimsal [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 10, 2002 8:17 PM To: Chuck \ Pup\\ Payne Cc: mysql lists.mysql.com Subject: Re: [PHP] Re: A stupid question... 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 helps. I can order by, but I can't so a sort like the example above. Chuck Payne Magi Design and Support One of two things to do: When you're inserting the data, figure out the first letter and store that as a separate column (letter perhaps) Second, probably easier to implement in your case with existing data, is to use LIKE. $sql = select * from datatable where last_name like '$letter%'; The % is a wildcard symbol, so if $letter is a then a last name of adams, aames, aston, etc. would all match. I know there's someway to have mysql do a string manipulation to compare just part of a column's data with something, so you could do something similar to a 'substr' in PHP - but it's late and I can't remember off the top of my head. Hope that helps... -- Michael Kimsal http://www.phphelpdesk.com Taking the ? out of ?php 734-480-9961 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on XP
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 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 mysql and am given a can't connect error. Has anyone had any experience of this / solution? I have it running on Win 2K no problem but need to migrate to XP. Thanks for all input, if not just to quell my cynicism of XP. Paul. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: A stupid question...
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 ( {
Stuff();
}
at least that's how I would go about it if I wanted a quick fix...
$.002 given ;)
cheers
-Original Message-
From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 10, 2002 7:04 PM
To: Chuck PUP Payne; Cary; mysql lists.mysql.com
Cc: PHP General
Subject: Re: [PHP] Re: A stupid question...
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 so a sort like the
example
above.
Chuck Payne
Magi Design and Support
on 3/10/02 9:42 PM, Cary at [EMAIL PROTECTED] wrote:
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 elaborate a
little
I am sure that one of us could help you out.
Cary
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Distribution of MYSql
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 I have to obtain some license ? Best Regards Prasad Gurav - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: A stupid question...
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 rightwords(text,1) which would return the rightmost word from text. I'm trying to extract the lastname only from a column which holds the full name (the data is coming from another database where the first and last names are combined). Alternatively, is there a way to parse the names during a LOAD? cheers Kim Sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Leaking Handles
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 time the handle count increases . Approximately 24 per hour . The handle count can be seen by using the Task Manager . The application has to work with 2500 simultabeously open tables. Can some one suggest any solution ? Best Regards Prasad Gurav - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Leaking Handles
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 :- 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 time the handle count increases . Approximately 24 per hour . The handle count can be seen by using the Task Manager . The application has to work with 2500 simultabeously open tables. Can some one suggest any solution ? Best Regards Prasad Gurav We fixed this Windows handle leak just couple of days back and fix will be there for 3.51.03. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
dbf2mysql conversion file format?
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. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
