Davy Durham <[EMAIL PROTECTED]> wrote on 06/17/2005 12:41:24 PM:
> Hi,
> I was wondering if there's a way to make mysql not care about (or
> ignore) columns in an insert statement that don't exist in the table.
> For example, I have a dump from a table with 10 columns, but the new
> table has one
Kevin Burton <[EMAIL PROTECTED]> wrote on 06/20/2005 01:35:38 PM:
> We're noticing a problem where if we were to write to the master with
> multiple threads that our slave DB will fall behind.
> Note that we're trying to perform as many inserts as humanly possible
> and the load on the master is
comex <[EMAIL PROTECTED]> wrote on 06/21/2005 11:07:35 AM:
> I have a table:
> create table example(time datetime, username varchar(255));
> timeusername
> 2005-06-21 15:58:02 user1
> 2005-06-21 14:58:02 user1
> 2005-06-21 11:57:51 user2
> 2005-06-21 10:57:51 user1
> 2005-06-2
Dan Bolser <[EMAIL PROTECTED]> wrote on 06/21/2005 09:51:06 AM:
> Hello,
> I am interested in the theoretical time / space complexity of SQL
queries
> on indexed / non-indexed data.
> I think I read somewhere that a JOIN on an indexed column is something
> like O[mn*log(mn)] (m rows joined to n
comex <[EMAIL PROTECTED]> wrote on 06/21/2005 12:46:00 PM:
> > Basically it boils down to the fact that with SQL you have to use
> some other way of telling
> > each group apart other than position (or interposition, as you say
> in your example). The fact
> > that you have entries in your table
[EMAIL PROTECTED] wrote on 06/21/2005 01:56:50 PM:
> Hi everyone,
> Trying to connect to a MySQL database from a Linux Server using PERL
> to a Windows Machine with a MySQL database (5.0.6). I can connect
> successfully on the windows box but cannot on the Linux server! I
> ran a SQLTRACE (DBD)
Jochem van Dieten <[EMAIL PROTECTED]> wrote on 06/22/2005 07:34:30 AM:
> On 6/22/05, David Kagiri wrote:
> > When i run the queries below they all work just fine
> >
> > SELECT sum(consultation)+ sum(laboratory) FROM nairobi,
> familymembers WHERE familymembers.dependantid = nairobi.memberid and
>
Ed Curtis <[EMAIL PROTECTED]> wrote on 06/22/2005 02:27:02 PM:
> I've been cruising the docs for a while now and can't find what I'm
> looking for. I know it has soemthing to do with value or LEN or
something
> easy like that but I just can't find the right command structure.
> I need to list th
Responses interspersed
James <[EMAIL PROTECTED]> wrote on 06/22/2005 04:48:59 PM:
> I did a little test by configure the `name` and `city` with FULLTEXT
> INDEX and a regular INDEX.
>
> mysql> describe testing_text_performance;
> +---+--+--+-+
James Black <[EMAIL PROTECTED]> wrote on 06/23/2005 03:41:32 PM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> How would I add a comment to rows in an existing table, if I am not
> changing the row definition?
> This is for mysql 4.1 and 5.0.
> Thanx.
> - --
> "Love is mutual self-giving
Sajith A <[EMAIL PROTECTED]> wrote on 06/24/2005 02:07:22 AM:
> Thank you Mathias once again
> > I suggest you to test after optimize table ... and analyze table ...
> > if you stay with the problem and you can give me a set of data,
> i'll try to help
> > more.
> Initially while posting... i
"Rob McDonald" <[EMAIL PROTECTED]> wrote on 06/24/2005 10:37:39 AM:
> I'm running MySQL 4.0.18-nt & accessing the database primarily through
Java
> with MySQL/Connector J (similar vintage). I am administering this
myself,
> and can upgrade as needed. I know I'm a bit behind the times.
> I apo
"Harish Gabbita" <[EMAIL PROTECTED]> wrote on 06/27/2005 10:17:48 AM:
> Hi Everybody,
> I am using MySql 4.0.21 standard version. I have a profile table with
the
> structure in similar manner:
> mysql> select A0,A1,A14,A15,A19,Split from PROFILE where A1=100;
> +---+-+-+-+-+
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/26/2005 11:02:30 AM:
> Hi,
> is there anyway that I can have more than 20 digits for integer
> (bigInt)? If not, what I can use for database index?
BIGINT UNSIGNED can range from 0 to 18446744073709551615
(http://dev.mysql.com/doc/mysql/en/numeric-ty
Christopher Molnar <[EMAIL PROTECTED]> wrote on 06/27/2005
12:55:08 PM:
> I have a table that has the following structure:
> mysql> describe time_sheet;
> +--+---+--+-+
> ++
> | Field| Type | Null | Key | Defaul
Eko Budiharto <[EMAIL PROTECTED]> wrote on 06/27/2005 12:28:27 PM:
> >Are you actually saying that you have a database with more than 1.8e+19
> >records in it? I don't think you do. I think you are combining several
> >pieces of information into something that looks like a number and it's
> >e
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 06:13:08 AM:
> Selon Behrang Saeedzadeh <[EMAIL PROTECTED]>:
>
> > Mathias,
> >
> > Thanks a lot!
> >
> > > I will not explain the same thing for sqlserver, sybase ..., but
when
> > > your RDBMs
> > > have a data dictionnary, you don't need to exec
Mathias <[EMAIL PROTECTED]> wrote on 06/28/2005 01:11:59 PM:
> Selon [EMAIL PROTECTED]:
>
>
> Thanks Shawn, but i'm not speaking about data consistency during
> transaction and
> isolation levels.
> I spoke about what is seen in the data dictionary as num_rows an why
> it can not
> be used ev
"Lee Denny" <[EMAIL PROTECTED]> wrote on 06/29/2005 08:00:49 AM:
> Hello,
>
> If got a simple sessions table basically holds a session id and datetime
> field for last modification also a session type, so I can have several
> records with the same session id, with different types and different
>
Can I vote for just enabling FULL regex support? Let's get it all working
(pattern matches (already done), substring replaces, pattern extraction,
everything else...).
Shawn
Pooly <[EMAIL PROTECTED]> wrote on 06/29/2005 09:31:24 AM:
> That I'd love to have a regex_replace available in MySQL
"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 06/29/2005 03:09:28
PM:
> 671 Did not find any old versions with SELECT cJobTitle FROM
jobtitlecount
> WHERE fkJobPosting = 209689 AND dtSnapShot = '2005-06-26', attempt to
insert
> one: INSERT INTO jobtitlecount (fkJobPosting, dtSnapShot, cJobTi
[EMAIL PROTECTED] wrote on 06/30/2005 11:59:43 AM:
> news <[EMAIL PROTECTED]> wrote on 30/06/2005 16:47:43:
>
>
> > I'm designing a simple family tree db which is at present just a flat
> table
> > In which each record everyone has a father & mother, a variable
> > number of wives,and variable
"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 06/30/2005 10:29:48
PM:
> Approximately a half year ago I started to install bugzilla on windows
which
> uses mysql and perl.
>
> After much grief, I discovered that there was a problem with windows
perl
> and the latest version of mysql at the
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/01/2005 03:46:49 PM:
> Hello,
>
>
> MYSQL on PC v 4.0.15
>
> And I am trying to add an address table off of it. Using the
> users(id) as a primary key and deleting on cascade. So when the user
> is deleted from system, so are the addresses associ
Seth Leonard <[EMAIL PROTECTED]> wrote on 07/01/2005 04:43:05 PM:
>
> I constantly bump up against this issue and am looking for a good
> solution. I want a query that will return multiple rows, but only one
> row per unique identifier in one field.
>
>
>
> For instance, if I have the followi
"Matt Babineau" <[EMAIL PROTECTED]> wrote on 07/01/2005 05:05:28 PM:
> Hi Again -
>
> I need some more help with a query. I have a list of numbers (bandwidth
> required)... 2200, 2200, 2200, 400, 320
>
> My data looks like this:
>
> Bandwidth | Distance
>
> 2250 | 10km
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/05/2005 04:21:06 PM:
> Hello,
>
> I have created a web-based simple application, and used mysql for
> data storage. All has worked well. But I do have a simple question I
> would like to ask the group.
>
> I have some web-based forms that match ta
Ruben Carvalho <[EMAIL PROTECTED]> wrote on 07/06/2005 11:06:10
AM:
> I think I haven't understood your question. I guess
> that in case of a network failure you can have the
> same behavior as a power shutdown.
>
> About the networked drives? Anyone?
>
>
> --- Martijn Tonies <[EMAIL PROTECTED
Dan Tappin <[EMAIL PROTECTED]> wrote on 07/06/2005 11:26:13 AM:
> I am running into repeatable table corruption with MySQL 4.x on Mac
> OS X 10.x.
>
> I previously had a MySQL install on 10.2 Client under 3.x and never
> had an issue or any major problems at all. I upgraded to MySQL 4.x
> and
Ruben Carvalho <[EMAIL PROTECTED]> wrote on 07/06/2005 12:54:24
PM:
> Well, thank you very much for your explanation.
>
> My problem is I would like to have the data files
> being saved in a machine behind a proxy but the server
> running in a machine outside the proxy (the clients
> don't have
He doesn't need ODBC to make a connection, his Java app is doing that
already...
I agree with J.R., you should move your database server behind your
firewall and just open the one port (3306). If you would prefer, you can
designate your database server to use a different port (42000 for examp
Charles Kline <[EMAIL PROTECTED]> wrote on 07/06/2005 02:25:12 PM:
> Hi all,
>
> I have a table:
>
> id, name, parent_id
>
> I need to find all records that have no children. I know how to do it
> using a sub select, but I need to do this in version MySQL 3.32 and I
> am not sure how.
>
> Th
"Haisam K. Ido" <[EMAIL PROTECTED]> wrote on 07/06/2005 02:35:54 PM:
> I want to store a date of this format
>
>mmddhhmmss.ss
>
> Should I use DOUBLE as the data type? Yes I do need all the .sss's. Or
> should I use DATETIME and then have another column to store the fraction
>
Brian Dunning <[EMAIL PROTECTED]> wrote on 07/06/2005 04:43:11 PM:
> I am cross-posting this to the PHP and the MySQL lists because I'm
> not sure in which technology my solution will lie.
>
> I have a pretty busy PHP/MySQL site that executes the following query
> a lot:
>
> select count(*) as
Scott Haneda <[EMAIL PROTECTED]> wrote on 07/06/2005 08:16:41 PM:
> I am using 4.0.18-standard
> So I do not have `DATEDIFF`, but I need to ability to do so, anyone know
> some other simple trick to get days between two dates?
> --
> -
>
[EMAIL PROTECTED] wrote on 07/07/2005 11:22:52 AM:
> Dear list:
> I am preparing an entity relationship diagram and encountered the
> following problem:
> The entity "individual" has the attributes firstname, lastname.
> The entity "company" has the attributes name, companytype.
> Now I wish to i
[EMAIL PROTECTED] wrote on 07/07/2005 01:57:33 PM:
> Dear Shawn,
> Thanks for your reply.
> I find that "individuals" and "companies" each have attributes that
> are completely irrelevant to the other. E.g. "individuals" have sex
> and language (so e-mail can be sent to them as "Dear Sir" or "De
Juan Pablo Espino <[EMAIL PROTECTED]> wrote on 07/08/2005 03:37:14 PM:
> Hello all!
>
> I have two tables in my database: results(20 000 rows) and
> data_lab1(3 000 rows) Both are related by a sample number (sample_id.)
> I need to find the samples of data_lab1 table that they are not in
> resul
Albert Padley <[EMAIL PROTECTED]> wrote on 07/11/2005 02:30:51 PM:
> First, I have spent hours searching the web and the list archives and
> can't find anything helpful.
>
> Second, I'm using MySql 4.0.24
>
> Third, I'm still a novice at query formulation, so be kind.
>
> The Problem---
>
> I
Albert Padley <[EMAIL PROTECTED]> wrote on 07/11/2005 07:20:04 PM:
> OK. I'm responding to my own post since I figured out the syntax.
> This allowed me to figure out how to compute the ties as well as the
> wins. How to I compute the losses. I can't use the same technique
> because I'd be look
Michael Louie Loria <[EMAIL PROTECTED]> wrote on 07/13/2005
06:42:45 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA512
>
> I would like to ask what is the best type of engine
> for this project I
> will take
>
> Payroll and Daily Time Record system
>
> - -
> Payroll system is located in
replies embedded
James Black <[EMAIL PROTECTED]> wrote on 07/13/2005 10:03:09 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> If I run the first query on mysql 5.0.6 the results are correct, I get
> 142 rows, if I run it on 5.0.7 I get 8 rows back.
>
> If I remove the nested selec
If you have your native, auto-updated table in MS Access and a different
Linked table pointing to the MySQL copy of it in the same database, just
build an Access query that will INSERT or UPDATE (as appropriate) your
linked table with data from your native table. No scripting required,
just th
Manoj <[EMAIL PROTECTED]> wrote on 07/14/2005 06:09:24 AM:
> Greetings,
> I am trying to get a feel of how MySQL would handle certain types of
> situation, mainly concerning the usage of indices.
>
> Say I have two exactly identical table structures namely table A &
B.
>
> For table
Joerg Bruehe <[EMAIL PROTECTED]> wrote on 07/14/2005 09:35:50 AM:
> Hi!
>
> Jochem van Dieten wrote:
> > On 7/14/05, Joerg Bruehe wrote:
> >
> >>
> >>However, the online manual is not cloned, so while we are building
5.0.9
> >>there can also be new text for 5.0.10 changes that gets integrated
James Black <[EMAIL PROTECTED]> wrote on 07/18/2005 08:42:31 AM:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> I have a query that uses a subquery that works under mysql 4.1 and
> 5.0.6, but doesn't work on 5.0.7 or 5.0.9
>
> I am trying to understand why it may be having a problem so I
Aiby <[EMAIL PROTECTED]> wrote on 07/18/2005 11:15:26 AM:
> Does it posible to set a user previlage to table wise!! Rather then a
Whole
> Database.
>
> --
> Aiby
Yes! You can even determine permissions for specific columns, if you
really want to.
Details here: http://dev.mysql.com/doc/mysql
Scott Hamm <[EMAIL PROTECTED]> wrote on 07/18/2005 12:01:49 PM:
> How do I rename a database? The help online is pretty ambigous.
>
> --
> Power to people, Linux is here.
I wouldn't say "ambiguous". I would rather say "indirect".
Renaming a database is nearly the same thing as moving tables t
shantanu oak <[EMAIL PROTECTED]> wrote on 07/18/2005 01:17:57 PM:
> I am getting two different results for the same set of commands on two
> different versions of MySQL.
> Can anyone explain what the issue is?
>
> CREATE TABLE `testdecimal` (
> `rate` decimal(7,4) NOT NULL default '0.'
> ) EN
"Octavian Rasnita" <[EMAIL PROTECTED]> wrote on 07/19/2005 02:45:58 AM:
> From: <[EMAIL PROTECTED]>
> Subject: Re: more queries vs a bigger one
>
>
> > Hello,
> > approx. how long does it take your "big" query to run as it is now?
Are
> > these queries appending a table? or are they buiding a r
王 旭 <[EMAIL PROTECTED]> wrote on 07/18/2005 03:17:51 AM:
> Follow is the sql statement:
>
>
> explain SELECT ol_i_id
> FROM orders, order_line
> WHERE orders.o_id = order_line.ol_o_id and o_id>0
> ORDER BY SUM(ol_qty)DESC
>
王 旭 <[EMAIL PROTECTED]> wrote on 07/18/2005 03:12:28 AM:
> NO effect :-(
>
> >From: pow <[EMAIL PROTECTED]>
> >To: 王 旭 <[EMAIL PROTECTED]>
> >Subject: Re: optimize a sql statement
> >Date: Mon, 18 Jul 2005 11:51:23 +0800
> >
> >Do u have composite index on order_line.ol_o_id AND order_line.ol_i_i
Eric Jensen <[EMAIL PROTECTED]> wrote on 07/20/2005 02:00:26 PM:
> I have a field that was set as a unique key when created via:
> UNIQUE KEY `username` (`username`)
>
> I no longer want it unique, but can't see a way with ALTER TABLE to
> remove it. It isn't the Primary Key or an index. The de
Les Schaffer <[EMAIL PROTECTED]> wrote on 07/20/2005 12:06:46 PM:
> I am working on a MySQL application where laptops will be collecting
> data into local MySQL tables, and then once a week they will be
> network-connected to a central server where they will "check in" their
> new data and "che
"me you" <[EMAIL PROTECTED]> wrote on 07/20/2005 03:05:30 PM:
> Hello,
>
> Having some problems trying to get the correct data from MySQL. I need
to
> grab a bunch of information based on a date the user selects (no problem
> there). However, this is an events type situation, where I want t
Scott Hamm <[EMAIL PROTECTED]> wrote on 07/21/2005 09:39:48 AM:
> I'm now trying to learn engines in MySQL. When I migrated from M$ SQL to
> MySQL to learn the migration process and executed the following:
>
> SELECT
> *
> FROM
> QA
> LEFT JOIN
> Batch
> ON
> Batch.QAID=QA.ID
> LEFT JOIN
"Ryan Stille" <[EMAIL PROTECTED]> wrote on 07/21/2005 05:47:28 PM:
> I'm trying to get a handle on MySQL backups and hot backups using MyISAM
> and InnoDB tables together. We plan to switch from SQL Server to MySQL
> soon.
>
> How are you guys handling full-backups of databases with mixed MyISAM
Jacek Becla <[EMAIL PROTECTED]> wrote on 07/21/2005 02:47:20 PM:
> Hi,
>
> Is there a way to insert binary data representing numbers
> directly into (preferably MyISAM) table. We are trying to
> avoid conversion from ASCII to float/double/int...
>
> Thanks,
> Jacek
>
> --
> MySQL General Maili
"Darryl Hoar" <[EMAIL PROTECTED]> wrote on 07/21/2005 04:12:39 PM:
> Greetings,
> I am currently using Mysql 3.23.52. I am looking for events (when a
record
> is added, mod'd or deleted
> from a table, and event is sent to each client connected to the DB.
> Firebird can do this,
> but before I
"Siegfried Heintze" <[EMAIL PROTECTED]> wrote on 07/24/2005 11:35:36
AM:
> I have a large number of job titles (40K). Each job title has multiple
> keywords making a one-to-many parent-child relationship.
>
> If I join job title with company name, address, company url, company
city,
> job name,
news <[EMAIL PROTECTED]> wrote on 07/25/2005 10:41:46 AM:
> Hi,
>
>
> I have the following table :
>
> CREATE TABLE `raw_outgoing_sms` (
>`id` bigint(20) NOT NULL auto_increment,
>`id_gsm_operator` bigint(20) NOT NULL default '0',
>`id_shortcode` bigint(20) NOT NULL defa
I am trying to find documentation on how to use the new Distributed
Transactions (XA) feature without going through a JDBC driver. According
to a Webinar I just reviewed, the XA protocols are "available in the SQL
layer" but I am having the hardest time finding documentation on how to
initiate,
Pupeno <[EMAIL PROTECTED]> wrote on 07/26/2005 03:53:10 PM:
> I have esentially this query (the list of integers may differ):
>
> SELECT `Plans`.`id`, `Plans`.`name`, count(*) as 'count' FROM `Plans`
JOIN
> `TechsPerPlan` ON `Plans`.`id` = `TechsPerPlan`.`plan` WHERE
> `TechsPerPlan`.`id` IN (
Michael Monashev <[EMAIL PROTECTED]> wrote on 07/26/2005 04:41:28 PM:
> Hello,
>
> How to optimize != statement?
>
> SELECT * FROM table1 WHERE char_255_column != '';
>
> How to fast select all rows, where CHAR(255) NOT NULL column not
> empty?
>
>
>
> Sincerely,
> Michael,
You could
Scott Hamm <[EMAIL PROTECTED]> wrote on 07/27/2005 07:48:56 AM:
> 'Batch', 'CREATE TABLE `batch` (
> `QAID` int(10) default NULL,
> `Order` varchar(9) default NULL,
> `Errors` tinyint(1) NOT NULL,
> `Comments` varchar(255) default NULL,
> `QEID` int(10) default NULL,
> KEY `Index_1` (`QAID`)
> ) E
(I don't like top-posting but we are already in that pattern...)
This looks good, except for the "Using temporary; Using filesort"
(http://dev.mysql.com/doc/mysql/en/explain.html)
>From http://dev.mysql.com/doc/mysql/en/order-by-optimization.html
>>>
If you want to increase ORDER BY spe
Gyurasits Zoltán <[EMAIL PROTECTED]> wrote on 07/27/2005 12:57:42 PM:
>
> TIMESTAMP() is available as of MySQL 4.1.1.
>
> I can't use this version because replication working :(
>
> I use version 4.0.22
>
> - Original Message -
> From: "Martijn Tonies" <[EMAIL PROTECTED]>
> To: "Gyur
Eric Bergen <[EMAIL PROTECTED]> wrote on 07/27/2005 05:03:40 PM:
> Try this:
> concat('UP', lpad(category_id, 6, '0'));
>
> Scott Purcell wrote:
>
> >Hello,
> >
> >I have the following dilemma, that I do not know how to handle.
> >
> >I have the need for a table where I create a identifier. The
Andy Pieters <[EMAIL PROTECTED]> wrote on 07/28/2005 05:06:46 AM:
> Hi all
>
> I installed mysql client on a windows box and created a my.conf filewith
the
> following:
>
> [client]
> server=servername
> user=username
>
> When I type the full path of the executable, it reads the conf file,and
Zhe Wang <[EMAIL PROTECTED]> wrote on 07/28/2005 10:40:08 AM:
> Hi, there,
>
> I am have a hard time figuring out why a simple query is extremely
> slow. I would greatly appreciate if you can shed some light!
>
> The table is in InnoDB:
>
> CREATE TABLE `rps_hits` (
> `gi` int(
"Johnson, Michael " <[EMAIL PROTECTED]> wrote on 07/28/2005
01:56:33 PM:
> Why are you going backwards MySql is an 8th grade toy.
>
> -Original Message-
> From: Nguyen, Phong [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 28, 2005 9:42 AM
> To: mysql@lists.mysql.com
> Subject: M
"Octavian Rasnita" <[EMAIL PROTECTED]> wrote on 07/28/2005 02:18:05 PM:
> Hi,
>
> I am using a MySQL database on a web site, and I would like to know what
> happends if someone searches in the database using a form, but after a
few
> seconds MySQL starts the query, that user hit the "Stop" butto
Gregory Machin <[EMAIL PROTECTED]> wrote on 07/29/2005 08:00:07 AM:
> Hi
> Please could advise me.
>
> I need search all the tables in a database for a single string. I'm
> trying to figure out how, where and what other tables exponent cms
> saves it text pages and references to, so i can finish
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 07/29/2005 04:44:10 PM:
> Hello,
>
> I have created a table for items. And I needed some of the columns
> to be searchable, so I created the table as:
> a MyISAM for full text search.
>
> CREATE TABLE `item` (
> `parent_id` int(11) NOT NULL default
René Fournier <[EMAIL PROTECTED]> wrote on 07/30/2005 02:10:02 AM:
> Thanks, this is very helpful. I'm finally starting to understand
> Joins. But now I have a serious performance problem. Using INNER JOIN...
>
> SELECT users.*, COUNT(history.user_id) as num_events
> FROM users
> INNER JOIN hist
[EMAIL PROTECTED] wrote on 08/01/2005 09:13:46 AM:
> I have this query which gets executed often, but when I saw this today I
> panicked. Any suggestions to why this took so long?
>
> mysql> SELECT t2.id, t2.bdate, t2.level FROM bvolset AS t1 JOIN bvolset
AS
> t2 ON t2.bdate bdate DESC LIMIT
"Jay Blanchard" <[EMAIL PROTECTED]> wrote on 08/01/2005
09:20:59 AM:
> [snip]
> I have this query which gets executed often, but when I saw this today I
>
> panicked. Any suggestions to why this took so long?
>
> mysql> SELECT t2.id, t2.bdate, t2.level FROM bvolset AS t1 JOIN bvolset
> AS
> t2
"Kapoor, Nishikant" <[EMAIL PROTECTED]> wrote on
08/01/2005 09:55:21 AM:
> I am probably missing something very simple, but appreciate it if
> someone could point me to that.
>
> I am doing this query on following table to fetch recs for a month:
>
> SELECT fName, lName, acctOpenDate FROM test
Scott Hamm <[EMAIL PROTECTED]> wrote on 08/02/2005 10:12:01 AM:
> I'm used with MS SQL and could not understand MySQL's document. I'm
trying
> to create something like the simple example
>
> DECLARE @title varchar(255)
> SET @title='%Unconditional%'
> SELECT @title;
>
> How do I get around to
"Kapoor, Nishikant" <[EMAIL PROTECTED]> wrote on
08/02/2005 02:58:08 PM:
> Just wondering if someone would be kind enough to take a look at it -
Nishi
>
> > -Original Message-
> > Following query is taking a long time (upto 10 secs) to
> > return the resultset. Would greatly appreciate
That's an excellent paper. However, David (the OP) is not actually in
control, nor is he designing his ontology He is attempting to build a
persistence/retrieval system for the taxonomy (ontology) that the
scientific community has already created to categorize life on our planet
(Kingdom, Phylu
[EMAIL PROTECTED] wrote on 08/03/2005 10:20:36 AM:
> What is a schema? How is different from a database?
>
As I understand it, and some scholars may disagree with me, a schema is
(most often) a description of a data structure. A database IS a data
structure composed of tables and other possibl
"Christian Lee" <[EMAIL PROTECTED]> wrote on 08/03/2005 02:19:30 PM:
> Hi all,
>
> I've a question to guru :)
> there're two tables:
> mysql> show fields from domains;
> ++--+--+-+-+
> | Field | Type | Null | Key | Default | Extra
> +--
I am not sure about index merging but you should be able to speed things
up if you ORDER BY and LIMIT your inner queries as well:
(SELECT * FROM t1 WHERE a='a' ORDER BY id limit 0,5)
UNION
(SELECT * FROM t2 WHERE a='a' ORDER BY id limit 0,5)
ORDER BY id LIMIT 0,5
To answer your UNION query, y
It's only known in certain circles and it's only useful as an educational
tool. What it is: Northwind is a small, populated, relational database for
a fictional trading company that MS uses as an example database in several
layers of training documentation. If you have never used any of the MS
Yesmin Patwary <[EMAIL PROTECTED]> wrote on 08/04/2005 12:42:44 PM:
>
> Dear All,
>
>
>
> I am trying to calculate balance for all id's. Can it be done using
> only one MySQL query (without any scripting, eg: php,perl,asp..)?
>
>
>
> price table:
>
> id|price
>
> 1|150
>
> 2|100
>
> 3
Sebastian <[EMAIL PROTECTED]> wrote on 08/04/2005 01:31:13 PM:
> i forgot to add another question,
>
> is it ok to add index after the tables and data are already built, or is
> it better to create the index before data gets inserted?
>
> Sebastian wrote:
>
> > I read the manual on indexes bu
"Nguyen, Phong" <[EMAIL PROTECTED]> wrote on 08/05/2005 08:26:58 AM:
> Good morning All,
>
> What Mysql command show us CONSTRAINT_TYPE value as UNIQUE, PRIMARY KEY,
or
> FOREIGN KEY of and schema?
>
> Thanks.Nguyen.
>
I believe you are looking for the SHOW CREATE TABLE comma
"Suryya Ghosh" <[EMAIL PROTECTED]> wrote on 08/05/2005 09:50:27
AM:
> Hi,
>
> We have a table containing more than 15 million rows of data, can
> anybody please help in this problem of fulltext search described below.
>
> The following query is giving a good result in terms of query time.
>
>
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:04:35 PM:
> Hello list,
>
> I'm getting the distinct 'params' columns from a table with this query
>
> SELECT DISTINCT params FROM table;
>
> but this gets the rows with distinct 'params' cols, but I want to know
> from which row each par
Joerg Bruehe <[EMAIL PROTECTED]> wrote on 08/05/2005 02:08:35 PM:
> Hi David, all!
>
> David Sparks wrote:
> > I have a query that is taking days to complete (not good). If I
change
> > the query so that it selects less rows it runs fast.
>
> I fear I have no decisive hint for this (sorry), bu
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/05/2005 02:41:45 PM:
> Following the "SELECT DISTINCT" topic, I have another question.
>
> I tryed to UPDATE all the tables, replacing one column in every tables
> with the contents of one specific row. I tried this, but the syntax is
> incorrect:
>
Sebastian <[EMAIL PROTECTED]> wrote on 08/08/2005 10:53:55 AM:
> Gleb Paharenko wrote:
>
> >Hello.
> >
> >
> >
> >What about this:
> >
> >
> >
> >UPDATE news
> >
> >SET comments =
> >
> >(
> >
> > SELECT COUNT(id)
> >
> > FROM comments
> >
> > WHERE newsid = news.id
> >
> > GROUP BY news
Scott Hamm <[EMAIL PROTECTED]> wrote on 08/08/2005 08:11:18 AM:
> Where can I put in my suggestion (I'm sure others suggested the same)
for
> MySQL Query Browser?
>
> Scott
>
ROFLMAO -- you really DON'T check the website before asking the group do
you (or read the manual, or check the archi
Scott Hamm <[EMAIL PROTECTED]> wrote on 08/08/2005 11:24:22 AM:
> On 8/8/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Scott Hamm <[EMAIL PROTECTED]> wrote on 08/08/2005 08:11:18 AM:
>
> > Where can I put in my suggestion (I'm sure others suggested the same)
for
> > MySQL Query Brows
David Sparks <[EMAIL PROTECTED]> wrote on 08/08/2005 12:20:41 PM:
> Hi all!
>
> Gleb Paharenko wrote:
> > Hello.
> >
> >
> >
> >>I have a query that is taking days to complete (not good). If I
change
> >
> >
> > Really, not good. What does SHOW PROCESSLIST report about the thread
of
> >
Sebastian <[EMAIL PROTECTED]> wrote on 08/08/2005 01:19:32 PM:
> Nuno Pereira wrote:
>
> > [EMAIL PROTECTED] wrote:
> >
> >> Sebastian <[EMAIL PROTECTED]> wrote on 08/08/2005
> >> 10:53:55 AM:
> >>
> >>
> >>> Gleb Paharenko wrote:
> >>>
> >>>
> Hello.
>
>
>
> What about
Nuno Pereira <[EMAIL PROTECTED]> wrote on 08/08/2005 01:49:44 PM:
> Sebastian wrote:
> > Nuno Pereira wrote:
> >
> >> [EMAIL PROTECTED] wrote:
> >>
> >>> Sebastian <[EMAIL PROTECTED]> wrote on 08/08/2005
> >>> 10:53:55 AM:
> >>>
> >>>
> Gleb Paharenko wrote:
>
>
> > Hello.
> >
m i l e s <[EMAIL PROTECTED]> wrote on 08/08/2005 03:10:21 PM:
>
> Hi,
>
> IS the following query counting cumulative (see below **) pHITS or is
> it counting individual counts for each user for a particular day. Im
> not skilled enough to answer this question myself. My instinct says
> tha
"Kent Roberts" <[EMAIL PROTECTED]> wrote on 08/08/2005 04:50:15 PM:
> I am having inconsistent behavior maintaining a remote connection
> with MySql Administrator/Browser. Brand new installations of clients
> on Windows XP and MySql server on Windows 2003 server. It worked
> fine at first then s
1 - 100 of 1593 matches
Mail list logo
