parameterized view ?

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

Best way to store these data?

? The 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

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

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)

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

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 yourself a

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

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

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

Quoting Michael Stassen [EMAIL PROTECTED]: According to the manual http://dev.mysql.com/doc/mysql/en/UPDATE.html, the multi-table UPDATE syntax is UPDATE [LOW_PRIORITY] [IGNORE] tbl_name [, tbl_name ...] SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] so,

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,

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

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 meaningful.

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

Re: MIN(foo) as bar WHERE bar50

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

MIN(foo) as bar WHERE bar50

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

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

For list archives: 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

Re: Partnership Required!

and fax mostly. Awaiting your urgent reply via my email. Thanks and my regards. Mr.Christpher Tayelor, Manager, Brait Merchant Bank. Laszlo Illyes Teaching-assistant Sapientia University (Csikszereda) Miercurea-Ciuc Tel:+40266317310 Fax:+40266317310/+40266371121 Mobil:+40740055706 E

Re: Java related

, __ 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/ Laszlo Illyes Teaching-assistant Sapientia University (Csikszereda

Re: mysql development tools

together? I'm just trying to get an idea of what's out there, so I don't have to reinvent the wheel. Thanks for any ideas, cpp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Laszlo Illyes

Re: finding equations intersections

Mailing List For list archives: 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

RE: web interface...

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 General Mailing List For list archives: http

Re: export from Access so MYsql can read it

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. Thanks Dan Laszlo Illyes Teaching-assistant Sapientia

Re: Can records be moved between tables without knowing columns

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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] Laszlo Illyes Teaching-assistant Sapientia

Re: UNION syntax (Request for feature)

, __ 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/ Laszlo Illyes Library-informatics Sapientia University (Csikszereda

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

. 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, Laszlo

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!

(url,username,password); 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 properly? Is there a test file? thanks

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() OR INSERT SELECT MAX(id) FROM tablename

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, REQUEST FOR URGENT BUSINESS

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 weight the random selection so

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.mysql.com

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

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 create a temporary merge table

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

SQL executes on command-line but not in PERL

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 things -- with NO success. Thank yo

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

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. Thank you very mu

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

Windows ME / 2000 VB problem with BIGINT data type

. Thank you very much, Laszlo Szijarto

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

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 / 2000 VB

Winblows ME and MYODBC

y 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 (the manua