I just recently downloaded the source code and
compiled it. It worked fine. But I am lost when I
tried to read through it. Could anyone give me any
explaination of the sttucture of the code. Or any
reference about it? Thanks
Erming
__
Do you Yahoo!?
The New Yahoo!
Does anyone know if there is a way of setting an auto numbered field
that starts at say 2,000,000 and decreases by one on each insert?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have some MyISAM tables that have backups only of the FRM and MYD
files (the MYI files are huge).
Yesterday I needed to restore some of them. To recreate the indexes I
followed the procedures under section 4.4.6.9 How to Repair Tables of
MySQL manual. I read and tried everything before
Hi,
Does anyone know a way to do multiple unique updates in one query, the
way you can in an insert query?
I have a table with several thousand records. Periodically every record
in this table needs one field to be updated. Slows down the process if
each record is updated with a separate
I'm new to mySQL, but like what I see so far.
I'm converting several databases from other products to mySQL 4.0.12 for
improved speed and reliability. But I'm having trouble with computed
columns. I don't see how to define them. Can't find it in the manual.pdf.
I need 2 computed columns, 1st
Does anyone know if there is a way of setting an auto numbered field
that starts at say 2,000,000 and decreases by one on each insert?
Well, if you know the starting number you can use a normal autoinc field and
retrieve the value you want by substracting:
2,000,000 - AutoIncField
Regards
Ways around inner select statments
Select ID, Sum(CASE WHEN phone.PHN = NULL THEN 1 ELSE 0 END) as PHNCount
from person left outer join phone on ID
where PHNCount = 0 GROUP BY phone.ID;
The alias in the WHERE clause is illegal; it would have to be
SELECT persons.ID,
Sum( CASE WHEN
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
I could encrypt certain table fields, but this will make
writing the front
end a pain because all SQL statements will now need to be
changed any time
a new column is encrypted.
It also won't help you any, because the
Hi,
I would like to fill an Blob with binary data thru SQL-statements or any
other MySQL tools and don't know how!?
Are there suggestions?
Thanks,
Thomas Hoelsken
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Petre Agenbag schrieb:
DOH!
After some RTFM'ing,
which is your 'really_little_part' in the great game called 'open-source'
I found that the /etc/my.cnf was holding the info
for the data dir and the sock, also, the old mysql client worked fine
when using that as it was looking for the sock in the
On 27-May-2003 Jose Miguel Pérez wrote:
snip
SELECT
CASE
WHEN age 15 THEN 1
WHEN age BETWEEN 15 AND 29 THEN 2
WHEN age BETWEEN 30 AND 45 THEN 3
WHEN age 45 THEN 4
END AS
Search the mailing list archives for this... There is a link to this
article:
http://www.php4.com/forums/viewtopic.php?t=6
I wonder if the mailinglist search was powered by google more people would
use it?
On Tue, 27 May 2003, Thomas Hoelsken wrote:
Hi,
I would like to fill an Blob with
I know MySQL CC can place a text or image blob into the database, might
be worth a look.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Thomas Hoelsken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 10:54 AM
To: [EMAIL PROTECTED]
Subject: How to fill an Blob with binary
Hi,
isn't there any other solution instead of using PHP just for filling an
Blob!?
I don't need php and would prefer any other way!
Thanks,
Thomas
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 6:56 PM
To: [EMAIL PROTECTED]
Mascon can do it .. it's a win32 app..
On Tue, 27 May 2003, Thomas Hoelsken wrote:
Hi,
isn't there any other solution instead of using PHP just for filling an
Blob!?
I don't need php and would prefer any other way!
Thanks,
Thomas
-Original Message-
From: [EMAIL PROTECTED]
I am in need of help with the same question (sent late last night, but
apparently got passed over).
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Thomas Hoelsken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:11 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject:
In the last episode (May 27), [EMAIL PROTECTED] said:
Rebuilding my (Mac OS X Server 10.2.x) server and installing MySQL
again, I have forgotten how to fix this, which I've seen long ago:
%mysql_install_db
Sorry, the host 'rogers' could not be looked up.
Please configure the 'hostname'
Like I said, for Image and text blobs, use MyCC and it should work.
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Clauss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 11:18 AM
To: [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
I am in need of
On 27 May 2003 at 19:10, Thomas Hoelsken wrote:
isn't there any other solution instead of using PHP just for filling
an Blob!?
Of course there is, but if you need more specifics you need to give
us more details. How are you executing your SQL statements? It's
just a matter of getting your
Thanks, FreeMascon is able to do it und it works fine. If anyone knows
another solution, I'm interested in!
Thomas
---
_
/ __// __// ___/Thomas Hoelsken [EMAIL PROTECTED]
/ /_ / __// /_ / IT-Coordinator
/___//_/ // Operations Control FRA HE/I
In my case, its neither. Some random binary data. Could be ANY kind of
file... (I'm doing mine programmatically).
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:23 PM
To: Adam Clauss; [EMAIL PROTECTED]
What is the source of the binary data you want to use to fill the blob?
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 12:23 PM
To: Adam Clauss; [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
Like I said, for Image and
In what language?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Adam Clauss [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 11:30 AM
To: Mike Hillyer; [EMAIL PROTECTED]
Subject: RE: How to fill an Blob with binary data
In my case, its neither. Some random binary data.
Copied from my original message:
I am writing a database that will contain a blob field for some binary data.
My question is, what is the most efficient way to load this binary data in?
I could turn it into a string and pass it into an INSERT/UPDATE statement,
but I am afraid that problems will
Not just MySQLFront. PhpMyAdmin chokes on it, too.
-
- Original Message -
From: ML
To: [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 9:08 AM
Subject: Re: User Variables doesn't work?
You are right, I tried from command line and it works, the problem occurs
with MySQL
Depending on size of data there are a few different methods... Just like
what most people do.. use plain insert statements with the data properly
escaped and shouldn't have any problem going in.
Pulling data out is pretty quick .. I can stream binary data out of my
mysql storage servers via our
Hello
I prefer SQLyog at http://www.webyog.com/sqlyog
Its FREE, extremely fast and very easy to use. Runs
only on Windows though. Should give a try!!!
Karam
--- Thomas Hoelsken [EMAIL PROTECTED] wrote:
Thanks, FreeMascon is able to do it und it works
fine. If anyone knows
another solution,
OK question then - when I use LOAD_FILE, does it automatically put escape
characters in front of anything that needs it?
I am in development on an SMTP server with an SQL backend rather than simply
a filesystem. My concern is regarding file attachments which could be
pretty much anything
Hi list,
I have a question about replication in MySQL.
I have mysql 4.0.12 (master and slave) on windows 2000.
Can I make master and slave on the same computer?
If I have the master on disk c, and the slave on disk d:
1) When do I put the my.ini file of the slave?
2) How can I stop and start the
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 3:16 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Catching Exceptions
I noticed that the exceptions were being caught by pointer. I
recommend that
MySQLFront 2.5 had so many bugs that I had to leave
it. I prefer SQLyog now. Its FREE !!! and has all the
features ( plus some realy cool extra features ).
You can try SQLyog at http://www.webyog.com/sqlyog
Karam
--- Peter Brawley [EMAIL PROTECTED]
wrote:
Not just MySQLFront. PhpMyAdmin chokes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Tue, 27 May 2003, Erming Zheng wrote:
I just recently downloaded the source code and
compiled it. It worked fine. But I am lost when I
tried to read through it. Could anyone give me any
explaination of the sttucture of the code. Or any
You need to start 2 instances of mysqld both on different ports and
different datadirs.
I recommend reading Paul Dubois MySQL second Edition- The definitive
guide to using, programming, and administering mysql 4 databases.
He has a section on replication + running multiple instances of mysqld.
At 17:51 27/5/2003 +0200, Vico Timmermans wrote:
Hi,
Hi list,
I have a question about replication in MySQL.
I have mysql 4.0.12 (master and slave) on windows 2000.
Can I make master and slave on the same computer?
Yes.
Assuming that you want the master on drive C and the slave on
drive D, the
On Tue, 27 May 2003 12:18:13 -0400, David Shelley wrote:
I'm new to mySQL, but like what I see so far.
I'm converting several databases from other products to mySQL 4.0.12 for
improved speed and reliability. But I'm having trouble with computed
columns. I don't see how to define them. Can't
In our production environment, we are receiving sporadic but constant 2013
errors from one of our mysql dbs.
The production environment consists of 5 servers running RH 6.2/apache
1.3.27/php 4.0.6, load balanced with a foundry server iron. Each app box
queries a central db box, using pconnect,
Actually it's not FileMaker that the old database is in, it's R:Base.
I was hoping mySQL supported calculated columns because they're mentioned a
couple of times in the manual.pdf for version 4.0.3.
Thanks for the suggestion on select concat ...
I realize I could do that but I was hoping to make
I have a club roster database set up on our web site in which the
underlying data is in a MySQL database. I am using PHP to access the
data and display it on a web page as a phone list, e-mail list,
directory etc. Now what I need it to give the club secretary a way
to print mailing labels.
At 02:22 PM 5/27/2003, you wrote:
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Correct, which is why I have a means of compressing and
*encrypting* the .exe file.
I don't understand how this helps... The EXE file has to contain a complete
decryption routine or it can't be
At 11:36 AM 5/27/2003, you wrote:
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
I could encrypt certain table fields, but this will make
writing the front
end a pain because all SQL statements will now need to be
changed any time
a new column is encrypted.
It also won't
On Tue, 27 May 2003 15:23:28 -0400, David Shelley wrote:
Actually it's not FileMaker that the old database is in, it's R:Base.
I haven't heard of R:Base in YEARS.
I was hoping mySQL supported calculated columns because they're mentioned a
couple of times in the manual.pdf for version 4.0.3.
Well this is very interesting
At the start of the script they have
root_password=$1
host=localhost
user=root
I added in just below the above
echo --
echo $root_password
echo --
Then
3 things I can think of. None of them really good.
1: VERY BAD
Use PHP to generate VBScript to control MS Word. I've actually done this
with Excel and while it works, it's not the best solution. (Not by a long
shot)
2: BETTER
Use PHP to build a PDF on the server in the proper Avery label
I'm having trouble pulling a response.redirect to an IP located in a Group table. The
user logs in ok, the currentUser variable is dim'ed and stores the data fine.
The problem is matching the currentUser to the user.username stored in MySQL, and
redirecting to the associated IP from the Group
Dear Edward,
Thank you for the reply. I appreciate your informaton. Do you have by chance
also any practical samples ?
f.e Until which table size might it be better to use f.e MyISAM and when
would you use another format (Heap or a TST table ?
f.e When you have have mostly read only access
Hi,
I have a text file where lines look like this:
3 Mac Performa6300CD 338211 LOV 109 \ \ \
4 Mac G3BT/266350755 LOV 003 \ 9.1 104.103
Except they are not wrapped like in this email!
Each column
I have some doubts on how to secure a MySQL database (MyISAM InnoDb)
against people who have physical access to the machine. Here are a few
scenarios.
1) Let's say I want to use MySQL with my vertical market software but I
don't want the customer to have access to my data outside of my
Ted-
check out
http://www.mysql.com/doc/en/LOAD_DATA.html
(go to mysql prompt and issue command LOAD DATA INFILE)
keeping attention to format for INFILE
Hth,
Martin
- Original Message -
From: [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 9:25 PM
Subject:
Hello, I have a date field in my database
Format is -MM-DD
Once a day at 12:01AM a script is going to run that will
Select name, email from users where birthday = ??
And the ?? Is where I am stuck, I don¹t care about the year at all, I just
need to match on the month and day, how would I do
Where MONTH(birthday)=MONTH(now()) AND
DAYOFMONTH(birthday)=DAYOFMONTH(now())
Adam Clauss
[EMAIL PROTECTED]
-Original Message-
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 9:21 PM
To: MySql
Subject: Select name, email where birthday = ??
Hello, I
I also have it prepared like this:
1,Mac,SE30,314784,LOV,115,,,
2,Mac,Performa6300CD,338211,LOV,109,,,
Also, I did have all the \ as \N previously.
But what about at the end of lines. What I had with \N wouldn't take
so I was hoping someone might out what the error might be coming from
by
Yes, I simply don't understand this:
===
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LINES
Try:
select name, birthday from atable where month(birthday)=month(now()) and
dayofmonth(birthday)=dayofmonth(now());
Marcel
- Original Message -
From: Scott Haneda [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 10:20 PM
Subject: Select name, email where
In the meanwhile I found a bit information which goes into the direction what
I look for.
http://www.mysql.de/newsletter/2002-12/a91.html
www.nusphere.com/products/library/gemini.pdf (page 11)
I still would appreciate any feedback or additonal information from
experienced MySQL users.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote:
I can ask for the data in any data format, but I would like to get some
advice on what is best to ask for.
I have found text format to be the most flexible method for transferring
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 16:33:45 +0200, Anthony Ward wrote:
SELECT userid,subject,date,code FROM testing WHERE userid=testid
Use only single quotes.
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.net/en/
-BEGIN PGP
Hi,
I have FreeBSD 5.1beta with mysql 4.0.13.
When I try to insert 18MB data into myisam table using command mysql emls
big_query, it says Error 1030 (Got error 12 from table handler). After
that myisam table crashes and I have to run mysqlcheck command to fix the
index.
The query is only
57 matches
Mail list logo