I hope someone can give me a suggestion on this.
I'd like to find records in a table where a specific field only contains a
number.
For example,
Select Field1 as f
from table1 as t
where lcase(t.f) not like in
('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','
Is it possible for a trigger to test the data to be inserted and if it doesn't
meet specific criteria not insert the data at all?
I have an application that writes a lot of data to my table. I don't have
control over this application and it writes a lot more data then I need. So I'd
like to ha
I've found a glaring problem with the latest ODBC connector. Data types have
been changed and data is no longer being read correctly.
I'm running MySQL 5.1.16 on Netware. My apps are VB6 and VBA using ADO. The
following query produces different data types depending on the version of the
ODBC d
Does anyone have an explanation as to why it's taking so long for an official
release of version 5.1? Is it me or does it seem like 5.1 is taking a lot
longer to be released. I don't remember previous versions having 20 beta revs
before an official release. Is there a real date available for an
JOIN
(SELECT Item, SUM(Qty) AS TotQty
FROM inventory
GROUP BY Item) AS totals
ON r.Required = totals.Item
WHERE r.Qty > totals.TotQty;
>>> On 8/10/07 at 12:33 PM, in message <[EMAIL PROTECTED]>, Jay Pipes <[EMAIL
>>> PROTECTED]> wrote:
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative values; request, which e
ad System Admin -- Senior Programmer
http://www.eeinternet.com ( http://www.eeinternet.com/ )
PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE
PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/29/07 1:57 PM >>>
I just
place to go and I don't wanna go back. I'd just like to see it held someplace
new every year.
Thanks for replying to my comment
>>> Lenz Grimmer <[EMAIL PROTECTED]> 1/25/07 2:21 AM >>>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi Ed,
thank you for you
----- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To: "MySQL List" ; "PostgreSQL Announce List"
; "SQlite Users Group"
; "Firebird Tools" <[EMAIL PROTECTED]>
Sent: Tuesday, January 23, 2007 3:20 PM
Subject: Re: New DBManager
The free version is crippled. You don't get all the capabilities they say.
>>> "COS" <[EMAIL PROTECTED]> 1/23/07 8:16 AM >>>
Hi,
DBTools Software is proud to announce the availability of the new DBManager
Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2.
For a complete
w will accept any correct password combination
under ShadowHash or other authorising protocol, but you will still be
working in the account you are in with those privileges. HTH
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 4:49 PM, Ed Reed wrote:
> Unable to manage user accounts throug
I don't have any way of selecting a host. I only have one host on my system and
I don't see anything in the program that explicitly shows me where to select
the host.
>>> Igor Alexandrov <[EMAIL PROTECTED]> 1/17/07 9:30 PM >>>
-BEGIN PGP SIGNED MESS
There was already a bug report submitted. That's where I found other users that
have the same problem.
>>> Colin Charles <[EMAIL PROTECTED]> 1/17/07 6:05 PM >>>
Ed Reed wrote:
> Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
Unable to manage user accounts through MySQL Administrator 1.2.8. I've found
that I'm not the only one with this problem but no one seems to have an answer
for it.
The problem is that when you select a user in the user list of the prog the
user's detail don't appear on the right side so that t
The first to generate you sequence, then
second to populate the main table.
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 12, 2007 8:22 PM
Subject: Re: Insert ... Select troubles
Thanks for the suggestion Brent. The auto_increment won&#
auto increment sequence to be made
for each record "group".
- Original Message -
From: "Ed Reed" <[EMAIL PROTECTED]>
To:
Sent: Friday, January 12, 2007 12:42 PM
Subject: Re: Insert ... Select troubles
> ItemCount is essentially a counter of the records fr
ykman" <[EMAIL PROTECTED]> 1/12/07 8:13 AM >>>
On 1/11/07, Ed Reed <[EMAIL PROTECTED]> wrote:
>
> I need some help creating an INSERT * SELECT statement that supplies
a record counter in the returned items. Here's the task,
>
> I have t1 and t2. t1 is GroupCount
I need some help creating an INSERT * SELECT statement that supplies a record
counter in the returned items. Here's the task,
I have t1 and t2. t1 is GroupCount, ItemCount, Field1, Field2, Field3. t2 is
Field1, Field2, Field3.
t1 has a multiple field unique key called Request that has Group
Sorry for the premature question. I think I figured it out.
On Duplicate Key Update Qty=Qty+Values(Qty);
I haven't tested it yet but it makes sense that it'll work.
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/5/07 2:40 PM >>>
I use On Duplicate Key
I use On Duplicate Key Update a lot and I usually use it like this,
Insert Into tablename (myID, Qty)
Values (1034,15),
(6,13),
(5001,1),
(145,20) On Duplicate Key Update Qty=Values(Qty);
This works very well but now I'd like to do something a little
different. I'd like to have a query like this
Can someone tell me what happen to the MySQL 5.1.x-beta for Netware
binaries? They aren't in the downloads page anymore.
Thanks
Is there anyway to use RegExp in a field parameter? What would be great
is if I could do this,
SELECT Trim(Both RegExp '[a-z]' From value) as value_num, value
FROM num_test
WHERE value REGEXP 'N[1-999]';
The biggest problem is trying to find the position of where the number
starts in the string
:11 PM >>>
On Thursday 07 December 2006 14:57, Ed Reed wrote:
> Can someone help me with this?
quick hack, but it works from what you've stated:
mysql> create table num_test (id SERIAL PRIMARY KEY, value
VARCHAR(256));
Query OK, 0 rows affected (0.07 sec)
mysql> insert int
Can someone help me with this?
I have a text field that sometimes contains a number preceded with the
letter N. So it might look like this
A test N60
or
N45 someother text
or
This happened. N122, Then there was this.
I need to come up with a Select statement that can show me all the
Can someone tell me if it is possible to create stored procedures with
Query Browser and if it is can you provide an example the works?
Thanks
s <[EMAIL PROTECTED]> 12/2/06 10:38 AM >>>
At 11:34 AM -0800 12/1/06, Chris White wrote:
>On Friday 01 December 2006 11:22, Ed Reed wrote:
>> I have a problem/question I'd like to find someone else to
verify/answer
>> for me.
>>
>> I'm using
Got it.
Thanks
>>> Chris White <[EMAIL PROTECTED]> 12/1/06 11:34 AM >>>
On Friday 01 December 2006 11:22, Ed Reed wrote:
> I have a problem/question I'd like to find someone else to
verify/answer
> for me.
>
> I'm using MySQL 5.1.09 running on Netwa
I have a problem/question I'd like to find someone else to verify/answer
for me.
I'm using MySQL 5.1.09 running on Netware. I've created a stored
procedure that has one parameter,
Create Procedure MyTest(strVal VarChar)
Begin
Select Field1, Field2, Field3 From MyTable
Where Field3=strVal;
En
ea on this?
>>> "Jochem van Dieten" <[EMAIL PROTECTED]> 7/6/06 9:47:26 AM >>>
On 7/6/06, Ed Reed < [EMAIL PROTECTED] > wrote:
> Anyone have an idea on this?
Upgrade. Or at least stop repeating the question.
Jochem
--
MySQL General Mailing List
For list archive
Anyone have an idea on this?
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 7/5/06 1:54:25 PM >>>
Anyone have an idea on this?
Thanks
>>> "Ed Reed" < [EMAIL PROTECTED] > 6/30/06 2:51:44 PM >>>
Opps!
Thanks for the quick repl
Anyone have an idea on this?
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 6/30/06 2:51:44 PM >>>
Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL
4.1.11
Any other suggestions?
Thanks again.
>>> Dan Nelson < [EM
Opps!
Thanks for the quick reply, Dan. But I forgot to mention I'm running MySQL
4.1.11
Any other suggestions?
Thanks again.
>>> Dan Nelson <[EMAIL PROTECTED]> 6/30/06 2:48:57 PM >>>
In the last episode (Jun 30), Ed Reed said:
> Is there a Select statement
Is there a Select statement I can use to get table names so that I could use
other Select statement syntax on the results?
What I'd like to do is this,
SHOW Replace(TABLES, 'tbl','') Like 'tbl%';
But this doesn't work so I need a Select statement that can do the same thing.
Thanks in adva
once.
- Thanks again
>>> Shawn Green <[EMAIL PROTECTED]> 4/12/06 12:15:56 PM >>>
--- Ed Reed < [EMAIL PROTECTED] > wrote:
> Thanks for the response but neither one of the responses I've
> received does exactly what I need since they don't return multip
Thanks for the response but neither one of the responses I've received does
exactly what I need since they don't return multiple rows.
Are there any other ideas out there?
Thanks
>>> "Jay Blanchard" <[EMAIL PROTECTED]> 4/7/06 12:37:32 PM >>>
[snip]
Anyone have an idea on this?
Can anyone exp
Anyone have an idea on this?
Can anyone explain how I might be able to return a numbers of records based on
the sum of a quantity in a field in the same table? (After I read that it
sounds even confusing to me).
Let me explain. I have records like this,
Part#Qty
1254
Can anyone explain how I might be able to return a numbers of records based on
the sum of a quantity in a field in the same table? (After I read that it
sounds even confusing to me).
Let me explain. I have records like this,
Part#Qty
1254 5
1414
gt;> Peter Brawley <[EMAIL PROTECTED]> 4/5/06 10:28 AM >>>
Hi Ed,
Count(1) works just as well. Sum(1) just adds 1 for each row so it's logically
equivalent.
PB
-
Ed Reed wrote: WOW!!! THAT WAS AWESOME!!! Thanks a lot Peter. Ok, so what is
SUM(1)? How is it able to do
'Problem Report',
IF(@n=1,'','s'), ': Priorities(High=',
SUM(IF(Priority='High',1,0)), ',Med=',
SUM(IF(Priority='Med',1,0)), ',Low=',
ed',1,0)),
',Low=',
SUM(IF(Priority='Low' ,1,0)),
')'
)
)
FROM probsum;
DROP TEMPORARY TABLE probsum;
All this would be easier in a stored procedure, if you have MySql 5.
PB
-
Ed Reed wrote:
Can
Sorry, here's the results. BTW the query works it just seems overly complex and
I'd like to streamline it.
CREATE TABLE `employees` (
`EmployeeID` int(11) NOT NULL auto_increment,
`FirstName` varchar(50) default NULL,
`LastName` varchar(50) default NULL,
`DateTerminated` datetime default
Can someone help me simplify this query please? It's meant to return a single
string result that looks something like this,
"You have 12 open Problem Reports: Priorities(High=5, Med=6, Low=1)"
The relavent columns from the two tables are
Table: ProblemReports
Fields: PRNo, Status, Priority,
le to
say.
mysql> source full_path_to_oldgrants.sql
and do one last
FLUSH PRIVILEGES;
Your old accounts should now exist on your new server with their old
permissions restored. Sorry but you asked for "any" ideas... ;-)
Shawn Green
Database Administrator
Unimin Corporati
Does anyone have any idea on this one?
- Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 2/10/06 3:09 PM >>>
I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0
system. It doesn't appear that it can successfully migrate my usernames a
I'm trying to use the Migration Toolkit to migrate a 4.1 system to a 5.0
system. It doesn't appear that it can successfully migrate my usernames and
privileges. Is it supposed to be able to and is there anything special I need
to do to make it happen?
- Thanks
I built my inventory system like this,
I have a products table that contains all the information specific to each
part, less the quantity, i.e. Part Number, Description, Vendor, Color, Weight,
SKU number, etc...
Then I have another table that is my Inventory Tranactions Log that is just the
Actually please ignore my previous question. I just had a brain cramp.
Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/18/06 11:34:11 AM >>>
Can you (or anyone else) explain to me how, or point me somewhere that I can
learn how this works? I'd really like to
Can you (or anyone else) explain to me how, or point me somewhere that I can
learn how this works? I'd really like to know more about how bitwise arithmetic
works.
Thanks
>>> Francesco Riosa <[EMAIL PROTECTED]> 1/10/06 4:58:47 PM >>>
Francesco Riosa wrote:
> And another one is (in inverse orde
Well I solved the problem by using LPAD but it would be nice if there was a
more elegant way of handling this problem.
Thanks for the help.
>>> "Ed Reed" <[EMAIL PROTECTED]> 1/10/06 2:52 PM >>>
Thanks Gordon and Bill but this has one big problem
If my deci
t;>
Actually CONV converts from any base to any base so if it is base 10
then just replace the 16's with 10's.
Too much time looking at dump's.
-Original Message-
From: Bill Dodson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 3:09 PM
To: Gordon Bruce
Cc: Ed
Can anyone tell me if it's possible, in 4.1.11, to convert a decimal number to
binary and have the result be returned as a separate field for each bit? For
example, what I'd like to do is,
Select ConvertToBin(245);
And have a result that looked like this
+---+---+---+---+---+---+---+---+
| 7 |
Thanks Peter, for the quick reply.
>>> Peter Brawley <[EMAIL PROTECTED]> 1/4/06 11:44 AM >>>
Ed,
>Can someone tell me why this fails? I'm using v4.1.11
>Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1),
>'WRONG')
>I would expect a result of 2.
NULL is neither equal nor un
Can someone tell me why this fails? I'm using v4.1.11
Select IF(((Select 1+1) <> Null) and ((Select 1+1) <> 0), (Select 1+1), 'WRONG')
I would expect a result of 2.
- Thanks
Can anyone please help me with this? I'm just not getting it.
- Thanks
>>> "Ed Reed" < [EMAIL PROTECTED] > 10/6/05 2:50:46 PM >>>
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
>>> Pooly < [EMAIL PROTECTED] > 10/6/05
Can anyone please help me with this? I'm just not getting it.
- Thanks
>>> "Ed Reed" <[EMAIL PROTECTED]> 10/6/05 2:50:46 PM >>>
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
>>> Pooly < [EMAIL PROTECTED] > 10/6/05
Thanks for the reply,
Sorry; I'm using 4.1.11
Thanks again.
>>> Pooly <[EMAIL PROTECTED]> 10/6/05 1:51 AM >>>
2005/10/6, Ed Reed < [EMAIL PROTECTED] >:
> I'm trying to group some sub categories with a concatenated result. I'm
> trying to
I'm trying to group some sub categories with a concatenated result. I'm trying
to get the max sub for each item per month. I think it should be fairly easy
but it is kicking my butt. My data looks like this,
+++--+
| month | item | sub |
+++--+
|
I meant 600k not 6meg. Sorry
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/30/05 9:46:32 AM >>>
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
secu
I think Control Center is a much better tool then the combination of Query
Browser and Administrator. I still use Control Center for my day to day stuff
and only check out Query Browser when new versions come out to see if they've
solved the major problems.
I think they've gone completely in t
That's not true.
Group_Concat can already return more than 6meg. It's set by
group_concat_max_len variable. The fact is that I've been told there are
security issues corrected in the 4.1.14a update and I can't apply them because
it will break my already existing apps.
Is there a fix?
- Th
Will someone please respond to this?
- Ed
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/22/05 1:30 PM >>>
Bump!
>>> "Ed Reed" < [EMAIL PROTECTED] > 9/21/05 2:09:58 PM >>>
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat re
Bump!
>>> "Ed Reed" <[EMAIL PROTECTED]> 9/21/05 2:09:58 PM >>>
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
I just upgraded from 4.1.11 to 4.1.14a and now Group_Concat returns garbage. In
the previous version Group_Concat returned a text string and after the upgrade
they are returning a blob.
I know this has to be a simple query but its really kickin' my butt. I have the
table below where fld1 is the year, fld2 is a number, fld 3 is a subnumber, and
fld4 is the user. I need to know the count of all the records for user am
without the sub number getting in the way. For example, the f
Thanks guys!
>>> [EMAIL PROTECTED]> 8/30/05 1:22 PM >>
The correct syntax for the second method doesn't use "VALUES()". I would always
use this form if I were going to exclude any columns from receiving data. It's
just safer and relies less on the SQL engine to correctly divine what it is y
Can anyone please tell me why this fails, I've done this type of thing before
without a problem
Insert Into tbl1 Select 10306, fld2, fld3, fld4 From tbl1 Where fld1=8114
tbl1 has five fields all ints with fld5 being the autoincrement index.
I've also tried it as,
Insert Into tbl1 (fld1, f
select USERS.Name, Count(WINS.user_id)
>From USERS inner join WINS on WINS.user_id = USERS.id
Group By USERS.Name
>>> René Fournier <[EMAIL PROTECTED]> 7/29/05 4:40 PM >>>
Let's say I have two tables:
USERS
id name
1 John
2 Mary
3 Sue
4 Paul
5 David
WINS
id user_id
1 2
2 4
3 3
4 5
5 1
6 4
7 4
I have a table that contains all the part number and cost transactions over
time. I wanna get a get the summary cost of each part number for each month.
For example, when I supply a single part number to this query the results
should be something like this.
+--+--+
| Month |
I do this all the time and it works flawlessly. Just like your example and even
more extreme. I use this technique to provide search mechamisms for my
applications. ex,
SELECT ID
FROM table
WHERE concat(field1, field2, field3,...{all the fields in the table}) Like
'%searchstring%';
This w
Thanks for the reply.
What do you mean by 'self join'?
>>> Eric Bergen <[EMAIL PROTECTED]> 6/17/05 4:39:28 PM >>>
Could you accomplish this with an update and self join?
Ed Reed wrote:
>Sorry, I thought it was easy to understand.
>
>I wanna upda
+
| a | b |
+--+--+
| 1 | one |
| 1 | two |
| 1 | one |<==== changed
| 2 | two |
| 1 | Un |
+--+--+
5 rows in set (0.00 sec)
Mathias
Selon Ed Reed < [EMAIL PROTECTED] >:
> Can anyone tell me how I can make this work or suggest a work around?
>
> Update tab
Is there way to return the ordinal position of a value within a table?
Let's say I have a table of phone numbers. Over time the table has had
additions and deletions. The table has an autonumber ID field. If I sort by the
ID field I'd like to know what position the number '555-1212' is in the t
get an error that says "You can't specify
target table 'table1' for update in FROM clause"
- Thanks
>>> <[EMAIL PROTECTED]> 6/17/05 11:03:40 AM >>>
"Ed Reed" < [EMAIL PROTECTED] > wrote on 06/17/2005 01:35:40 PM:
> Can anyo
Can anyone tell me how I can make this work or suggest a work around?
Update table1 Set field1=(Select field1 From table1 Where field2="Some Value")
Where field2 ="Another Value";
Thanks
Is there anyway to force UCASE and UPPER to convert the alpha characters of a
string even if there's a number in the string somewhere?
I have a field that contains large amounts of user entered text. I want to
convert the whole thing to upper case so I can do a case insensitive compare
against
Does anyone else have any ideas about this topic?
Thanks
>>>Ed Reed <[EMAIL PROTECTED]> 04/23/05 1:29 pm >>>
Thanks for the reply,
I realize that user variables disappear when the connection closes but I don't
understand why what I'm trying to accomplish can
Try this
SELECT *
FROM applications LEFT JOIN rejected ON application.appid = rejected.appid
WHERE rejected.appid Is Null
ORDER BY application.appid DESC;
>>> Wade <[EMAIL PROTECTED]> 4/23/05 3:12:37 PM >>>
04232005 1707 GMT-6
I need to do something like this:
$sql = "SELECT * FROM applicatio
ully then you should be able to have a single call with
multple SQL commands work just as succesfully? Is there any way to do what I
asked in my original post?
Thanks again for the reply.
>>> Paul DuBois <[EMAIL PROTECTED]> 4/23/05 12:12:32 PM >>>
At 22:04 -0700 4/22/05,
;s no way I can change them to do otherwise.
Thanks again.
>>> Chris <[EMAIL PROTECTED]> 04/22/05 7:56 PM >>>
Ed Reed wrote:
>If I run the following in MySQLFront v3.1
>
>Set @A='Test';
>Select @A;
>
>I get back same result
>
>+--+
>
I'm having trouble using user variables and I hope someone can help,
My test environment is MySQL 4.1.11 on WindowsXP with MyODBC 3.51.11
If I open a command line client, I can do this
mysql> SET @A='Test';
Query OK, 0 rows affected (0.00 sec)
mysql> Select @A;
+--+
| @A |
+--+
| Te
FROM test WHERE log LIKE '%tested this%'
Don't try this at home.
____
Eamon Daly
- Original Message -
From: "Ed Reed" < [EMAIL PROTECTED] >
To: < mysql@lists.mysql.com >
Sent: Thursday, March 24, 2005 3:37 PM
Subje
vious problem is that there doesn't seem to be an easy way to search
backwards through a string.
Any ideas on that line of thought?
Thanks
- Ed
>>> <[EMAIL PROTECTED]> 3/24/05 1:18 PM >>>
"Ed Reed" < [EMAIL PROTECTED] > wrote on 03/24/2005 04:02:28 P
Sorry everyone for not being more clear. The field IS in a multiline
varchar field. The example data was all from one record in the table.
Unfortunately, this is a database that has been around for many years
and backward compatibility with other apps limits redesigning the table.
It is a Comment
This is an interesting problem that I hope someone can help me with. I
have a varchar field that contains data like this,
01/01/05 SG Reviewed this
12/15/03 DSD Reviewed that
10/24/02 EWW Worked on that and tested this then stop to do something
else
05/02/01 AW Did something
08/31/98 DSD Tested
That did it.
Thanks for the quick response!
>>> <[EMAIL PROTECTED]> 2/16/05 11:19 AM >>>
"Ed Reed" < [EMAIL PROTECTED] > wrote on 02/16/2005 02:13:40 PM:
> Can anyone tell me the limit for the number of records that can be
> inserted in a s
Can anyone tell me the limit for the number of records that can be
inserted in a single call?
I'm trying to insert multiple records like this,
INSERT INTO t1 (f1, f2, f3, f4) VALUES
("test", 1, "some data", "Done"),
("testing", 21, "some more data", "Still Done"),("tested", 50, "no more
data",
Can someone explain how I can make a combination of two fields be a
unique index.
For example, in my table I have an OrderID field and a LineItems field.
Individually the fields are not unique but when combined they are. I'd
like to create a unique index of the two together but not individually.
How do I prevent IFNULL and ISNULL from returning a null?
I have the following query where this is occurring,
Select IFNULL(sum(qty),0)
from inventory
where partnumber=111
group by partnumber;
If the partnumber has never been in inventory then the sum and ifnull
functions both return null. If
Is there anything wrong with just stopping the server and renaming the
database's directory in the DATA directory? I've used that method
without any problems. It also works very well for making a copy of the
database to a new differently named database. Are there any pitfalls
that I haven't encount
Where's the presentations? They were supposed to be on the website at
the end of last week.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where's the presentations? They were supposed to be on the website at
the end of last week.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where's the presentations? They were supposed to be on the website at
the end of last week.
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I'm trying to get the presentations too. I found one of them. the
session was in the Orlando room and it was called Crack-Proofing MySQL.
I found the presentation on the authors site at
http://www.appsecinc.com/presentations/Hackproofing_MySQL.pdf. I thought
the session was pretty good and luckily
Mehta" <[EMAIL PROTECTED]> 3/29/04 12:18:37 AM >>>
please include the query, you are using with no success and also
specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" < [EMAIL PROTECTED] >
To: < [EMAIL PROTECTED] >
S
We like it on Netware 6.5, with memory equal to 10 times the size of
your largest DB. ie; DB=100mb RAM=1gb. Fastest proc you can afford.
>>> "Chad Attermann" <[EMAIL PROTECTED]> 3/29/04 1:56:05 PM >>>
Hello All,
I have been a MySQL user for some time and have always run MySQL on
older generati
Mehta" <[EMAIL PROTECTED]> 3/29/04 12:18:37 AM >>>
please include the query, you are using with no success and also
specify the
version of your mysql.
Nitin
- Original Message -
From: "Ed Reed" < [EMAIL PROTECTED] >
To: < [EMAIL PROTECTED] >
S
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
I'm coverting an Access database to MySQL 4.1.1 and I need help with a
near impossible query. In the Access DB I used a stored procedure; I
think I should be able to solve this problem with a subselect in MySQL
but so far I'm not having any luck.
Here's the problem; In my stored precedure query I
Thanks Jeff,
After a little more investigation it turns out that the problem only
exists when I run the query through a MS Access database attached to
MySQL via ODBC. If I run the query in MySQLCC or MySQL-Front it runs
just fine.
Any ideas for a work around?
- Ed
>>> <[EMAIL PROTECTED]> 3/2
1 - 100 of 126 matches
Mail list logo
