parameterized view ?

Is there such a thing in mySQL ? I could not find anything anywhere. thanks, laszlo

Best way to store these data?

main search would be by zip or state. Thank you Laszlo Antal -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

explain says: no index is used - however it exists....

Hi! I have a table with the following fields: varchar(200) title, varchar(200) link, text content I made an index on the table, named "common", with type fulltext, which contains the title, link, content fields. When i execute the explain on the following select: (SELECT * FROM tdpages wh

Re: why aren't my PRIMARY KEYs being used?

On Oct 29, 2004, at 6:26 AM, [EMAIL PROTECTED] wrote: I think it may be because of your mixed left and right joins. There are several bugs listed that show that the optimizer mishandles certain combinations of left and right joins. SELECT activelayers.id,activelayers.lid,activelayers.rsrcc,

why aren't my PRIMARY KEYs being used?

I've created two temporary tables: CREATE TEMPORARY TABLE `activenodes` ( `id` smallint(6) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `rsrcc` bigint(21) NOT NULL default '0', PRIMARY KEY (`id`) ); CREATE TEMPORARY TABLE `activelayers` ( `id` int(10) unsigned

slow query (JOIN JOIN LEFT JOIN ... HAVING)

When I'm posting a question here I usually post a simplified abstraction. This time I have to post the full problem - and my problem is that my query takes far too long to complete. The query is quite speedy with very small data sets, but it slows down unacceptably with data sets of any decent si

Re: Monkeys and Banannas (UPDATE .. JOIN .. SET .. GROUP)

Quoting [EMAIL PROTECTED]: > Good, you recognize the need to perform two separate aggregates (GROUP > BYs) and compare the separate results... In fact, you may need two temp > tables so that you can (INNER / LEFT) JOIN one to the other. (Yes, I can > think of a query that works without the second

Re: Monkeys and Banannas (UPDATE .. JOIN .. SET .. GROUP)

Quoting [EMAIL PROTECTED]: > > Why would you want to do that? bananacount is something you can > > calculate with a LEFT JOIN and a GROUP BY, so storing it in the DB > > would break normalization. > > This would also the first step in creating your own OLAP cube. For each > statistic, you save yo

Re: Monkeys and Banannas (UPDATE .. JOIN .. SET .. GROUP)

Quoting Michael Stassen <[EMAIL PROTECTED]>: > According to the manual , the > multi-table UPDATE syntax is > >UPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...] > SET col_name1=expr1 [, col_name2=expr2 ...] > [WHERE where_definiti

Monkeys and Banannas (UPDATE .. JOIN .. SET .. GROUP)

I'm trying to create a single UPDATE query to deal with the following problem: == -- I've got two tables: CREATE TABLE `banannas` ( `owner` varchar(15) NOT NULL default '' ); CREATE TABLE `monkeys` ( `name` varchar(15) default

matching people with projects via resources

I'm having difficulty constructing a query. I've got two kinds of information: a table of resources that various people have, and a table of resources that various projects need. === CREATE TABLE `people` ( `name` varchar(11) default NULL, `

Re: client ip address

Quoting [EMAIL PROTECTED]: > You might look at the USER() and CURRENT_USER() functions. > > http://dev.mysql.com/doc/mysql/en/Information_functions.html Aha! I think this is what I was looking for: "the client host from which [I] connected". I'll have to do some in-query string processing to ex

Re: client ip address

Quoting Mazhar Bilen <[EMAIL PROTECTED]>: > Use this variable: > > $REMOTE_ADDR. > > Such that: > > $client_IP = $REMOTE_ADDR; > UPDATE clients SET ipaddr= $client_IP WHERE [EMAIL PROTECTED]; This doesn't appear to work: I don't think the MySQL server recognizes $REMOTE_ADDR as anything meaningfu

client ip address

Is there a variable or function in MySQL which resolves to the connecting client's IP address? I have SQL clients which will be connecting through a NAT firewall. I want to keep a record of IP of the client that connected to it. It would look something like this: UPDATE clients SET ipaddr=INET_

Re: MIN(foo) as bar WHERE bar>50

> What version of MySQL are you running? Version 4.1.x and 5.0.x offer many > more potential solutions than the earlier versions, which don't support > subqueries. Sorry, should have specified. I am using 4.0.20, but I am under no obligation to stick with this version. (I'm developing an applica

MIN(foo) as bar WHERE bar>50

I'm trying to construct a query and running into either a limitation of the SQL language or (more probably) a limitation in my *comprehension* of the SQL language. Here's a simplified version of my data set: === CREATE TABLE people ( name varc

Re: 2 Query with same criteria giving different number of rows

t; Hector > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Laszlo Illyes T

Re: Partnership Required!

ost profitable for both of us because I shall require > your assistance to invest my share in real estate within your country. > > Due to the nature of confidentiality in this Transaction our > communication can only be via email and fax mostly. > > Awaiting your urgent reply

Re: Java related

ld install? > > Thanks, > __ > NZEYIMANA Emery Fabrice > NEFA Computing Services, Inc. > P.O. Box 5078 Kigali > Office Phone: +250-51 11 06 > Office Fax: +250-50 15 19 > Mobile: +250-08517768 > Email: [EMAIL PROTECTED] > http://www.nefacomp.net/

Re: mysql development tools

http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Laszlo Illyes Teaching-assistant Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706 E-mail: [EMAIL PROTECTED] -- MySQL Ge

Re: finding equations intersections

is 8. Is there a way store > equations with one variable in MySQL such that I could compare them > for intersections by plugging in values for the variable? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists

Re: export from Access so MYsql can read it

file, > but it's in a format that mysql won't recognize. I know it just > needs to be formatted on export a little but the macro options > aren't available for the extra formatting. Any help on how to > export to the proper .txt format would be great. > &

RE: web interface...

For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Laszlo Illye

Re: Can records be moved between tables without knowing columns

on/mysql/bychapter/manual_Reference.html#DATET IME > > Thanks for the help; I hope it isn't a trivial question. > I'm new at this; I didn't find anything on moving records in the list > archives. > > Jim Cant > > -- > MySQL General Mailing List > For

Re: UNION syntax (Request for feature)

10 * 20 + 10 * 30 + > 10 * 40 + 10 * 50 + 10 * 60 + 10 * 70 > > Thanks, > __ > NZEYIMANA Emery Fabrice > NEFA Computing Services, Inc. > P.O. Box 5078 Kigali > Office Phone: +250-51 11 06 > Office Fax: +250-50 15 19 > Mobile: +250-08517768

unicode_support

Hi Everybody! I use MySQL with JavaNetBeans. Please tell me, if only the InnoDb support unicode, or MyISAM also supports, and how. best regards Laszlo Illyes Library-informatics Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706

MySql SETUP Problem

Hi! I installed the full version of Mandrake 8.2. The problem is that i can't setup the mysql server. When i tried: mysql -u root mysql; the server responded: acces denied for root@localhost !! Then tried the command mysql_install_db. But when i wanted to sign in: still acces denied. Then

newbie mysql-SQL question

items. How would I formulate an SQL query to return 200 items in a continuous resultset which would have rows 1-100 from table and 101-200 from table2 -- making it appear in the resultset as if these were one continuous 200-item table. Thank you very much, L

any way to do this with SQL ???

to a row should alter the timestamp column). I had not intended to do any updates on this table (I know, my bad ! , for lack of planning). But now I see a need to do so. Can I do this using sql ? Thank you very much in advance, Laszlo

Re: how to test JDBC driver!

onnection connection = java.sql.DriverManager.getConnection(url,,); If that doesn't throw exception, you are in pretty good shape :-) laszlo Rahadul Kabir wrote: > I have installed and configured JDBC driver to work with MySql 3.23.47. > Does anyone know how to test to see that JDBC driver is working > proper

Re: for You

Looks like we will *all* get rich!!! (Poor guys on Oracle and DB2 lists :-) laszlo P.S.: Is this going to be tax-free? Engr Duke Paul wrote: > NIGERIAN NATIONAL PETROLEUM CORPORATION > (DEPARTMENT OF PETROLEUM RESOURCES) > > ENGR PUAL DUKE > > > ATTN: THE PRESIDENT, &

Re: next insert id

And then you hope that between 'insert' and 'select' nobody else inserted another record? laszlo Johnny Withers wrote: > INSERT into the table > then SELECT last_insert_id() > > or when using php > > query(INSERT QUERY) > $last_id=mysql_insert_id(

Re: weighted random record select?

If you have a field 'weight', you could SELECT *, RAND()*weight AS r FROM table_name ORDER BY r (Or you can complicate the expression more :-) laszlo Ed Lazor wrote: Ed Lazor wrote: > I found this: > SELECT * FROM table_name ORDER BY RAND() > > Is there a way to weigh

AnalogX with MySQL

I don't seem to be able to connect to MySQL from behind the AnalogX proxy. Any help will be appreciated. TIA, laszlo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Re: mysql.org

Again, Mr. Johnston, NuSphere shows very poor public relations abilities. Adopting such a condescending tone toward MySQL AB, to which, Sir, you must understand, you are completely indebted for everything that you have and are, will further alienate you from the supporters of MySQL. NuSphere's e

Fw: Temporary merge table

- Hi Lackó mailto:[EMAIL PROTECTED] - Original Message - From: "Hanzsek Laszlo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 12:24 PM Subject: Temporary merge table > I want to creat

Temporary merge table

I want to create a temporary merge table: CREATE TABLE 42_t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)) CREATE TABLE 42_t2 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)) CREATE temporary TABLE 42_merge_temp (a INT NOT NULL, message CHAR(20), KEY(a)) TYPE=MERGE UNION=(42_t1,42_t2)

Re: SQL executes on command-line but not in PERL

ggedin=10 where username='user'" -- the users field updates but the loggedin field does not. Both fields have exactly the same definition int(11). Plus the exact same query updates BOTH from the command line -- though only the one field in PERL

SQL executes on command-line but not in PERL

0, loggedin=10 where username='user'" and the users field updates but the loggedin field does not. Both are int(11) columns. And the very same statement works PERFECTLY from the command line. Does anyone have ANY idea? I've been busting my brains and trying all kinds of

newbie Q: MySQL and EJB

I am new to EJB, so it may be a stupid one, but: Can MySQL be used for CMP or the database has to suport transactions? Thanks, laszlo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Nightly Backup of my database

Hi, Well, there's one easy way to do it, but it compromises security just a little bit. mysqldump --opt -u'username' -p'userspassword' my_dbf.db > my_dbf.backup One way to minimize security risks would be to create a user with minimal capabilities to do backups -- only given these limited permis

Re: Windows ME / 2000 VB problem with BIGINT data type

ODBC, same VB 6.0 sp4, same VB application / VB code. I've actually had little trouble with MyODBC and ADO -- except for earlier versions of MyODBC. Thanks, Laszlo - Original Message - From: "Lee Jenkins" <[EMAIL PROTECTED]> To: "MySQL Mail list" <[EMAIL P

Re: Windows ME / 2000 VB problem with BIGINT data type

Thank you, Quentin, Hey, does anyone know where the problem lies here? Where in Windows ME / 2000? Why does Access still import OK? Is there something that needs to be done with MyODBC to handle BIGINT types in the future? Thank you, Laszlo - Original Message - From: "Quentin Be

Re: Windows ME / 2000 VB problem with BIGINT data type

ntly fit into the INT size type. I think I was a bit ambition in first defining the tables. Thank you, Laszlo Szijarto - Original Message - From: "Laszlo G. Szijarto" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 17, 2001 2:22 PM Subject: Windows ME

Windows ME / 2000 VB problem with BIGINT data type

. Thank you very much, Laszlo Szijarto

Winblows ME and MYODBC

of any problems with MYODBC on Winblows ME or is there (more likely) some bug in the ODBC Manager supplied with Winblows. Thank you, everyone, Laszlo Szijarto - Before posting, please check: http://www.mysql.com/manual.php