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 shut
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 Swanson [EMAIL
. 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. Just trying to pass on what I've learned.
|
| Cal Evans
| http://www.calevans.com
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?
Regards
Luiz
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
and 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 having
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 commands
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
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
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 business.
*
* I think inside
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 NULL without
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/MySQL
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 care of your business.
*
* I
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.
Arnas Milaauskas wrote:
No, no, no ... Dear Friends, defining column as NOT NULL and do not
specifying default value does not means
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
://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
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 internet. It is secure to do this using
MySql
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.
Kind Regards,
Lennie
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
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
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
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.
*
- Original Message
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 the
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
: 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 wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a
restriction.
2: It doesn't work
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
B Checks for empty
AUpdates
AReads ( and owns record
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 [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:59 AM
Subject: RE: How Many
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
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 plugged
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: Chidambaram
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
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
.
=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 in a mysql
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
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 plugged into your audience.
* http
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: when
of 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
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
*
-Original Message
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: '[EMAIL
by 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]]
Sent
.
=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't
,
=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 29, 2002 9:34 AM
To: MySQL
Subject: Anyone have MySQL/PHP running
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 Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 10:02 AM
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%22btnG=Froogle+Searc
h
and
http://froogle.google.com/froogle?q=%22SQL+For+Smarties%22btnG=Froogle+Sear
ch
2 more excellent resources.
*
* Cal Evans
* The Virtual CIO
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 [mailto
(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 CIO
* http
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:[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
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
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 (rt2 jobs
in
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
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 Virtual CIO
* http
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
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]]
Sent
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 user
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
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
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: Hanxue Lee [mailto:[EMAIL
=
*
* 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 can go
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
. 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
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 recompiled
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:[EMAIL
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: Opposite
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
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, 2002 8:48 AM
To: [EMAIL PROTECTED]
Subject
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 command
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 10:33
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
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
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, July 15
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
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
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
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: [EMAIL PROTECTED]
Subject
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 Message-
From: Kevin Passey
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
)
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 requirements
To run
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
) 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
Subject: InnoDB
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
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
* The Virtual CIO
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
What's your log file say?
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Jacques Steyn [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 01, 2002 8:28 AM
To: Alexander Barkov
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: mysql
.
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
Subject: Speed issue
Hi
I am
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 [mailto:[EMAIL
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.calevans.com
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 PM
last I heard it was 'sometime before the end of the year.'
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Julian Htun [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 9:34 AM
To: [EMAIL PROTECTED]
Subject: MySQL
wrong mailing list. (This is abuse, you want arguments...down the hall, to
your left.)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: toby - [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 6:05 AM
To: [EMAIL
The commands you are typing are shell commands. You are in the mysql
client. Try:
use mysql;
select * from user;
You need to be at a shell prompy to issue bin/mysqladmin -password
testpassword
HTH,
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
yes. Using myODBC you can connect with any ODBC client and issue any valid
sql statement. (Personally, I use VFP but it's dumber brother Access will
work also.)
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Dennis [mailto
Mysql does not currently support stored procedures. Check the website for
the features that will be added to the 4.x seriese.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Pradeep.C.Pangi [mailto:[EMAIL PROTECTED]]
Sent
1 - 100 of 297 matches
Mail list logo