Dan Bolser [EMAIL PROTECTED] wrote on 04/08/2005 12:41:35 PM:
On Thu, 7 Apr 2005, Sean Nolan wrote:
I think you'll find you can do what you want with a cross join. A cross
join
will join every row from the first table with every row from the second
table. It will not randomly do this,
l'[EMAIL PROTECTED] [EMAIL PROTECTED] wrote on 04/08/2005 01:52:20
PM:
When I opened the message send by:
[EMAIL PROTECTED]
subject: Boolean searches
a pop up box appeared stating
Connect to 70.84.29.164
Web host manager
Username mymachine/administrator
password:
Has
ManojW [EMAIL PROTECTED] wrote on 04/06/2005 10:09:31 PM:
Dear All,
Just to get a better understanding of how indices work in MySQL - If
I
have a Innodb table with a composite primary key
(fld1,fld2,fld3,fld4,fld5),
then my understanding is that MySQL optimizes just the leftmost primary
[EMAIL PROTECTED] wrote on 04/07/2005 03:42:45 AM:
Hi,
we are facing problem with the sql queries given below
query number one gives the output as workstation and total logon failure
attempts from that workstation
which is fine
1) select logonsvr,workstnid, count (username) from
Ed Lazor [EMAIL PROTECTED] wrote on 04/07/2005 12:39:01 PM:
Three tables like this:
--
product_lines
--
id
title
--
manufacturer
--
id
title
--
manufacturer_product_line_index
--
id
product_line_id
Anchan, Dinesh [EMAIL PROTECTED] wrote on 04/07/2005
03:44:07 PM:
Peter,
Thank you for your reply.
Actually that request was accidentally sent to mysql@lists.mysql.com
instead of [EMAIL PROTECTED]
MySQL support also suggested the same thing. Problem is, values in the
OUT variable
Robert Citek [EMAIL PROTECTED] wrote on 04/06/2005 10:55:07
AM:
On Monday, Mar 7, 2005, at 16:04 US/Central, [EMAIL PROTECTED] wrote:
It would be happy to try to help if I worked in or on either of those
platforms (Apache + Java). I am Win32(IIS), ASP (VBScript/JavaScript)
using MyODBC
Just turn your subquery into another join
SELECT C2.City, N.Distance
FROM Cities C
INNER JOIN Nbc N ON C.CityID = N.PrimaryCityID
INNER JOIN Cities C2 ON C2.cityID = N.CityID
WHERE C.City = 'Los Angeles'
AND N.Distance 20
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
I do not recommend trying to install a new language if you don't need to.
Windows Scripting Host, DAO, and ADO are already installed on most windows
machines and are the native way of dealing with tasks that the other
scripting languages (like PERL) take care of on other platforms.
My
Chris [EMAIL PROTECTED] wrote on 04/02/2005 12:35:57 AM:
Tom Crimmins wrote:
On Friday, April 01, 2005 19:27, Chris wrote:
Hi all,
I've got 3 or 4 queries UNIONed together in a single query. I want to
GROUP the UNIONed result, by one field, and SUM() another field.
Is that
news [EMAIL PROTECTED] wrote on 04/04/2005 12:59:53 PM:
Greetings everyone,
I haven't been able to find any piece of information on temporal
databases
and MySQL except the code from the TAU Project which seems to be
experimental at best. Not even discussions on the mailing lists or on
the
[EMAIL PROTECTED] wrote on 04/04/2005 01:14:23 PM:
Hello all,
mysql 4.0.20
I'd like to know how one can do a full outer join.
I've read some workaround with a UNION, but i need the join only on a
few
columns, while UNION will make double tuple if one column is not the
same.
I also
My responses blended in
Jason Johnson [EMAIL PROTECTED] wrote on 04/04/2005 02:19:12 PM:
The premise of the query is to return required continuing education
hours for the entire membership of the organization. Limited to one
member when providing a membership ID.
The query is a
Julian Pellico [EMAIL PROTECTED] wrote on 04/04/2005 06:38:57 PM:
Hello,
I'm using MyISAM tables in mysql and in order to make a certain
operation appear atomic, I need to insert records into 2 tables in a
certain order. In particular, in one of the tables is a key that maps
to multiple
Could it be that you are using a pre-4.1 client with a post-4.1 server? Do
exactly what you did before except try this:
UPDATE mysql.user SET Password=OLD_PASSWORD('my_new_password') WHERE
User='root'
You will need to FLUSH PRIVILEGES again. If this doesn't work at least we
have eliminated
X y [EMAIL PROTECTED] wrote on 04/05/2005 03:51:02 PM:
On Apr 5, 2005 9:06 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Could it be that you are using a pre-4.1 client with a post-4.1
server? Do
exactly what you did before except try this:
UPDATE mysql.user SET
Mister Jack [EMAIL PROTECTED] wrote on 04/05/2005 01:38:00 PM:
Hi,
I've got a dump file from my main DB (MySQL 4.1.10a), when I load it
with source backup.sql I can see some warnings around. Is there any
way to log those warnings, or to stop on warnings ? (show warnings
only show warnings
James Black [EMAIL PROTECTED] wrote on 04/01/2005 04:11:49 PM:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is it possible to have a stored procedure query another database?
I have two databases where the second (B) uses information from (A) to
make decisions.
It would be great if
Dan Nelson [EMAIL PROTECTED] wrote on 03/31/2005 03:01:45 PM:
In the last episode (Mar 31), Chris W. Parker said:
I searched the archives, looked through the manual, and searched
google for info on how to actually perform a multi-row INSERT but
didn't find an answer.
Would someone
My response intermixed...
Denis Gerasimov [EMAIL PROTECTED] wrote on 03/30/2005 09:29:00
AM:
Hello list,
I have two MySQL 4.1 servers, one local and one remote. I need to
transfer
database from one server to another. What actually is the best way
of
handling this task?
Asad Habib [EMAIL PROTECTED] wrote on 03/30/2005 10:53:38 AM:
Does MySQL 4.1 support the use of GROUP BY and ORDER BY used in
conjunction with one another? I have tried to execute several queries
with both these clauses but the result set I get is different from what
I
expect. My queries
G M [EMAIL PROTECTED] wrote on 03/29/2005 01:54:17 AM:
hi all,
in a table of say 100 fields, how many (maximum )numbers of indexes
can be created...
thx in adv.
This is really just a math problem as the database limits are much smaller
than the number of possible index combinations.
Jerry Swanson [EMAIL PROTECTED] wrote on 03/29/2005 11:43:56 AM:
I want to get everything from user than if record exist in admin so
user has admin(administrator) in table user with user.id =
admin.admin_id, so I need to get 'admin' first_name and last_name
If there is no record in table
Graham Anderson [EMAIL PROTECTED] wrote on 03/29/2005 02:20:48 PM:
I am trying to determine the average time that a Distinct IP address is
using the server
If I have 15 thousand records of ip addresses and access times like:
IP Now() media.id
TYPO ALERT!!! I left out the all important word INTERVAL. The query
should read:
SELECT accesstime
FROM userlog
where accesstime (NOW() - INTERVAL 15 minutes)
and IP='10.1.7.205'
LIMIT 1;
Sorry all!
-S
[EMAIL PROTECTED] wrote on 03/29/2005 02:50:35 PM:
Graham Anderson [EMAIL PROTECTED]
This is it. I quit for today... Change minutes to minute and I promise
to be more careful next time -- ROFLMAO!
-S
[EMAIL PROTECTED] wrote on 03/29/2005 02:59:09 PM:
TYPO ALERT!!! I left out the all important word INTERVAL. The query
should read:
SELECT accesstime
FROM userlog
where
leegold [EMAIL PROTECTED] wrote on 03/29/2005 04:58:11 PM:
Hi,
I understand that we should use IS instead of = for selecting fields
with NULL. But then, shouldn't the statement below cause a syntax error?
Please explain.
select * from test2 where datecurrent=NULL;
Thanks,
Lee
Nope
Grant Giddens [EMAIL PROTECTED] wrote on 03/28/2005 12:43:09 PM:
Hi,
If I do a query like:
SELECT prodname, price FROM prod_table WHERE sku in
($sku1, $sku2, $sku3, $sku4)
Will my results always be ordered in $sku1, $sku2,
$sku3, $sku4 order? I can't really do a ORDER BY
prodname
Graham Anderson [EMAIL PROTECTED] wrote on 03/23/2005 06:19:34 PM:
stupidly
My DateTime field is in this format:
March 23, 2005, 3:49 pm
If I want to run this sql
SELECT TO_DAYS(MAX(DateTime)) - TO_DAYS(MIN(DateTime)) AS record
FROM userLog
I gather I need some extra function
Graham Anderson [EMAIL PROTECTED] wrote on 03/23/2005 08:09:48 PM:
I have 3 different tables I need data from
And, the tables have the potential to get fairly large
I am using mysql 4.1.3
This working query below pulls up all media requests for 'Yolanda
Perez' in Los Angeles
Is
David Blomstrom [EMAIL PROTECTED] wrote on 03/24/2005 12:28:53
AM:
I was trying to imnport a csv file into an online
databse table, but I kept getting error messages
alluding to a child row, foreign key, etc. So I
decided to delete both keys (primary and index), then
import the csv file.
Mathew Ray [EMAIL PROTECTED] wrote on 03/24/2005 10:42:51 AM:
Been searching for a while and can't seem to come up with any good
answers to this - I have a normalized structure of about 5 tables that I
need to denormalize into one big representation of the entire structure.
Anyone know
You are on the right track. Don't forget to use the EXPLAIN command to
help you tune in your indexes.
One other thing that may help is to try making extracts of some of your
tables as temp tables and using them in the final JOIN query that pulls it
all together. For instance, you could make a
Lily Wei [EMAIL PROTECTED] wrote on 03/24/2005 03:08:28 PM:
Is there a way to use MySQL API that established ODBC calls without
going through ODBC driver?
Is it even possible?
Thanks,
Lily
There is a non-ODBC API (written in C) that comes pre-packaged with your
MySQL
Ed Reed [EMAIL PROTECTED] wrote on 03/24/2005 02:49:30 PM:
This is an interesting problem that I hope someone can help me with. I
have a varchar field that contains data like this,
01/01/05 SG Reviewed this
12/15/03 DSD Reviewed that
10/24/02 EWW Worked on that and tested this then stop
Ed Reed [EMAIL PROTECTED] wrote on 03/24/2005 04:02:28 PM:
Sorry everyone for not being more clear. The field IS in a multiline
varchar field. The example data was all from one record in the table.
Unfortunately, this is a database that has been around for many years
and backward
mel list_php [EMAIL PROTECTED] wrote on 03/23/2005 06:00:08 AM:
Unfortunatly they are not, I have something like 30 tables, with I would
say
10 to 15 fields per table.
The number of row per table is quite low, i think it won't exceed
500-1000/table. But I may sometimes have to search into
Justin Moore [EMAIL PROTECTED] wrote on 03/23/2005 10:38:48 AM:
Hi,
Anyone know why I can't run multiple commands from the query browser
using semicolons to separate the commands?
ex:
The following command works fine:
select now();
However the following commands do not
select
I am not aware of any SQL dialect that supports a query of the kind you
are asking about. If there were such a query it _might_ look something
like this
SELECT column list
FROM table reference
WHERE ANY_COLUMN(column name list) LIKE search parameter
but like I said, I can't think of any SQL
Normally, MySQL queries DO NOT end in a semicolon. The semicolon (;) and
the \G terminators are used by the command line client to differentiate
between normal (wide output) and vertical output. I have also used
semicolons in SQL scripts loaded by the source command to be processed
through
mos [EMAIL PROTECTED] wrote on 03/23/2005 12:04:59 PM:
I have a compiled application that accesses a dedicated MySQL 4.1.1
server
with MyISAM tables on Win XP. For some reason when the application is in
a
loop doing simple single table Select statements, the MySQL server after
48
But you can use column aliases in a HAVING clause (a simple mistake when
you are typing as fast as you are thinking). The other option is to put
the CONCAT(...) into the WHERE clause in place of the alias. Either way,
you will absolutely NOT be using an index to search that table. You will
Z X C V [EMAIL PROTECTED] wrote on 03/21/2005 08:32:24 PM:
Hello,
Are there any good rfcs or other documents that would assist in the
discussion I'm having with our organization's Oracle programmers in
regards the following:
Oracle DB - MySQL
They recommend:
~ col~col ~col~
Stembridge, Michael [EMAIL PROTECTED] wrote on 03/22/2005 10:30:50
AM:
A table exists with id and datetime columns; I need to SELECT records
from
the previous business day. I began with this:
SELECT id FROM table WHERE TO_DAYS(NOW()) - TO_DAYS(datetime) =1
But if NOW() is
Mike Rykowski [EMAIL PROTECTED] wrote on 03/22/2005 11:12:41 AM:
Hello,
I have historical dates in datetime format and they are in UTC. I'd
like
to convert them to localtime. Can this be done with mysql 3.23.22? It
looks like 4.1 can handle this, but I won't be upgrading in a while.
One problem with that formula is that it fails if you wrap around from one
year to the next. But as a quickie, it's good.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Peter Brawley [EMAIL PROTECTED] wrote on 03/22/2005 01:01:29
PM:
Michael,
Someone on the list
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 08:08:53 AM:
Dear friends
we have a problem here.
We have 3 tables
- table language (id int not null auto_increment primarykey,
languageName
tinytext)
- table country (id int not null auto_increment primarykey, defaultName
symbulos partners [EMAIL PROTECTED] wrote on 03/21/2005 10:25:27 AM:
I don't think so. You already have the country's name in it's own
language
on the countryToLanguage table, don't you? What name in which language
is
the defaultName column supposed to represent? If you can define what
Ben Clewett [EMAIL PROTECTED] wrote on 03/21/2005 11:36:45
AM:
Dear MySQL,
I have an application which need to wait for some data to change, then
act on this change.
I am polling the MySQL once a second using SELECT ...
I believe there is an alternate method where a thread can be
My reply below:
mel list_php [EMAIL PROTECTED] wrote on 03/21/2005 11:49:26 AM:
Hi,
Sorry for the late reply, out for the week-end!
Here is the information you asked for (I modified the columns' type as
you
suggested)
mysql show create table matches\G
*** 1. row
There is the UUID() function (added in 4.1.2).
http://dev.mysql.com/doc/mysql/en/miscellaneous-functions.html
However you cannot make a field's DEFAULT value a function (yet) so you
will need to use UUID() in your INSERT and UPDATE statements where
appropriate.
Shawn Green
Database
Responses embedded below
mel list_php [EMAIL PROTECTED] wrote on 03/18/2005 05:57:29 AM:
Hi Shawn,
Thank you very much, I'm impressed by the time you took to answer me,
and
the quality of the reply!!!
I forwarded the answer to my friend.
I'm wondering, I knew the mechanism of temporary
shaun thornburgh [EMAIL PROTECTED] wrote on 03/17/2005
06:46:22 PM:
Hi,
I have ( among others ) three tables in my database: Claims, Expenses
and
Mileage. A claim can contain many expense entries and many mileage
entries.
I am using the follwing query to show the total expenses and
mel list_php [EMAIL PROTECTED] wrote on 03/18/2005 10:35:30 AM:
Hi again,
Thanks for the explanation about the join and the group by.
I wanted to test your query (almost a simple copy/paste :-)) ).
The first 2 queries are ok, but the third one still is too long :
mysql CREATE
Eko Budiharto [EMAIL PROTECTED] wrote on 03/18/2005 11:54:09 AM:
Hi,
I am trying to to update one field with multiple value.
I tried with regulare update command syntax does not work. How to
update a field with multiple value.
regular update syntax is this, UPDATE variableInfo SET
For those of you watching but still not getting his point: He is saying
that QUOTE() improperly escapes a string where a \ and a ' appear together
in the unquoted text. the sequence \' should look like \\\' when
QUOTE()-ed. It should escape \ as \\ and ' as \'.\\+\' = \\\' .
QUOTE() seems
brian ally [EMAIL PROTECTED] wrote on 03/17/2005 02:28:46 PM:
I have 2 tables, category product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
Mahmoud Badreddine [EMAIL PROTECTED] wrote on 03/17/2005 03:16:47
PM:
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular
Gabriel PREDA [EMAIL PROTECTED] wrote on 03/16/2005 06:12:14 AM:
It looks from googling as though I need to drop all foreign key
constraints on this column, perform the change and then reestablish the
foreign keys. Could anyone confirm or advise of a better solution?
That is the way ! :)
You are confusing data retrieval with data presentation. Sure, SQL can do
many things to format data but some data formats are better achieved
through the programming language you are using to present this data for
viewing. In my opinion, the type of formatting you want to do is one of
those
sguazt sguazt [EMAIL PROTECTED] wrote on 03/16/2005 11:54:26 AM:
Hi!
From: Tom Crimmins [EMAIL PROTECTED]
To: sguazt sguazt [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: RE: Queries inside UDF
Date: Wed, 16 Mar 2005 10:09:16 -0600
...
Can you explain exactly what you are
I have a favorite technique for improving the results of queries , like
this, which involve fairly large JOINed tables. It's a form of
divide-and-conquer in that you pre-compute what you can then make the
JOINS you need to finish up the results.
I agree that the AND s2.syn LIKE '%' in the ON
Marco,
I think I understand why you might want the end date of your projects to
be dynamically calculated (assuming that's why you want this calculation
to be a UDF?). You would be able to change a starting date, the project's
duration, or add or delete a holiday and your ending dates would
Stembridge, Michael [EMAIL PROTECTED] wrote on 03/14/2005 02:18:25
PM:
I noticed another listmember used COUNT(fieldname) instead of COUNT(*).
Is there a noticeable performance increase with COUNTing a column name
instead of all columns? (ie, like SELECTing specific columns instead
of
Nick Zukin [EMAIL PROTECTED] wrote on 03/14/2005 05:22:38 PM:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the
vendors
and the products. There is
Crouch, Luke H. [EMAIL PROTECTED] wrote on 03/14/2005 09:34:02
AM:
This error message seems a bit different than others I have gotten.
it is from a ColdFusion server that uses an ODBC driver...
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost
Richard Lynch [EMAIL PROTECTED] wrote on 03/10/2005 05:13:09 PM:
Apologies if this comes through twice...
I *think* I fargled the To: the first time...
My boss is claiming that having multiple 1-1 tables, with an index on
the
keys, is better performance.
Example of his claim:
Steve Buehler [EMAIL PROTECTED] wrote on 03/11/2005 10:10:57 AM:
At 02:35 AM 3/11/2005, you wrote:
You can simply specify the database:
--replicate-do-db=db_name
Stupid/Not so Stupid question here. What mysql program has that option?
I
searched mysql.com and couldn't find it. I
Fan, Wellington [EMAIL PROTECTED] wrote on 03/11/2005 01:09:13 PM:
Hello MySQL'ers,
Is there a way to return a simple table of one-column, with *fixed*
output?
For example, I would like to return a one-column, 3-record table:
-
| value |
-
| 'a' |
-
| 'b'
Scott Haneda [EMAIL PROTECTED] wrote on 03/09/2005 08:51:43 PM:
Mysql 4, I have datetime field set of -00-00 00:00:00
Sampling of data I need to insert in is as follow:
12/26/04 13:35
12/25/04 12:41
12/25/04 8:53
How do a massage that to the proper format YYY-MM-DD HH:MM:SS
Daniel Dabner [EMAIL PROTECTED] wrote on 03/10/2005 08:18:31 AM:
Hi,
I have been trying to construct an SQL query joining two tables for an
image
gallery.
I want to display all the IMAGE_CATEGORIES along with the first image in
that category from the IMAGES table. The images are
Nico Sabbi [EMAIL PROTECTED] wrote on 03/10/2005 10:46:37 AM:
Hi,
the documentation reads:
REVOKE /|priv_type|/ [(/|column_list|/)] [, /|priv_type|/
[(/|column_list|/)]] ...
ON {/|tbl_name|/ | * | *.* | /|db_name|/.*}
FROM /|user|/ [, /|user|/] ...
REVOKE ALL PRIVILEGES, GRANT
Brett Harvey [EMAIL PROTECTED] wrote on 03/10/2005 01:24:54 PM:
I have a query that worked just fine in Mysql 3.x and 4.0. It no
longer works in 4.1. I receive the The SELECT would examine more
than MAX_JOIN_SIZE rows; check your WHERE and use SET
SQL_BIG_SELECTS=1 or SET
John Nichel [EMAIL PROTECTED] wrote on 03/08/2005 04:40:00 PM:
Hi all,
I have a table which contains amoung other things, search terms used on
our web site. What I'm trying to do is select the count of distinct
search terms in one query. I think this is possible, but I can't seem
to
news [EMAIL PROTECTED] wrote on 03/05/2005 04:21:26 PM:
Probably a real n00b question.
I am writing a simple contact management database with MySQL (version
3.23.49-8.9, Debian Woody). I'd like users to be able to enter the
first
few characters of a contact's name to do a search, and
I agree with Greg, your data structure may be getting in your way. It's
more normalized to make a list of values into rows of values, not into
lots of columns.
I may have had a similar design problem as you are facing. I have to deal
with LOADS of laboratory analysis data (lots of data points
Dave Kennedy [EMAIL PROTECTED] wrote on 03/06/2005 05:09:36 PM:
SELECT sum(col1) AS total1
FROM t1
GROUP by col1
SELECT col1, sum(col2) AS total2
FROM t2
GROUP by col2
Table t1 contains 4 rows to sum for each value in col1
Table t2 contains 8 rows to sum for each value in col2
Scott Purcell [EMAIL PROTECTED] wrote on 03/07/2005 04:29:18 PM:
Hello,
I am working with a traditional database pooling class basically
putting connection objects into a Vector. When I run the code from
a main, it appears solid. I have run 10s of thousands of back to
back queries and
Scott Purcell [EMAIL PROTECTED] wrote on 03/07/2005 04:59:27 PM:
Thanks Sean,
I am using standalone Apache/Tomcat 4.1.31
mysql \s
--
mysql Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
Connection id: 184
SSL:Not in use
Server version:
MrExecutive [EMAIL PROTECTED] wrote on 03/04/2005 01:12:02 PM:
Hello Guys,
I am a newbie to mySQL and im trying to export my database via the
mySQL Command line but i cant seem to find any good documentation on how
to do this. More articles are telling me to use phpAdmin or some
Scott Purcell [EMAIL PROTECTED] wrote on 03/04/2005 01:42:40 PM:
UPDATE menu_sequence SET id=LAST_INSERT_ID(id+1);
I am writing some code that I need to actually get the menu_sequence
from above, store it in a variable and then do a increment. I do
not know why I am having trouble with
H Ba [EMAIL PROTECTED] wrote on 03/03/2005 02:14:57 PM:
I have multiple tables set up and need to export these to csv in
order to import them into Excel. Since all tables are related to
each other and I can only export one at a time, is there a way to
somehow get a readable file after
Jonathan Mangin [EMAIL PROTECTED] wrote on 03/03/2005 02:38:54
PM:
Hello,
Does this mean a key is not being used?
mysql explain select vl_ts from view_log where vl_uid='bb';
+--+--+---+--+-+--+--
++
| table| type |
Rich Allen [EMAIL PROTECTED] wrote on 03/03/2005 04:28:07 PM:
iH
i have a database that i only have READ access to (i am not the
creator). there are tables with stats data that are created each day;
ie data3_1_2005 and 'data3_2_2005. each table has the same layout.
create table
shabanip [EMAIL PROTECTED] wrote on 02/25/2005 03:21:10 AM:
which version of mysql has more features?
Payam Shabanian
[EMAIL PROTECTED]
Have you had no luck understanding the information that starts here?
http://www.mysql.com/products/
If you tell us specifically which features you are
Joppe A [EMAIL PROTECTED] wrote on 03/01/2005 02:21:31 PM:
Hello all,
I have I small problem I wonder if there is a easy solution for..
I have a SQL-query where I count out how many users per n_id I
have. it is a little tricky because I had to do a left joint and
compare two tables to
Don Huff [EMAIL PROTECTED] wrote on 03/01/2005 02:33:34 PM:
Hi,
I am wanting to write a nesting of queries without having to
retrieve all the records of the first query (because of the volume).
pseudo code, using MySQL 5. alpha/PHP mysqli C connector
res1 = query(db, sql1,
Chris Knipe [EMAIL PROTECTED] wrote on 02/28/2005 11:53:14 AM:
Hi,
Is two-way replication possible with MySQL 5.x? Any good sites / docs
describing this type of setup?
--
Chris.
By two-way replication, do you mean changes to either database are
synchronized to the other? This is
(response NOT top-posted. see below...)
Dale Roddy [EMAIL PROTECTED] wrote on 02/24/2005 05:40:22 PM:
I am new to MySql. I have a query with a subselect that is running
very slow (28 seconds).
SELECT *,MATCH(title, descr_part) AGAINST (Project Manager IN
BOOLEAN MODE) AS score
FROM
Tom Cunningham [EMAIL PROTECTED] wrote on 02/24/2005 11:31:31 AM:
It appears you can't combine an insert-select with an
on-duplicate-key-update.
I would find it very useful if you *could* do this. I know it would be
complicate how you would handle the syntax for what to do when you hit
a
David Blomstrom [EMAIL PROTECTED] wrote on 02/24/2005 04:10:17
PM:
Oops, I guess I added wrong.
Nevertheless, unrestricted linking to database tables
with no keys would increase loading time, right? Is
there some way to gauge the effect, other than
tweaking all my scripts and tables and
Jim McAtee [EMAIL PROTECTED] wrote on 02/24/2005 04:50:11 PM:
Say a row is inserted into a table with an auto_increment column and
then
deleted before another record is inserted. When a new row is inserted,
will the value of the auto_increment column be the same as the deleted
record's,
(forwarded to the list)
- Forwarded by Shawn Green/Unimin on 02/23/2005 09:08 AM -
[EMAIL PROTECTED] wrote on 02/22/2005 04:59:39 PM:
Regardless of the Mysql angle - a windows editor that allows you to
view large text files is an absolute necessity. Notepad tries to
load the
Rene Churchill [EMAIL PROTECTED] wrote on 02/22/2005 09:21:29 AM:
Good evening folks, I'm seeing some odd behavior in MySQL 4.0.21
running on Mac OS X 10.3.7
I'm trying to compare two identical tables and find the rows
that are new/modified. I can't use a timestamp column because
the new
Begumisa Gerald M [EMAIL PROTECTED] wrote on 02/22/2005 02:03:43 AM:
Hi,
I'm writing an application that uses InnoDB tables to provide
transactional integrity. The front-end is a web-based interface.
I'd like to know - is there a way one can issue a query to test whether
a
particular
Crouch, Luke H. [EMAIL PROTECTED] wrote on 02/22/2005 12:18:51
PM:
what is the limit to the number of records that can be inserted via
an extended insert statement. I know mysqldump creates a new insert
statement every X records, but I forgot what that number is, and I'm
trying to
Martijn Tonies [EMAIL PROTECTED] wrote on 02/21/2005 10:20:28 AM:
Hi,
why not try:
SELECT COUNT(s.Id)+COUNT(se.Id)
FROM subs s
INNER JOIN subs_erased se ON s.Id=se.Id
WHERE s.Id=1;
/Johan
This won't return the same result if there's no entries
in subs_erased for the ID =
Jim Grill [EMAIL PROTECTED] wrote on 02/18/2005 03:17:39 PM:
Hi,
I need some SQL guru help on this one.
I'm trying to re factor an existing application where a number of clicks
grouped by keyword for two different time periods are needed. For
example, a user picks a date range and
Gerald Taylor [EMAIL PROTECTED] wrote on 02/18/2005 10:18:29 AM:
I have a database thats full of ingredients that are placed in various
categories. and then there are mixtures that are allowed to
be labelled with a certain grade based on the quality and
composition of the ingredients it is
phpninja [EMAIL PROTECTED] wrote on 02/22/2005 03:37:37 PM:
I have a small question. Whenever I try to dump a sizeable Innodb
table, lets say 33,000,000 records I find that mysqldump cannot handle
that kind of load and usually freezes. I am not sure if it is my
system, as its only a pentium 4
801 - 900 of 1587 matches
Mail list logo
