On Fri, 2003-07-11 at 13:41, Nils Valentin wrote:
> Hi MySQL Fans ;-)
>
> I would like to list all courses with have less than lets say 10 participants.
> Does anybody know how I would have to modify the code below to get this to
> work ?
>
> schedule_id is the course itself
>
>
> SELECT sche
On Sun, 2003-01-05 at 00:00, David & Angela Ehmer wrote:
> Hi
>
> I am having problems generating the mysqldump file. I have tried a range of
> options and carefully studied several tutorials I have on using this
> command. Each time I get the following errror.
>
> ERROR 1064 you have an error
"year/month/day - hour/minute"
basically i need some select command like this:
SELECT * FROM NEWS ORDER BY "year/month/day - hour/minute" DESC LIMIT 10
How can i do such a thing?
Thanks.
look at:
http://www.mysql.com/doc/en/String_f
sql, query, mysql,"I'm a lumberjack and I'm ok" for he spam police.
Has anyone been successful in signing up for the certification exam?
I've entered dates going up to Jume 30,2003 to schedule an exam and all
I get back is exam not available.
John
---
ySQL is looking for a integer
so as to tell how large to make VARCHAR at it's largest value.I suggest
you read:
http://www.mysql.com/doc/en/Storage_requirements.html
John Coder
-
Before posting, please check:
http://www.
p one hundred result,
> but this is left out.
>
> So the question is, can I limit the result and get all
> the highest scores from my table with a query, or do I
> have to add a counter in my PHP-script that breaks out
> of the loop at 100?
>
> Must this be done in PHP?
>
> Thanks for all replys to my topics, btw.
>
What exactly do you want all you state is what you don't want.
John Coder
-
Before posting, please check:
http://www.mysql.com/manual
to do to show the album name and song title for song ID # 1
> above).
>
Try
Select name from album join reference join songs where
album.ida=reference.ida and reference.ids=songs.ids and
songs.title='sometitle';
John Coder
--
#x27;');
> #
>
> is there a way to run, and restore the database with this file. i dont have
> phpmyadmin installed, didnt really like the prog and trying to learn mysql
> through t
On Sat, 2002-11-09 at 23:53, Chip Shabazian wrote:
> ok, here is my code without all of the html (sorry people). I'm trying
> to get a sum of the field runtime. With this code, I get "Resource id
> #3" as an error. Any help getting me to the proper result would be
> greatly appreciated.
>
> @$
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote:
>
> > > tables have met with a 1175 error ("You are using safe update mode and you
> > > tried to update a table without a WHERE that uses a KEY column").
> > Nothing is obvious and is hard to advise you if you don't give us some more
>
word: NO)'
>
> in /etc/group, I added root and my user john to the mysql group.. but
> that did not help.
>
> If there is something in the manual, please point it out to me, so I can
> figure this mess out.
>
> Thanks a million
>
> John
Have you ran
On Fri, 2002-11-08 at 14:12, SpyProductions Support Team wrote:
>
> I just installed the most recent version of MySQL with an RPM (through
> webmin interface), but it doesn't seem to have installed a
> mysqladmin.anyone know why? :)
>
> Thanks!
>
> -Mike
>
Probably you just installed the s
115
I personally would try:
SearchSQL=select
MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,
MarketData.Occupation,MarketData.Country,County,MarketData.Forename,
MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts
WHERE MarketData.CustID=Contacts.C
At least we called them intersecting entities while
> I
> > > was in Oracle training (which was some time ago). I think I
> remember
> > > how to set them up, but I'd love to have something to refer to
> quickly
> > > before I start. Can anyone point
mail on my form (it works because the person has posted
>their e-mail name when logging in). How can I echo the company and email on to my
>form as well. Please help.
>
Is this query on your form or the form that the person has filled out?
John Coder
---
support through tje dbx commands look at
the manual for PHP condcerning dbx. My copy says it's experimental. I
suggest looking at php.net for some online documentation concerning dbx.
>
> At 12:03 AM 11/5/2002 -0500, John Coder wrote:
> >On Mon, 2002-11-04 at 23:51, Ken Arck wrote:
&
On Mon, 2002-11-04 at 23:51, Ken Arck wrote:
>
> > then it's compiled under dbx functions not mysql functions run
> >configure again with the same arguments except for mysql just run
> >--with-mysql and it should be ok.
>
> <-As I said, it was installed from an rpm as part of the Redhat inst
On Mon, 2002-11-04 at 23:20, Ken Arck wrote:
> At 10:32 PM 11/4/2002 -0500, you wrote:
>
> > What exactly do you mean by compiled in ? what does your phpinfo say.
> >You should have a section on mysql not just the line supported databases
> >mysql,pgsql,etc.
>
>
On Mon, 2002-11-04 at 21:51, Ken Arck wrote:
> Hi folks. I'm a real newbie to mysql (believe it or not!)
>
> While just starting to get my feet wet in it, I've come across a huge
> stumbling block already. I am familiar with php however.
>
> A php script I'm playing with has this line:
>
> $db =
Is it possible to do a insert into blah
(select...)union(select.)
with mysql 4.03?
John Coder
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
On Mon, 2002-11-04 at 18:52, john wrote:
>
>
> When I start safe_mysqld &, I get a command prompt back again and ps aux
> shows this:
>
> mysql30269 0.0 0.1 10580 1024 pts/1S17:38 0:00
> /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/lib/my
merge at www,mysql.com
John Coder
-
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 PROTECTE
nsely that I
> forgot which machine it happened on... Please forgive me, it did happen on a
> Redhat 7.0? 7.1 build of Redhat! I compiled it from source
> ./config --prefix=/usr/local. I am so sorry. This is a production machine...
> What's the best way to upgrade from this to 3.2
On Mon, 2002-10-21 at 13:07, Chip Rose wrote:
> I can't get PHP-4.2.3 compiled to work with MySQL and Apache, despite months
> of trying. Apache compiled ok, and so did MySQL -both work, on my Debian
> Linux box.
>
> I've tried various combos of installing the Deb packages, compiling from
> so
; I was trying mysql> @theFile, but it doesn't work.
>
> Thanks,
>
> Andre
>
Also the mysql --help shows that \. does it from the command prompt.
John Coder
-
Before posting, please check:
http://
am I doing wrong ??
>
>
> Thanks, Daniel
it's easier to do this from and rpm that suse provides. if you do
reinstall using a rpm from suse before you issue the command
mysql_install_db run the command from any terminal 'r
ase
> files?
>
> 2 - Can you change the default directory for a data
> base?
>
> 3 - How do you get Linux to search the entire disk for
> a file?
>
> Thanks for any help...
>
> tmb
look in /var/lib/mysql t
rom the binary, is this possible? The workaround
> provided below does not seem to be tested, before I cause any more damage I
> would like to clean the orig install up, if it even did anything... Thanks.
I beleive the command is rpm -e
-e for erase I assume
John Coder
> Found this
Max is a server.
your install directory out of an RPM should be /var/lib/mysql if you are
root su to root and see if it's there. It should tell you this in
/usr/share/doc/packages/Mysql
thwere's a manual there or it should be.
John Coder
On Thu, 2002-10-03 at 21:55, Chris Be
;
> SELECT hl7incom.id
> FROM hl7incom, pid_segment
> WHERE hl7incom.msg LIKE '%PID%'
> AND pid_segment.id != hl7incom.id
> GROUP BY hl7incom.id;
>
Try
SELECT hl7incom.id
FROM hl7incom, pid_segment
WHERE hl7
Check out
http://www.mysql.com/doc/en/mysqldump.html that should help you.
John Coder
On Sat, 2002-09-28 at 13:18, Shaun Bramley wrote:
> Hello all,
>
> I have yet to find this bit of information within the documentation. Is it
> possible to copy the contents of a table
Just a thought look in your my.ini file and make sure the paths are
correct. I too had this problem but I was upgrading to a binary from an
rpm and that was where my problem was. the my.ini file expected the
paths to be in /var instead of /usr/local.
Hope this helps
John Coder
On Sat, 2002-09
die(mysql_error());
$totals=mysql_query("SELECT COUNT(deptId),sum(complete),
sum(InProgress),sum(parts),sum(deferred),
sum(reset)/sum(complete) * 100 ,sum(Tmp.reset)/$days_result
from
Tmp");
any thoughts on the dupl
ssion
>denied
> rm: cannot unlink `/var/lib/mysql/cords-orj86jfje.pid': Permission denied
> Fatal error: Can't remove the pid file: /var/lib/mysql/cords-orj86jfje.pid
> /usr/bin/safe_mysqld: /var/lib/mysql/cords-orj86jfje.err: Permission denied
> Please remove it manually an
On Wed, 2002-09-25 at 10:10, Keith C. Ivey wrote:
> On 25 Sep 2002, at 0:57, John Coder wrote:
>
> > So it's probably the fact that I didn't make the connection persistent
> > that screwed me up sometimes I feel so stupid.
>
> I don't think that will hel
So it's probably the fact that I didn't make the connection persistent
that screwed me up
sometimes I feel so stupid. hehehe
John
On Wed, 2002-09-25 at 00:34, Paul DuBois wrote:
> >hi all
> >I',m wondering if temporary tables stay around longer then the page you
> >use to create them if you crea
hi all
I',m wondering if temporary tables stay around longer then the page you
use to create them if you create them with a php page. my thoughts were
they do but mine doesn't for some reason. I've made a temporary table to
query on a page that draws a pie chart out of the data in the temporary
ta
38 matches
Mail list logo
