t the name for the Proposer, but I
>can't think of a way to make it work!
>
> Any help would be appreciated. :)
>
> Regardez,
>
> Michael Carter
> Pilot/Programmer
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
--
herswise shows null in fieldvalue
>
> please help
>
> __
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
--
ed DESC;
> +-+
> | UID |
> +-+
> | 255 |
> +-+
> 1 row in set (0.11 sec
>
> I've already worked around this, I'm just letting you guys know.
>
>
> >Fix:
>
--
John Ragan
[EMAIL PROTECTED]
http://w
cribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> --
> - Visit me - http://www2.ebtech.net/~nlamoure/index.htm
> - Information Sarnia Lambton - http://www.informsarnialambton.org
> - Sarnia Computer Users' Group - http://www.sarnia.com/scug
> - Lawrence
; there would be a way to export the data.
> Any ideas?
>
> Steve Jackson
> Web Developer
> Viola Systems Ltd.
> http://www.violasystems.com
> [EMAIL PROTECTED]
> Mobile +358 50 343 5159
>
>
--
;
> However, the size of tables remain same as after
> insertion made.
>
> Q: How come the size of table does not decrease
> after deletion?
>
> Thank you. And regards,
>
>
> Pae
>
> P.S.: MySQL, S
Any input?
>
> ---
> Rodney Broom
> President, R.Broom Consulting
> http://www.rbroom.com/
>
> sql
>
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
-
Before posting, please
ysql server? I use Visual Basic for accessing mysql server.
>
> Thank You very much
> Bruno
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
-
Before posting, please check:
http://
delete to the tables
> are so slow compared with the former MS Access ODBC connection.
> COULD U TELL ME HOW TO FIX THIS?
>
> thanks a million!!
> weiwei
>
>
>
>
--
John Ragan
ODBC Drivers (0x80040E21)
> ODBC Drivers can't support this attribute
> /upload.asp, line 7
>
>
> I want to know what is the problem.
> I have the Mysql 3.23.52-max-nt, ODBC2.50, windows XP and ASP.
>
> Can anyone help?
>
> Regards,
> luoya
>
>
> __
o learn more about queries and
if you have a windows box for a front end,
download corereader from http://corereader.com
it will let you quickly do and re-do join queries
just by clicking on your database objects, so you
can concentrate on developing logic without
worrying about syntax. when y
a
> couple of REAL beefy boxes with a couple of gig of ram a piece and have them
> store the recordset in a disconnected method, so once oracle is done tossing
> records its out of the loop completly.
>
> Right now using LO
ndows based web site
> using MySQL.
> >
> > I have used MySQL on Linux/FreeBSD for 3/4 years, but never
> on Windows.
> >
> > How does MySQL compare on Linux and Windows for stability
> and performance ?
> >
> > Simon
> > --
> > Simon Wind
some of my data is not shown.
> However when viewed from within a tool like PHP MYADMIN all the data is displayed
> correctly.
>
> Is this a bug or a limitation of mysql? Or am I doing something wrong?
>
> Any advice/help would be most appreciated.
>
> Thanks
>
> Be
and trying to get
> the oracledump.pl perl script to run with no success. If anyone has had a
> chance to do this type of migration please point me in the right direction.
> I would really hate to stay with Oracle for the only reason that we can't
> get the data off of it and on to
out the index it works fine. Must be a bug
> AB> Cheers,
> AB> Andrew
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
-
Before posting, please check:
http://www.mysql.com/manual.php
; T1.Snum=T2.Bnum
> T1(Snum,name,email,address)
> T2(Bnum, notes, time)
> I wnat ot get the result(name, email, notes).
> Any suggestion, comments? Thanks
> Yan
--
John Ragan
[EMAIL PROTECTED]
(decheader.code = '00004' and
> > decplacement.product = '1029104') or (decheader.code = '4' and
> > decplacement.product = '1029105')
> >
> > In the above example, all of the codes exist in the decheader table but
> only
>
type questions. If
> you need more detail just ask.
>
> All comments appreciated.
>
> Thanks for reading.
>
> Regards
>
> Brynley
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
-
ll the
> 'remote_addr' rows from 'brute_force' that are NOT in the 'block_ip'
> table?
>
> Something like:
>
> select brute_force.* from brute_force, block_ip where
> brute_force.remote_addr != block_ip.remote_addr
>
> maybe? I have a feeling it
> Hello All,
> >
> > How do I determine the best architecture for my MySQL database?
> >
> > Do I create multiple databases or do I create only one database with
> > multiple tables? (Any general rules of thumb?)
> >
> > How do I know if I need to use
ld be nice...
>
> Thanks for any help - tmb
>
>
> __
> Do you Yahoo!?
> U2 on LAUNCH - Exclusive greatest hits videos
> http://launch.yahoo.com/u2
>
--
e knowledge of
> a large (>10 records) table cannot issue commands to grab *all* of the
> data.
>
> Thanks ahead of time for any info!
>
> --Raj
>
>
--
John Ragan
[EMAIL
from http://corereader.com
it connects to any data source, and it likes
mysql a lot. it does quick point and click
queries so you can, hopefully, find for yourself
the logic errors such as has been pointed out in
your query.
have fun.
--
John Ragan
[EMAIL PROTECTED]
;
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
> > ---
a nested SELECT:
>
> SELECT department,
>SUM(IF(gender = 'm', 1, 0)) AS male,
>SUM(IF(gender = 'f', 1, 0)) AS female
> FROM empdb
> GROUP BY department
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.co
> Before posting, please check:
>http://www.mysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[
one from time to time ...
>
> >A report builder
> >
>
> Any report program that works from ODBC will work.
>
> --
> Michael T. Babcock
> C.T.O., FibreSpeed Ltd.
> http://www.fibrespeed.net/~mbabcock
>
>
>
--
John Ragan
[EMAIL
let me know so I can breath a sigh of relief. And if the
> structure is right, could someone offer some guidance on how a query
> that allows me to query new_req using the intersecting entity (or
> three-way join, whatever it's called) would be written.
>
> Thanks,
>
>
ss. I chose "\n" as the end of line
> character to separate records, but maybe it is something else.
>
> Any ideas?
>
> Thanks,
>
> Brad
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
---
the right direction?
>
>
> Rik Forgo
> JIST3
> Army Test, Training and Technology Integration Office (T3I)
> Diverse Technologies Corp.
> (c) 443.463.8571
> (h) 410.859.8474
>
>
>
--
John
e sensitivty is an issue with Linux/Windows
> 2. Beware of special keywords (I called a field in my database "date" - that
> was also wrong -)
>
> Since I've checked the case and prefixed my field names it works fine on
> both platforms
>
> Thanks for your help
>
itioned on the select returning no data.
>
> As I said it works on windows but not on Linux.
>
> Can anybody point me at anything obvious that I have missed.
>
> Thanks in advance.
>
> Kevin Pass
gt; Instead of converting on matching row (for example 123.123.123.2) to
> 123.123.123.0 it can be left as 123.123.123.2 or even can be truncated to
> 123.123.123
>
> The table is stored on a 3.23.43 mySQL Server. The table type is varchar(15)
> but this can be changed.
>
> Thanks,
riented
> toward.
>
> Any pointers that you could provide to this beginner would be very
> appreciated.
>
> Thank you.
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
t; -rw-r--r-- 1 root root 178 Sep 5 2000 /usr/lib/libc.so
> lrwxrwxrwx 1 root root 19 Sep 26 2001 /usr/lib/libc-client.a ->
>/usr/lib/c-client.a
> Configure command: ./configure --prefix=/usr/local/mysql
>--with-unix-socket-path=/tmp/mysql.sock --
-
> | United States | United Kingdom | United States |
> --
>
> I can dump one country by doing:
>
> SELECT x_country, country_name FROM request, countries WHERE x_country =
> country_id AND
lley, Anguilla, British West Indies
> Tel: 264 497 5670 Fax: 264 497 8463 Cell: 264 235 5670
> http://www.anguillaguide.com/ The Anguilla Guide
> Talk to me in real time:
> Yahoo:netconcepts_anguilla
> US Fax and Voicemail: (815)301-9759
>
>
>
--
John Ragan
ok.
> At 10:10 -0400 10/11/02, Michael T. Babcock wrote:
> >John Ragan wrote:
> >
> >>try corereader. it will run queries against your mysql, oracle,
> >>and ms sql server (and anything else laying around). you can
> >>switch between your serve
m it is addressed. It may contain information which is
> privileged and confidential. Copying or use by anybody else is not
> authorised. If you are not the intended recipient, please contact the sender
> as soon as possible. The views expressed in this communication may not
>
rson(s) to whom it is addressed. It may contain information which is
> privileged and confidential. Copying or use by anybody else is not
> authorised. If you are not the intended recipient, please contact the sender
> as soon as possible. The views expressed in this communication may n
(0.00 sec)
>
>
> If it is not obvious, I want the sum of "first," which, by my calculations,
> should be 3. What am I doing wrong?
>
>
> Thanks!
>
> --kevin
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
--
-+--+-+-++
> | id | int(12) | | PRI | NULL| auto_increment |
> | fg_number | varchar(8) | | MUL | ||
> | spec_name | varchar(255) | | | ||
> | spec_v
ause it's so powerful, corereader contains
safeguards that prohibit updates, so you cannot
update directly from it. )
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
-
Before posting
le)
>SELECTs together
>i.e.:
>
>UPDATE mytable
> SET xxx = (SELECT xxx from mytable2 WHERE config="yyy") ...
>
>thanx
>
>Mirza
>
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
> >
> >
> >>Is there a document that compiles examples on different ways of joining
> >>two or more tables? I found a few on
> >>http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
> >>than two tables.
> &
a document that compiles examples on different ways of joining
> >>two or more tables? I found a few on
> >>http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
> >>than two tables.
> >>
> >>Thank
on
> http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
> than two tables.
>
> Thanks for any suggestions.
>
>
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
| Tony Devlin - [EMAIL PROTECTED] |
> | Airewaves Broadband, Systems Admin |
> | Website - www.airewaves.com |
> | Atlanta, Ga - 678.522.3923 |
> | Beaufort, SC - 843.379.AIRE(2473)|
> +------+
>
>
&
Website: www.techex.com.au Email: [EMAIL PROTECTED]
> Telephone: 1300 88 111 2 - Fax: (02) 9970 5788
> -
>
>
--
John Ragan
[EMAIL PROTECTED]
501-228-0317
http://www.CoreReader.com/
-
Before posting
ql or any other database) computer department to install linux on a
> computer and install mysql on that computer, can I just enter its ip address
> in the myodbc dialog, and be amazed at how well it works?
>
> Bjarki
>
>
--
John Ragan
[EMAIL PROTECTED]
..
> > > ...
> > > _
> > > Total
> 125
> > > VA
tute a contract offer, a contract
> amendment,
> > or an acceptance of a contract offer. This e-mail does not constitute
> > a consent to the use of sender's contact information for direct
> marketing
> > purposes or for transfers of data to third parties.
> >
&
his is basically what I would want it to do
> > (assume all the keywords are stored in a field called "keywords" in the
> > projects table):
> >
> > SELECT * FROM projects where keywords like "%historical%" and
> > keywords l
>
> --
> MySQL Training in Auckland and Sydney, http://www.mysql.com/training/
> Purchase Training, Support, Licenses @ https://order.mysql.com/?marl
>__ ___ ___ __
> / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz <[EMAIL PROTECTED]>
> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Techni
there are
no problems involved?
--
John Ragan
[EMAIL PROTECTED]
501-228-0317
http://www.CoreReader.com/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
56 matches
Mail list logo
