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
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
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
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
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
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
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
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
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
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
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
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
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]
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
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
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
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
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
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
://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
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
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.
&
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
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
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
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
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
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
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"
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
&
-
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
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
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
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
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
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
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
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
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
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]&
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
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
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
*
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
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
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
.
=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&#
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]]
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: '[
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
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
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
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
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
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
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
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:[
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 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
uence table.
(I did)
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Mike Patterson [mailto:mp72@;excite.com]
Sent: Monday, November 04, 2002 1:19 PM
To: [EMAIL PROTECTED]
Subject: Maintaining #'s between 2 databases
I have two databases (
red a change) Similar
to your option 2 but without the extra database. (and lose the MSSQL box and
move to MySQL...had to say it to make this relevant to MySQL!) :)
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Benji Spencer [mailto:ben.spencer@;mood
It is bad form to expect the
client/compiler or interpreter of any language to make up for your typos.
BTW, the source is available to MySQL, if you REALLY consider it a bug, fix
it and submit the patch...and can you do the form->from thing for me too?
:)
=C=
*
* Cal Evans
* The Virtu
Access that you won't be able to do in MySQL.
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Publici-Textes [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 2:41 PM
To: [EMAIL PROTECTED]
Subject: Query as source for query
Hi
mysqldump -opt > everything.sql
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 8:44 AM
To: [EMAIL PROTECTED]
Subject: shell script to backup
Hi all...
I am a new Linux u
yes, write them all to a file and put that file in a directory you have
access too. Then when you want to execute them:
mysql -u user -p < filename
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
S
have you tried mysqldump?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ilyas Keser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 6:15 AM
To: [EMAIL PROTECTED]
Subject: backup
Hi list...
What is the best way to backup a Mysql
That sir, it the coolest hint I've seen in a while.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 5:47 PM
To: [EMAIL PROTECTED]
Cc: Andy Smith
Subject: Re: Opposi
Dig around for a log file or an error file. Whenever it won't start it tells
you why (or gives you a hint) in the error file. tail it and post if you
still need help.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Richard Fox [mailto:[
could it be a system permissions problem?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Shon Stephens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 2:38 PM
To: '[EMAIL PROTECTED]'
Subject: more weird my.cnf foo???
i
. Give it as much RAM as you can. If you are using
InnoDB tables then check out http://www.innodb.com/ibman.html#InnoDB_tuning
for more suggestions. They used to have several versions of my.cnf
suggestions (small, medium and large) but I can't seem to find them anymore.
HTH,
=C=
*
* Cal Evans
Yes, but this would be better addressed on a PHP list. This is MySQL.
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Harpreet Kaur [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 2:38 PM
To: [EMAIL PROTECTED]
Subject: using a php page to
H,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: forum mail [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 17, 2002 2:30 AM
To: [EMAIL PROTECTED]
Subject: paging of records.. any suggestions?
Hi list,
I would like to get any suggestion on how i c
ng them on the other machine.
master
mysqldump -opt > everything.sql
slave
mysql < everything.sql
Warning this will wipe everything on your slave machine as it imports from
the master.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ha
I can see where accessing the server from a handheld would be cool but I
question the concept of actually RUNNING the server on a handheld. Write a
cool lightweight client with the library and leave the server on beefier HW.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
Have you tried explain?
Do all of your ID fields have indexes?
Have you tried breaking it into multiple statements? Each statement creating
a temp table except the last?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Lorenzo De Vito [mailto
lways, NEVER use Select *...I'm using it as an example. :)
=C=
p.s. switch to home-cooked Italian. :)
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Robo [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 4:39 PM
To: [EMAIL PROTECTED]
Subje
two pieces of advice.
1: Stop posting over and over again.
2: Check the archives. This is has been discussed in the past 3 months.
There is probably some very good advice there.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: K Frey [mailto
http://www.thekompany.com/products/dataarchitect/
It's not free but it is cross platform and I think it supports pgsql.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Dusan Juhas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002
I and others posted should point you
in the right direction.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Patrick J Okui [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 10:16 AM
To: Cal Evans
Cc: [EMAIL PROTECTED]
Subject: RE: UPDATE co
omain = "domain1.com"
or something along those lines. Check out
http://www.mysql.com/doc/S/t/String_functions.html
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Patrick J Okui [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 200
great
pagination tools to make this stuff easy.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Walter D. Funk [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 9:02 AM
To: [EMAIL PROTECTED]
Subject: Calculating rows in a result set
Hi
Can you post your query along with the output of explain?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 3:45 PM
To: Cal Evans; [EMAIL PROTECTED]
Subject: Re: MyISAM v. InnoDB
switching to InnoDB won't help. Take a look at optimizing your queries. Are
you using LIKE? have you looked at the output of EXPLAIN?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]]
Sent: Monday, Ju
No.
http://www.mysql.com/doc/N/u/Nutshell_4.1_development_release.html
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: root [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 15, 2002 10:06 AM
To: [EMAIL PROTECTED]
Subject: Stored Procedures
dear all
Hiya,
Why would you want to? Any time you need days elapsed, just compute it.
Never store summary data without a good reason. (making things go faster is
a good reason) :)
select (orderdate-shipdate) as dayselapsed from ...
should work.
=C=
*
* Cal Evans
* The Virtual CIO
* http
3.23.51-max if you are using Windows.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Ki Mien [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 10:17 AM
To: [EMAIL PROTECTED]; Heikki Tuuri
Subject: Innodb
Hi all,
Can anyone out there
o create databases, this should eat your SQL and execute it.
If you are using Windows,check out mySQLyog. (Google it, they didn't put a
URL in their About box) It's the best Windows client I've seen.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original M
n was the last time
(paid or not) that you called Microsoft to get support and got one fo the
DEVLOPERS of windows?
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Dane Anderson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 04, 2002 9:31 PM
To:
rrier)
It really depends on what you ware wanting to do.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Kevin Passey [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 04, 2002 5:53 AM
To: Mysql (E-mail)
Subject: What are the hardware requirement
What tests have you done to satisfy to yourself that it is turned off?
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Tom Robinson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 04, 2002 6:10 AM
To: [EMAIL PROTECTED]
Subject: Row level
looks like mysql is not running.
type ps ax
and see if you see any mysqld lines.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Rahadul Kabir [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 2:24 PM
To: MySql Mailing List
Subject
me) There is a limit on both types as to how big of a number they can
store...check the docs.
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Wouter van Vliet [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 03, 2002 2:06 PM
To: MySQL Mailinglist
depending on your distro. You should have a dir named /etc/rc.d/init.d or
/etc/init.d in it should be a script named mysql for starting and stopping
mysql. Use it (as root) to start mysql.
/etc/init.d/mysql start
or
/etc/rc.d/init.d/mysql start
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http
Try
mysql -u root mysql -p
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Page Works Web Solutions [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 02, 2002 11:02 PM
To: MySql mailing list (E-mail)
Subject: root passwords
Hi all,
MySql on linux
attendance left outer join person on attendance.personID =
person.personID
order by person.region
SHOULD give you a 0 in present if they were not there.
(DISCLAIMER: It's late, I've not tested this code, and this is free advice,
take it for what it's worth.) :)
HTH,
=C+
*
* Cal Evans
*
http://www.thekompany.com/products/dataarchitect/
$49.00 - Well worth it even with it's flaws.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: abhishek sahay [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 1:33
use the --opt option for mysqldump.
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --lock-tables
Other than that, it's the method I use.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevan
e the constraint, add a dummy record into the parent table or
re-think what you are trying to do. (You've put on a constraint and now you
are trying to break it!)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Arul [mai
the important stuff.
In short:
MySQL != "Drop in replacement for desktop database"
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Simon Ashby [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 4:58 AM
To: MYSQL
S
1 - 100 of 360 matches
Mail list logo
