the same session if it wants to. If you need a stable sort every
time, you'll need to add another column to your ORDER BY clause. `id` might
be a good choice (since it's your primary key for that table), or
credential_id (since you're using that in your WHERE clause already).
--
Dan Nelson
url with the one you want to insert.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
queries that cover all shows if
you want to generate summary reports.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
/doc/refman/5.5/en/adding-udf.html
As for debugging, you should be able to write things to stderr which will
show up in the mysql logfile, or you could open your own logfile and write
to that.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives
2,3,1,20,9
19 john 20,9
75 mark 1,20,9
You want GROUP_CONCAT:
http://dev.mysql.com/doc/refman/5.5/en/group-by-functions.html#function_group-concat
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
),from,to), though, at the expense of having
your result string lowercased on you. If you need to preserve case, try the
stored function at http://forge.mysql.com/tools/tool.php?id=135 .
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http
-DWITHOUT_SERVER=1 ; it's not documented, but matches the autoconf
--without-server flag, which was documented.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub
the
server restarts, it will fall back to whatever you have set in my.cnf, or
the default value if you don't have anything in my.cnf.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Display output in table format. This is the default for interactive
use, but can be used to produce table output in batch mode.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
In the last episode (Oct 16), Kailash R said:
Nice input Dan. Let me run some checks. My query is as follows:
select group_concat(Field1), field2, field3 from table1 group by field2,
field3 into str;
@sql = concat(select blah ... where field1 in ' ,str);
prepare stmt from @sql;
execute
long strings with no problems, at least:
mysql set @a=repeat('a',1024*1024*10);
Query OK, 0 rows affected (0.95 sec)
mysql select length(@a);
++
| length(@a) |
++
| 10485760 |
++
1 row in set (0.05 sec)
mysql
--
Dan Nelson
dnel
some tables to open others.
http://dev.mysql.com/doc/refman/5.5/en/not-enough-file-handles.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
to scan a 3.5 million entry table instead of a 20,000 entry table.
Can you post the EXPLAIN EXTENDED output for your before and after queries?
also, have you recently run an ANALYZE TABLE on the tables?
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list
first, then the format string.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
()) |
+--+
| 6faefaf3f7bb9ba0d1e7a44cf6a9b1da |
| 740135ab69a1825630aeaf475b39f8b8 |
| 5c91a9132ad3e49e098e41d573de8e00 |
+--+
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
is simply the maximum
allowed size.
http://dev.mysql.com/doc/refman/5.5/en/char.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
. If not, you'll need to bounce mysql.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
In the last episode (May 12), Halßsz Sßndor said:
2011/05/12 13:06 -0500, Dan Nelson
In the last episode (May 12), Rocio Gomez Escribano said:
I found it,
mysql select userID from user where datediff(now(), userPaymentDate) 365;
This can be made more readable by using mysql's
,
so if you have an index on that column mysql can use it:
select userID from user where userPaymentDate (now() - interval 1 year)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
]]/NETWORK_ID/NICRANK![CDATA[-
RUNNING_VMS]]/RANKREQUIREMENTS![CDATA[CLUSTER =
kvm]]/REQUIREMENTSVCPU![CDATA[1]]/VCPUVMID![CDATA[713]]/VMID/TEMPLATE
|
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
by
an optional semicolon terminator, but the short form should not.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
between your two
mysql commandlines it won't be noticed.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On 2011-1-16 20:22, Jørn Dahl-Stamnes wrote:
Hello,
I got a table that store information about which photo-albums that a client is
viewing. I want to get the N last visited albums and use the query:
mysql select album_id, updated_at, created_at from album_stats order by
updated_at desc limit
time to
run, run some show processlist commands and see if there are any INSERT or
UPDATEs running.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
| 5 |
| 10 | 7 |
| 10 | 11 |
+--+-+
, then your original query would work the way you expected.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
|
+-+-+
1 row in set (0.00 sec)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
switched the default to innodb_file_per_table=on, but
if you are running any older version, you will need to set that value in
your config file.
http://dev.mysql.com/doc/refman/5.1/en/multiple-tablespaces.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
the
penalty you pay for supporting transactions and concurrent read/write
access, and for switching to an index-organized table.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
try it on InnoDB. MySQL 5.5 is supposed to have a lot
of concurrency improvements in; can you test your application on that and
see if it's any faster than 5.0?
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
|
++
4 rows in set (0.00 sec)
TIA,
Victor
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
http://dev.mysql.com/doc/refman/5.1/en/innodb-physical-structure.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
in set (0.00 sec)
mysql
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
situation
You could use a trigger that updates C whenever A or B changes, to make sure
it stays in synch.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
sec)
what goes with this, how can i ensure that this is NULL?
Your url may be the empty string . If it was really NULL, you would see
NULL in the resultset. Try
SELECT * FROM product WHERE url=
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list
(32GB for
example), running LOAD INDEX INTO CACHE for your index, then running show
status like 'key_blocks_used'; .
http://dev.mysql.com/doc/refman/5.1/en/load-index.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http
for the filesystem as a whole.
In `vmstat` output, I thought bi is in terms of fixed-size blocks, not
I/O commands.
It looks like on Linux, bi and bo are the total disk throughput in
kbytes.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http
In the last episode (Jul 27), Dan Nelson said:
In the last episode (Jul 27), Mike Spreitzer said:
If I want to try to actually hold a 2GB table in RAM, is there anything I
need to set in my.cnf to enable that?
Just make sure your key_buffer_size is large enough to hold the index. You
the fldrcv table ... so why is it taking so
long to do this join to make the fldpar table?
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
:)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Another solution might be to create another index on (c1,c2), since that
index is the most efficient one for your particular query. MySQL will
always pick that index over the other two.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http
= replace(column, regex '%-%', ' ') where id = xxx;
You don't need a regex for that. REPLACE(column, '-', ' ') should do what
you want.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
to see is zeros, meaning that for some
reason your mysql connection is getting dropped after your first query
completed. Locks are held for the lifetime of a connection, so if you
disconnect, your lock disappears.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing
and no index on
work_data...
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, b.frm,
b.MYI, b.MYD, etc, then run show create table a etc to determine the
table layout and match them up to known mythtv tables.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
authentication. It's all done with hashed versions. You'll probably have
to cache the original password used to make the connection, if you need to
use it again later.
http://dev.mysql.com/doc/refman/5.1/en/password-hashing.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General
#option_mysqld_safe_syslog
Next best solution:
tail -F -n 0 /path/to/mysql.err | logger -p daemon.notice -t mysql
Run that before starting mysql, and any lines written to the log file will
get redirected to syslog.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
a simple code fragment to print a resultset on this page:
http://dev.mysql.com/doc/refman/5.1/en/mysql-fetch-row.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
It works great for me. After working out the bugs and adding the spatial
index I am now searching in the 0.05 second timeframe vs. minutes
otherwise.
Dan
On Sun, 2 May 2010 23:39:41 -0700, Rob Wultsch wult...@gmail.com wrote:
On Sat, May 1, 2010 at 11:12 PM, dan d...@tappin.ca wrote
a specific point.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
data.
Dan
On Sun, 2 May 2010 06:43:13 -0700, Ted Yu yuzhih...@gmail.com wrote:
I think you may have seen this:
http://dev.mysql.com/doc/refman/5.0/en/relations-on-geometry-mbr.html
On Sat, May 1, 2010 at 11:12 PM, dan d...@tappin.ca wrote:
Can any one help me with understanding
101.36211395) |
+---+
But after my UPDATE my poly column is still full of NULL values.
Dan
On Sun, 2 May 2010 13:34:14 -0400, Baron Schwartz ba...@xaprb.com
of PolygonFromText ?
On Sun, May 2, 2010 at 10:59 AM, dan d...@tappin.ca wrote:
I am still lost... I tried this:
UPDATE `grid` SET poly = PolygonFromText(CONCAT('POLYGON(',n,' ',e,',
',s,'
',e,', ',s,' ',w,', ',n,' ',w,', ',n,' ',e,')'));
I had my delimiters mixed up and I know my
14:00:16 -0700, Ted Yu yuzhih...@gmail.com wrote:
Have you declared poly to be of spatial type ?
Cheers
On Sun, May 2, 2010 at 1:03 PM, dan d...@tappin.ca wrote:
Tried it but no luck:
mysql UPDATE `grid` SET poly = GeomFromText(CONCAT('POLYGON(',n,'
',e,',
',s,' ',e,', ',s
need to figure out the rest of it...
Dan
On Sun, 2 May 2010 14:00:16 -0700, Ted Yu yuzhih...@gmail.com wrote:
Have you declared poly to be of spatial type ?
Cheers
On Sun, May 2, 2010 at 1:03 PM, dan d...@tappin.ca wrote:
Tried it but no luck:
mysql UPDATE `grid` SET poly
On Sat, 01 May 2010 15:28:46 -0500, mos mo...@fastmail.fm wrote:
SELECT * FROM `grid`� force index(section) WHERE n 49.012 AND s
49.012
AND e
110.0244 AND w 110.0244;
It should give you the answer around 0.1 seconds. Give it a try. :-)
Mike
It actually makes it worse
the specific area that the point is located in.
I tried a simple index with my n,e,s w but it still takes along time to
run such a query i.e. phpmyadmin times out. Any idea on the best structure
for such a query?
Thanks,
Dan T
--
MySQL General Mailing List
For list archives: http
an average of 15 seconds
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
products, even if they are the 10 newest
records in the table.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
if there are other SELECT
statements pending.
http://dev.mysql.com/doc/refman/5.1/en/delete.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
PRIMARY KEY)
ENGINE=InnoDB; Query OK, 0 rows affected (0.20 sec)
Yup, that was it. I'm migrating from Postgres, so it never occured to me
that lines might be reserved.
On the plus side, you can now use the word vacuum :)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL
and they all live just fine without swap.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, and as your number of concurrent readers and
writers grows, the improvement in performance from using innodb over
myisam becomes more pronounced.
His scenario is perhaps updated once a year, though, so crash recovery and
multiple writer performance is not important.
--
Dan Nelson
doesn't provide binaries, but the FreeBSD ports tree lets you build it
yourself, and has ports for MySQL 3.23, 4.0, 4.1, 5.0, 5.1, and 5.5.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
have to worry about
that.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
* from t1 where ordno=' '
ordno qty
'aaa' 18
'b' 20
mysql version 5.1.44 still with the bug
Best regards!
Shuming Wang
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
|
+---+
| |
| |
| |
| 000 |
| abc |
+---+
5 rows in set (0.00 sec)
mysql
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
treat subqueries as dependent, even ones that are
obviously not. The 6.0 branch was a significant improvement, but that
branch has been killed off, and there's no indication of the fixes being
backported to 5.x .
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
- Win, Windows Scripting Host, MySQL
WTM - Win, Tomcat, MySQL
...
Are there other stacks on MS that you have heard of or are using?
WWJD - Windows, Websphere, Java, Derby? :)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http
will also fire the same whether the server is
running Unix or Windows.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
with queries A and B.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
,cCurstatus,cMmrcashworker,cHospital,cHospital1,cHospital2
FROM med_patient WHERE updateDate between '2010-01-01' and '2010-01-28'
order by id desc
and verify that the other fields in your WHERE clause have the values you
think they do.
--
Dan Nelson
dnel...@allantgroup.com
this as two separate
queries. One for the 'inner' select to get an array of orderID and then
shove those back into the 'outter' query using PHP's implode() or
something. I suspect this would be significantly faster no?
IN() using constants should be very efficient.
--
Dan Nelson
#sysvar_open_files_limit
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_table_open_cache
http://dev.mysql.com/doc/refman/5.1/en/table-cache.html
http://bugs.mysql.com/bug.php?id=17646
http://bugs.mysql.com/bug.php?id=24509
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL
.
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
#function_group-concat
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
need to do one disk seek per lookup). Next
best would be enough to cache all but the leaves of the index (requiring one
index and one table seek per lookup); this depends on your key size but
200MB should be enough.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing
logfile (in your
data directory, it's the only file ending in .err). I don't think any of
the storage engines keep track of when the last analyze was done, though.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
);
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
//
DELIMITER ;
CREATE TABLE `products` (
`id` int(11) NOT NULL auto_increment,
`description` text collate utf8_bin NOT NULL,
`daily_charge` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;
Thank you in advance.
Dan
CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;
- michael dykman
On Sat, Oct 17, 2009 at 2:20 PM, Dan Saul daniel.s...@gmail.com wrote:
This is the first time I have attempted to expand beyond basic sql for
storing data in a table like structure. So my level of knowledge is
familiar
include the table name, so if you're loading into a
different table, you'll need to rewrite the output with sed, or maybe create
a select * from oldtable view on your first server that matches the table
name on the second server, so your table names match.
--
Dan Nelson
dnel
data into RAM, which
makes for much faster lookups on the next run. What do top and iostat stats
show on both runs? I'd expect heavy disk usage and little CPU on the first
run, and light disk and heavier CPU usage on the second.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL
be a drawback here, if it's more at the
operational level of old Berkely DB 1.x-style databases (where one has to
manually maintain the index, there are no transactions, etc). SQL-based
databases sit on top of the lower-level table engines and handle all that
work for you.
--
Dan Nelson
is in mm/dd/yyy format, you would want a
format string of %m/%e/%Y %r.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
-physical-record.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
?
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
code 145: Table was marked as crashed and should be repaired
$
You need to repair your table:
http://dev.mysql.com/doc/refman/5.1/en/repair.html
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
in your own table might be the best
solution.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
on r.comm_id = c.Comm_id
where
recordtype = INDIVIDUAL
and c.party = D
and r.amount = 1
Returns 294 records.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
| |
++-+--+--+---+-+-+---+--+---+
1 row in set (0.01 sec)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
it using the index?
Yes.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to the table rows to fetch result_id). If you also add result_id to your
compound index, then mysql will be able to get all its information from the
index without having to go to the table at all.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives
IF;
END;
I have my idea of a trigger above that for obvious reasons wont work ,
however describes what im trying to do best!
Im monitoring a value status and if it changes id like to insert a record
into a entirely separate table in a separate DB.
insert into smsgw.outbox [...]
--
Dan
);
SET NEW.AcctOutputOctets=(0 - NEW.AcctOutputOctets):
END IF;
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
does not end although complied with
LINUX_THREADS.
Try building without LINUX_THREADS; that option shouldn't really be used
with FreeBSD 6 or newer.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
('8',numbers);
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_find-in-set
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
In the last episode (Jun 30), Dainis Polis said:
Hi MySQL fans!
Is there way to create subj ?
http://dev.mysql.com/doc/refman/5.1/en/adding-functions.html
http://dev.mysql.com/doc/refman/5.1/en/adding-udf.html
http://dev.mysql.com/doc/refman/5.1/en/udf-aggr-calling.html
--
Dan
of create table user, a sample query, and its EXPLAIN output.
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
). The first query uses the ename index and estimates it will
return one row. The second query uses the mgr index based on the empno
value returned by the first query and estimates it will return 2 rows. Much
better :)
--
Dan Nelson
dnel...@allantgroup.com
--
MySQL General Mailing
1 - 100 of 2033 matches
Mail list logo
