I think I'll just make a nightly process run that drops and then recreates the
table, unless someone has a workable idea of how to make this view query-able.
Thanks!
Jim McNeely
On Aug 23, 2012, at 2:06 PM, James W. McNeely wrote:
> This didn't help, but good try!
>
> Jim McNeely
>
> On Au
mysql> update student t1, student t2
-> set t1.gpa = t2.gpa
-> where t1.id=5 and t2.id=1;
Query OK, 1 row affected (0.36 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> select * from student;
+++--+
| id | name | gpa |
+++--+
| 1 | Bob | 4.0 |
|
This didn't help, but good try!
Jim McNeely
On Aug 23, 2012, at 12:27 PM, Martin Gainty wrote:
>
> If memory serves predicates convert strings to column-data-type (in your case
> DATE) this *should* help
> WHERE dateexam = STR_TO_DATE('2012-08-13','%Y-%m-%d')
> does this help?
> Martin
> ___
Thanks for the responses to everyone! Here is the result for the explains.
view query=
explain select * from admin_exam_view where dateexam = '2012-08-13';
++-+---+--+-++-+++
Consider two rows with id m and n in a table tb with a column cl,
what's the sql command to set the value of cl in row n the same as
that in row m?
Below is my testing
mysql> desc student;
+---+--+--+-+-++
| Field | Type | Null | Key | Defau
On Thu, Aug 23, 2012 at 11:30:17AM -0700, James W. McNeely wrote:
> I am working on a view based on this query:
>
> ===
> SELECT
> -- Patient Info
> p.IdPatient,
> p.IdLastword MRN,
> p.NameLast,
> p.NameFirst,
> p.Addr1,
> p.Addr2,
> p.AddrCity,
> p.AddrS
That is an example of where VIEWs screw up optimizations.
Rumor has it that 5.6.6 might have improvements.
Probably inefficient:
ON CONCAT(e.IdAppt , '0') = c.IdApptType
p might benefit from
INDEX(AddrState, DateOfBirth)
SHOW CREATE TABLE (for each table)
EXPLAIN SELECT (with and without VIE
On 8/23/2012 2:30 PM, James W. McNeely wrote:
I am working on a view based on this query:
===
SELECT
-- Patient Info
p.IdPatient,
p.IdLastword MRN,
p.NameLast,
p.NameFirst,
p.Addr1,
p.Addr2,
p.AddrCity,
p.AddrState,
p.AddrZip,
p.Gender,
p.DateOfBirth,
-- Provi
If memory serves predicates convert strings to column-data-type (in your case
DATE) this *should* help
WHERE dateexam = STR_TO_DATE('2012-08-13','%Y-%m-%d')
does this help?
Martin
__
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentia
On Thu, Aug 23, 2012 at 8:08 AM, Larry Martell wrote:
> On Tue, Aug 21, 2012 at 8:26 PM, Larry Martell
> wrote:
>> On Tue, Aug 21, 2012 at 8:07 PM, wrote:
>>> 2012/08/21 16:35 -0600, Larry Martell
>>> I am trying to write a query that selects from both a correlated
>>> subquery and a
That is in fact a very interesting approach... I like it very much. Any
architectural thoughts on an auto-population attempt? Odly I have not created a
db like this before, not from this large of an import anyway... Please share
some thoughts there and I will get that rolling... seems that if w
I am working on a view based on this query:
===
SELECT
-- Patient Info
p.IdPatient,
p.IdLastword MRN,
p.NameLast,
p.NameFirst,
p.Addr1,
p.Addr2,
p.AddrCity,
p.AddrState,
p.AddrZip,
p.Gender,
p.DateOfBirth,
-- Provider Info
af.IdAffil,
af.PractName,
af.O
I apologize for my assertion that system requirements do not appear on the
website.
In retrospect, that was silly of me to assert ANYTHING is not on ANY WEBSITE
anywhere.
What I should have said (hinted at in my last sentence) is that system
requirements are not PROMINENTLY listed on the websi
Shawn and Garot
I like the parsing capability of the lucene and its ability to stem incoming
queries..
If you are able to start populating your data then we *should* be able to start
identifying which root terms we can pull for building lucene-indexes
I have an upcoming
stuck-in-JFK-airport-on
Hello Gael,
The technology is brand new and you'll need to ask them the question.
Parallel Universe has no hardware dependencies (it'll need multi core/CPU
server only if you enable parallel processing).
Hope this helps,
Hiromichi
- Original Message -
From: Daevid Vincent
To: 'Gael Ma
just a few thoughts (things to look into)
if you want to populate a db with command parameters, i'd mine the man
pages. it's a consistent format and you should be able to find a
parser for whatever language you prefer.
if you want to see what has been entered and statistics about that
process, lo
On Tue, Aug 21, 2012 at 8:26 PM, Larry Martell wrote:
> On Tue, Aug 21, 2012 at 8:07 PM, wrote:
>> 2012/08/21 16:35 -0600, Larry Martell
>> I am trying to write a query that selects from both a correlated
>> subquery and a table in the main query, and I'm having a lot of
>> trouble gett
Hi!
It is not correct. System requirements are published on the website:
http://www.sqlmaestro.com/products/mysql/phpgenerator/help/00_04_00_system_requirements/
Sincerely yours,
The SQL Maestro Group Team
http://www.sqlmaestro.com
- Original Message -
From: "Jan Steinman"
To:
Sent:
18 matches
Mail list logo
