I will be gone from the list until further notice. Unfortunately, the volume of
email and volume of work do not coincide well. Should anyone need to contact
me, please do so directly. Thanks a lot, and sorry for the OT.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
--
MySQL
Actually, Live and Learn is correct. Life and Learn makes no sense.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: Bruce Feist
. I've tried using
Crystal Reports and SQLyog but they don't seem to work, either.
As the end result is to convert this data for use in MySQL, I'm hoping that the
fine folks on here may be able to help me. Thanks a lot.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
--
MySQL General
You need a LEFT JOIN. Check the manual for more info and let us know if you
have any more questions.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: motorpsychkill
so mysql can take full advantage of the dual cpu w/out a recompile?
Your choice of OS will probably affect this as well.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message
MySQL GUI is no longer supported. Try using MySQL CC instead and let us know if
you still have problems.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: Tang, Sean X
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry/EGDXEBBWTYUU
- Original Message -
From: Leonard French [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, 27 June, 2003 16:56
Subject: Re: New to Mysql
If possible, what is the syntax?
It's possible, but if you can't search, I'm not sure you can handle it. ;P
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Edward Dudlik
Becoming Digital
www.becomingdigital.com
Did I help you? Want to show your thanks?
www.amazon.com/o/registry
SELECT Place.id, Place.name FROM Place
LEFT JOIN Place_link ON Place.id=Place_link.Place
WHERE Place.id!=1 AND Place_link.LinkTo!=1;
This section of the manual will probably help you further.
http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html
Edward Dudlik
Becoming Digital
that helps.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: I-A.Kotopoulos [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, 20 June, 2003 04:36
Subject: InnoDB file size...
I am currently working on some experiments and have to deal
You have to implement the view functionailty in code. Or maybe someone
else has a better suggestion :)
There are PHP classes that create views. Check the Repository for them.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Oh Chye Yong [EMAIL
If you're using PHP, format the result with addslashes(). This will escape-out
any quotes in the string.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Weston Skeans [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 13:47
Subject
, it seems
better suited to your level of experience. As they say, if you need to ask...
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: nabil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, 18 June, 2003 02:44
Subject: [PHP-DB] PLS Advise
Please note, as always that 72.83% of all statistics are made up on the
spot.
As someone (who, specifically, is oft-disputed) once said:
There are three kinds of lies: lies, damn lies, and statistics.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From
And, where's the repository?
www.phpclasses.org.
If you'd checked Google first, you wouldn't have had to wait for my reply.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Lingua2001 [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]; [EMAIL
I'd suggest a version difference, but I guess that might rule out things working
in phpMyAdmin.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Martin H.J.Smetsers [EMAIL PROTECTED]
To: 'mysql' [EMAIL PROTECTED]
Sent: Wednesday, 18 June, 2003 15:35
in agreement. :p
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 10:40
Subject: Re: NOT NULL ?
On 16 Jun 2003 at 19:29, Becoming Digital wrote:
Think of the many cases
I found one item in the PHP Classes Repository that may be of use.
Unfortunately, the comments are in Spanish, so it's up to you to figure out the
code.
http://promoxy.mirrors.phpclasses.org/browse.html/file/3077.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message
That's really odd. I've never experienced that problem, but I'm running the
latest production release (4.0.13), so I perhaps it's been fixed between
versions.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Lucas Heuman [EMAIL PROTECTED]
To: [EMAIL
work.
Unfortunately, these won't work from the command line, so perhaps that's why the
original poster hasn't taken this route.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Primaria Falticeni [EMAIL PROTECTED]
To: Kerry Colligan [EMAIL PROTECTED]
Cc
That should have had a question mark.
What version of MySQL are you running?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: John Farkas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 13:28
Subject: Open Tables
I am new
What version of MySQL are you running.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: John Farkas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 13:28
Subject: Open Tables
I am new to mysql so please excuse my ignorance.
I am
.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Primaria Falticeni [EMAIL PROTECTED]
To: MySQL LIST [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 12:50
Subject: I wonder why nobody answered me
Why nobody answered me?
I posted two questions on this list
mysql SELECT CONCAT(LEFT(@v, 4), 'e', SUBSTRING_INDEX(@v, 'e', -1)) as v;
Nice job. The only problem now is that the result doesn't round properly.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Don Read [EMAIL PROTECTED]
To: Paula R. T. Coelho
Folks PHP is available from the command line...we
use it for triggers and stored procedures all the time.
Most people I've spoken too are either not aware of or not comfortable with CLI
PHP. I can't explain why, but I've almost given up on suggesting it.
Edward Dudlik
Becoming Digital
that I'm mistaken, but I believe that 'if($flag)' would
evaluate to false if '$flag = false'.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Jonas Geiregat [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 17 June, 2003 15:19
Subject: Re
so i want userTypeID in tblUsers to be a foregn key referencing the
userTypeID col in userTypes
both tables are myISAM
You answered your own question. MyISAM tables don't support foreign keys.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From
be. The difference in speed
comes when you're looking at two queries or two program functions; the latter is
almost always a great deal faster.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Lingua2001 [EMAIL PROTECTED]
To: Roman Neuhauser [EMAIL PROTECTED]
Cc: Ryan
not want a field left blank: a
customer's last name or zip code, a product's name or id number, a payment
amount. Were any of those fields allowed to be NULL, the system of which they
are a part could fall on its face. We wouldn't want that, would we?
Edward Dudlik
Becoming Digital
older ones, always stemmed
from the fact that neither the processor or the OS (in the case of Windows) was
capable of making full use of a multi-proc architecture.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Shane Bryldt [EMAIL PROTECTED]
To: [EMAIL
Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Roddie Grant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 16 June, 2003 10:52
Subject: Re: checking NULL or ''
I'm still a bit of newbie, but surely these are not the same query. The
empty string
Your statements are all too true, so much so that I feel no need to quote any
one part. This is information everyone should pay attention to.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Ryan Yagatich [EMAIL PROTECTED]
To: Becoming Digital [EMAIL
.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Jed Hunsaker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 22:03
Subject: SELECT... EXCEPT FOR
If there's not a way to do this I would suggest it be added to the next version
Consider going over Section 5.2.9 of the manual.
http://www.mysql.com/doc/en/Insert_speed.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Shane Bryldt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 01:12
Subject: Question about
will likely run into the same problem once your table grows, even
with the best choice of UPDATE or INSERT.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Shane Bryldt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 06:03
Subject: Re
I have all privileges to all the databases and tables, with user 'root'.
User 'root' likely doesn't have access from the desired IP. Users are
configured by both name and approved hosts. Try this:
GRANT ALL ON database TO [EMAIL PROTECTED] IDENTIFIED BY 'password';
Edward Dudlik
Becoming
to make sure you handle the
variable names properly (dot concatenation).
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Tad Ellis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, 15 June, 2003 19:27
Subject: mmmh
hello and thank you for your time
Try specifying someuser at all hosts.
GRANT ALL ON * TO [EMAIL PROTECTED] IDENTIFIED BY 'somepass';
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Timothy Waters [EMAIL PROTECTED]
To: MySQL mail [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 22:54
You saved my day. Haven't laughed like this for long time ;-)
Seriously. I wish I was drinking more earlier so as to fully appreciate this
one.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: John Chang [EMAIL
The error is in FLOAT(1). Think about that for a moment. What's a float with
one-digit precision? It's an integer. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Chris Webster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003
Take a look at this section of the manual.
http://www.mysql.com/doc/en/LOAD_DATA.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Ben Miller [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 07:20
Subject: import weirdness
Try setting the user as [EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: John Utting [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 07:57
Subject: Setting root password
Hi,
I have installed MySQL v4.0.13
| 0| nok |
| 10 | 9| nok |
| 11 | 10 | ok |
+-+--+--+
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: trashMan [EMAIL PROTECTED
If you mean a file as in an image or other binary data, you need to use a BLOB
field.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Joe Baptista [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 14 June, 2003 19:57
Subject: howto store files
MySQL should have no problems running on your system, and if it runs better on
another box, that would indicate a configuration problem or background processes
clogging up the works. If you post your my.cnf file, someone here might be able
to rule out the former.
Edward Dudlik
Becoming Digital
Losing your mind, perhaps?
http://www.mysql.com/downloads/download.php?file=Downloads%2FMySQL-4.1%2Fmysql-4
.1.0-alpha.zipmirror=http%3A%2F%2Fmysql.secsup.org%2F
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED
If PHP was built without MySQL support, you need to recompile it. It should be
in there, though, so check the php.ini file.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Subscriptions [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, 13 June
Arrays are not currently supported in any production-release versions of MySQL.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Hans Nerdell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 09:25
Subject: table creation - arrays
http://www.mysql.com/doc/en/mysql.html
In the MySQL client, end your command line statement with \.
From the shell, use this syntax:
shell mysql database script.sql output.tab
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: CM Miller [EMAIL
While I'm not sure I understand your intention, it seems to me like you need
another table to hold your data. As Paul stated, AUTO_INCREMENT doesn't work
this way.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Q Zantos [EMAIL PROTECTED]
To: [EMAIL
Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Jay Blanchard [EMAIL PROTECTED]
To: CM Miller [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, 11 June, 2003 08:04
Subject: RE: Can't insert data from Apache/PHP
[snip]
Sorry, but I am a bit behind on MySQL
or as developed as the InnoDB or Gemini table types.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 12 June, 2003 02:19
Subject: BDB or InnoDB
Hi MySQL Fans,
I am sure this question was asked
Please check the manual.
http://www.mysql.com/doc/en/Memory_use.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: George Christoforakis [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 12 June, 2003 04:07
Subject: memory setup
Hello,
anybody
, but shouldn't you declare 'count(*) AS
C' before you start trying to do calculations on it? Try this:
select count(*) as C,
SUM(IF(C=1,1,0)) AS VIEW_1,
SUM(IF(C=2,1,0)) AS VIEW_2,
SUM(IF(C=3,1,0)) AS VIEW_3
from object_hist
where type_id=5879
group by object_id
Edward Dudlik
Becoming
help. Most significant is likely the data format coming from your
sensors.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Chris Webster [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 12 June, 2003 11:46
Subject: soft real-time database
this:
SELECT * FROM table ORDER BY id_field DESC LIMIT 1;
You could also use a DATETIME type field for the id (primary key) so that it
contains useful data.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Chris Webster [EMAIL PROTECTED]
To: Curtis Maurand [EMAIL
http://www.mysql.com/doc/en/SHOW_TABLE_STATUS.html
Searching is usually faster than waiting for the list to respond, too.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Sohail Hasan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, 11 June
I've been having the same problem with one of my systems, also on Windows XP,
but using 4.0.12. Perhaps it's time for a bug report...
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Jonas Geiregat [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday
Why not try MySQL Control Center? It's MySQL AB's own project.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Rodolphe Toots [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, 11 June, 2003 07:16
Subject: mySQL GUIs
hi!
i am looking
. ;)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: System Administrator a.k.a. The Root of the Problem
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, 11 June, 2003 19:15
Subject: Need help with an update
Here is the scenario.
I was running
I hate to be the one to ask, but what's the subject have to do with the rest of
the message? I can't see how the two are related at all.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: rich johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday
of the manual linked
below.
http://www.mysql.com/doc/en/Disaster_Prevention.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Steve Mansfield [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 04:24
Subject: Dual boot system
I have MySQL
Becoming Digital
www.becomingdigital.com
- Original Message -
From: rich johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 05:48
Subject: Re: Dual boot system
I take this to mean that you want to installations of MySQL
Fair enough. I was afraid that something rather obvious was going over my head.
Fortunately, Egor had the answer you needed. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: rich johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent
supports 2G tables).
http://www.mysql.com/doc/en/CREATE_TABLE.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Martin Waite [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 04:45
Subject: is it possible to get around 4
Sorry, I meant to include this link, too.
http://www.mysql.com/doc/en/Table_size.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Martin Waite [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 04:45
Subject
Take a look at the PHP Classes Repository for plenty of authentication classes.
Also consider subscribing to the PHP-DB mailing list. The address is below.
[EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Timothy Waters [EMAIL
based on the great user reviews at Amazon. Here
are links to both.
http://www.amazon.com/exec/obidos/tg/detail/-/0471380237/102-5674589-9040158
http://www.amazon.com/exec/obidos/tg/detail/-/0471353485/102-5674589-9040158
Good luck!
Edward Dudlik
Becoming Digital
www.becomingdigital.com
PostgreSQL at some point in time, if only for curiousity's sake, I'm glad I
started with MySQL.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Kaarel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 07:38
Subject: Which database?
Hi
I am
Check out make sure you're properly encoding the string. You likely need to use
addslashes() and htmlspecialchars(), possibly htmlentities() as well.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Steve Marquez [EMAIL PROTECTED]
To: MySQL List [EMAIL
Without seeing your code, it's hard to gauge what the problem is, but my guess
is that your insert statement in missing a VALUES field (or one has been
transposed). If data types don't match up, this will cause your query to fall
on its face, just as it seems to be doing.
Edward Dudlik
Becoming
What's your end goal, and for what do you need/desire a weighted random? Your
objective will determine if this is actually of use or if it simply appears to
be.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Dathan Vance Pattishall [EMAIL PROTECTED
Assuming you have the proper permissions (which could get confusing), I suppose
it could be done. So, I'll follow up with one of my most frequent responses:
why don't you try it and then let us know?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From
stored.
The 4-byte storage overhead is easily justified by this.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Quinlan, Grant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 15:16
Subject: RE: money field
I would use Decimal (12,2
for the
example):
$query = INSERT INTO table (field, messageDated)
VALUES( \.$value1.\, NOW() );
Being that the messageDated and messageTimed (not shown in example) fields
aren't user variables, there's no problem with hard-coding them into the insert
statement.
Edward Dudlik
Becoming
) NOT NULL default '',
`item_price` decimal(5,2) NOT NULL default '0.00',
PRIMARY KEY (`item_id`),
KEY `idx_cat` (`cat_id`)
) TYPE=MyISAM |
If I'm overlooking something simple, I apologize, but this just isn't working
for me. Thanks a lot.
Edward Dudlik
Becoming Digital
Thank you much. I don't know why that didn't occur to me. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Jim Winstead [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]
Cc: MySQL List [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 22:18
http://www.innodb.com/ibman.html#Backing_up
See the section on Forcing Recovery.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Nils Valentin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 10 June, 2003 01:40
Subject: InnoDB question(s
http://www.innodb.com/ibman.html#InnoDB_transaction_model
Scroll down a bit to Section 8.5
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 18:44
Subject: INNODB
So the next step would be to provide us with the code so that we might try to
help you. :)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: ComCity [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, 08 June, 2003 01
Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Stefan Hinz [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, 07 June, 2003 03:25
Subject: Re[2]: Please help: Can not insert binary data larger than 16 megabytes
Brad
The InnoDB manual (below) doesn't mention it. Why not try and let us know?
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: san [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, 06 June, 2003 09
The linking table adds more flexibility at the cost of complexity. In this
case, I see absolutely no reason for it as it only serves to muck up your data.
As Jeff mentioned, a linking table is great for many-many relationships, but
otherwise it's just a pain.
Edward Dudlik
Becoming Digital
.
[EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Andre [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 07 June, 2003 17:09
Subject: CAUTION! ALERT! WARNING! Newbie on board :)
I hope this is the correct place to ask for help
chances are they wouln't upgrade until 4.0 has been in use a while.
Version 4.0.1 has been out since December 2001. Tell them that and you just
might luck out.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED
That points to a fault in your coding because phpMyAdmin *is* PHP running via
the web server.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: ComCity [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, 07 June, 2003 21:09
Subject: More: Can't insert
Ever consider that this could have something to do with the fact that you're
running an alpha release?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Ed Leafe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 05 June, 2003 14:53
Subject: Where
of which will facilitate
much more complex processing of your data. However, if someone can explain how
to do this strictly with SQL, I would be impressed.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: kallwn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
Unknown table 'item' in where clause
while of course table 'items' exists...
Well... which table exists, 'item' or 'items?'
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Moj Bordel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, 05 June
just suppress the error with @.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Mark Rages [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, 06 June, 2003 17:15
Subject: SQL no-op?
I need a placeholder statement that does nothing
PROTECTED]) and
re-posting there. We'd all be happy to help you. :)
PS - If you're worried about getting too much mail, that list generates a whole
lot less than this one!
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: David Blomstrom [EMAIL PROTECTED
better practice to do the
latter.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, 06 June, 2003 17:11
Subject: Please help: Can not insert binary data larger than 16 megabytes
Hello --
I am having
with the operating system.
I did a search on Google and was able to find a setup tutorial that may be
helpful. Good luck.
http://www.ricocheting.com/server/
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: David Blomstrom [EMAIL PROTECTED]
To: Becoming Digital [EMAIL
I believe this thread (from only three days ago) will answer your question.
http://lists.mysql.com/list.php?1:mss:141551:200306:kkmidpclnclgkpjgpgkd
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Dylan Pham [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent
Sub-selects are supported in v4.1, which is still in Alpha release.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Petre Agenbag [EMAIL PROTECTED]
To: Egor Egorov [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, 05 June, 2003 06:18
Subject: Re
I'd suggest using phpMyAdmin on the remote server for your setup. Depending on
the application, it might make further transfers easier in the future.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Creative Solutions New Media [EMAIL PROTECTED
, ...) syntax.
Long story short, regardless of whether or not MySQL complies with SQL92 specs,
it currently doesn't even comply with it's own documentation. That, I will
concur, is a problem.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Neil Zanella
the new release notes. Thanks for the heads up,
though.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Mark Matthews [EMAIL PROTECTED]
To: Becoming Digital [EMAIL PROTECTED]
Cc: MySQL Mailing List [EMAIL PROTECTED]
Sent: Wednesday, 04 June, 2003 18:54
Subject
http://www.mysql.com/doc/en/Commands_out_of_sync.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Andrew Hazen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, 03 June, 2003 09:40
Subject: Meaning of error codes
Hi folks,
A couple of my
FWIW, there is a PHP-DB mailing list that might prove more helpful to you. I
know certain folk on both lists can get mighty annoyed when an off-topic
question is posted, so I thought I'd give you a heads-up.
[EMAIL PROTECTED]
Edward Dudlik
Becoming Digital
www.becomingdigital.com
1 - 100 of 128 matches
Mail list logo