Filter-fodder: mysql, query
Ah. Sorry about that.
Given a query:
"SELECT academic_institutions.name,
academic_institutions.town, countries.abbrv,
inst_types.name, academic_institutions.acinstid
FROM academic_institutions, inst_types
LEFT JOIN countries ON academic_instituti
Filter-fodder: mysql, query
Hi,
How can I avoid "Using temporary, "Using filesort"
when creating indices when my selects MUST be ordered?
Donna
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
filter-fodder: mysql, query
Hi,
I have a persistent connection.
but when a query fails for whatever reason,
( eg. user doesnt have permission to delete a row )
I lose the connection.
HOW can I stop this happening, and WHY is it happening?
Donna
-
filter fodder: sql, query
Hi,
Hope someone can help with this.
I have a table subjects:
qsid smallint ...
name varchar(60)
The table contains eg.
Mathematics
English
Biology
... ...
I also have a table vx_students:
vxid smallint ...
pri_qskey smallint not null default 0
sec_subj smal
Filter fodder: query, sql
On Wednesday 21 August 2002 3:03 am, Nathaniel Mallet wrote:
> I haven't read Managing and Using MySQL, but I do own (and read cover to
> cover) MySQL and mSQL. While it's not a bad book, it's definitely not
> for anyone wanting to do anything serious. It's about 460 pag
Filter fodder: mysql, query
Hi,
I think the O'Reilly books
- Managing and Using MySQL
- MySQL and mSQL
and _very_ good.
and if you want a real tome, then try
- Mastering SQL, by Martin Gruber, pub. by SYBEX
Donna
On Tuesday 20 August 2002 3:40 pm, John Gruber wrote:
> Actually... Jay Greenspan
Course, you could just be v. nice to me - I made it into separate pages in 2
frames for much the same reason. :-)
donna
( v. 3.23.34)
On Friday 16 August 2002 9:21 pm, Frank Shute wrote:
> I'm using 3.23.51 and I wondered if the manual was available as
> separate pages of html in a tarball.
>
>
This solution worked really well for me:
www.cynergi.net/exportsql/
Donna
On Friday 16 August 2002 6:48 pm, Oladejo, Tokunboh wrote:
> Hi All,
>
> Does anyone knows of any easy way/short cut of exporting Microsoft access
> tables into MySql database.
>
> Thanx
> All
>
>
filter fodder: sql, query
Hi all,
I feel like I am probly being amazingly stupid, but here goes nothing.
I have 3 tables:
"students"
"undergrads"
"postgrads"
"students" holds all common info. eg dt_matric, dob, religion, etc.
undergrads hold eg. degree, subject
postgrads holds eg. transfer_dat
[filter-fodder: sql, query]
Hi,
I am having trouble finding differences.
Table1 holds the current data, and Table2 holds the updates.
I need to query the two and find ONLY the rows showing the current+updates.
Table1:
TABLE dttunes (
id smallint(5) unsigned NOT NULL auto_increment,
danceid sma
FilterFodder: sql, query
Yo Jeremy,
On Sunday 05 May 2002 9:31 pm, Jeremy Zawodny wrote:
> That one isn't fixed as easily. ...
> You might be able to use a BETWEEN query:
(eyes raised to heaven, hands clasped in prayer)
o jeremy you are my hero!
(grin)
seriously, thanks a lot, i really apprec
Hi Jeremy,
On Sunday 05 May 2002 5:52 am, Jeremy Zawodny wrote:
> REGEXP queries don't use indexes. Change the:
> REGEXP "^A"
> to
> LIKE "A%"
> and it'll use the index and give you a nice speed boost.
which indeed it did! I checked the manual (yet again) and it doesn't actually
say anythin
filter-fodder:
Hi,
I am trying to speed things up a bit by indexing, but am having a bit of
trouble.
Take two tables:
TABLE dances (
danceid smallint(5) unsigned NOT NULL auto_increment,
ddref smallint(5) unsigned NOT NULL default '0',
has_desc enum('T','F') NOT NULL default 'F'
Hi,
Hope you don't mind me hassling you about this yet again.
>> ... So you would need to run two queries, a LEFT JOIN and a
>> RIGHT JOIN (or a LEFT JOIN with tables swapped) to get all
>> results.
> ... ... which is what I did in the end.
except that on further checking it doesn't work!
T
Hi,
I am using MySql Ver ll.15 distrib. 3.23.41
I want to write an sql query something like:
update ddata
set ddata.pubkey = pubdata.pubkey,
ddata.title=pubdata.title
where ddata.dkey=pubdata.dkey;
This generates an error:
ERROR 1109: Unknown table 'pubdata' in where clause
and using thi
Hi,
I am sure this is an old chestnut, but a web search has revealed no answers.
I have:
table pubdata (
dkey smallint(5) unsigned NOT NULL default '0',
pubkey smallint(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '' )";
table ddata (
dkey smallint(5) unsigned NOT NULL
Hi,
I am sure this is an old chestnut, but a web search has revealed no answers.
I have:
table pubdata (
dkey smallint(5) unsigned NOT NULL default '0',
pubkey smallint(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '' )";
table ddata (
dkey smallint(5) unsigned NOT NULL
> 1. I found I had a RPM Install of PHP and a compiled version. (Off my book
> cdrom)
:-(( happened to me 2
> 4. I want to start from scratch but don't want to have to re-format
nah. you've rpm -e'd the rpm. I had to build from scratch to compile mysql +
php in as I couldn't find an off-the-she
> Guten Tag Donna Robinson,
Hi 2u2 sir!
and god bless your cotton socks.
> i hope this will help you..
...
it didn't but it gave me enough of a clue so that this did:
select dancedetails.coupletypes.*
from dancedetails.coupletypes
left join dancedata2.couples
on dancedetails.coupl
Hi,
I am going nuts!
I am querying two databases which are very similar to find the differences
between various tables.
These two tables are 15 rows and 14 rows respectively.
Why does this work (finds all similar rows):
select ddetails.name, ddata.name
from dancedetails.coupletypes as ddetails,
Hi,
I am using OpenBSD 2.8 and spent a frustrating evening last night trying to
make MySql come to heel. Installed just fine - the first sign of something
not right was inability to complete the "run-all-tests" scripts - just hung
there gobbling up 95% CPU.
Gave up on that eventually, and tr
21 matches
Mail list logo