oup by
a.assignmentid,
a.attenddate;
I want it to return those values where sum(a.attendhours) does not equal
s.attendhours. What more do I need to add to my query to accomplish this?
Thanks in Advance
Scott Pippin
[EMAIL PROTECTED]
can buy
V11 but wasn't sure if the STD version was enough to set a report and run it
with MySQL.
Kerry
-----Original Message-
From: Scott Pippin [mailto:[EMAIL PROTECTED]
Sent: 28 April 2005 15:11
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: Crystal Reports &
I haven't tested it but I am using version 10 with no problems. See the
announcement made by business objects at the MySQL users conference:
http://www.mysql.com/news-and-events/press-release/release_2005_10.html
I hope this helps.
Scott Pippin
[EMAIL PROTECTED]
>>> "Ke
What knid of performance difference can I expect between 2 xeon 3ghz
32bit compared with 2 IBM Power5 64bit processors if memeory and
everything else is the same?
Thanks,
Scott Pippin
[EMAIL PROTECTED]
ompared to some of the other databases I have seen. Hope this helps.
Scott Pippin
[EMAIL PROTECTED]
)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:439)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)
** END NESTED EXCEPTION **
Scott Pippin
[EMAIL PROTECTED]
>In the MySQLdocumentation, it does not clearly explains how a Tablespace is
> created. Under "Creating a Tablespace" heading ( 14.4.4), it says how a Innodb
> database is created but not >tablespace.
> Also how exactly you create an Innodb Database. Well it says in the
> documen
rom yesterday's output:
The RPM database can become corrupted, causing the rpm -qa to hang. To rebuild the
database follow the following instructions:
ps -ef |grep rpm - kill all rpm processes
rm -rf /var/lib/rpm/__db*
rpm --rebuild
You should then be able to query the rpms.
Scott Pippin
[EMAIL PROTECTED]
following link to see a databse
comparison done by eweek magazine. I hope this helps.
http://www.eweek.com/article2/0,4149,1184846,00.asp
Scott Pippin
[EMAIL PROTECTED]
advance
Scott Pippin
[EMAIL PROTECTED]
ficient with only one of the files ?
>I have only my.ini
>For which purpose is my.cnf , please?
It is my understanding that it looks for either file. As long as you have one file
you should be ok.
Scott Pippin
[EMAIL PROTECTED]
I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it
up I get an hourglass for a second, then nothing happens. Has anyone
had similar issues or any ideas as to what could cause this?
Thanks
(mysql, query)
Scott Pippin
[EMAIL PROTECTED]
Try putting the following before the mysqld call but before your ulimit calls -
export LDR_CNTRL='MAXDATA=0x8000'
Also try setting ulimit -m unlimited and ulimit -s unlimited.
Hopefully this helps.
Scott Pippin
[EMAIL PROTECTED]
I am about to install Red Hat Enterprise Server 2.1. I would like to put MySQL on it.
I was wondering if there were any Red Hat settings I should be aware of as I install
the OS.
Thanks,
Scott Pippin
[EMAIL PROTECTED]
>Where do you change the default LIMIT value for queries. I am using
>0.9.1-beta.
right click on the server name and click on edit. Click on the MySQL Options tab.
Scott Pippin
[EMAIL PROTECTED]
;advice you may have.
What version of crystal are you trying to use?
Thanks,
Scott Pippin
[EMAIL PROTECTED]
>I am trying to install on a AIX box. I do not want >to install into
>/usr/local. I have put everything >in /sybase/mysql/mysql. I am running
into
Set up a symbolic link from usr/local/mysql to the directory where your
files are stored. Let me know if you need any more help.
Scott P
(query, sql)
Scott Pippin
[EMAIL PROTECTED]
-
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
lot better for me than mysqldump. The larger tables
seemed to transfer faster than with mysqldump.
Let me know if you have any other questions.
Scott Pippin
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/ma
log in to the MySQL server on
your windows machine.
Then open another window and log in to your linux box in MySQLFront.
Click on the Import/Export option and select Export tables. Select the
Another Host/Db option.
I hope this works, let me know if you have any other problems.
Scott Pipp
Try SQlyog
http://www.webyog.com/
or
MySQL-Front - very good but no longer being developed
http://mysqlfront.sstienemann.de/
Both of these are free.
Hope that helps.
Scott Pippin
[EMAIL PROTECTED]
-
Before posting, please
ts.StudentID = ''
Hope this helps.
Scott Pippin
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
you in a separate email. I wanted to put
the fix instructions on the list for others to access if needed.
Scott Pippin
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
>Are many people using MySQL version 4 yet? I'm interested in it
because I
>want to use it's SSL capabilities but would like to hear that people
are not
>having trouble with it first.
We have been using 4.0.x for about five months now on a production
system and have had n
You should be able to just install over the top without any problems.
Backup tour data directory to a different directory though to play it
safe.
Scott Pippin
[EMAIL PROTECTED]
-
Before posting, please check:
http://www
Yes you can. There are a few changes you have to make to the registry
to get it to work. Let me know off list if you need any more help. We
use mysql as our databse and Crystal Reports as our reporting engine.
Scott Pippin
[EMAIL PROTECTED]
>>> geeta varu <[EMAIL PROTECTED]&
> I'm a beginner with mysql and i installed it with linux.
> I'm getting this message when i tried to be connected :
> Error 2002 : can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (111).
>
> Can you help me by finding how to be connected to the database ?
Make su
ne of the best books for understanding how joins work is
"SQL for Dummies"
It was a combination of the article and the book that helped me
understand joins and how to use them with MySQL.
(mysql, query)
I hope that helps.
DDBI_NO_THREADS Perl.c
/bin/sh: cc: not found.
make: 1254-004 The error code from the last command is 127.
Any suggestions would be greatly appreciated.
Thanks
(mysql, query)
Scott Pippin
[EMAIL PROTECTED]
-
Before
Scott Pippin
[EMAIL PROTECTED]
>>> "Wesley Brown" <[EMAIL PROTECTED]> 11/20/02 11:24AM >>>
>Well, This is my first attempt at moving from Oracle to MySQL on such
a
>large scale and so far it isn't going well at all. We are running
oracle
>7.3.4.0
What version of MySQL JDBC are you using?
Scott Pippin
[EMAIL PROTECTED]
>>> "jsplist" <[EMAIL PROTECTED]> 11/16/02 12:13PM >>>
Hello ! ,
Im running Tomcat on a Windows machine and Ive got my CLASSPATH
pointing to c:\tomcat\lib\mysql.jar .
Then in my webap
arted it with -u root but still got the same error.
Since I installed with the RPM didn't it give root permission?
-Original Message-
From: Scott Pippin [mailto:spippin@;mtctrains.com]
Sent: Tuesday, November 12, 2002 10:43 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: R
Scott Pippin
[EMAIL PROTECTED]
>>> "Phil Iovino" <[EMAIL PROTECTED]> 11/12/02 08:13AM >>>
>I'm trying to install MySQL under RedHat 8. I installed the MySQL
>3.23.53a-1 and MySQL-client 3.23.53a-1 RPMs.
>Per the instructions at
>
.
Scott Pippin
[EMAIL PROTECTED]
>>> "Kees Hoekzema" <[EMAIL PROTECTED]> 10/30/02 10:57AM >>>
Hey,
Use mysqldump.
See the manual / cli help for how to do it :0
-kees
> -Original Message-
> From: Silmara [mailto:silmara.sami@;uol.com.br]
> Sen
recommend, though, saving your larger
tables to a separate file to make the import(if you ever need to do it)
go faster.
Scott Pippin
[EMAIL PROTECTED]
>>> "GAY Samuel" <[EMAIL PROTECTED]> 10/30/02 12:21AM >>>
Hi,
Shut your database down, backup all files, and rest
Make sure it is not part of a primary key.
Use a front-end like
MyCC(http://www.mysql.com/downloads/gui-mycc.html)
or SQLyog(http://www.webyog.com/sqlyog/download.html)
(query, mysql)
Scott Pippin
>>> "Ciprian I. Acatrinei" <[EMAIL PROTECTED]> 10/22/02 08:25AM >>
Search the MySQL list, http://lists.mysql.com/php/search.php for "ram
needed", there are some pretty good references there as to what the
footprint of MySQL is.
>>> Simon Green <[EMAIL PROTECTED]> 10/22/02 02:59AM >>>
Hi
I am putting together a MySQL server for the ISP I work for. We are
going to
UNIX
or the Windows-system-directory in Windows. The INNodb from what I
understand should be set up to run as a global option and not a
server-specific option, that is why you should put it in one of the
directories above.
Scott Pippin
>>> Shomal Bafna <[EMAIL PROTECTED]> 1
We use Crystal and it is great. It is especially good for the more
complicated reports.
>>> "Webmaster MBTRADINGCO" <[EMAIL PROTECTED]> 10/15/02
11:45PM >>>
Hi, does anyone knows if Crystal reports is a good reporter to make
reports out of MySQL, or does anyone knows a good reporter for PHP
MySQ
I have one database(test) i would like to copy over to (test1). Ehat is
the syntax to do this? Is there any to just change the name of the
database?
Thanks in advance
(query, mysql)
-
Before posting, please check:
http://ww
I am trying to set up two data files in case the first one fills up. I
tried to use the following in my.cnf but it says there is an error. If
I take out the reference to the second data file everything works
AIX 4.3.3
MySQL 4.0.4
innodb_data_file_path=libdata1:100M:autoextend:max:2000M;libdat
If you want to stay with 3.23 then download the max version. Install
the max version. Look at one of the .cnf files in the main mysql
directory. Uncomment the lines having to do with innodb. Change the
innodb_data_home_dir variable to be the path you want d:\mysql for
instance. When you are d
I had the same thing happen to me. Go in to services and right-click on
the mysql service. Go to properties and verify that the service is
assigned to the right executable. Mine was not so I had to start MySQL
manually every time I restarted.
(MySQL, query)
>>> Steve Bradwell <[EMAIL PROTECTE
I had the same problem happen to me. Go in to services and right-click
on the mysql service and check the properties. Check that the service
is assigned to the right executable. Mine was not so I had to start it
manually every time I restarted.
>>> Steve Bradwell <[EMAIL PROTECTED]> 10/08/02
I am new to InnoDb and was wondering what steps I would have to do to
restore a table. Lets assume I am backing up the data by backing up the
tablespaces.
Thanks in advance
(MySQL, query)
-
Before posting, please check:
htt
It is supported in MySQL 4.0.x if you use the InnoDb table handler. I'm
not sure about 4.1.
>>> Remco Barendse <[EMAIL PROTECTED]> 09/27/02 09:29AM >>>
Hi!
According to the website MySQL 4.0.x supports "foreign key
constraints".
For version 4.1 "foreign key integrity rules" are planned.
What
I am new to InnoDb and was wondering what steps I would have to do to
restore a table. Lets assume I am backing up the data by backing up the
tablespaces.
Thanks in advance
(MySQL, query)
-
Before posting, please check:
htt
I am new to InnoDb and was wondering what steps I would have to do to
restore a table. Lets assume I am backing up the data by backing up the
tablespaces.
Thanks in advance
(MySQL, query)
-
Before posting, please check:
htt
We are moving a databse over from Oracle to MySQL 4.0.3 and I was
wondering if I should use MyISAM or InnoDb. The databse currently has
800-900 updates and inserts done to it in a day along with about 1000
selects. Would I run in to any table locking problems with MyISAM?
Thanks in advance.
--
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
When will MySQL 4.0 be released as a stable version?
-
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 <[EMA
Which Operating Systems limit MySQL to a 2GB table size?
-
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 <[
I need to run a file called sms.sql from the command line. Is this
possible and what is the syntax?
Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I get the following error when installing the MySql Binary in AIX:
exec(): 0509-036 Cannot load program mysql because of the following
errors:
0509-130 Symbol resolution failed for mysql because:
0509-136 Symbol stpcpy (number 125) is not exported from
depend
54 matches
Mail list logo