On Sun, Nov 09, 2003 at 12:48:42AM -0600, Carl Karsten wrote:
It looks like sql_yacc.y is what is used to define the syntax that
MySql uses.
Yes.
It has been a while sense I took a compiler class, so forgive my
ignorance. is sql_yacc.y used to generate the parser which is then
compiled,
I have a table of full URLs and IPs and am using the following query to return
distinct web requests by domain. Using SUBSTRING_INDEX it only returns the
domain part of the URL:
SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct ip) as count
from tablename WHERE SUBSTRING_INDEX(url,
Yes, the sql_yacc.y is used to generate the sql parser. The
parser is used more to run the sql rather than to break it into its
tokens. Using the lex files would be closer to your stated goals. The
file lex.h in the same directory as sql_yacc.y contains all the tokens
mysql uses to break
installed mysql on gentoo linux.
[EMAIL PROTECTED] etc # mysqladmin version
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
[EMAIL PROTECTED] etc # mysqladmin -p version
Enter password:
mysqladmin Ver 8.40 Distrib
I have a table called TRANSACTION, it has some fields :
REGDATE - date of the transaction
WHAT - a string (NOT UNIQUE)
CUSTOMER - customer code
I want to query all WHAT that the date of the transaction was 15 days before.
So, my sql query is :
SELECT WHAT FROM TRANSACTION WHERE REGDATE Now()
Hi, i got this message after querying the 3255 records table, and the query
is like this:
SELECT a.book_no, a.isbn_a, a.author_a, a.title_a, a.title_b, a.title_c,
a.edition, a.place_publication_a, a.place_publication_b,
a.place_publication_c, a.physical_desc_b, a.physical_desc_c, a.actal_price,
Hi
Using mysql 3.28
I have a table with numerous columns and with a index on the surname
column
In order to give user a choice of searching on an exact name or using
soundex I did the following:
Inserted a new field in the table, SURNAME_SDX char(5)
Populated it from the surname column
Hello!
I have one question. MySQL is better than Oracle or not?
Thank you.
--
___
OperaMail free e-mail - http://www.operamail.com
OperaMail Premium - 28MB, POP3, more! US$29.99/year
Powered by Outblaze
--
MySQL General Mailing List
For list
OK, I'll qualify the statement. Software RAID-5 on my adaptec SCSI
controller and external disk array logs a message aic7xxx_abort returns
0x2003 to /var/log/messages and the whole array shuts down (and
anything else attached to the card, regardless of bus) for minutes at a
time before
Hello,
I've got a table with articles and a table with categories. Using a
'temporary' table it's easy to assign multiple categories to an
article. The insert is no problem, because I can perform two queries,
but for the output I get one row for every every category. But i like
to get one row
Did we already talk about the log flush method you're using with
InnoDB? I don't recall...
Log flush method? As described by Mysql documentation:
insert
If you can afford the loss of some latest committed transactions, you
can set the `my.cnf' parameter |innodb_flush_log_at_trx_commit| to
* John Berman
Using mysql 3.28
There is no such version... you probably have version 3.23.something...?
I have a table with numerous columns and with a index on the surname
column
In order to give user a choice of searching on an exact name or using
soundex I did the following:
Inserted
I am trying to do a select statement where I am using one of the aliases in
the where clause. I keep getting an error that the field does not exist.
example:
Select invno, invdate, invamt, left(invdate,2) as month from salesfile where
month = '01'
MySql keeps telling me that month is not a
* David Katz
I am trying to do a select statement where I am using one of the
aliases in the where clause. I keep getting an error that the field
does not exist.
From the manual: Note that standard SQL doesn't allow you to refer to an
alias in a WHERE clause. This is because when the WHERE
* Andreas Ahlenstorf
I've got a table with articles and a table with categories. Using a
'temporary' table it's easy to assign multiple categories to an
article. The insert is no problem, because I can perform two queries,
but for the output I get one row for every every category. But i like
This may be another silly question
Looking at our dbase I noticed that a number of tables have been added
The all start nuke_
I have no idea who added them, I can only assume my ISP added them, do
they have a purpose, can I remove them etc
Regards
John Berman
--
MySQL General Mailing
these are tables for either postnuke or phpnuke. Both are very nice
content management systems:
http://www.postnuke.com/
http://www.phpnuke.org/
This may be another silly question
Looking at our dbase I noticed that a number of tables have been added
The all start nuke_
I have no idea
From: your mail address
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description:
precise description of the problem (multiple lines)
How-To-Repeat:
code/input/activities to reproduce the problem (multiple lines)
Fix:
Hi
It gives me great pleasure to inform you that Rekall, the cross-platform
alternative to MS Access, is now totally GPL. So please visit http://
www.totalrekall.co.uk get youself a copy. In order for you to be
able to download you must register with the Total Rekall Portal. The reason
we
* Admin-Stress
I have a table called TRANSACTION, it has some fields :
REGDATE - date of the transaction
WHAT - a string (NOT UNIQUE)
CUSTOMER - customer code
I want to query all WHAT that the date of the transaction was 15
days before.
So, my sql query is :
SELECT WHAT FROM
* Gaston Escobar
I need to sincronice two mysql databases that are in different
places. It is imposible to centralice everything in one database.
Then I would need to sincronice the changes made in both of them
one time per day. Is there any way to do this?
* Roger Baklund
This very much
* John Kelly
I have a table of full URLs and IPs and am using the following
query to return
distinct web requests by domain. Using SUBSTRING_INDEX it only returns the
domain part of the URL:
SELECT SUBSTRING_INDEX(url, '/', 3) as topsites, count(distinct
ip) as count
from tablename WHERE
Hi
It gives me great pleasure to inform you that Rekall, the cross-platform
alternative to MS Access, is now totally GPL. So please visit
http://www.totalrekall.co.uk and download download a copy for yourself. In
order for you to be able to download you must register with the Total Rekall
Portal.
Hello all,
We recently upgraded to 4.0, it went
very well and the performance gains have been great.
But now the server has started to act strangely. Every few days, the
server starts to refuse connections, saying
that there is already more than max_user_connections, but there is really
only one
* Andreas
[...]
On the other hand one could use intervals for key assignment.
Every time a server runs out of keys it throws a warning at the admin
and rejects further inserts until it gets a new key interval.
It's a way to go at least with a low number of servers.
Maybe even give a warning
Hi Jeremy,
Sorry, it seems like I'm saying this a lot lately. Is it not true that
if the whole table will fit in [free] RAM, that the OS will cache the
file data and there is no need for a RAM disk. I don't really see how
performance would be any different than using a RAM disk. Either way,
you
* Roger
Maybe even give a warning some time _before_ you run out of keys...? ;)
You should never run out of keys. Every time you sync, you also check if
there are many keys left to use... if you sync once a day, as soon as you
have less than 10 times the expected daily usage of keys left to use,
On Sun, Nov 09, 2003 at 12:13:34PM +, george atef wrote:
Hi, i got this message after querying the 3255 records table, and the query
is like this:
SELECT a.book_no, a.isbn_a, a.author_a, a.title_a, a.title_b, a.title_c,
a.edition, a.place_publication_a, a.place_publication_b,
I am hoping someone here might have an idea how to set up a complex query I
have been trying to figure out.
Basically I have a table that contains 3 types of records. Property
managers, buildings and tenants. They are related upon insert by an ID and a
PID (parent id). For example :
ID PID
have you try left join?
select
mgr.company,
building.bldgname,
tenant.id
from
customers mgr
left join customers building on building.pid=mgr.id
left join costumers tenant on tenant.pid=building.id
group by mgr.id, building.id, tenant.id
order by mgr.company, building.bldgname, tenant.company
Hello, mysql,
I want to monitor the replication of slave.
chk.sql
content:
show slave status
$mysql -uroot -p chk.sql result
But nothing happend.
I want to know,how can I monitor the slave mysql.
Any idea appreciated.
Best regards.
MaFai
[EMAIL PROTECTED]
31 matches
Mail list logo