At 01:22 AM 3/3/2002 , you wrote:
>I need to pull a variable number of fields from a table from the last
>inputted fields. For example, instead of doing something like
>
> "SELECT * FROM table"
>
>I am looking for a way to do something like this(hypothetical, I don't
>really know what I shou
I need to pull a variable number of fields from a table from the last
inputted fields. For example, instead of doing something like
"SELECT * FROM table"
I am looking for a way to do something like this(hypothetical, I don't
really know what I should do).
"SELECT LAST_TEN_FIELDS FROM
Thanks again, Jeremy. Good stuff all around!
I think the best part is that I can mix and match MyISAM and InnoDB in the
same database for different purposes. Nice to have the choice. (now if there
were only triggers... :o)
--jeff
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTE
mysql_insert_id returns the correct value to my application when I insert a
single
row using the INSERT...VALUES syntax. However, when I insert multiple rows,
it always returns 0. This is inconsistent with the behavior of
LAST_INSERT_ID,
which returns the id of the first row.
Has anyone else ob
>Description:
Down loaded bin/mysqld Ver 3.23.49-max for pc-linux-gnu on i686 from U of
Wisc site gunzipped and untarred in /usr/local ran mysql_install_db then ran
./bin/safe_mysqld & from install directory kept coming up with error 020303 5:20:41
/usr/local/mysql/bin/mysqld: Can't
On Sat, Mar 02, 2002 at 09:51:12PM -0800, Jeff Kilbride wrote:
>
> If you cover stuff like this in your book, I'll definitely buy it.
> :)
Now that's what I like to hear! :-)
> Ok, last question on this subject, I promise! Why not use InnoDB and
> replication? I was looking through the manual ex
On Sat, Mar 02, 2002 at 10:32:39PM -0700, Sasha Pachev wrote:
> On Monday 11 February 2002 01:01 pm, Jeremy Zawodny wrote:
> > Okay, I've hit a bug. ?It happened after the slave had replicated
> > about 5,397,000 queries.
>
> Jeremy:
>
> I have finally gotten around to this and I think I've foun
If you cover stuff like this in your book, I'll definitely buy it. :)
Ok, last question on this subject, I promise! Why not use InnoDB and
replication? I was looking through the manual expecting to find a line that
says "replication is only available with MyISAM tables" -- but I can't find
it a
On Saturday 16 February 2002 01:09 pm, Tod Harter wrote:
> I on the other hand had ZERO luck with it. The server simply segfaults. It
> appears from error log that the initial thread corrupts memory BADLY. All I
> get is a garbage backtrace like:
Tod:
Sorry about the problems. We've hit a few
On Thursday 28 February 2002 02:57 am, Christian Rabe wrote:
> Hi,
>
> I just run into a "problem".
>
> RENAME TABLE put_tablename_here TO another_tablename here
>
> is not replicated. But a
>
> ALTER TABLE RENAME put_tablename_here TO another_tablename here
>
> is replicated.
>
> Is this a
If your server's not running, there won't be a mysql.sock file. It's created
when the server starts and disappears when the server stops. It's not really
a "file" in the regular sense -- it's a unix socket. So, the server does not
need it to start, it creates it and all the other command line appl
On Monday 11 February 2002 01:01 pm, Jeremy Zawodny wrote:
> Okay, I've hit a bug. ?It happened after the slave had replicated
> about 5,397,000 queries.
Jeremy:
I have finally gotten around to this and I think I've found the bug. At
least, on a different system where I could repeat it before m
It's like multiple script try to update the same piece of data in
the mySQL at the same time.
Do I need to provide a method to synchronize to all my scripts.
Son Nguyen
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> Son,
>
> Saturday, March 02, 2002, 6:34:37 AM, you wrote:
>
> S
Ok, I think I have mentioned this like 3 times already. there is no
mysql.sock anyplace on my system. I need a mysql.sock file.
I have set the symbolic links. Originally they were in the /var/lib/mysql
directory, then I changed it to the /tmp directory per so many peoples
advice. not mater wh
On Fri, Mar 01, 2002 at 02:41:03PM -0800, Jeff Kilbride wrote:
>
> Does replication hurt MyISAM performance in the same way? If I'm
> running a master that takes all the inserts and one or more slaves
> to take all the select queries, would it be better implemented in
> MyISAM or InnoDB?
It depe
Hi!
> "martinG" == martin tunggorono <[EMAIL PROTECTED]> writes:
martinG> Thanks for the article it is definitely helpful and narrow down my choice.
martinG> Anything against the 4.0 MAX here?
MySQL 4.0.1 max should be quite safe to use
Note that as InnodB is already included in the stand
I ran the following command to change the status field from a varchar
text to ENUM("Input","Published") NOT NULL
$sql = "ALTER TABLE $table_name
CHANGE status
status ENUM(\"Input\",\"Published\") NOT NULL
";
The changes took effect according to the comm
You need to create a symbolic link
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
or
ln -s /tmp/mysql.sock mysql.sock
Do a search to find where it's at first though
locate mysql.sock
Mike
-Original Message-
From: Intrex [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002 8:14
Hi!
> "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes:
Benjamin> Hi.
Benjamin> IMHO your query should work. This looks like a bug to me. I can
Benjamin> confirm this on 3.23.46, but have no more current version available
Benjamin> for testing.
>> I'm having a simple but annoy
All:
For compiling (MySQL v4.0.1), can anyone tell me the preferred threads
package to use under SuSE linux? The included mit threads? Or Linux
portable threads pthreads¹? This is under a SPARC architecture.
On a new build of 4.0.1, we are getting bdb errors related to architecture
does not
Have you tried running these from the command line mysql client, to see what
may be up? Maybe you have a variable in your code that's not getting
re-initialized properly.
If you get the same results from the mysql client, it might be time to run
myisamchk on your table. (or just dump the data, dr
Bill:
What about the DBI's quote() method... isn't this what its for?
http://www.mysql.com/doc/P/e/Perl_DBI_Class.html
Keith
-Original Message-
From: Bill Platt [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 02, 2002 2:25 AM
To: [EMAIL PROTECTED]
Subject: Quotation Marks in Mysql fiel
Actually, I've been looking pretty closely at a couple of other tables I
wanted to implement as HEAP tables -- and I didn't even think about moving
my little lookup tables into HEAP. :)
Thanks!
--jeff
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jeff Kilbride" <[
--- DL Neil <[EMAIL PROTECTED]> wrote:
> John,
>
> > I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
> > results are the same as when I attempt = \"published\"
> >
> > Something in the query processing works differently when = is
> used in
> > the WHERE.
> >
> > I can see no expla
Hi Jeremy,
My follow-up for this answer from the other list was:
Does replication hurt MyISAM performance in the same way? If I'm running a
master that takes all the inserts and one or more slaves to take all the
select queries, would it be better implemented in MyISAM or InnoDB
On Wed, Feb 27, 2002 at 09:14:51PM -0800, Jeff Kilbride wrote:
>
> Is there a rule of thumb for small tables and whether they should be
> indexed? I have several small, two column lookup tables with few
> rows (100-300) and some very small tables (< 10 rows). I don't plan
> on indexing the very sm
Having worked with Oracle, and MS SQL databases, the only "backup/recovery"
I usually deal with after the admins have their dumpdb run to a secondary
transaction database is tape backup of some form. Most of the sites I have
worked with however use 3 disk mirrors, and disk cloning, and disk snap
Well, my MySQL server is not running. I have followed all of the
instructions to install, and no matter what commane I run the server does
not run, and I get the error I mentioned below.
locate mysql.sock provides nothing. I am just about to go back to Win2k and
IIS. God the though of that mak
On Sat, Mar 02, 2002 at 06:52:57PM -0800, Jeff Kilbride wrote:
> I'm looking to make the move to InnoDB, too. All I've heard is positve.
> Here's a reply I got on another list:
>
>
> If you have a very busy read/write op database, MyISAM can't handle
> it. It's very efficie
I'm looking to make the move to InnoDB, too. All I've heard is positve.
Here's a reply I got on another list:
If you have a very busy read/write op database, MyISAM can't handle
it. It's very efficient for when you have many more reads than
writes, but once you start hitting
First of all, are you sure MySQL is running? The mysql.sock file only
appears when the server is running. Run the following command on the command
line to make sure:
ps awx | grep mysqld
You should see one line with "safe_mysqld" in it, and at least a few lines
with "mysqld" in them. If not, you
On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote:
>
> Hi,
>
> I am planning to have MySQL database backup and recovery from the
> web interface. Is it possible to do this. If yes, then what
> procedure I should follow. If anybody have any idea about this then
> please, do help me.
Hi,
I am new to MySQL and to this list. I am currently going through Paul Dubois' book,
"MySQL." I have set up MySQL on my Win 98 machine and am able to access and create
databases and tables.
The problem I am having is when I try to LOAD DATA, I get the following error: "The
used command
On Sat, Mar 02, 2002 at 11:14:42PM +0100, Steve Rapaport wrote:
>
> I'm seriously considering switching to mysql-max so I can make my
> session handling table an Innodb type. Currently the mysql locking
> policy allows big traffic jams when several sessions are active
> simultaneously, and it's t
I was experimenting with BLOB (binary large object). I have learned my lesson and
decided it's NOT a
good idea to store binary files in a mySQL database. However, the damage has been
done so to speak. I
stored some pictures in a mySQL database, now I cannot get them out.
When I use mysqlfr
I installed mysql-3.23.49a on my redhat 7.2 machine with the binary.
While working throught the tutorial I was attempting to do:
load data local infile "/home/tomb01/data/pet.txt" into table pet;
and got:
ERROR 1148: The used command is not allowed with this MySQL version
What is the real meaning
Ok here it is. I get that annoying error. ERROR 2002: Can't connect to
local MySQL server through socket /var/lib/mysql/mysql.sock (111)
Ok now I DO NOT have a mysql.sock anyplace on my system. I have downloaded
the "stable" .tar.gz and unzipped it and still do not have a mysql.sock
Someplea
re. my previous message:
I found a few postings suggesting setting CXXLD=g++, and indicating that I
needed to have v3 of libstdc++ installed.
Did it, and the library is installed, but got the same error message.
Any suggestions?
---previous message---
Hi,
I'm trying to install the latest ver
Alex,
> Thanks, but I'm still stuck! on a page using mysql how do I use the
query
> you gave me in a page?
> this is my code now but it wont show the total groundballs, how do I
make it
> add up the sum of all the rows then output it onto the page for me?
>
> $db = mysql_connect("db", "", "*
Spambusting: MySQL
> Hey Alex,
>
> > I am looking to take a column in my table and add all the values,
they
> are
> > all numerical. how do I do this? Below is an example of my table:
> >
> >
>
+-++--+-+-+---+-
>
> > -+
Thanks for hte help with both the SUM and ABG mysql fuction, can you take a
look at my last e-mail too and see if you can help me implement this code
into my site?
Thanks!
-Alex "Big Al" Behrens
E-mail: [EMAIL PROTECTED]
Urgent E-mail: [EMAIL PROTECTED
Thanks, but I'm still stuck! on a page using mysql how do I use the query
you gave me in a page?
this is my code now but it wont show the total groundballs, how do I make it
add up the sum of all the rows then output it onto the page for me?
Thanks!
Hi,
I'm trying to install the latest version of MySQL on a Netra AC200 running
Solaris 2.8, using gcc 3.0.3.
Configure command was:
CC=gcc CFLAGS="-O3 -mcpu=v8 -Wa,-xarch=v8plusa" CXX=gcc CXXFLAGS="-O3 \
-felide-constructors -fno-exceptions -fno-rtti -mcpu=v8 \
-Wa,-xarch=v8plusa" \
./configure
John,
> I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
> results are the same as when I attempt = \"published\"
>
> Something in the query processing works differently when = is used in
> the WHERE.
>
> I can see no explanation in the data stored in the table.
The important thing
Hey Guys & Gals,
I'm rather new to mysql and need some help accomplishing a command for my
site:
I am looking to take a column in my table and add all the values, they are
all numerical. how do I do this? Below is an example of my table:
+-++--+-+
I'm seriously considering switching to mysql-max so I can make my
session handling table an Innodb type. Currently the mysql locking policy
allows big traffic jams when several sessions are active simultaneously,
and it's the only table that has frequent updates. I need row-locks!
BUT, and it's
Hi,
I'm running mysql 4.0.1.max on freebsd 4.4-stable. I have a fairly high
volume db server which is user to processe approx 200 apache hits/sec. After
previously having problems with 4.0.0 I changed to 4.0.1 and everything
seemed fine for about 4 days. The exact same queries happen almost ev
It's probably easier to resync the whole database to the laptop, than try to
do two-way updates -- unless it's very hard to copy the datafiles from the
central database.
You can use the binary logging facility of MySQL to keep track of changes on
the laptop and then update those changes to the ce
Evening all,
Apologies if this is more of an Access problem but am not sure which end of
the system needs tweaking.
I have an Access database that I have exported and linked the tables from
MySQL. At present I am still using the previous forms in Access to input
data but it is causing problems.
Hi,
I have the following problem:
I have a database in mysql and a C++ program to manage it. Now some people
need to work in the train or something on their laptop, so I was wondering
if it's possible to put the same mysql-database local on the laptop and let
those people edit it local.
Then when
I know Databases are supposed to be larger than the data normally would
be in straight txt form, but 370% larger?
I'm a newbie to MySQL. I made a new database/table with 2 columns and I
was importing a 24.1 meg TXT into column 2. It's nothing in
particular...just radom txt and words because I wan
I tried using LIKE \"%published%\" and even LIKE \"%ub%\" The
results are the same as when I attempt = \"published\"
Something in the query processing works differently when = is used in
the WHERE.
I can see no explanation in the data stored in the table.
John Hughes
--- Jeff Kilbride <[EMAIL
I am creating site for greeting cards and need help desiging tables for DB
Currently I have three tables..
1) maincat which has following fields:
maincatid (autoincrement)
main_name (name of category)
2) subcat which has following fields:
subcatid (autoincrement)
maincatid
sub_name (name of sub ca
--- Georg Richter <[EMAIL PROTECTED]> wrote:
> On Saturday, 2. March 2002 09:32, John Hughes wrote:
> > I have a table with approximately 600 rows. Two of the fields are
> > "record_date" and "status" Every record has an entry in the
> > "record_date" in -00-00 format. The "status" is eithe
BS> Wow, never would have come up with that, thanks very much for the help.
I'm half way done with a programming version rather than sql. I will try
yours first.
BS> I guess this would work if person_id 3 was also assigned to org 1 as
well as org 2, they wouldn't show up the final results?
Yes
It's like multiple script try to update the same piece of data in
the mySQL at the same time.
Do I need to provide a method to synchronize to all my scripts.
Son Nguyen
--- Egor Egorov <[EMAIL PROTECTED]> wrote:
> Son,
>
> Saturday, March 02, 2002, 6:34:37 AM, you wrote:
>
> S
On Tuesday 12 February 2002 09:23 pm, you wrote:
> Sasha,
>
> I compressed it first, 'cause it was nearly 400MB in size. ?It's on
> the FTP site as mysqld.core.bz2.
Jeremy:
Can you upload the binary itself also? I need it to be able to study the core.
--
MySQL Development Team
For technical s
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
[skip]
> 22 rows in set (0.00 sec)
>
> mysql> DELETE FROM online WHERE date < 1001511;
> Query OK, 21 rows affected (0.01 sec)
>
> mysql> SELECT * FROM online;
> ERROR 1030: Got error 124 from table handler
>
> So the problem is here when th
I believe the problem occurs only when I execute the DELETE when someone is
inserting a records at the same time.
Perhaps the hash index is not updated properly whereas the data are deleted
properly, which entails a mismatch between data and index ?
(I believe this because the following behaviour
Hi,
In fact it seems to be really hard to reproduce and to provide you a
testcase, because I've no idea of what could be the reason of this error.
I've an other site with exactly the same table structure, and it runs
without a glitch.
The only clue I have is that the server which return the error
Fournier Jocelyn [Presence-PC] writes:
> Hi,
>
> I encounter a strange problem on one of my server with a lot of heap table.
> (I'm using latest mysql-4.0.2 version)
> Here is the error :
>
> mysql> use forum;
> Database changed
> mysql> SELECT * FROM online;
> ERROR 1030: Got error 124 from tab
- Original Message -
From: "cherian" <[EMAIL PROTECTED]>
To: "MySql" <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 1:12 PM
Subject: Hi
> Hi,
>
> I have an application that has got Oracle as the central databse, if all
the
> client machines are online then it will update the central
Dear Sirs,
Please see our medical and health informatical project with freesoftware.
The aim of this idea is to offer high quality and economically available
software to contribute to health networks development, specially in
unfavorized regions.
The website is at
http://ovnibus.free.fr
We will
While I'm at it...
ROUND(X,D) and FORMAT(X,D) are quite similar, but they are in different
places in the documentation. Why is FORMAT() placed under Miscellaneous
functions? It seems to be just as mutch 'mathematical' as ROUND(), even if
it returns a string... (All the 'mathematical functions' r
Hi,
I have an application that has got Oracle as the central databse, if all the
client machines are online then it will update the central oracle databse
otherwise in the offline mode the client machine will update the local MS
Access databse, and later on when ever the network comes back the ce
Hi,
I've been struggeling with floating point numbers for a couple of days, and
in the process reading up on the different numeric types in the online docs.
I came across what I think is a serious inconsistency.
http://www.mysql.com/doc/N/u/Numeric_types.html >
This page describes DECIMAL (and
cherian,
Saturday, March 02, 2002, 12:42:46 PM, you wrote:
c> Is MySql a freeware that we can distribute with our application?
c> If not how does the prcing and all work/ from where can I find details
c> regarding this?
MySQL is free for regular usage, but there are some cases when licensing
is
* Jamil Ahmed
> is this a mysql Bug ?
>
> curdate()-3 returns 20020299
> curdate()-2 returns 20020300
No, curdate() returns "today" as a "date string" or as a number, based on
the context in which it is used. From the manual: "Returns today's date as a
value in '-MM-DD' or MMDD format, de
On Saturday, 2. March 2002 12:10, Jamil Ahmed wrote:
> is this a mysql Bug ?
>
> curdate()-3 returns 20020299
> curdate()-2 returns 20020300
No it's not a bug! But why do you want substract numbers from a string?!
In this case 2002-03-02 will be interpreted as 20020302 and from
Hi
Rekall from http://www.theKompany.com includes a task scheduler
At 09:27 02/03/2002 +0100, Georg Richter wrote:
>On Saturday, 2. March 2002 09:11, Varsha Gaware wrote:
>
> > Can I schedule a task in mysql ? I want to perform some operation on
> > database after a specific period of time. Is it
is this a mysql Bug ?
curdate()-3 returns 20020299
curdate()-2 returns 20020300
Keep smiling, ;^)
~Jamil
*
mysql> select curdate();
++
| curdate() |
++
| 2002-03-02 |
++
1 row in set (0.00 sec)
mysql>
Hi,
Is MySql a freeware that we can distribute with our application?
If not how does the prcing and all work/ from where can I find details
regarding this?
How much Disk space does MySql require to run also the memory ?
Regards,
Cherian.
Son,
Saturday, March 02, 2002, 6:34:37 AM, you wrote:
SN> Does mySQL synchronization between queries? How does mySQL handle the
SN> query synchronization. Does anyone know?
What do you mean "query synchronization" ?
--
For technical support contracts, goto https://order.mysql.com/
This
Jason,
Friday, March 01, 2002, 8:45:23 PM, you wrote:
JF> I'm running the latest MySQL on RH Linux 7.2, and I'm trying to figure out
JF> how to make the MySQL server accessible via the net (on port 3306, I assume).
JF> Right now, the server is just accessible from the localhost.
MySQL is accessi
Wilbur,
Saturday, March 02, 2002, 12:23:08 AM, you wrote:
WS> I'm doing development directly in C.
WS> So which API is recommended..?
MYSQL C API
Look at:
http://www.mysql.com/doc/C/C/C.html
WS> Wilbur
--
For technical support contracts, goto https://order.mysql.com/
This email is s
At 13:26 01/03/2002 -0700, Van wrote:
>Ronald Arenas wrote:
> >
> > I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
> > my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
> > 3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My
> atte
Hi
All you need to do is include a symlink on libmysqlclient.so.11 to point to
libmysqlclient.so.10
e.g ln libmysqlclient.so.11 libmysqlclient.so.10
At 15:18 01/03/2002 -0500, Ronald Arenas wrote:
>I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
>my RH 7.2 box. Now
On Saturday, 2. March 2002 09:32, John Hughes wrote:
> I have a table with approximately 600 rows. Two of the fields are
> "record_date" and "status" Every record has an entry in the
> "record_date" in -00-00 format. The "status" is either "input"
> or "published" (I DID NOT create this colu
If your condition that the status field only contains two values holds true,
then there should be no difference in the two queries you have below -- that
I can see, unless someone can prove me blind...
Are you *absolutely* sure none of the columns contain extra spaces, nulls,
etc...? You might tr
I have a table with approximately 600 rows. Two of the fields are
"record_date" and "status" Every record has an entry in the
"record_date" in -00-00 format. The "status" is either "input"
or "published" (I DID NOT create this colum as ENUM; those are simply
the only values my PHP interface
On Saturday, 2. March 2002 09:11, Varsha Gaware wrote:
> Can I schedule a task in mysql ? I want to perform some operation on
> database after a specific period of time. Is it possible ?
Hi,
MySQL currently has no task schedulers. But you can use "cron" (*nix) or "at"
(windows) commands to sta
On Saturday, 2. March 2002 08:11, Hoo Kok Mun wrote:
> Hi,
>
> I have look thru the website on date and time functions but nothing that I
> can use.
> http://www.mysql.com/doc/D/a/Date_and_time_functions.html
>
> How do I dynamically calculate how many working hours in a particular
> month? Has an
On Saturday, 2. March 2002 08:24, Bill Platt wrote:
> Now, my question is this. How do I get the database to accept
> the quotation marks and apostrophes?? The kind of data I am
> entering into the tables is better with these items left in
> rather than left out.
>
Hello Bill,
all you have to do
83 matches
Mail list logo
