Gentoo (www.gentoo.org)
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Fernando Grijalba" <[EMAIL PROTECTED]>
To: "MySQL Help" <[EMAIL PROTECTED]>
Sent: Thursday, January 23, 2003 10:32 AM
Subject: Red Hat/Mandrake o
A guess...
select t1.cat1 as result from t1
union
select t2.cat2 as result from t1
union
select t3.cat3 as result from t1
union
select t4.cat4 as result from t1
group by result
order by result
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Doug C
sub-selects are not yet (to the best of my knowledge) supported in MySQL.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Frank Peavy" <[EMAIL PROTECTED]>
To: "Doug Coning" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]&
If you create in index on your FK then it will be used to optimize the
query.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Kiss Dániel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 9:19 AM
Su
thing you
need to know about licensing is explained there.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "MySQL Newsgroup" <@[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 5:10 PM
Subject: MySQl pri
at
you are doing. (and 4 & 5 are not used that much, concentrate on 1-3)
Keep up the good work!
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "César L. Aracena" <[EMAIL PROTECTED]>
To: "MySQL General" <[EMAIL PROT
talled on my desktop machine
and it's fast becoming my favorite. (It was announced within the last month
on the announce list...check the archives.)
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Morris Ford" <[EMAIL PROTECTED]>
To:
backup open files but none of them are pretty.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 8:08 AM
Subject: make backup
When I try to make a backup execu
ith a little preparation, you should be able to do the ./configure, make,
make install without a problem.
=C=
p.s. did I mention making a backup of your system before starting? This is
VERY IMPORTANT! :)
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: &q
1 reason and 1 reason only. To speed up queries. The flip side of that is
if you have an index that is not being used by a query somewhere, get rid of
it.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "ally" <[EMAIL PROTECTED]
What version of MySQL?
What interface are you using to execute the delete?
How do you know you only deleted one of the records? From a CLI, without a
PK, there would be no way to delete only one. Delete from Works where title
= something would delete both of them.
=C=
*
* Cal Evans
* Techno
ut a PK, but my working theory is that if he's using a
Win-based FE, accessing through ODBC and issuing an ambiguous delete (i.e.
browsing the table in access and deleting a specific record) This MAY be the
problem.
As I said, I've not tested it so I could be off in left field. :)
=C=
*
issue.
See if that clears it up.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Nick Traenkner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 12:18 PM
Subject: Re: de
It's easier (as in less typing) to sort by one field than two.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Ray" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 9:23 AM
Subject: pointless q
2 rows with the data you are
looking for.
HTH,
=C=
|
| Cal Evans
| http://blog.calevans.com
|
|
John Heim wrote:
I need to write a query that essentially does both a left and right
join. I have a list of people and the rooms they occupy. Some rooms have
no people. Some people have no room
http://dev.mysql.com/doc/refman/4.1/en/control-flow-functions.html
ifNULL()
=C=
www.calevans.com
sol beach wrote:
The subject says it all!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You could still still use mysqldump. There is a parameter to specify
which specific table you want to dump.
Usage: mysqldump [OPTIONS] database [tables]
=C=
www.calevans.com
Michael Williams wrote:
Hi all,
Is there a command similar to "SHOW CREATE TABLE. . ." that will output
the command
Hi,
If you've just installed it then the root user has no password.
Change the root user to have a password then you will have to specify
the -p parameter on the command line before you can log in. (Or you can
put it in your local my.cnf file)
=C=
www.calevans.com
Beauford wrote:
I just in
adds 17 days to it (checking month overlap and stuff), but I want to
skip scripting if there is an solution within MySQL that does it for me.
/Peter
--
|
| Cal Evans
| http://www.calevans.com
|
--
MySQL General
If your servers is Linux based try running mysqldump locally on the
server via ssh. Then you can zip it up and transfer it over.
=C=
|
| Cal Evans
| http://www.calevans.com
|
Anthony Ettinger wrote:
I'm using the typical --opt with mysqldump, over the internet.
the problem I'm hav
http://dev.mysql.com/doc/refman/4.1/en/odbc-and-last-insert-id.html
|
| Cal Evans
| http://www.calevans.com
|
Danesh Daroui wrote:
Hi all,
I have a simple table with an Auto_Increment column. I insert NULL
to this column each time I insert a row to have an automatic unique
value
Subqueries.
select * from ClientJune2005 where customerCode = (select customercode
from ClientAug2005);
http://dev.mysql.com/doc/refman/4.1/en/subqueries.html
=C=
|
| Cal Evans
| http://www.calevans.com
|
VaioLord wrote:
I have just moved over to a new job and been given the task of trying
No way to do it post-insert. However, if you are designing a new
database, checkout a timestamp field.
=C=
|
| Cal Evans
| http://www.calevans.com
|
prathima rao wrote:
hi all,
can anyone tell me if we can anywhere find out what time that data was
entred in the database
i was actually
es for the server to respond
positively. But all of these pale in comparison to most recordsets.
=C=
|
| Cal Evans
| http://www.calevans.com
|
Luiz Rafael Culik Guimaraes wrote:
Dear Friends
Is their an Page with data of how much bandwidth mysql consume when
using remote servers?
Re
e's back-handed slap at MySQL, nobody's taking the bait. If it's
good enough for finance.yahoo.com, I'm guessing your application just
isn't gonna pose a challenge.
All of this was said with a smile on my face...not trying to pick a
fight or come across rude. Jus
u how to create a tunnel, I believe the switch you are looking for
is -L. It's not difficult.
=C=
|
| Cal Evans
| http://www.calevans.com
|
Karam Chand wrote:
If you are looking for a client to connect to MySQL
using SSH tunnel, try out SQLyog. It has SSH
Tunneling.
Karam
--- Jerry Swans
Notes in-line
=C=
www.calevans.com
On Mon, 2005-12-12 at 18:33 +0100, Juan Jose Sanchez Mesa wrote:
> Hi!
>
> We have 2 MySQL servers and now we have purchased one more powerfull server
> and want to combine the databases from the two older server into the new
> server.
Yes, you can. I would s
the data is unchanged.
Depending on the structure of your application and the resources
available, you could put the checksum table on a separate server. This
would isolate it even further and make it harder to crack.
Let me know how I may be of service,
=C=
* Cal Evans
* http://www.eicc.com
* We
select @colOne:=colOne from myTable where tableOneID=thisKey;
update myTable set colOne=colTwo, [EMAIL PROTECTED] where tableOneID=thisKey;
HTH.
humbly,
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines
use mysqldump to just dump the schema. Then edit the script to change the
database name and pump it back into mysql.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of
use a smaller font. This is really a function of your shell or client, not
MySQL.
humbly,
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of lines he does not have to
I believe all you have to do is install the ODBC drivers and then
configure a DSN.
=C=
*
* Cal Evans
* http://www.eicc.com
* We build IT solutions
*
Lennie said:
> Hello Guys,
>
> Is there support for ADO?
>
> Im a proffesional Delphi developer and must access mySQL via ADO.
&
ySQL host address is
localhost because you are talking to your tunnel, not the server.
That's all there is. Now you have a safe and encrypted tunnel to MySQL.
HTH,
=C=
*
* Cal Evans
* http://www.eicc.com
* We build IT solutions
*
Flavio Tobias said:
> I need to access a database thru i
://sourceforge.net/projects/miniserver/
No developer (who has to run windows) should be without it.
=C=
--
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take care of your business.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
ll prevent ANY program (even Access) from writing to the table
without specifying a value.
Now if you want more than that you'll have to write it into your FE.
(i.e.not null and not '')
HTH,
=C=
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take car
havior has changed in 4 but I
hope not.
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take care of your business.
*
* I think inside the sphere.
Arūnas Milašauskas wrote:
No, no, no ... Dear Friends, defining column as NOT NULL and do not
specifying default value does not
I humbly submit an apology. You are correct. This is a bug (No it is
NOT a feature) you should be able to define a field as NOT NULL without
a default or at the very least, define the default as NULL.
My bad,
=C=
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take
Michael Stassen wrote:
Cal Evans wrote:
or '' (empty string). You can change this behavior by building your own
mysql from source with the -DDONT_USE_DEFAULT_FIELDS compile option.
Thanks, I'm off to recompile my development server.
you should be able to define a field as NOT
nly have 1 database but your data is kept separate. (Until MySQL
comes out with views, then it gets a lot easier.)
HTH,
=C=
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take care of your business.
*
* I think inside the sphere.
Steve Buehler wrote:
I am running PHP
ble,
sometimes the editor gets confused) but other than that it's rock solid.
It's one of three programs that I almost always have open. (See, there
it is in my toolbar now!)
HTH,
=C=
* Cal Evans
* http://www.eicc.com
* We take care of your IT,
* So you can take care of your busines
select Realm, AcctStartTime, AcctStopTime from radacct;
??? Did I miss something here?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: David Lubowa [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 9:29 AM
To: [EMAIL PROTECTED]
Subject
Select * from employees left outer join dept on employees.emp_DepId =
dept.dep_id where dept.dep_id is null
(Subselect would be easier if MySQL supported it!)
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Silmara [mailto:[EMAIL PROTECTED
select req_number,
right(concat('00',trim(req_number)),6) as sort_req,
case
from req
order by sort_req;
Haven't tried it but it should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Norris, Joseph [mailto:[
Run your database from a RAID 0. At some point during the night. Down one of
the drives, mount it and copy the data. Then unmount it bring it back
on-line. The RAID card should re-sync them without any down time.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original
sum(purchase.amount) as total
from person left join purchase on person.personID = purchase.personID
group by personID
order by name;
Now, by executing this statement you can see how much each person has
purchases without storing these totals in the database.
HTH,
=C=
*
* Cal Evans
* The Virtual
either mysql is not running or php doesn't know where to find your sock.
make sure that php.ini has the correct location for your sock and that ps
auxwww shows mysql running.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Rich Dodge [m
track their usage through your web server's log files.
HTH,
=C=
p.s. nothing works WITH WinME. Some things work in spite of WinME! :)
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: databarn [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December
and are constantly amazed at what you DON'T know) share kindly
and willingly. To those seeking enlightenment...RTFM you mook! Check the
!*#&^ archives and use Google, this issue has been beat to death!
Humbly,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Mes
try:
create table aaa(id int(5) unsigned not null, name text);
not sure why but unsigned needs to come before not null.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Octavian Rasnita [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002
Paul's book is an excellent one.
I also recommend (to anyone who asks):
http://froogle.google.com/froogle?q=%22SQL+For+Dummies%22&btnG=Froogle+Searc
h
and
http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22&btnG=Froogle+Sear
ch
2 more excellent resources.
*
* Cal Evans
* Th
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#UPD
ATE
Last line in 6.4.5
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Jim Racster [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 10:06 AM
To: '[
dateTime
I've not tested this but it should point you in the right direction. (But
again, changing your structure is a much better solution.)
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 11:12 AM
To: [EMAIL PROTECTED]
Subject: Trying to find a .zip binary install for Windows 2000 for 4.0.7
gamma
I couldn&#
duction.
Vocal range deserves a 'domainTable' of it's own.
vocalRangeType
---
vocalRangeTypeID
===
description
===
product then has vocalRangeTypeID as a FK.
Nothing wrong with a table that is just a bunch of FKs to other tables.
YMMV, HTH,
=C=
*
* Cal Evans
* Stay plug
select statement and bring in all the data
at once.
=C=
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 7:53 PM
To: mysql users
Cc: Cal Evans
Subject: Re
the detail in the table structures. But you
should be able to get the general idea form it.
HTH,
=C=
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-Original Message-
From: David T-G [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 5:10
iption as range
from product p left join voicingType v on p.voicingTypeID =
v.voicingTypeID
where productID = 4
should get you a result set back with a productID, title and the description
of the range.
=C=
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
it should
*
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
*
-Original Message-
From: Smita Marda [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 03, 2003 5:25 AM
To: [EMAIL PROTECTED]
Subject: question
technical question-
The MySQL-4.0-mysql
ook above.
=C=
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
-Original Message-
From: Andrew Maynes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 05, 2003 4:22 PM
To: MySQL-Lista
Subject: query produces a navigation
I have a set of records i
check the docs at www.mysql.com for the CORRECT command to create indexes.
=C=
* Cal Evans
* Stay plugged into your audience.
* http://www.christianperformer.com
-Original Message-
From: Hawk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 06, 2003 9:03 AM
To: [EMAIL PROTECTED
Hi,
I managed to install kafee and run a few java programs.
Now, comes the time those java program have to use MySQL database.
This is the error I get everytime I run my program:-
06-12-2002 00:43:27.302 [INFO] [main] JDBC Driver class:
com.mysql.jdbc.Driver
06-12-2002 00:43:27.304 [ERROR
use the -opt flag.
=C=
* Cal Evans
* Stay Plugged Into Your Audience
* http://www.christianperformer.com
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 4:27 PM
To: MySql
Subject: Best way to dump for daily archiving
I wrote a sh script
It looks like you've got a type in your my.cnf
check where your mysql.sock is trying to create. It should be something
like:
/var/lib/mysql/mysql.sock
^
=C=
* Cal Evans
* Stay Plugged Into Your Audience
* http://www.christianperformer.com
-Original Message-
From: Chidam
Edit the script created by mysqldump. Add
create database if not exists databaseName;
to the beginning of the script.
Or what I usually do is create the database first then use:
mysql -A databaseName < test.sql
to load it.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plug
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming you have a primary key
-
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "Ed Kiefer" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 9:22 AM
Subject: Re: How Many
>
>
> Cal Evans w
last man wins.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
> AChecks for empty
&
I like this solution. Gonna cogitate on it for a while.
=C=
- Original Message -
From: "GERST, MICHAEL (SBCSI)" <[EMAIL PROTECTED]>
To: "'Cal Evans'" <[EMAIL PROTECTED]>; "gerald_clark"
<[EMAIL PROTECTED]>
Cc: "MySQL"
Lots of them. None cheap. What ever you do, steer clear of the one at
www.thekompany.com. It's a piece of crap. I bought a version and then
foolishly bought an upgrade thinking it would be better. it's not and the
primary programmer for the project is very arrogant on the mailing list
setup for
www.sqlyog.com
Absolutely the best tool I've used to work with mysql. And a VERY responsive
development team.
=C=
- Original Message -
From: "Neil Tompkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 04, 2003 1:49 PM
Subject: mySQL GUI
>
> I have recently purchased
al, simply output the labels to the proper
LPR/LPD or CUPS device.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged into your audience
* The measure of a programmer is not the number of lines of code he writes
but the number of lines he does not have to write.
*
- Origin
Is it possible to issue 1 select that gathers data from databases on 2
separate servers?
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
sql, query
-
Before posting, please check:
http
Did you check the log file?
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
David Adam
Sent: Friday, April 12, 2002 7:51 PM
To: mysql mailing list
Subject: I have been
Check the docs on GRANT. Sounds like you have an incorrect host. Either
set the host to % on your current record (manually and then FLUSH
PRIVILEGES) or figure out the hostname from the machine you are trying to
connect from and grant yourname@hostname the necessary privileges.
=C=
*
* Cal
Since MySQL does not yet support stored procedures, and this problem
requires looping logic, I'm guessing no. You will have to use whatever
language you are using to access MySQL to do it.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Me
check the manual for GRANT. The knowledge you seek is contained therein.
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Alex Lui [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 14, 2002 10:56 AM
To: [EMAIL PROTECTED]
Subject
zations but they should help you. Or not...
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002 10:45 AM
To: [EMAIL PROTECTED]
Subject: Simple Question relating to Inde
I've not checked your syntax but it looks like you've got the idea. One
caveat. Unless you have a UNIQUE index, you can have multiple people named
John Smith. If you specify UNIQUE in your index clause then you can't.
=C=
*
* Cal Evans
* Journeyman Programmer
* Tec
4 step process
ALTER TABLE to add a new Date column
Populate the new field with the date portion of the DATETIME
Drop the DATETIME column
Rename the DATE column with the name of the original field.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
anity)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Simon Tierney [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 3:49 PM
To: [EMAIL PROTECTED]
Subject: time recording
Has anyone on this list used MySQL for time rec
mysqladmin variables
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Edilson Vasconcelos de Melo Junior
[mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 4:04 PM
To: Paul DuBois; MYSQL
Subject: RES: Innodb
Hi,
The server
y got any ideas?
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
Found it, it was INNODB running out of space. (Can we get better error
messages here?)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 14, 2002 3:24 PM
To: [EMAIL
Since Access is using ODBC to get to the tables I'm pretty sure this is not
possible. You could write an access form with a timer on it that requereies
the data ever x seconds to refresh it. (But this is bad...m'Kay?)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-M
you can't. Check the archives, this was discussed about 2 weeks ago.
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 03, 2002 7:13 AM
To: [EMAIL PROTECTED]
Su
'salright.
Short answer. The driver does not give you this message. you can time the
execution yourself and then count the rows. For the full discussion try
digging around at:
http://www.mysql.com/documentation/searchlists.html
HTH,
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno
Need to go grab myodbc. Check downloads at www.mysql.com. grab the
binaries unless you are brave enough to compile. :)
Install (It comes with a setup) and then configure an ODBC source like
normal.
it works, I've done it.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
*
cepts to make a tree structure work with
single select.
It's not easy. It's a complex concept but once you master it you'll find
100's of uses for it. (I use it to open pickle jars these days!) :)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calev
Yes, the concepts he presents are in generic SQL. I've used them in 2
different systems (menus and security) and they work fine. (NOTE: You DO
have to write your own code.) ;)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
processing.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: N.Elangovan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 12:03 AM
To: [EMAIL PROTECTED]
Subject: "ON DELETE" , "ON UPDATE"
http://www.mysql.com/doc/G/R/GRANT.html
It's in there...keep digging.
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: vlady [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 9:15 AM
To: [EMAIL PROTECTED]
Subject:
It's ODBC in general. One more layer of abstraction to deal with.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Tom Worobec [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 2:56 AM
To: MySQl Lists
Subject:
ll be trying to lock the record. make sure the
value in the lock field is what you wrote to it.
4: Issue the UPDATE to make your changes.
optional
5: unlock the record by clearing the lock field.
HTH,
Cal
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Ori
SELECT DISTINCT(mi.interest_id), COUNT(*) AS count,
i.name
FROM member_interests AS mi left join outer interests AS i on
mi.interest_id = i.id
GROUP BY mi.interest_id
ORDER BY i.name
You are correct, a left outer join is what you need.
*
* Cal Evans
* Journeyman Programmer
* Techno
would leave orphaned FKs in the members table and
orphans are bad mojo.)
Anyhow, this has worked for me in the past.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Daren Cotter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
char(1) default to either 0 or 1. I do not believe that SQL93 has a boolean
data type nor a standard for implementing it.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Michael Ivanyo [mailto:[EMAIL PROTECTED]]
Sent
Try this.
SELECT DISTINCT(mi.interest_id), COUNT(*) AS count,
i.name
FROM member_interests AS mi left join outer interests AS i on
mi.interest_id = i.id
GROUP BY mi.interest_id
HAVING count < 5
ORDER BY i.name
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* h
Not like they exist in MS SQL. However, take a look at the mysql database.
My guess is that you can infer the information you want from the permissions
granted.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Niall Merrigan
The pros are you can run them under separate user/group ids therefore you
can make it much harder for someone with access to only one to get to the
other's data.
The cons are that you will have 2 copies running therefore it will take
longer to maintain.
=C=
*
* Cal Evans
* Journ
No, a batch file and the task scheduler are the best way to do it. As to
the syntax I've not used mysqlhotcopy but most of the mysql programs will
display help if you enter no parameters to invalid parameters. (or the
parameter --help)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno
1 - 100 of 360 matches
Mail list logo
