--- mysqlman <[EMAIL PROTECTED]> wrote:
>
> I am attempting to get a simple query working:
>
> select *,MAX(a.teaching_date) as max,
> MIN(a.teaching_date) as min from
> teaching a, topic_cat b where a.teaching_topic =
> b.topic_id or
> a.teaching_topic = 999 group by a.teaching_topic
> order b
--- [EMAIL PROTECTED] wrote:
> Néstor wrote:
>
> I think you'd best begin by normalising your
> database. Something along
> these lines:
>
very true indeed, that would save you major headaches
when right after finishing the demo, someone would
say, "can we add a 18 gallon pledge? what about
--- Enrique Sanchez Vela <[EMAIL PROTECTED]>
wrote:
> Date: Mon, 5 Nov 2007 15:01:59 -0800 (PST)
> From: Enrique Sanchez Vela <[EMAIL PROTECTED]>
> Subject: Re: Need help creating query statement
> To: Néstor <[EMAIL PROTECTED]>
>
>
> --- Néstor <
I am fairly newbie at MySQL in general, not to mention
MySQL on Windows which I've never used, but I'll trow
my 2 cents here.
Instead of installing a whole new set of files,
wouldn't that be easier just to start a 2nd instance
of the MySQL server using a different configuration
file? indicating a
ttp://thewishzone.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
--
http://www.savethei
e on a non-partitioned table,
> everything work as
> expected.
>
> I haven't found any limitations of the partitioning
> in the manual, which
> could be the reason.
>
> Is this a bug or a feature ?
>
> Thanks in advance for
ps, I meant to delete the note from my draft
folder... sorry
Enrique Sanchez.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's ||We live in the o
e database and to try to
alter it?
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's ||We live in the outer space
principles than to live up to them
from a mysqldump script.
>
> Cheers,
>
> Tripp
> --- Enrique Sanchez Vela <[EMAIL PROTECTED]>
> wrote:
>
> > hi,
> >
> > I've been assigned the task to come up with a
> script
> > to clean up a database that has a LOT of foreign
> ke
DB DEFAULT CHARSET=latin1
===
I would like to know what would be the best method to
delete some records of the table without lossing
referential integrity.
thanks,
esv.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
.geozoo.org/stacks/Panthera leo
check:
http://us2.php.net/manual/en/function.html-entity-decode.php
next: use substr_replace to replace spaces with
underscores, if there are no spaces then there will no
be replacements :).
check
http://us2.php.net/manual/en/function.substr-replace.php)
fina
iles,
> the rest of the
> configuration, make, and make install ran smoothly.
>
> Thanks for all of your suggestions.
>
> Sean
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often ea
splay everysingle step ./configure is
taking to configure the build process. way down to the
bottom, you will find the program and command line
MySQL's configure was using to test for ssl
availabilty.
regards,
esv.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
---
ts.mysql.com/mysql
> > > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> > >
> > >
> >
> >
> >
> >
> >
> > -
> > FREE E-MAIL IN 1 MINUTE!
> > - [EMAIL PROTECTED] - http://www.pc.nu
> >
> >
ists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
>
>
>
>
> -------------
> FREE E-MAIL IN 1 MINUTE!
> - [EMAIL PROTECTED] - http://www.pc.nu
>
> --
> MySQL General Mailing List
> For list archives: http://lis
/[EMAIL PROTECTED]
> >>
> >>
> >
> >
> >
> >
> >
> >-
> >FREE E-MAIL IN 1 MINUTE!
> > - [EMAIL PROTECTED] - http://www.pc.nu
> >
> >--
> >MySQL General Mailing List
&
nd check for this
parameter:
safe-show-database
if you remove it (and restart the DB server) you and
everybody who logs to the database server will be able
to see all databases.
regards,
esv.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
d1, the server has to go and browse the
whole dataset to search for matches, try creating an
index on user_account1 using id and run an explain
statement against your query.
hope it helps,
esv.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
> I use excell to
> format my queries into graph?
>
If all you need is to query the database and create an
Excel SpreadSheet, I'd use perl plus the DBI and
Spreadsheet::WriteExcel modules.
regards,
esv.
E
the previous query going to update the
news.comments with the last count from the sub-query?
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's||We live in the
SQL
> script for populating the
> > tables.
> >
> > PB
> >
>
> I would like to see these scripts as well. Can you
> please post them
> somewhere, or mail them to me as well?
>
> Dave
>
>
> --
> M
ir=/usr/local/mysql/share/mysql/charsets
==========
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
-
It's often easier to fight for one's||We live in the outer space
uto_increment,
> PRIMARY KEY (ID),
> UNIQUE KEY year (Year)
> ) TYPE=MyISAM DEFAULT CHARSET=latin1;
>
> DROP TABLE IF EXISTS SemesterTBL;
> CREATE TABLE SemesterTBL (
> SemesterYear varchar(50) NOT NULL default '',
> ID int(5) NOT NULL auto_incremen
--- Jeff Smelser <[EMAIL PROTECTED]> wrote:
> On Monday 01 August 2005 12:43 pm, Jason Pyeron
> wrote:
> > On Mon, 1 Aug 2005, Enrique Sanchez Vela wrote:
> > > Most likely you would need to specify the
> database
> > > server hostname with the -h optio
through socket 'no' (2)
>
> trying to disable unix sockets altogether
>
>
>
Most likely you would need to specify the database
server hostname with the -h option.
regards,
esv.
Enrique Sanchez Vela
email: [EMAIL PROTECTED]
ot;
> VALUE=`echo "$ACTION" | mysql -u$APMU -p$APMPW
> -h$HOSTDB -D$APMDB`
> if [ $? != 0 ]; then
> echo $ACTION >> $LOG
> echo [DBERR-001] >> $LOG
> continue
> fi
> echo $VALUE > /tmp/tmp_129.bin
>
> [EMAIL PROTECTED] tmp]# diff ts_129.bin tmp_129.bin
do additional
> queries to get the skill
> > counts?
> >
> > help?
> >
> > Dean...K...
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mys
Hi,
Would anyone explain me why the startup scripts check
for command line arguments and the contents of
/etc/my.cnf right after setting the env variables such
as basedir, pid-file and so?
if the MySQL code and scripts are expected to be on a
specific hardcoded location (yeah, right we could
spe
28 matches
Mail list logo
