Query mych slower when using index (Innodb)

Hi, I have the following tables : CREATE TABLE articoli ( codice varchar(16) PRIMARY KEY, descrizione varchar(255), marca varchar(255) NOT NULL, misure varchar(32), pesofloa

RE: GUI for MySql

> What GUIs exist for MySql and which is the best to use? http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_1_0 lists most of them... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq ---

Programming with C API question

Hi, I am a programmer. Now i want to know how to know whether MySQL server is down or not through C API. For me, i know if we use mysql_real_connect() to connect MySQL server, when error returns we can not distinguish it's due to authentation error or mysql server down. Can we use mysql_error()

Re: pls help !!

On Wed, 2001-10-31 at 08:52, kmlau wrote: > hi all, > >Let me to introduce somethings first, we use mysql for a logging system > and take about max 150 000 records hourly. And we need to take a period of > data for analyzing. I haven't followed the thread but do you use INSERT DELAYED alread

Re: Will MySQL latest version support subqueries

Hi Madhuri, Subquery is in the immediate todo list of Mysql. It should be soon available. The alternative is to use temporary tables. You can read about temporary table in the Mysql manual. Section 3.5.4. would be helpful. Anvar. At 10:58 PM 30/10/2001 -0800, you wrote: >hi, > I hav

Re: Can't create a table with MySQLGUI

> I'm newly acquinted with MySQL today, and made a very first attempt to > create a table with MySQLGUI. However, the "Commands-Tables-Create Tables" > menu option doesn't seemed implemented -- nothing happens. Is this something > that hasn't been implemented, or am I not using the tool correctly?

Re: GUI for MySql

Powerful MySQL Manager for Win32. http://www.mysqlmanager.com Regards, Vadim - Original Message - From: "Joe Fan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 31, 2001 9:44 AM Subject: GUI for MySql > What GUIs exist for MySql and which is the best to use? > > _

Re: BUG: Need option to disable "tty" check in mysql client

Shankar Unni writes: > Please treat this as a fairly urgent problem. It's simple to fix, but the > effects of the bug are a severe loss of functionality under Win32. > > Several options in the mysql client (--batch, --silent, etc.) have no > corresponding options to reverse that behavior (e.g.

rearranging id's

Hello, is there an easy way of rearranging id's in a table after deleting one or more entry/entries (other than creating a new tbl and dropping the old one). I appreciate any hint. Thank you. --- Ali Reza Sajedi http://www.bupnet.de/info/mitarbeiter.php3?id=1&acti

How Can I Set CurrentDate As Default Date

hello, I got problem when I tried to have CURRENTDATE as DEFAULT date. For this I gave sql statement as CREATE TABLE XX(..,fldDate DATETIME DEFAULT NOW() NOT NULL, ..); NOW() & CURDATE() both will give Current date. But I am getting syntax error. If i give some Date like 10/31/2001 it is tak

Re: installations

Nathan A. Saint Clair writes: > I'm looking for instructions on installing the mysql GUI interface on a unix system. > Is that possible? Thank you, > > Nathan Of course it is possible. What Unix system. There are binaries for Linux and some other Unix systems ready so that you can download t

bugs / inconsistencies with date functions

Hi! > "oliver" == oliver <[EMAIL PROTECTED]> writes: >> Description: oliver> I have found some inconsistencies (one may call them bugs ;-) in the oliver> current MySQL 3.23 version. I tested this on Linux and Solaris 2.8 oliver> so this should not be platform specif

How to make apache webserver on a Linux box connect to a remote mySQLdatabase on a separate Sun box

Can someone pls advise me on how to make a website running in an apache webserver on a Linux box connect to a remote mySQL database on a separate Sun box? Thank you. - (on foxtrot) Privileged/Confidential Information may be contained in this message. I

ANNOUNCE: moomps-0.9

Moomps is a monitoring daemon which works using configuration (dashboard) files created by the moodss (Modular Object Oriented Dynamic SpreadSheet) graphical application. The configuration files contain the definition of thresholds, which when crossed, trigger the sending of email alert messag

MySql install manual: please cover error "Cant find host.frm"

There is an error which I encountered and overcame while installing mysql which I suggest needs better coverage in the MySql manual. Its caused by the default ownership on /mysql being incorrect, and causes an error message like: "Cant find host.frm" in the log. A fix that worked for me is: cd /

Re: How Can I Set CurrentDate As Default Date

sreedhar writes: > CREATE TABLE XX(..,fldDate DATETIME DEFAULT NOW() NOT NULL, ..); > > NOW() & CURDATE() both will give Current date. But I am getting syntax > error. > > If i give some Date like 10/31/2001 it is taking as default. You didn't bother to search the manual, did you? In the chap

Re: rearranging id's

Ali writes: > Hello, > > is there an easy way of rearranging id's in a table after deleting one or > more entry/entries (other than creating a new tbl and dropping the old one). > I appreciate any hint. Thank you. Drop the column and recreate it. It really is an incredibly dumb thing to do, bu

Replication problem (with temporary heap tables ?)

Hi, MySQL V. 3.23.33 with binary log and replication turned on: this is what i do on the master (in a perl script): === create temporary table TEMP_HITS ( ... ) TYPE=HEAP; Insert several things into TEMP_HITS; Select from TEMP_HITS and insert

Migrate from mssql7 to Mysql

How can i migrate a database from mssql7 to Mysql? - Moreno Riccardi - Before posting, please check: http://www.mysql.com/manual.php

Re: Can't create a table with MySQLGUI

Scott Seong writes: > Hi, > > I'm newly acquinted with MySQL today, and made a very first attempt to > create a table with MySQLGUI. However, the "Commands-Tables-Create Tables" > menu option doesn't seemed implemented -- nothing happens. Is this something > that hasn't been implemented, or am I

Auto_increment

HI everybody. I saw, when i delete all records from the table where id is primary key and auto_increment, the first number for id is'nt 1 but next in a row (the last was 5 the next will be 6). Can i change this behavior ? Mybe in file my.ini ? The goal is, that when i delete all records from the

Re: Replication problem (with temporary heap tables ?)

Similar thing happens with alter table/drop table. alter table isn't logged to binary log, but drop table is. - Original Message - From: "Dr. Frank Ullrich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 31, 2001 10:55 PM Subject: Replication problem (with temporary

Re: MySQLGUI hangs on certain commands

[EMAIL PROTECTED] writes: > MySQL is working perfectly on my Linux box. I downloaded MySQLGUI, and ran it. > It connects fine, I can view a table, etc.. But, when I click on the > GRANT/REVOKE menu, it hangs on the Windows side. When I go to the Linux side and > issue SHOW PROCESSLIST, there are a

Re: query unions..

Since I don't think anyone answered my question I did find a combination of queries that seemed to do the trick. In case anyone else might need to know this is what I did.. please correct me if you see anything I did wrong.. CREATE TEMPORARY TABLE tmp1 SELECT vc0.imageid FROM vote_count AS vc0 LE

Re: Replication problem (with temporary heap tables ?)

> = > 45219 > 011031 2:17:41 Slave: connected to master > '[EMAIL PROTECTED]:3306', replication started in log > '3306_bin_log.001' at position 71445219 > ERROR: 1051 Unknown table 't' > 011031 3:09:04 Slave: error running query 'drop table MY_SHOP.t' > 011031 3:09:04 Err

LIMIT

Hi! I'm new to linux, PHP and MySQL. I'm having a problem using LIMIT and ORDER BY in the same query. When I use this: SELECT uid,name,uname,email,local,tel FROM users order by name LIMIT 10 , 19 And mysql is returning 14 results. I'm testing, so I replaced the names for numbers to undestand

Re: Programming with C API question

Li, Robert writes: > Hi, > I am a programmer. Now i want to know how to know > whether MySQL server is down or not through C API. > For me, i know if we use mysql_real_connect() to > connect MySQL server, when error returns we can not > distinguish it's due to authentation error or mysql server

Re: LIMIT - Upgrade

Please ignore the first part of my question, related to using LIMIT, I've solved it, it was my mistake. My question now is only: Are there any tutorials that explain how to upgrade mysql version step by step? Thank's Joao -

Re: rearranging id's

Jari Mäkelä writes: > It is easier to have consequential data before starting to make the > relations if you are forced to work on fixing up the follies/ages old > tables of other people True, true. What I can't understand is why so many people insist on wanting to renumber things continously

RE: Problem with LOAD DATA INFILE

I suggest writing a PERL script/filter which accepts the text file and sends a comma-delimited file to standard-out. This file could then be sucked in by mysql -Original Message- From: Michael Benbow [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 30, 2001 7:48 PM To: [EMAIL PROTECTED

database synchronization

Hello guru, It is not appropriate to me to use standard replication mechanism of MySQL. because the interactions between master server and slave server will be too busy. Is any possibility 1. to replicate data over certain period of time ( I need period 24hours) 2. some how to replicate lates

java.util.Date, jdbc, and DATETIME

This question was asked back in 1999 and wasn't answered, so hopefully someone will answer it now. I am using JBoss and they provide a JDBC to mySQL type mapping that maps java.util.Dates to a jdbc-type of DATE and mySQL type of DATETIME. Well, only the date portion (10-31-2001) is being stored

unicode - utf8

Does mysql support the utf-8 (Unicode) character set? If so, where can I find it. Thanks, Neil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list arc

Running Query

I did a dump of a table from another database table and wanted to run the .sql file in another database. I used PHPadmin to do this and used phpadmin to run the .sql file against the other database I have this is the error from mysql: SQL-query : CREATE TABLE tblmembers ( ID int(11) defau

Re: java.util.Date, jdbc, and DATETIME

> This question was asked back in 1999 and wasn't answered, so hopefully > someone will answer it now. > > I am using JBoss and they provide a JDBC to mySQL type mapping that maps > java.util.Dates to a jdbc-type of DATE and mySQL type of DATETIME. Well, > only the date portion (10-31-2001) is be

Re: java.util.Date, jdbc, and DATETIME

On Wed, Oct 31, 2001 at 09:35:49AM -0500, [EMAIL PROTECTED] wrote: : This question was asked back in 1999 and wasn't answered, so hopefully : someone will answer it now. : : I am using JBoss and they provide a JDBC to mySQL type mapping that maps : java.util.Dates to a jdbc-type of DATE and mySQL

RE: Running Query

"By" is not a legal data type -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:17 AM To: [EMAIL PROTECTED] Subject: Running Query I did a dump of a table from another database table and wanted to run the .sql file in another databas

RE: Phrase based fulltext searching

A relatively straightforward way round this - and a number of other problems with FULLTEXT - is to combine a full text search with a LIKE criterion to narrow the results. Example (assuming that you are searching a table called Documents on a TEXT field called Term): SELECT * FROM Documents WHERE

RE: java.util.Date, jdbc, and DATETIME

That is the problem. I changed the mapping for java.util.Date to a JDBC type of TIMESTAMP, which is mapped to a mySQL type of DATETIME. I am now getting the desired results. Thanks, Michael -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31,

RE: Running Query

No, The column name should have been "Modified By" data type should have been "text" Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:20 AM To: 'Todd Williamsen';

Re: HOW do I return the results of a count to a variable

In message , Paul DuBois <[EMAIL PROTECTED]> writes >At 12:43 AM + 10/31/01, Mark Worsdall wrote: >>Hi, >> >>I want to alter this statement so it returns the number of records. >> >>$prep = "SELECT COUNT(*) FROM go.objectives WHERE subjects_id='1' AND >>su

Re: Having trouble using LIMIT

In message <[EMAIL PROTECTED]>, Steve Meyers <[EMAIL PROTECTED]> writes >> But when I add in the LIMIT statement it returns no records >> >> $prep = "SELECT id,name FROM go.objectives WHERE subjects_id='1' AND >> subjectHeadings_id='2' LIMIT 1,5 ORDER BY displayOrder"; >> >> $sth = $dbh->prepare(

Q: Using Linux LVM snapshots for replication setup?

Has anyone used LVM to create snapshots on a master in order to set up replication? We have specialized scripts that are getting harder and harder to maintain as we find weird edge cases and other annoying bits. Jeremy Zawodny's 'myrepl' script locks our larger tables for too long. So, we're l

RE: Running Query

"By" is not a legal data type. Did you mean "By text", without the word "Modified"? -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:17 AM To: [EMAIL PROTECTED] Subject: Running Query I did a dump of a table from another database ta

Re: "ROW_FORMAT=compressed" has no effect on db file sizes

At 12:18 PM 10/30/2001 -0600, Dan Nelson wrote: >In the last episode (Oct 30), Bennett Haselton said: > > I created one table with the command: > > > > CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species > VARCHAR(20), sex CHAR(1), birth DATE, death DATE, id INT UNSIGNED NOT > NULL);

Load data infile

Hi I'm working on importing csv datafile returns Warnings, after carefully checking data I noticed that there are double quotes (") inside the records. mysql> LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'; Query OK, 20

Query mych slower when using index (Innodb)

Hi! > "nsabbi" == nsabbi <[EMAIL PROTECTED]> writes: nsabbi> Hi, I have the following tables : nsabbi> explain SELECT DISTINCT a.* FROM articoli a, keywords k WHERE a.codice = nsabbi> k.codice AND keyword IN ('tubo') GROUP BY a.codice HAVING nsabbi> count(k.keyword)=1 limit 1, 26;

Problem adding table

I've been trying to add the following table to my database, and I keep getting the error below. CREATE TABLE mod_userpage_data ( id INT(5) NOT NULL default '0', title VARCHAR(200) NULL, data LONGTEXT NULL, PRIMARY KEY (id) ); ERROR 1064 at line 1: You have an error in your SQL synta

Re: bad practice to have a primary key field whose value changes?

At 02:32 PM 10/30/2001 -0700, Steve Meyers wrote: > > What would be ideal would be to use auto-incremented numeric fields as > > primary key fields, and then have a special field in each table > designated > > as the "user-friendly field". That way, when you want to view the > contents > > of a

RE: How to make apache webserver on a Linux box connect to a remote mySQL database on a separate Sun box

I think you are mistaken, you do not connect the Apache you connect your script ie php, perl, python to talk to your remote database, by specifying the dns database and password in your config file which should be on your apache server. You must ensure you have the specific odbc modules installed

Listing ignored words for fulltext searches

It would be nice if mysql had a function that would return a list of words that it's going to ignore when I do a full-text search. Its hard for me to explain to users of my site the difference between "your words didn't match anything", and "the database ignored your query because the words were

Linux VM on MySQL Servers...

Hi there, After reading some debate under way in kernel lists, i'm curious regarding performance of MySQL under the two diferent VM currently in the kernels (Linus and Alan Cox kernels). Has anyone any info regarding this? Cheers, Luis Ferro -

Re: Problem adding table

is data a reseverd word in mysql? On Wed, 31 Oct 2001, Richard W. Wood wrote: > I've been trying to add the following table to my database, and I keep > getting the error below. > > CREATE TABLE mod_userpage_data ( >id INT(5) NOT NULL default '0', >title VARCHAR(200) NULL, >data L

RE: Load data infile

Use "optionally": mysql> LOAD DATA INFILE '/home/sql/data.csv' INTO TABLE csvdata FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"' LINES TERMINATED BY '\n'; -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:33 AM To: [EMAIL PROT

RE: Problem adding table

There may be a space before the word "data" as in "mod_userpage_ data" -Original Message- From: Richard W. Wood [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 9:44 AM To: [EMAIL PROTECTED] Subject: Problem adding table I've been trying to add the following table to my data

Re: LIMIT

And the problem is? João Rosa - Dimensão Global wrote: > Hi! > > I'm new to linux, PHP and MySQL. > > I'm having a problem using LIMIT and ORDER BY in the same query. > > When I use this: > > SELECT uid,name,uname,email,local,tel FROM users order by name LIMIT 10 , 19 > > And mysql is retur

Re: How to turn beeping off

I confess to using Windows NT (my job requires it) and running the command line utility mysql.exe. Since I make mistakes, it likes to tell me that by beeping at me. I'd like to use some control panel utility, but I to mute the speaker, but I don't have one. I'd really love to cut the speaker ca

RE: Migrate from mssql7 to Mysql

You can use a pretty cool software from http://www.datanamic.com/ First one being ImporterScript http://www.datanamic.com/importerscripts/index.html then dump your datastructure from your m$sql7 into Dezign http://www.datanamic.com/dezign/index.html then use this to change the database to MySQL.

Re: Problem adding table

From: rc <[EMAIL PROTECTED]> > is data a reseverd word in mysql? No. > On Wed, 31 Oct 2001, Richard W. Wood wrote: > > I've been trying to add the following table to my database, and I keep > > getting the error below. I copy-pasted your SQL and it worked. I'm using 3.23.38. --- Rodney Bro

Re: Problem adding table

No it is not. Reserved word list: http://www.mysql.com/doc/R/e/Reserved_words.html I think Richard's problem is the NULL. You could do default NULL, but I think NULL by itself doesn't mean anything to mysql (in a create table, anyway). - Original Message - From: "rc" <[EMAIL PROTECTED]

MySQLGUI?

Hi Can MySQLGUI start and stop the daemon? /Henrik - 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 <[E

Re: database synchronization

On Wed, Oct 31, 2001 at 04:28:27PM +0200, Vyacheslav I. Raytsin wrote: > Hello guru, > > It is not appropriate to me to use standard replication mechanism of > MySQL. because the interactions between master server and slave > server will be too busy. > > Is any possibility > 1. to replicate da

Multiple Join Headache

I am having some problems with using join. here's the tables: t1 t2 MachineId MachineNameMachID Service_Name 111mach1 111DHCP 112SNMP t4 Service_cat Service_name Network DHCP EmailExchange Network SNMP t

sage v6 to mysql

Has anyone played with extracting data from sage version 6 on Windows to MySQL? What is the easyest way of extracting data from sage? Their support will not help sing my contract with them expired and I have decided to use a different product. Regards Ajdin --

Re: Can't set max_connections on debian version

thanks, I finnally figured out how to set it on the command line and modified safe_mysql script to do it. Thanks On Wed, 31 Oct 2001, Wouter de Jong wrote: > Date: Wed, 31 Oct 2001 09:19:14 +0100 > From: Wouter de Jong <[EMAIL PROTECTED]> > To: "William R. Mussatto" <[EMAIL PROTECTED]> > Cc: [

RE: How to turn beeping off

I've been lurking here for a while and have been itching to ask this... Does anyone use mysqlfront to manage and work with MySQL on Windows? I love it and can not live without it now. My other favorite is Advanced Query Tool and the combination is fantastic! Any thoughts?? (and it does not beep

Multiple Join Headache

I am having some problems with using join. here's the tables: t1 t2 MachineId MachineNameMachID Service_Name 111mach1 111DHCP 112SNMP t4 Service_cat Service_name Network DHCP EmailExchange Network SNMP t

RE: Migrate from mssql7 to MySQL

Since this is the first mention of the datanamic tools I have seen, I have a question. In using DeZign to layout the structure and then generate scripts to build the tables, what happens when you just want to make a few changes to the tables? Do you have to re-generate the whole thing? Do you add

JSP newbie needs to run MySQL-JDBC.

Hello Everyone, I need to run MySQL using JSP. I am a JSP newbie, actually a Java newbie too. I am more of a PHP/MySQL guy. I have successfully installed Allaire JRun 3.0 on Win98 using PWS. JRun has an application management console and I cannot seem to run MySQL. I am totally unfamilia

Alternative for UNION

I had a view on sqlserver which i am trying to convert to work with mysql. It uses a union which i believe does not work with mysql. What is another alternative for union. Sql with union: select a.asset_id,a.material_id,b.material_id as parent_material_id from lib_asset_tbl a inner join lib_asse

RE: How to turn beeping off

> Any thoughts, besides switching to Linux? Linux beeps also, as evidenced by this intentionally incorrect query (had to get "query" in there so the message wouldn't bounce!): mysql> select * from junk; ERROR 1146: Table 'SBS4_run_db_25_10_2001__16hr8min36sec.junk' doesn't exist (and a beep) --

Help on SQL Statement

Hello, I've been working on this for a long time now and I cannot figure this out. Can someone help me get this sql statement without erroring or why it doens't work. Here is the SQL statement... SELECT DISTINCT ItemMaster.ParentNum, ItemMaster.Desc1, ItemMaster.Price FROM BillOfMat AS BillOfMat

Alternative for UNION in MYSQL

I had a view on sqlserver which i am trying to convert to work with mysql. It uses a union which i believe does not work with mysql. What is another alternative for union. Sql with union: select a.asset_id,a.material_id,b.material_id as parent_material_id from lib_asset_tbl a inner join lib_asse

Re: Problem adding table

On Wednesday 31 October 2001 10:44 am, Richard W. Wood wrote: > I've been trying to add the following table to my database, and I keep > getting the error below. > > CREATE TABLE mod_userpage_data ( >id INT(5) NOT NULL default '0', >title VARCHAR(200) NULL, >data LONGTEXT NULL, >PR

MySQL Authors Needed

Hi, I am looking for experienced writers who would like to write a complete and authoritative reference on MySQL. If you are interested in writing such a book, please contact me at [EMAIL PROTECTED] To learn more about the books we publish, please visit our Web site at www.osborne.com. McGraw-Hil

Off the shelf MySQL products

Hello everyone, We'll probably be using MySQL with our software. But in order to do that it has to be aproved by FDA( Food and Drug Administration). Are there any off the shelf products that will have all the MySQL capabilities bundled up in it? I think that way our software will be approve

MySQLfont Tools

On Wednesday 31 October 2001 12:00 pm, Schmidt, Allen J. wrote: > I've been lurking here for a while and have been itching to ask this... > > Does anyone use mysqlfront to manage and work with MySQL on Windows? I love > it and can not live without it now. My other favorite is Advanced Query > Tool

RE: Mysqlfront Tools

Advanced Query Tool - uses the MySQL odbc connection to get to the remote MySQL server. http://www.querytool.com The group that produces it is really great and has added several things I have suggested. Great support. Easy to use. Hope you like it too. We are switching out Zope installation over

Re: Problem adding table

The problem was in fact an illegal column name in one of the tables that a Content Management program tried to create. (phpWebSite) The program seems to be well done, but somehow they missed a beat on one of the modules that it creates (or doesn't because of the illegal name) I tracked it down

Multiple Join Headache

Is there anyway in SELECt statement to tell, if service name is DHCP look into service table , if service name is exchange look into software table. Can i use something like this service.DHCP , soft.Exchange. You could use a UNION and then specify both queries if you're using mysql 4.0 i

Re: Request for Mysql GUI.

Anything you could want to know, and more, can be found here: http://www.mysql.com/downloads/gui-mysqlgui.html Mike [EMAIL PROTECTED] wrote: >Hello, >I have the Mysql 3.23.27-beta version installed on my Windows NT PC and I am able to >create the database and query from the command line and f

A space is contained in colum??

I am a newbie. When I create a table, one colum contains a space, how can I caeate it correctly? like: CREATE TABLE mytable( name CHAR(60) NOT NULL, Email VARCHAR(50) NOT NULL, Thrid colum CHAR(60), ///Here there is a space? PRIMARY KEY (Email) ); W

Left join w/o on or using join_condition

My mind is not working with me this morning... According to the manual about join syntax: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#JOIN One should be able to do a LEFT JOIN without a join_condition, eg. an "ON" or a "USING": > table_reference LEFT [OUTER] JOIN tab

Help on SQL Statement

You can't use brackets on left joins like that. If you want to do two left joins, you use: LEFT JOIN table1 ON conds LEFT JOIN table2 ON conds That's why you're getting the error that mysql displayed, it doesn't expect a bracket. Chris >>>SELECT DISTINCT ItemMaster.ParentNum, ItemMaster

Re: Alternative for UNION

Harpreet wrote: > I had a view on sqlserver which i am trying to convert to work with mysql. > It uses a union which i believe does not work with mysql. What is another > alternative for union. > > Sql with union: > > select a.asset_id,a.material_id,b.material_id as parent_material_id from > lib_

A space is contained in colum??

You use the ` char as a quote. (the backwards quote, right below the ESC key on your keyboard with ~) Chris When I create a table, one colum contains a space, how can I caeate it correctly? - Before posting, please check:

Re: JSP newbie needs to run MySQL-JDBC.

> Name: MySQL > Display Name: MySQL > Driver: org.gjt.mm.mysql.Driver > URL: > jdbc:mysql://192.168.0.2:80/studiosusa?user=root&password=axnolnms I would assume that here is your problem, most likely mysql is not running on port 80 on your machine and you should change it to 3306,

RE: What are MYSQL_RES limits ? -- update

Some other useful information on this problem: I have tried the operation in two other ways, both based on a version of the program with only one connection using the API and emiting the UPDATE statments on standard output: 1. output piped onto mysql --> failure :-( 2. output saved on a fil

RE: Off the shelf MySQL products

for windows environment: http://sourceforge.net/projects/phptriad/ for linux: I've had complete success with Red Hat 7.1 -Original Message- From: Demirchyan Oganes-AOD098 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 11:43 AM To: '[EMAIL PROTECTED]' Subject: Off the shelf

RE: MySQL Authors Needed

> Subject: MySQL Authors Needed > > > Hi, > > I am looking for experienced writers who would like to write a > complete and > authoritative reference on MySQL. > > Thanks, > > > Chris Johnson Paul DuBois has already done a bang-up job. His book, MySQL (New Riders), is the bible as far as I'm con

RE: Alternative for UNION

I am using version 3.23 and dont think will be moving up to 4.0. Can i somehow create a temporary table and add all the rows i need and do a select query from that temp table. Neone done this before. Thanks for ur responses and time, Regards, Harpreet Kaur Software Developer Crispin Corporations

Re: deadlock - Innodb Monitor

Heikki, thanks for the reply. Regarding the trace output, My test has been "bombarding" the db server with 15 simultaneous clients, each generating up to 1000 transaction sets. I still do not get any output from Innodb Monitor. I created table innodb_monitor in the database that I'm accessing

RE: Help on SQL Statement

Change: LEFT JOIN (BillOfMat LEFT JOIN ItemMaster ON BillOfMat.CompNum =ItemMaster.ParentNum) ON BillOfMat_1.CompNum = BillOfMat.ParentNum to: LEFT JOIN BillOfMat ON BillOfMat_1.CompNum = BillOfMat.ParentNum LEFT JOIN ItemMaster ON BillOfMat.CompNum =ItemMaster.ParentNum You cannot do embedde

RE: A space is contained in colum??

What do you mean "there's a space"? You mean after the comma in "CHAR(60), "? And you you provided is not what you entered into mysql, because "Thrid colum CHAR(60)," won't work; "colum" is not a legal data type -Original Message- From: I. TS [mailto:[EMAIL PROTECTED]] Sent: Wednesday,

RE: Left join w/o on or using join_condition

Try going with simply: SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2 WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b; -Original Message- From: Bill Adams [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 12:21 PM To: Mysql List Subject: Left join w/o on or using join_condition

Re: deadlock - Innodb Monitor

Gisella, >Heikki, > >thanks for the reply. Regarding the trace output, My test has been >"bombarding" the db server with 15 simultaneous clients, each >generating up to 1000 transaction sets. this is strange. When you start the server from the command promp, does it then print something to the

[off topic] open source jobsite

Hi, We have just launched a non-profit open source jobsite. Check it out at http://www.freeusall.com/ It's built on MySQL 4.0 (Alpha), Perl and Apache. We'd appreciate any feedback you might have. kind regards, Mark Maunder.

Re: Update JDBC Driver (gweMysql Driver)

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> TAKAHASHI, Tomohiro writes: >> Hi, All >> I Fixed two bugs. >> >> 1. If LoginUser has empty password, Driver can not connect to MySQL. >> 2. Connection Pool does not work correctly. ;-) >> >> >> Check this URL out f

Re: Left join w/o on or using join_condition

Rick Emery wrote: > Try going with simply: > SELECT T1.*, T2.* FROM tbl1 T1, tbl2 T2 > WHERET1.a=1AND T1.b=2 AND T2.a=2 AND T2.b=T1.b; Well, if I resort to that then the documentation is wrong. Here is what I am really trying to do. Say you have a table and data: DROP TABLE IF EXISTS tbl

RE: Alternative for UNION

>>Can i somehow create a temporary table and add all the rows i need and do a select query from that temp table. Yeah, that's the easiest way to do it. Create temporary table A. insert into A select insert into A select select * from A If you want to mimic 'insersect' features

  1   2   >