RT_ID().
Best,
/ Carsten
On 08-10-2015 15:48, Richard Reina wrote:
If I insert a record into a table with an auto increment ID how can I get
that records ID value? I have read about SELECT LAST_INSERT_ID() statement,
however, do not two statements introduce the risk that another insert may
occ
at line 1
Try:
alter table car_table modify column color varchar(10) after model;
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Or use the LOCAL diective to have the client send the csv file contents
to the server.
/ Carsten
On 23-06-2014 16:59, Scott Helms wrote:
I generally drop them into /tmp for easy access and cleanup after the data
load, but you can put them any place that the mysql daemon process has
access to
On 29-03-2014 19:26, william drescher wrote:
I am given a table: ICD9X10 which is a maping of ICD9 codes to ICD10
codes. Unfortunately the table contains duplicate entries that I need
to remove.
...
I just can't think of a way to write a querey to delete the duplicates.
Does anyone have a sugg
RAM all your live data will easily fit
in RAM at any given time - read speed will not be dependent on the disks
once the data is loaded.
Write speed might. "lots of writing" - what is that? 1000 10kB
inserts/sec? 100 1MB inserts/sec?
Best,
/ Carsten
--
MySQL General Mailing Lis
I don't know what you mean by "straight" mysql connection. At any rate,
the idea is to use --quick or otherwise using a connection which uses
mysql_use_result over mysql_store_result.
http://dev.mysql.com/doc/refman/5.6/en/mysql.html
Best,
/ Carsten
On 19-02-2014 12:02, M
If you're doing this from the cmd-line client, try running it using --quick.
Best,
/ Carsten
On 19-02-2014 09:03, Machiel Richards wrote:
Hi guys
I am hoping that someone might have experienced this before or
might know why we are getting this.
We regularly need to run
rence.
...right up to the day one of the disks fail, and you thought you could
just plug in a new spindle and let the system take care of the rest...
http://www.miracleas.com/BAARF/
http://www.miracleas.com/BAARF/RAID5_versus_RAID10.txt
/ Carsten
--
MySQL General Mailing List
For list archives:
This may be a naive question, but I'm not sure I can see you've covered
this: Have you tried "USE logs" before DROP TABLE `#sql-ib203` (without
the "logs/" bit)?
/ Carsten
On 19-06-2013 21:00, Franck Dernoncourt wrote:
Hi all,
A table `logs/#sql-ib203` appea
Based on the little information available, I would make a lookup field
consisting of tablename and primary keys.
(although I still believe that storing this information in the database
in the first place is probably the wrong approach, but to each his own)
/ Carsten
On 31-05-2013 12:58
erts you can do per second over the next 1.000 years if you use
a longint auto-increment field for your PK.
/ Carsten
On 31-05-2013 11:14, Neil Tompkins wrote:
Thanks for your response. We expect to use the Audit log when looking into
exceptions and/or any need to debug table updates.
when it comes to searching for text
strings. You could even consider having a CSV table, which will give you
an SQL interface to said text file.
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
:-)
...not to mention the many query generator tools that might come into
use, which will fail because they do not consistently use back-ticks.
NEVER use identififers - database or otherwise - that start with a digit.
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
You don't specify how many different types (including min/max values)
you expect to be using. If you expect to end up with a few hundred, then
you should perhaps consider using an ENUM or SET column directly in the
data table.
/ Carsten
On 10.08.2012 10:51, Gaston Gloesener wrote:
around. The
query you're showing here will force a table scan to calculate
LOWER(ksd) for every single row.
Also, how do you know that ksd id unique (as stated in your original
post)? You have no index on it to ensure uniqueness.
You'll have to find some other way to query the table.
Alternatively, you can copy the data into another table easily:
http://www.bitbybit.dk/carsten/blog/?p=115
Best,
/ Carsten
On 14.05.2012 09:34, P.R.Karthik wrote:
Hi Rafal,
If there are more slow queries in your server and logging them into a table
will increase the IO of the server.
It is
pping you from using
Excel or Access. Just create a read-only user on the tables they need to
view, and set up the client with Connector/ODBC.
Best,
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
(Key1, Key2) IN (val1, val2),(val3,val4), ...
If 'Abc' changes per Key1&Key2 values, explore the CASE statement.
Best,
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
le=databasetoignore.* | gzip >
/media/disk-1/Server11_MysqlBackup_15September2011/mysql_15sep2011backup.sql.gz
or create a short script that asks mysql> for all databases, greps away
those you don't want to dump, and runs mysqldump on the rest.
/ Carsten
3)
The docs are here for
`userTable.userid` => `userTable`.`userid`
/ Carsten
On 09-09-2011 23:01, Dotan Cohen wrote:
Now that I've got the syntax right, MySQL is complaining that a field
does not exist, which most certainly does:
mysql> UPDATE
-> `userTable`
-> INNER JOIN `anotherTab
On 22.04.2011 22:41, Larry McGhaw wrote:
It does appear to be some type of bug to me.
I agree. I was thrown by Daniels "first and third" comment, which I
guess should read "second and third"
I reproduced the behavior in 5.1.53-community on Windows.
/ Carsten
--
MySQL
ldn't at least one of them match the single row?
(Preferably first and third ones.)
What am I doing wrong here? I have no clue what's going on... Thanks a lot!
Hint: What's the output of "SELECT * FROM `myview`?
/ Carsten
--
MySQL General Mailing List
For list archives: http://
Den 23-02-2011 18:41, Jim McNeely skrev:
Is there a way to set the auto-increment for a particular table to increase by
some number more than one, like maybe 10?
Thanks in advance,
Jim McNeely
CREATE TABLE t (
...
) AUTO_INCREMENT=10;
/ Carsten
--
MySQL General Mailing List
For list
ehr...
Den 23-01-2011 15:36, Carsten Pedersen skrev:
Seeing from later posts that you're using InnoDB, why don't you simply
wrap the INSERT/UPDATE into a transaction? You don't avoid the UPDATE,
but I'm not sure I understand the need to mess w/ triggers.
BEGIN
INSERT INTO
Seeing from later posts that you're using InnoDB, why don't you simply
wrap the INSERT/UPDATE into a transaction? You don't avoid the UPDATE,
but I'm not sure I understand the need to mess w/ triggers.
BEGIN
INSERT INTO t(id) NULL
UPDATE t SET xxx=last_insert_id()
COMMIT
B
Usually this is caused by DNS-based authentication, where the
reverse-DNS lookups are hanging for one reason or another.
If you can, switch to IP-based authentication and use --skip-name-resolve.
/ Carsten
On 05.01.2011 08:26, Yogesh Kore wrote:
Hi,
What is unauthenticated user seen in
and mysqlimport
- checking user privileges (are you using the same account in both
instances?)
- checking the line delimiter and --lines-terminated-by
FWIW, I always prefer tab-delimited files over comma-separated ones.
This gets around a lot of i18n issues.
/ Carsten
Den 03-01-2011 19:33, J
s with error 1045. My
/etc/passwd file looks like there is no password for user mysql. What
else should I try?
You should use the password for the _MySQL_ root user, which is _not_
stored in /etc/passwd, but within MySQL.
/ Carsten
--
MySQL General Mailing List
For list archives: http://
detect that you got an error
1062, then do a db search to find out which field or fields have duplicate
information. Cumbersome, but OTOH you'd also get a chance to realize if
more than one key field is duped.
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.
y succesful with MySQL implementations, so if
you already have a marked preference for working with MySQL, you might want
to look at other products before making a decision. Having read that page,
I know I would.
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
it on the
> number of tables you can have in a schema imposed by mysql?
Not by MySQL. On some file systems, there's a practical limit of ~10k
tables/database. At that point, looking up directory entries can cause
slowdowns.
/ Carsten
--
MySQL General Mailing List
For list archi
ticed,
but e.g. "0x123" is going to give you a nasty surprise.
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Haven't done this in a while, but I'm guessing that you can't create
both a constraint and an index with the same name?
Type mismatch will in my experience most often generate an errno 150.
/ Carsten
j...@msdlg.com skrev:
I'm trying to create a foreign key by exe
There are SETs and ENUMs, but I've always found that dealing with them is
annoying.
YMMV
/ Carsten
On Fri, 14 May 2010 13:54:29 +0530, "Samrat Kar"
wrote:
> Hello,
>
>
>
> How to store multiple values in a single field? Is there any array da
Gving the full error message would be helpful.
Check that the sql mode settings for ALLOW_INVALID_DATE, NO_ZERO_DATE
and NO_ZERO_IN_DATE are the same on both master and slave.
/ Carsten
Prabhat Kumar skrev:
Hi,
I have setup replication between 2 servers, on both there is different
versions
rk on strings.
You should add a field to the result with the numerical value of
Balance, and then sort on that.
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
osely.
Wouldn't that strategy cause problems if one or more rows have been
deleted in the meantime? (i.e. sequence numbers 1-4 have been created, row
2 has been deleted - new sequence number would be 4).
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql
ressed since
then. How old is that MySQL book?
Remove the manual edits you have made to the grant tables, and use only
GRANT and REVOKE. I believe this will do what you want:
CREATE USER "lentes"@"localhost";
GRANT ALL ON "lentes_%".* TO "lent
Carsten Pedersen skrev:
Jim Lyons skrev:
Has anyone tried using the log_output option in mysql 5.1 to have the
general log put into a table and not a flat file? I used it for a while
before having to downgrade back to 5.0 but thought it was a great
idea. I'm
curious to see if anyone
tried that once, and ran into some problems. Depending on your exact
version, you might experience the same.
http://www.bitbybit.dk/carsten/blog/?p=115
(also has a number of good comments on analysis tools)
And yes, having the data available in a table is a Good Thing for analysis.
/ Carsten
t buffer and notices that
there's no-one around to receive the output, the process may well be
terminated.
As long as you do not echo(), print() or flush() to a closed connection,
you're probably going to be fine.
/ Carsten
--
MySQL General Mailing List
For list archives: http:/
http://php.net/manual/en/function.ignore-user-abort.php
/ Carsten
On Fri, 16 Apr 2010 18:39:07 +0900, Antonio PHP
wrote:
> This maybe a newbie question.
>
> Consider the following concept,
>
> ~/index.php
>
> #1. Fetch data from an external webpage
mos skrev:
At 01:20 PM 4/14/2010, Carsten Pedersen wrote:
Been there, done that. It's a maintenance nightmare.
Why is it a maintenance nightmare? I've been using this technique for a
couple of years to store large amounts of data and it has been working
just fine.
In a prev
Check out the DECIMAL type.
/ Carsten
Sebastien MORETTI skrev:
Hello,
I have a row which is defined as double unsigned (MySQL 5.0.26-Max,
OpenSuse).
Values in this row can go from a single digit, like 1, to values like
0.0006872207 or 1.2513e-18.
I want to store exact numbers.
But I
h data is not going to be great.
It's a bit of a hassle to set up, but once done you don't have to worry
about creating and deleting tables every day.
/ Carsten
mos skrev:
It looks like you only want to keep the current data, perhaps the
current day's worth, and delete the o
If you'll excuse the shameless plug: I once created a tool to help find
the exact parameters to use for PHPs date() and MySQLs DATE_FORMAT().
Please see
http://bitbybit.dk/php/date_format/
(Yes, it looks horrible. But it works)
/ Carsten
Martin Gainty skrev:
Good Afternoon All
foll
don't have a space between '-p' and 'password', i.e. -ppassword
/ Carsten
alba.albetti skrev:
I've just installed MySQL on Windows 2000.
I've opened the MS-DOS windows and I've written
>C:\Programs\MySQL\...\bin\mysqladmin -u root -p password mysql
The MySQL ODBC driver?
/ Carsten
On Thu, 8 Apr 2010 10:42:28 +0530 (IST), Vikram A
wrote:
> Hi,
>
> I would like to export my table structure from MYSQL from a particular
db.
> Is there any tool for doing this?
>
> Please guide me.
>
> Th
AFAIR, MySQL 4.x supports LIKE, e.g.
SHOW TABLE STATUS LIKE 'tab_%'
/ Carsten
spacemarc skrev:
hi all,
in MySQL 4.1.x i want to obtain the status of more tables with one only query.
In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3'
You can do some trickery with auto increment fields and multiple-column
indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131
Beware that this is apparently a MyISAM-specific trick.
/ Carsten
On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan"
wrote:
> I am
ed to disk, the data
will still be there if your db server crashes.
It does indeed sound like you will be better off using MyISAM. This will
also reduce your disk space usage considerably.
/ Carsten
Mitchell Maltenfort skrev:
I'm going to be setting up a MySQL database for a proje
-+--+--+
| @a:=...@a+1 | c1 | s|
+--+--+--+
|1 | 27 |5 |
|2 | 35 |7 |
+--+--+--+
2 rows in set (0.00 sec)
Best,
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
OPTIMIZE TABLE sometimes helps, ymmv.
http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
/ Carsten
Nico Sabbi skrev:
Hi,
I noticed that over the months the dump of my databases (very
subject to modifications, but not subject to increase significantly in
size) gets progressively
You might want to read the comments to this posting:
http://www.bitbybit.dk/carsten/blog/?p=116
Several tools/methods for controlling and analyzing the slow query log are
suggested there.
Best,
/ Carsten
On Tue, 23 Feb 2010 14:09:30 +0530, Ananda Kumar
wrote:
> slow query
other sources).
Don't forget to set the MyISAM sort buffer size high while you create
the indexes.
/ Carsten
mos skrev:
I am loading 35 million rows of data into an empty MyISAM table. This
table has 1 primary key (AutoInc) and 1 unique index and 2 non-unique
indexes.
Is it going to b
down query time significantly.
/ Carsten
Yang Zhang skrev:
I have the following table:
CREATE TABLE `graph` (
`tableid1` varchar(20) NOT NULL,
`tupleid1` int(11) NOT NULL,
`tableid2` varchar(20) NOT NULL,
`tupleid2` int(11) NOT NULL,
`node1` int(11) NOT NULL,
`node2` int(11) NOT
/customer decides to up the requirement to
six passwords, it will be a simple app change.
/ Carsten
Tompkins Neil skrev:
Hi
I'm in the process of designing a login system to a secure web page using
MySQL. One of the features is we need to record and ensure that the user
password is diff
27;;
Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0
mysql> select * from t\G
*** 1. row ***
sizes:
Extra-small,Small,Medium,Large,XLarge,XXLarge,XXXLarge
colorsShadesNumbersShort:
blue:99,gr
Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a tab-delimited
file mytab.txt might be:
mysql -e'select * from mydb.mytab' -sss > m
the candidate guide on the mysql web site before
you go to the exam. It has a lot of valuable hints.
Best of luck on the exam!
/ Carsten
On Mon, 4 Jan 2010 08:06:12 +0200, "machiel.richards"
wrote:
> Good day all
>
>
>
> I h
at least then you'll have made
an educated decision whether to sign the petition or not.
(Disclaimer: I'm a former employee of MySQL AB/Inc, but left before
MySQL was bought up by Sun).
/ Carsten
Michael Widenius skrev:
Hi!
We have just launched a worldwide, multilingual petition
at least then you'll have made
an educated decision whether to sign the petition or not.
(Disclaimer: I'm a former employee of MySQL AB/Inc, but left before
MySQL was bought up by Sun).
/ Carsten
Michael Widenius skrev:
Hi!
We have just launched a worldwide, multilingual petition
Oddly enough, that page fails to mention the <=> operator for which NULL
does indeed equal NULL.
http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_equal-to
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscri
-+
2 rows in set (0.00 sec)
/ Carsten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
On Fri, 11 Dec 2009 18:43:06 +0800, "Yang Wang"
wrote:
> Hi,All
>
>The version of 5.1 include microtime slow query patch?
It would have taken you less time to google "mysql long_query_time" and
getting your answer, than it did to write your mail...
/
++
>> > 1 row in set (0.00 sec)
>> >
>> >
>> > What do? How do I enter multiple values?
>>
>> Impossible to say, until you let us know how you defined the column in
>> the
>> first pla
+
> | Warning | 1265 | Data truncated for column 'sizes' at row 1 |
> +-+--++
> 1 row in set (0.00 sec)
>
>
> What do? How do I enter multiple values?
Impossible to say, until you let us know how you defined the column in the
first place...
/ Carsten
--
warning (0.00 sec)
>> Rows matched: 1 Changed: 0 Warnings: 1
>
> Look at the message, 0 rows changed and 1 warning.
> You cannot have ID=0 if ID is an index.
Then how did he manage to get a matched row?
Of course you can have I
nings: 1"
do a SHOW WARNINGS immediately after you execute the stmt.
/ Carsten
>
> mysql> select sizes, colorsShadesNumbersShort from products where ID=0;
> +---
Hello,
I'm using InnoDB with the "innodb_file_per_table" option on.
But now my .MYD-file has reached the maximum filesize of my filesystem
and i have to add a new tablespace.
Can someone tell me how?
Thanks in advance for your help
Carsten
--
MySQL General Mailing List
For list
dolphins
were going ballistic."
The 47-year-old said the dolphins herded the swimmers - who are all
members of the Whangarei Heads Surf Lifesaving Club - back together and
circled protectively around them for another 40 minutes, fending off the
shark.
===
The rest of the stor
at a reader might think, so it's misleading.
Posting your thinking to the list might be a good way to raise people's
awareness of the issues involved. That is of course said with no
knowledge of what kind of issues you have in mind :-)
Best regards,
/ Carsten
--
Warning: Certifica
r
address.
Best regards,
/ Carsten
--
Warning: Certification can seriously increase your wealth!
http://www.mysql.com/certification
Carsten Pedersen
Coordinator of Development, Certification Manager
MySQL AB, http://www.mysql.com
Office: +45 56 36 16 10
--
MySQL General Mailing List
For list
PM> Paul C. McNeil
PM> Developer in Java, MS-SQL, MySQL, and web technologies.
PM> GOD BLESS AMERICA!
PM> To God Be The Glory!
--
Best regards,
Carsten R. Dreesbach mailto:[EMAIL PROTECTED]
Senior Consultant
Systar, Inc.
8000 Westpark Dr
Suite 4
lready signed up for or taken a certification exam(s)
- if so, which one(s)
- Whether you're primary work with MySQL is as administrator or
developer.
Best regards,
Carsten H. Pedersen
Certification Manager, MySQL AB
--
Warning: Certification Can Seriously Increase Your Wealth!
http://ww
verage grade?Thanks in advance,Julien Martin.-- MySQL General Mailing ListFor list archives: http://lists.mysql.com/mysqlTo unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]--
Best regards,
Carsten R. Dreesbach mailto:[EMAIL PROTECTED]
Senior Consultant
Systar, Inc.
8000 Westp
ing before. Its running from a shell script, from my
MW> backup machine. Its currently setup to shut down the server, however i
MW> don't want to have to do this. Thanks in advance.
MW> Steve Sills
MW> Platnum Computers, President
MW> http://www.platnum.com
MW> [EMAIL P
| C|
CT> | 3 | Mary| P|
CT> | 4 | Madrid | C|
CT> | 5 | Berlin | C|
CT> ---
CT> where central_data.type is P for people and C for cities.
CT> Do you think it is a good ideea ?
CT> --
CT> Best regards,
CT> Ciprian T
es that they regard the Core exam as
being more of a "memorization" exam than Professional. Which only goes
to show, once again, that perceptions differ quite a bit as people come
out of the testing room.
Best regards,
/ Carsten
--
Carsten H. Pedersen
Coordinator of Development, Certifica
uide.
Best regards and good luck!
/ Carsten
--
Carsten H. Pedersen
Coordinator of Development, Certification Manager
MySQL AB, http://www.mysql.com
Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lis
ngs I didn't know about MySQL while studying" is a comment
we often hear -- which makes me and others here happy, as this is of
course one of the main ideas behind having a certification program in
the first place.
Best regards,
/ Carsten
--
Carsten H. Pedersen
Coordinator of Develo
hat this question is not _too_ stupid so that someone will have an
answer for me,
Carsten
-BEGIN PGP SIGNATURE-
Version: 6.5.8ckt
iQA/AwUBP9cfv7jxzYr/SJ6uEQLdpACfUhB9ON/F8sv0bFqEkVIJXcEyvfEAnjJ4
RRCqfhgx38hfAtqF50fWASm9
=m7D3
-END PGP SIGNATURE-
--
MySQL General Mailing List
For l
ing.
I hope you found this input helpful -- you (and anyone else reading this
reply) are very welcome to contact me directly if you want further
details on our certification program.
Best regards,
Carsten Pedersen
Certification Manager, MySQL AB
--
Warning: Certification can seriously increas
d" is one such as "quit", "rehash",
"connect" (They are listed on http://www.mysql.com/doc/en/mysql.html),
which is processed directly by the "mysql" program. An "SQL command", on
the other hand, is an e.g. SELECT or INSERT statement that
http://www.mysql.com/certification -- if you still have
questions, please do not hesitate to contact me directly.
Best regards, (and for those of you that decide to get certified: Good
luck on the exams!)
/ Carsten
On Tue, 2003-06-10 at 20:33, Mike Hillyer wrote:
> I think the other thing to rem
tware only in the scource tree directory, and not in the obj tree
directory, to expect the mysql version can build there with Innobase
and Berkeley DB support without errors.
Greetings,
Carstn Thoene
--
Carsten Thoene eMail: [EMAIL PROTECTED]
Technische Fa
h the option --enable-maintainer-mode
and after taken make the make output goes without errors an so I can fix the
problem.
Greetings,
Carsten Thoene
Carsten Thoene eMail: [EMAIL PROTECTED]
Technische Fakultaet
Universitaet Bielefeld
D-33594 Biel
s
with a MySQL Core Certificate! https://order.mysql.com/
Regards,
Carsten H. Pedersen
MySQL AB Certification Manager
--
MySQL Certifications, http://www.mysql.com/training/certification.html
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Carsten Pedersen &l
Have you tried to run the query in MySQL's console?
- Carsten
> -Oprindelig meddelelse-
> Fra: Rob Galvin [mailto:[EMAIL PROTECTED]]
> Sendt: 30. maj 2002 20:29
> Til: [EMAIL PROTECTED]
> Emne: ADO recordset is not returning rows in ASP page
>
>
> I have a
ameter. Otherwise
you'd be copying the whole array for each recursive function call.
The trick is, that to make a tree you always need to use recursive
functions. The performance is gained by loading the complete list from
database at once (instead of calling a mysql SELECT statement for each
Well you'll neew to do some coding in your application language. What are
you using to connect to MySQL? Perl? PHP? Java?
Tell me, and I'll give you an example where you only query the database once
(for optimum performance).
- Carsten
> -Oprindelig meddelelse-
> F
times (with
> no changes made to the queries). Memory usage is fine and swap space is
> ample.
May we see a) your queries and b) the tables involved? Without such
information it would just be a guessing game...
- Carsten
You can download MySQL++ from www.mysql.com
- Carsten
> -Oprindelig meddelelse-
> Fra: Hisseine Dj. [mailto:[EMAIL PROTECTED]]
> Sendt: 6. maj 2002 17:24
> Til: [EMAIL PROTECTED]
> Emne: C++ API for Mysql
>
>
> Hello,
>
> Can someone tell me if there is an
You could use Kylix from Borland. It's a RAD tool - it's actually Delphi
ported to Linux.
- Carsten
> -Oprindelig meddelelse-
> Fra: Yvon Darang [mailto:[EMAIL PROTECTED]]
> Sendt: 6. maj 2002 15:31
> Til: [EMAIL PROTECTED]
> Emne: Newbie Question
>
>
&
calculation was last run. The next time
one of your calculations are run, select all source-records with a datetime
value newer than your "last_run".
- Carsten
#¤&@&¤&#%#%¤ filter!!! (sql,database,query)
-
umber of
records and immediately do an extra query: EXPLAIN SELECT MailID, MailFrom,
MailTo, Subject, Body, Headers FROM
Mail WHERE Sent = 0
// Write the EXPLAIN result to a logfile.
exit;
}
This way you're able to diagnose the error when it hits again, which it
probably will.
Ask yourself,
m that it appeared to ignore the WHERE. According to my
> binary log, the
> Mail table wasn't changed at all during this time - so the results of all
> three queries should have been identical.
I think you better show us the script. This might help to
assic :-)
You've created your primary key (the autoincremented field) as a TINYINT,
which only allows values in the range -128 to 127. auto_increment does not
support negative numbers, so when you've filled the first 127 records, it
cannot add any more values.
Alter the field to a INT
_query($buffer) or die($buffer."".mysql_error());
Then you will a) print the failed query, and b) print MySQL's own
error-response. Then you cal probably figure out, what is wrong.
- Carsten
-
Before posting, ple
tly support both Java and a
> proprietary language like PL/SQL or Transact-SQL.
Well that sure sounds nice. I'm looking forward to this. :-)
- Carsten
-
Before posting, please check:
http://www.mysql.com/manu
1 - 100 of 322 matches
Mail list logo
