Hi all,
I'm having an issue using regular expressions, and I was hoping someone
can see the syntax error that I'm missing (Monday morning, not enough
coffee, etc). Running the following query returns the error:
SELECT `a.custid`,`a.login` FROM ol.customers a WHERE `a.login` NOT_REGEXP
-Original Message-
From: Rik Wasmus [mailto:r...@grib.nl]
Sent: Monday, October 01, 2012 10:44 AM
To: mysql@lists.mysql.com
Subject: Re: NOT_REGEXP Query Help
I'm having an issue using regular expressions, and I was hoping
someone can see the syntax error that I'm missing
Hi all,
Lets say I have a table with two colums: 'orderid' and 'productid'. This
table contains line items for purchases in a store where a purchase could
be 1 or more line items (1 or more rows). A typical order may look like
this:
orderid | productid
12345 | 9876
12345 | 6789
12345 |
Hi,
I'm hoping what I'm trying to do can be done, but I can't seem to find
the right syntax. I have the following query:
SELECT
a.productid,
a.productcode,
a.product,
if(
you for the reply. Unfortunately, not all of the rows I'm
selecting in the main clause will have an entry in the other table, so
if I do it that way, it won't return any data for the rows that don't
have a match in the order_details table.
On 7/8/2010 9:59 AM, John Nichel wrote to:
Hi
I have a query that is giving me fits, but I can't find where there
error is. I know its one of those things that I'll slap myself in the
forehead for not seeing, but after a half an hour, it's all a blur. ;)
If someone can spot it, I'd be most grateful.
REPLACE INTO product_dimensions SET
Please forgive my ignorance. Going from update to replace and left the
'where' part of the statement. Definitely a DOH! moment.
--
John C. Nichel IV
System Administrator
KegWorks
http://www.kegworks.com
716.362.9212 x16
j...@kegworks.com
-Original Message-
From: John Nichel
Hi,
The function is probably behaving as intended, but its confusing the
hell out of me. ;) Anyway, say I have two tables; orders and lineitems
Orders has two columns: orderid(primary key) and ordertotal
Lineitems has two columns: orderid and itemid
For every orderid in the orders table,
Lopez, Denise wrote:
I am sorry if I was vague. I know my version of PHP supports .png
images. My developers are having issues with extracting .png images
files from a mysql database that's why I wanted to make sure it wasn't a
support issue with mysql. They can upload the files into the
Octavian Rasnita wrote:
Hi,
Sometimes I see that some tables from my database get corrupted. Why
does this happpen and how can I avoid it?
It is not hard to go and use repair table but it seems that in this
way some records could be deleted and this is not ok.
If I want to have a very secure
Hi list,
I'm messing around with weighting my search results, and I've run
into a weird quirk that I'm hoping someone here could help me
understand. I have a query like such:
SELECT
xcart_products.product,
xcart_product_meta.synonyms_misspellings,
MATCH
Hi,
I have two tables:
orders -
orderid int(11) [UNIQUE]
total decimal(12,2)
source varchar(64)
[...]
order_details -
orderid int(11)
amount int(11)
[...]
The 'orders' table holds basic information about the order (customer,
sales tax, etc.) and the 'order_details' table holds products
bruce wrote:
hi...
i'm looking at what is probably a basic question.
i have a tbl with
-id
-action
-status
-date
ie:
id action statusdate
1 0 1
1 1 2
1 2 3
-
2
Hi,
I am having a bit of trouble with a SQL query that I am hoping
someone here can give me pointers on, or a nudge in the direction of a
place which can give me a better understanding of JOINS.
Running MySQL v4.0.27 Max on a RHEL4 box. I have three tables which
look like this...
Table
Running MySQL 4.0.20 on a RHEL3 box.
Hi,
I'm trying to find the data in a table which is common to two or more
ids. Let's say my table looks like this...
---
| col1 | col2 |
---
| a | 1 |
| a | 2 |
| a | 3 |
| b | 4 |
| b | 2 |
| b
to 'a', 'b', and 'd'.
I could just query each col1 that I need, and compare the results in my
app, but I hope it can be done in just one query.
John Nichel wrote:
Running MySQL 4.0.20 on a RHEL3 box.
Hi,
I'm trying to find the data in a table which is common to two or
more ids. Let's say my
|
+--+
2 rows in set (0.00 sec)
Dan
Thanks Dan, that's what I'm looking for
John Nichel wrote:
Running MySQL 4.0.20 on a RHEL3 box.
Hi,
I'm trying to find the data in a table which is common to two or
more ids. Let's say my table looks like this...
---
| col1 | col2
Hi, I have this query below, and I have been pulling my hair out for the
past couple of hours trying to get it to do what I want. As is, it
works, but I need it to consider other conditions. One of the columns
in the products table is called groupid. I need it to pull all products
with a
Hi all,
I have a table which contains amoung other things, search terms used on
our web site. What I'm trying to do is select the count of distinct
search terms in one query. I think this is possible, but I can't seem
to get the syntax quite right. I've tried things like the following
[EMAIL PROTECTED] wrote:
snip
Try something that looks like:
SELECT searchTerms, Count(1) as frequency
FROM your_table_name_here
GROUP by searchTerms
ORDER BY frequency DESC
LIMIT 10;
That will give you the 10 most frequently appearing searchTerms in the
table your_table_name_here. The GROUP BY
Jay Blanchard wrote:
snip
This is probably a better question for a PHP list.
Do you know of one? ;)
If you're running a rpm based distro (RedHat, Fedora, etc.), and you
have php installed by rpm, you should just need to install the php-mysql
rpm, and restart Apache.
--
John C. Nichel
ÜberGeek
nestor(earth) wrote:
People,
This more of a php mysql question. I have installed PHP ( 5.01) with
Apache(1.31) and it runs.
I have install Mysql (the latest as of last night) and it runs. My
problem is that PHP does not see
Mysql. Now I have done this installation 4 or 5 times but th elast
Hi, I'm trying to select data from a couple of tables with the same
query. Easy right? Well it's driving me crazy. I'm passing an integer
via an html form, using php to grab it, and insert it into the query
(albumSongs.albumID = 1), to where I want to grab all the data from the
first table
Hi list,
I'm currently in the middle of planning a server migration and am
trying to figure out how I am going to keep the databases in sync. The
problem lies in DNS. When I make the DNS change to switch our site from
one host to another, it's not automatic. For a period of a few days,
Hi,
I have a table which I want to select data from (obiviously). In
this table, I have a field which is an integer, and defaults to 0. What
I would like to do is count all rows in that table which not only equals
0 for the field, but has a distinct value which is greater than 0.
id
Rich Allen wrote:
iH
this should work
test select * from xt;
++---+
| id | field |
++---+
| 1 | 0 |
| 2 | 0 |
| 3 | 7 |
| 4 | 8 |
| 5 | 7 |
| 6 | 0 |
| 7 | 6 |
| 8 | 7 |
| 9 | 8 |
++---+
9 rows in set (0.00 sec)
test select
Zsombor Papp wrote:
Hi,
I would like to have MySQL 4.0.17, Apache, and PHP
with access to MySQL, all this on a Linux server. So
far I have RedHat 8.0 and MySQL 4.0.17 installed. I
would like to know if there are any Apache and PHP RPM
packages that I could install on top of this. I did
try
Zsombor Papp wrote:
I did try to install php-mysql-4.3.4-1 (I just noticed
that I mistyped the PHP version numbers below, I tried
4.2.x and 4.3.4-1), and everything else the RPM
dependency checks were complaining about. I gave up
when it looked like I would have to install two
conflicting
Louis van der Merwe wrote:
Hi,
Can someone please tell me how to set up a linux mysql server to accept
connections from remote machines.
I have tried creating users for all of the remote host, and creating
users with host '%' and '*', everytime I try to connect using myodbc or
mysqlcc, I get the
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different location and which file
Paul DuBois wrote:
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't start anymore.
Is there a way to install my.cnf in a different
Paul DuBois wrote:
At 14:37 -0600 11/24/03, John Nichel wrote:
Paul DuBois wrote:
Paul DuBois wrote:
At 14:17 -0500 11/24/03, Arnoldus Th.J. Koeleman wrote:
I like to install the my.cnf in another directory and not the default
/etc/my.cnf
When I move this file to another directory it can't
S Kusumo wrote:
Hello ..
I'm a CLIPPER programmer. I'm looking for programming language (like Clipper) for MySql, that supports constructs such as LOOP, If-then-Else etc.
Appreciate someone who could respond..
S Kusumo
[EMAIL PROTECTED]
I'm not familiar with CLIPPER. Is it a scripting
Braulio Lumbreras wrote:
What is the best way to learn php and mysql? What book is recommended for
self study of both ?
Braulio
The PHP website is an excelent place. The online manual is real nice,
and there are plenty of user comments which I have found useful. The
PHP mailing list is a
Claes Wiberg wrote:
Hi,
I need to a find a way to migrate a progress 4gl application from progress own
database enterprisedb to mysql. The thing is that progress 4gl doesn´t really speak
sql. Has anyone found a solution to this dilemma? Some sort of odbc-driver that can do
the trick?
brgds
Is
Mario Miyojim wrote:
I am trying to revive an existing LAMP system.
I recently installed RedHat9. I had several LAMP
applications
working under RedHat 7.1, but now they don't function
properly. For instance, I have many scripts that use
the
FORM ACTION=?php print($PHP_SELF) METHOD=post
Rob Wierenga wrote:
Thanks for the new MySQL server.
My MySQLcc works fine now.
But..
My PHP cann't connect anymore to the server.
The lib is not there i think. Because i get an error mysql_connect() doesnot exist.
What to do ??
snip
If php gives you the error that mysql_connect is a call to
bluejack wrote:
On Tue, 28 Oct 2003 14:13:45 +, Raiko Gonzales [EMAIL PROTECTED]
wrote:
perhaps this questions is not directly MySql related but MySql is very
related with my question. I'm learning Paul Dubois MySql and Perl for
the web and I have a lot of problems make working the
Martin Gainty wrote:
There are about 1000 people on this list that can put a web front end for
you
Something to think about..
-Martin Gainty
Who am I missing? I only counted 997.
--
By-Tor.com
It's all about the Rush
http://www.by-tor.com
--
MySQL General Mailing List
For list archives:
Dora wrote:
I m open to suggestions. I use HTML and JavaScript regularly. If I
have some sample code I could hack it do what I need. My website is on
a UNIX CGI plant form.
What are your thoughts?
Thanks
PHP... http://www.php.net
And if PHP isn't doable, Perl.
--
By-Tor.com
It's all about
I assume you're not installing from source, so do a
rpm -qa | grep php*
You should see php-4.x.x-x
and to use MySQL with php, you should see...
php-mysql4.x.x-x
gamalt tant wrote:
how do i check that my redhat8.0 contains php? is
there some command inform me if php is included?
Oliver Etzel - GoodnGo.COM (R) wrote:
Hello all,
after Installing mysql I started the mysql daemon.. The I tried to log
in to my mysql database and got the message could not find mysql.sock
in /tmp.
In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0)
I
changed the place for the
Kevin H. Phillips wrote:
Well, the find / -name mysql.sock didn't return anything at all so this
*is* an odd predicament. Would it work if someone with a similar
version e-mailed me a copy of their mysql.sock file?
Kevin
John Nichel wrote:
It doesn't look as if you have any conflicting
A mysqld process already exists at Tue Jun 24 16:37:12 CDT 2003
Was one of my installation attempts perhaps not removed cleanly?
Kevin
John Nichel wrote:
Did you install by RPM? If so, look in /var/lib/mysql
The file will be you machine name dot err, eg...
localhost.err
Possibly. Try
Kevin H. Phillips wrote:
Yes, the server is running. One odd thing about my setup is that when I
restart the service I get a Failed signal for the shutdown phase but
an OK for the start phase.
Thanks,
Kevin
Victor Pendleton wrote:
Is the mysql server currently running? You can also use either
Kevin H. Phillips wrote:
The output of the grep is:
[EMAIL PROTECTED] root]# ps -ax | grep mysqld
4578 ?S 0:00 /bin/sh /usr/bin/mysqld_safe
--defaults-file=/etc/my.cnf
4601 ?S 0:01 /usr/libexec/mysqld
--defaults-file=/etc/my.cnf --basedir=/usr
Kevin H. Phillips wrote:
I changed the port in /etc/my.cnf and restarted the service but still
get a message that I can't connect to the server, etc.
I am still not seeing any fresh log messages. Why would there not be
any output on that? Is there someplace I should look for a log file
azamka wrote:
I installed mysql manually on red hat 9. It worked fine couple days but from
yesterday i am getting a weird error when i tried to run the mysql. the
error
statement is Error 2002: Can't connect to local MySql server through
socket
'/tmp/mysql.sock'(2).
I am new user of Linux and I
JeRRy wrote:
Hi,
I want to run my php scripts, mysql from home. Now
after being pointed to download apache for Windows as
well as mysql for windows I have installed them both.
Apache loads fine on localhost as I have tested it.
But I can't get my php pages to load correctly via
apache. It
John Utting wrote:
Hi,
I have installed MySQL v4.0.13 on a Win2K machine. the installation
directory is C:\mysql
I've installed it as a service using 'mysqld-nt -install' and the service is
running.
I've checked to se that it is working using 'mysqlshow', 'mysqlshow mysql'
'mysqladmin version
Peter Burden wrote:
Subscriptions wrote:
The httpd.conf connects PHP to Apache. What connects PHP to MySQL?
I've looked through google and I can't find anything that makes since
to me.
Can someone point me in a direction as to where I can find this out?
The problem I'm having is I have PHP
John Chang wrote:
I changes the password but it still doesn't work. This is the error I
get when I try to connect to MySQL using phpmyadmin using a browser.
What do I need to change? Thanks.
Error
MySQL said:
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
At 11:37 PM
52 matches
Mail list logo