Michael Dykman wrote:
> One problem you might be having is the column named 'call'.. It's a
> keyword, so perhaps you might get away with backticking it?ie.
> `call`
>
> Also, you shouldn't need that final semi-colon inside your statement
> string.. I have had preparedstatement interfaces gi
Grant Peel wrote:
> Hi all,
>
> I recently migrated a script called perldesk from mysql 4 to mysql 5.
>
> When I envoke the script from the web, I am now getting an error. I suspect
> its a version syntax thing.
>
> Here is what I see:
>
> Couldn't execute statement: You have an error in your
On 04/21/2010 02:21 PM, Tom Worster wrote:
> I'd go with the 4G 4-core server. If you're running apache and a sensible
> OS, the extra cores can be helpful. So, unless you know you have a need for
> very large key buffers, 4G should leave the OS plenty for FS cache.
>
> Not that I actually have a
On 04/05/2010 02:06 PM, chen jia wrote:
> Hi there,
>
> I run simple statement like this:
>
> create table c
> select * from a
> union
> select * from b;
>
> where table a has 90,402,534 rows, and table b has 33,358,725 rows.
> Both tables have the same three variables.
>
> It's taken a long ti
On 01/29/2010 07:24 PM, Shawn Green wrote:
> Rudy Lippan wrote:
>> On 01/29/2010 02:57 PM, Chris W wrote:
>>
>>> Hardcore stupid if you ask me. I suppose it is "possible" to have a
>>> valid reason (can't imagine what it might be) for using more t
On 01/29/2010 02:57 PM, Chris W wrote:
> Hardcore stupid if you ask me. I suppose it is "possible" to have a
> valid reason (can't imagine what it might be) for using more than 61
How about complex data requirements? Depending on the resolution of
your data set, I could see a "simple" person-ty
On Fri, 24 Aug 2007, Michael Dykman wrote:
calculating the max key + 1 , as it has been noted, must be done
transactionally and will therefore require a transactional table
And with a transaction isolation level greater than Read Commited...
-r
--
MySQL General Mailing List
For list archives
If this trend is real, it doesn't seem like a very good trend to me. For
example, if you were keeping track of parts in a warehouse, why would anyone
make a table that looked like this:
ID (autogenerated PK) PART_NOPART_DESCRIPTION
1 A01
On Thu, 9 Jun 2005, Philippe de Rochambeau wrote:
> Hello,
>
> is there a way to switch from emacs binding to the vi binding in mysql?
>
The mysql client should pick up your .inputrc settings. 'man readline' for more
info.
-r
--
MySQL General Mailing List
For list archives: http://lists.my
tire data set is already
cahced client side, and that cached data set is free()d as soon as it is copied
into a perl data structure. But if you really don't wan't to have 2 copies
hanging around, you can always re-execute:
$sth->execute(@params);
while (my @array = $sth->
you
have to use the old passwords with 4.1.7 (Oh, and what about the shutdown
changes?)
Rudy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Best Practicals "request
> tracker". Currently this is a clean system. Any help is appreciated.
Make sure that the correct 'mysql_config' is in your path before running 'perl
Makefile.PL'
Rudy
--
MySQL General Mailing List
For list archives: http
solution for this. compiling the mysql binary and/or
installing a libcrypto/libssl rpm I would not really call a solution.
Anyone?
Thanx
/rudy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ou can
always hack the DB :)
cheers
/rudy
-Original Message-
From: Director General: NEFACOMP [mailto:[EMAIL PROTECTED]
Sent: dinsdag 7 oktober 2003 16:49
To: Wang Feng; [EMAIL PROTECTED]
Subject: Re: printing reports
To get data from/into MySQL, you will always need a client software.
S
If you want to restrict the tuples you get from 'broadcasts' use AND
instead of WHERE.
Cheers
/rudy
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]
Sent: dinsdag 7 oktober 2003 15:42
To: Wayne Helman
Cc: [EMAIL PROTECTED]
Subject: Re: Multiple Join Issue
Lea
and then using this result in an IF
clause (CASE too??, ifnull()???, any other expression?).
Thanx for any feedback!
Cheers
/rudy
-
HERE my Table definition:
CREATE TABLE `tpr` (
`tprnr` int(10) unsigned NOT NULL aut
ly being processed - they actually remain in
> the sending data phase for most of this time.
>
Which version of Apache are you using, for I have heard whisperings of
problems with socket communications in apache 1.3.28 + mod_perl -- this
might be a good place to look.
Rudy
--
MySQL Genera
If you give access rights to a user on a DB, he will always be able to
see the table structure. This is how it is implemented in MySQL (which
does not mean that I like this).
Cheers
/rudy
-Original Message-
From: QWERTY [mailto:[EMAIL PROTECTED]
Sent: maandag 4 augustus 2003 14
Or load the date into a column date_str and then convert and copy the
date into a column date AFTER loading.
Cheers
/rudy
ps: I already posted a function of how to convert this date format into
a MySQL date format somewhere on this list (prev month I think)
-Original Message-
From: Jay
trick")
Cheers
/rudy
-Original Message-
From: unplug [mailto:[EMAIL PROTECTED]
Sent: maandag 4 augustus 2003 12:03
To: mysql
Subject: replication question
HI all,
Is it possible to perform replication as follow? HOW?
master (innodb) ---replication---> slave (myisam)
Try to quote the password:
password= 'test#istest$'
or
password= "test#istest$"
Not sure if MySQL is doing command expansion. If yous, use the first
example, if not, it should not matter.
Cheers
/rudy
-Original Message-
From: Andy Eastham [mailto:[EM
Sorry, MySQL does not like the ( ). Try it without them :)
Cheers
/rudy
-Original Message-
From: Colt Brunton [mailto:[EMAIL PROTECTED]
Sent: vrijdag 18 juli 2003 15:38
To: [EMAIL PROTECTED]
Subject: Query debugging
Hi all
I am trying to adapt a query, (kindly) given by Rudy and I
they treat
NULL values in calculations. Until then, check the release notes for
every release concerning NULLs. And also the known bugs/future releases.
Cheers
/rudy
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: vrijdag 18 juli 2003 12:43
To: [EMAIL
tion. Then link your table not to the single combinations, but to
this meta attribute. This should give you best performance.
Things like that are normally used in DWH.
Cheers
/rudy
-Original Message-
From: awarsd [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 17:45
To: [EMAIL
Can you please post the source code?
In any case, I would consider using DBI.
Cheers
/rudy
-Original Message-
From: Ashwin Kutty [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 17:12
To: [EMAIL PROTECTED]
Subject: Select via Perl
I am trying to read a file and see if the
CREATE TABLE NAME (
SELECT name, work
FROM A
UNION ALL
SELECT name, home
FROM A
WHERE home IS NOT NULL
);
CREATE TABLE ADDRESS (
SELECT work
FROM A
UNION ALL
SELECT home
FROM A
WHERE home IS NOT NULL
);
Cheers
/rudy
-Original Message-
From: Colt
Hmmm... right.
You can compare the server to the instance.
And the user to the DB (in the scheme, not at authentication)
Thanx for the pointer!
/rudy
-Original Message-
From: Jim Smith [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 11:06
To: Rudy Metzger; 'Harald Falke
. Which is a clear BUG
imho because the where condition can never be true! But Victoria says in
her/his mail that this is expected behavior...
Cheers
/rudy
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 10:33
To: [EMAIL PROTECTED]
Subject
Also make sure that the port is not firewalled.
Cheers
/rudy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: donderdag 17 juli 2003 9:56
To: zafar rizvi
Cc: [EMAIL PROTECTED]
Subject: Re: mysql connection error
Keep in mind you need 2 things to happen:
A
)
6. no. executable are placed in the /bin foldes (depending on
installation). Cannot recall SID anymore, was this the instance config?
If yes, there is none.
Suitable docs: www.mysql.com :)
Cheers
/rudy
-Original Message-
From: Harald Falkenberg [mailto:[EMAIL PROTECTED]
Sent: woensda
error, John!
Cheers
/rudy
-Original Message-
From: John Hicks [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 22:03
To: Rudy Metzger; [EMAIL PROTECTED]
Subject: Re: Best practice column type for storing decimal currency
amounts?
Thanks for the reply, Rudy.
My source for the statement
Kill them :)
http://www.mysql.com/doc/en/KILL.html
Cheers
/rudy
-Original Message-
From: PAUL MENARD [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 16:44
To: [EMAIL PROTECTED]
Subject: How to terminate dead connections that are in SLEEP?
Good morning all,
I have a problem
#x27;Jun','Jul','Aug',
'Sep','Oct','Nov','Dec'),
2,'0'),
'-',
lpad(substring_index(DATE,'-',1),2,0),
Replace DATE by th
sarily represent a valid date/time!
>
>Just replace 06 with 24 and see what you yet.
>
>Cheers
>/rudy
>
>-Original Message-
>From: Johannes Pretorius [mailto:[EMAIL PROTECTED]
>Sent: woensdag 16 juli 2003 12:11
>To: [EMAIL PROTECTED]
>Subject: Re: Si
WRONG!
What will happen in this case? The DB is converting/casting the DATE
(curtime()) into an integer and then ads 6. So what you get does not
necessarily represent a valid date/time!
Just replace 06 with 24 and see what you yet.
Cheers
/rudy
-Original Message-
From
If you manually updated the tables, use flush privileges to inform the
DB server of your changes.
Cheers
/rudy
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:23
To: [EMAIL PROTECTED]
Subject: Re: Connection problem!!! Windows to Linux
Aric
Did you do that on the mysql command line? Or did you use a different
client and/or API?
Cheers
/rudy
-Original Message-
From: Sbandy [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 11:21
To: [EMAIL PROTECTED]
Subject: Can someone help me??
I am new in mysql
I wrote this
WHERE userid IN ( SELECT distinct toid
FROM m )
AND p.userid = m2.toid
AND p.userid = m1.toid
But I would use the first one...
/rudy
-Original Message-
From: Ben Margolin [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 1:36
To: [EMAIL PROTECTED]
Subject
Please check the manual, search for DATE_ADD().
/rudy
-Original Message-
From: Johannes Pretorius [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 8:01
To: [EMAIL PROTECTED]
Cc: Pieter
Subject: Simple newbie question - CURTIME()
Good day
\-=0=-=00-
I have looked in the manual and
ou need foreign constraints, use InnoDB.
Cheers
/rudy
-Original Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]
Sent: woensdag 16 juli 2003 4:54
To: [EMAIL PROTECTED]
Subject: Foreign Keys
When I type:
Show keys from [tablename];
I do not see foreign keys listed there and I cannot s
You
would have to check that out yourself.
Cheers
/rudy
-Original Message-
From: Dan Ullom [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 19:04
To: [EMAIL PROTECTED]
Subject: Single Record Locking - Permanent?
Is it possible to lock single records for all but a certain se
You are not allowed to use grouping functions in the WHERE clause. To restrict on
grouped values, you have to put them into the HAVING clause.
Cheers
/rudy
-Original Message-
From: Roy Walker [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 23:25
To: Rudy Metzger; [EMAIL PROTECTED
in ints and
multiply them by 100 (or 1000) before putting them there (thus taking
care of the decimal point myself).
Cheers
/rudy
ps: I wish DECIMALS would be stored as char :)
-Original Message-
From: John Hicks [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 21:39
To: [EMAIL
Really depends on what exactly you want to achieve. But as I read the
mail below, create a lot of smaller ones. If the ISP however charges you
for each DB it is also easy to only create one huge DB, just do not make
the table names too long. Developers are lazy in typing... :)
/rudy
someone should
put his/her attention to this very soon. Because its hard to sell your
manager a DB which does not support a well thought out backup and
RESTORE procedure!
Cheers
/rudy
-Original Message-
From: Gilbert Wu [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 18:31
To: [EMAIL
Maybe you could get some speed increase for you queries by setting the
record_buffer to a higher value. Because with fixed row length this
buffer fills up faster too. Although I doubt that you will gain a lot...
/rudy
-Original Message-
From: Alexander Schulz [mailto:[EMAIL PROTECTED
not be case).
Hope this is more clear now. If I sounded offensive in my first mail,
this was NOT the intent, but with my limited English knowledge I just
type what comes to my mind :( blame it to my Austrian heritage :)
Cheers
/rudy
ps: as to converting dynamic length to fixed length, procedu
Set the autoincrement column to the max value or the given data type
(via alter table), insert a record and see what happens...
Cheers
/rudy
-Original Message-
From: TheMechE [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 15:40
To: [EMAIL PROTECTED]
Subject: What about auto number
truncate table_name
does both in one statement. And even optimizes the table (frees up
unused disk space). However take care that you cannot rollback this DDL.
Cheers
/rudy
-Original Message-
From: Chris Boget [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 15:29
To
thing completely
different.
Cheers
/rudy
-Original Message-
From: Veysel Harun Sahin [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 15:22
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Managing big tables
http://www.mysql.com/doc/en/Data_size.html
[
ete records from one your
and optimize this hear only).
Cheerio
/rudy
-Original Message-
From: Alexander Schulz [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 14:35
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Managing big tables
Hello,
i've got a little problem,
we&#x
Please check the history on this list. There are numerous answers to
this problem.
Cheers
/rudy
-Original Message-
From: Miroslav I. [mailto:[EMAIL PROTECTED]
Sent: dinsdag 15 juli 2003 14:10
To: [EMAIL PROTECTED]
Subject: auto number primary key - restarting
Hi,
is there an SQL
11 ) LastActionCommentComplaint
FROM contact c,
contact_table cont,
complaints_table compl,
actions_table act
WHERE c.id = cont.main_id
AND c.id = compl.main_id
AND c.id = act.main_id
GROUP BY c.id. c.name, c.surname
Did not run it vs a DB so expect some typing erro
commands use safe_msyqld (mysqld_safe) to start the server. So you
from the commandline you can best use mysqld_safe to start (under normal
circumstances).
Cheers
/rudy
Ps: there is no linux 8.0 :) think you mean RH 8.0
-Original Message-
From: Eternal Designs, Inc [mailto:[EMAIL PROTECTED
M ...
I did not run this vs a DB so please excuse syntax errors and if I
forgot some brackets. But in principle it should work fine.
Cheers
/rudy
-Original Message-
From: Shazia Fazili [mailto:[EMAIL PROTECTED]
Sent: maandag 14 juli 2003 19:35
To: Rudy Metzger
Subject: RE: Rows into
Not by MySQL (or it is that high it doesn't really matter). Your OS
could put a limit on it with max file size.
Just do yourself a favor and apply "\n" after every "row" so that you
can open it with an editor. Otherwise a lot of editors will complain of
"
.
No data date
1uyt d1
1abc d1
cheers
/rudy
-Original Message-
From: Phil Evans [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 17:12
To: [EMAIL PROTECTED]
Subject: columns to rows
Hi there. I am a rank amateur at this trying to make sense out of a heap
(and
BY invoiceid;
Cheers
/rudy
-Original Message-
From: Shazia Fazili [mailto:[EMAIL PROTECTED]
Sent: zaterdag 12 juli 2003 0:19
To: [EMAIL PROTECTED]
Subject: Rows into Columns
Hi,
I have a table PAYMENT which has 3 fields.. PaymentID,InvoiceID,Payment
PaymentID is th eprimary key
ble you actually would loose time.
/rudy
-Original Message-
From: Phil Bitis [mailto:[EMAIL PROTECTED]
Sent: zaterdag 12 juli 2003 19:00
To: [EMAIL PROTECTED]
Subject: Improving insertion performance by locking tables
Hello,
We've got an application which does many multiple-value in
SELECT col1, IF(count(*)!=count(col2),NULL,'BAD')
FROM table1
GROUP BY col1;
This ONLY works EXACLTY for the case you submitted.
Please note that your example is wrong (I think). 3 should also return
NULL, shouldn't it?
/rudy
-Original Message-
From: Christopher
you would have rights to modify it,
not sure about that. Otherwise you have to contact your service provider
and ask them to change the values for you.
Not much help, I know...
Cheers
/rudy
-Original Message-
From: Dancing Tree [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 16:55
To
ld also be the way how I would do it in a different DB (e.g. ORACLE).
Cheers
/rudy
-Original Message-
From: Roy Walker [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 18:30
To: [EMAIL PROTECTED]
Subject: RE: Complex select statement
Eva,
Thanx for your help. Still having an issue
constant" (not indexed) part of the
equation.
Same counts for all other data type formats, of course.
Cheers
/rudy
-Original Message-
From: Adam Nelson [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 17:19
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Can mysql handle this
as MD5 or SHA
Cheers
/rudy
-Original Message-
From: GREEN, Darren [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 12:17
To: '[EMAIL PROTECTED]'
Subject: Encrypt().
I am running Discus Message Board on MYSQL server version 3.23.55 all on
Windows 2K platform. Discus app
http://www.mysql.com/products/myodbc/index.html
-Original Message-
From: Azrin Aris [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 12:15
To: [EMAIL PROTECTED]
Subject: How to connect o remote MySQL Database
I have a MySQL Server in a Windows Box. How can I connect to the server
fr
FROM table1
LEFT JOIN table2 ON table1.column = table2.column
LEFT JOIN table3 ON table1.column = table3.column
-Original Message-
From: Krasimir_Slaveykov [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: 2 or more LEFT JOIN?
Hello mysql,
If I
I am not sure if I fully understand your problem, but I think you have
to move the IS NULL to the LEFT JOIN condition.
Cheers
/rudy
SELECT distinct
useronline.uname,
penpals_fav.fav_user_id,
penpals_fav.ID,
penpals_privmsgs_block.blocked_id
FROM useronline
You could add a column 'is_updated' and set it to 'Y' when it is
updated. But depends very much on what you want to achieve by it
/rudy
-Original Message-
From: Keith Hamilton [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 18:39
To: MySQL
Subject: Pull updat
some bugs are also fixed in older releases
(e.g. very malicious bugs, or if a customer is paying for it).
Cheers
/rudy
-Original Message-
From: renniw one [mailto:[EMAIL PROTECTED]
Sent: vrijdag 11 juli 2003 4:38
To: [EMAIL PROTECTED]
Subject: mysql naming scheme
Hi,
In the mysql
l(c.field3,'string') = 'string'
...
Please know that there is a differences of a column being NULL or if no
record exists for specific join condition!
Cheers
/rudy
-Original Message-
From: Krasimir_Slaveykov [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 12:37
, which could give you even more
speed.
Best check all the variables starting with myisam (SHOW VARIABLES LIKE
'myisam%') and look up what they are doing. Then put all to a max and
try again. Maybe keep myisam_repair_threads to 1 though...
Cheers
/rudy
-Original Message-
From: Flor
Could you maybe send us your table definition, some example data and an
expected output?
/rudy
-Original Message-
From: Doug Wolfgram [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 4:53
To: [EMAIL PROTECTED]
Subject: REGEX
I am familiar with regex in general, but here is what
lates
that using key scan will not require more than scanning at least about
30% of the table records (MyISAM). So with very small tables indexes
will almost never be uses and only slow down inserts/updates/deletes.
Cheers
/rudy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Or drop and recreate the table (that's actually what truncate is doing)
/rudy
-Original Message-
From: Miguel Perez [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 20:08
To: [EMAIL PROTECTED]
Subject: RESETTING AUTO_INCREMENT
Hi everyone:
Does anyone know how to rese
Actually, mysql is only the client used to connect to mysqld.
mysqld does NOT automatically start up when it crashes.
But you can use mysqld_safe (or safe_mysqld which is a softlink to
former). This script then takes care of logging and restarting the
server. Init.d uses mysqld_safe.
Cheers
/rudy
(C) THEN lookup 2 entries (B) and THEN
lookup 10K entries (A). But however exactly this is implemented is
beyond my knowledge.
As for general indexing and tuning, it is always better to use keys with
high cardinality than keys with low one.
Cheers
/rudy
-Original Message-
From: Dathan
SELECT ...
FROM forms f
LEFT JOIN staff_assignments a ON f.form_id = a.form_id
LEFT JOIN staff s ON a.staff_id = s.staff_id;
Given that left joins are faster in MySQL anyway, this also gives you
speed.
Cheers
/rudy
-Original Message-
From: MightyData [mailto:[EMAIL PROTECTED
whole new array, you could use:
foreach @ad ( @array_data ) {
foreach $elem ( @ad )
print "$elem, ";
print "\n";
}
Have fun!
/rudy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: donderdag 10 juli 2003 10:43
To: [EMAIL PROTECTED]
Sub
What the former post was more about is REFERENTIAL INTEGRITY, which is something that
is not (yet) include in MySQL (at least for MyISAM, for InnoDB it is coming with 5.0 I
think).
Cheers
/rudy
-Original Message-
From: Mike Hillyer [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 200
situation. In general (for 90% of the
cases), make a primary key as short as possible and add indexes as you need them (use
EXPLAIN to see how the optimizer is parsing the kwiri). But keep in mind that although
indexes speed up kwiries (SELECTS) they slow down UPDATES/INSERTS/DELETES.
Cheers
/rudy
.
Cheers
/rudy
-Original Message-
From: Dan Anderson [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:49
To: [EMAIL PROTECTED]
Subject: Is it possible to dump images into a database?
Can anyone point me to a reference on how to insert images into a column
in a mySQL database -- or is
) NOT NULL, /* verbose description, e.g. ABSENT */
PRIMARY KEY(status)
)
Maybe keep 'verbose' on char to force fixed line size and thus faster access.
Cheers
/rudy
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:42
changed the file
permissions and/or ownership). You can change filepermissions on unix
(linux) with chmod (type 'man chmod') on the command line, and change
ownership with chown (man chown). You can delete files with 'rm' or
'unlink' (again, see the man pages for help
e on a not supported
system, above answer does of course not apply (but I still would use 4.0
even if you have to compile it yourself)
/rudy
-Original Message-
From: azamka [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:27
To: [EMAIL PROTECTED]
Subject: mysqld max
Hi I am trying to m
Everything from month to years. Might even be tomorrow...
/rudy
-Original Message-
From: Bernhard Schmidt [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 16:07
To: [EMAIL PROTECTED]
Subject: Re: recursive sql statement
hi victoria
sorry for this mysql newbie question, but what
Paul,
Did you try using REPLACE instead of UPDATE/INSERT? Could give you some
more speed enhancement.
Cheers
/rudy
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: woensdag 9 juli 2003 15:21
To: cmars
Cc: [EMAIL PROTECTED]
Subject: Re: Bulk loading data
On Tue
(except changing the port and using this port for backup, hoping noone
connects to the new port or to switch off tcp/ip at all and only connect
through unix sockets).
Thanx for any hint!!!
Cheers
/rudy
_default_file=/home/rac/.my.cnf','rac
> ',...)
Why bother with ssl when connecting to localhost?
Rudy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Nothing needs to be done in PHP
> except run this query and place the results.
>
> I feel like rudy today! :)
thanks, i'm honoured
especially since your comment comes right after
"nothing needs to be done except run this query"
that is indeed the holy grail of
maybe not the 100% correct list, but then again...
SCRIPT
-
#!/usr/bin/perl -w
use DBI;
my $dbh = DBI->connect( "DBI:mysql:database=xxx", "xxx", "xxx" )
or die( "Cannot connect
Dear all,
I have the following problem with load data... Please excuse layout, but the
linewidth is just too short
// ---
// Here is my table definition
// ---
mysql> desc customer;
+---+
91 matches
Mail list logo
