Hi,
1) Can a stored procedure call another stored procedure?
Ie, can you do 'call someproc()' from within a stored procedure?
2) Also, will a function ever be able to issue a SELECT query?
I am using mysql-5.0.1-alpha (built froms ource) , winXP win2k.
The mysql daemon crashes without an
Morning :)
1. You sure can, e.g:
CREATE PROCEDURE `user_authenticate`(IN sUserName VARCHAR(25), IN sPassword
CHAR(32), OUT sUserCookie CHAR(32))
BEGIN
DECLARE iUserID INT;
DECLARE iLogID INT;
SELECT MD5(CONCAT(UserID,NOW())) INTO sUserCookie FROM users WHERE UserName
= sUserName AND Password
Sorry, I spoke too soon.
I just made a test case of a proc calling a proc, which works,
so I must have a different problem.
- Still would like to know if a function will ever be able to issue a
SELECT tho.
Cheers
Mike
-Original Message-
From: Michael Pheasant [mailto:[EMAIL
Thanks a lot, I think I have enough to validate the syntax (sort of).
Ahmad Khashan
Michael Stassen [EMAIL PROTECTED] wrote:
Khashan wrote:
**None of these are table level modifiers**
Sorry, I guess I used the wrong terminology. I am aware of the table
options available. What I meant is
I've been unable to select or set an enum field by using the string values.
Numeric values work correctly.
SHOW CREATE TABLE gives the following:
CREATE TABLE `Organizations` (
`OrgID` int(11) NOT NULL auto_increment,
`Organization` varchar(50) NOT NULL default '',
* Eldon Ziegler
I've been unable to select or set an enum field by using the
string values.
Numeric values work correctly.
SHOW CREATE TABLE gives the following:
CREATE TABLE `Organizations` (
`OrgID` int(11) NOT NULL auto_increment,
`Organization` varchar(50) NOT
Hi,
i'm new around here.
I'm creating a e-commerce app and, consequently, a big
database. I've searched around mysql docs and realizes
that exists some especial (or better) kinda tables.
In my small experience i'd choose InnoDB tables for my
database, is this the best option for a e-commerce
* beginner aka ltcmelo
I'm creating a e-commerce app and, consequently, a big
database. I've searched around mysql docs and realizes
that exists some especial (or better) kinda tables.
I suppose you meant table handlers.
In my small experience i'd choose InnoDB tables for my
database, is
Hi,
I'm using a kernel 2.4.25 system (Slackware distro) installed
with gcc 3.2.3.
I've tried both 4.0 and 5.0 source tarballs and when
configured with :
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql \
--with-openssl
and compiled, I always end up with:
gcc
Hello,
I am a mysql newbie. Recently, I've been given the task of joining two tables
within the same DB into one table. Currently, the tables are named 'desktops'
and 'laptops'... ultimately, I would like one table named 'computers' Both
tables have the exact same fields... they fields even
To select the contents of both into one table, you most likely want to use
the 'UNION' operator:
SELECT * FROM desktops
UNION
SELECT * FROM laptops
If you create the computers table before hand (you can see how you would
create either of the others with SHOW CREATE tablename), then you can just
Thank you Matt, I am using Mysql 3.23.58 on RH Linux 9... UNION isn't
supported on this version.
On Saturday 03 April 2004 15:20, Matt Chatterley wrote:
To select the contents of both into one table, you most likely want to use
the 'UNION' operator:
SELECT * FROM desktops
UNION
SELECT *
* Brad Tilley
create table computers
select * from desktops, laptops where
desktops.field_1 = laptops.field_1
...
Thank you Matt, I am using Mysql 3.23.58 on RH Linux 9... UNION isn't
supported on this version.
You can do it in two steps:
CREATE TABLE computers SELECT * FROM
Osvaldo's question is a good one. How are you connecting to the MySQL
instance?
I use MySQL and Access as you are, but I use a MySQL instance running
on OS X. However, I don't have that problem. I use linked tables to
bring the MySQL tables into MS Access.
I have had quirky behavior when
There are two ways of handling this, the long way and the short way.
The long way is to prefix each ambiguously named column with the full table
name, as you have been doing. That *should* have worked for you since that
seems to be what you are doing in your example. Or did you literally write
Ensure you have a timestamp(14) field. This will provide the required
uniqueness for Access (Jet).
I hope this helps.
Pat...
[EMAIL PROTECTED]
CocoNet Corporation
SW Florida's First ISP
825 SE 47th Terrace
Cape Coral, FL 33904
- Original Message -
From: Adam [EMAIL PROTECTED]
To:
Hi all,
I have positively identified the row I want to delete using:
'SELECT * FROM table LIMIT 10,1'
This has returned 1 record and I now want to DELETE the record.
How do I identify this record in my DELETE statement?
(using 'DELETE FROM table LIMIT 10,1' does not work)
NOTE : I can't
I'm wondering if someone could help me figure out why I'm getting this error
when attempting to use phpMyAdmin to connect to mysql:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the
connection. You should check the host, username and password in
config.inc.php and make
I see $cfg all over the place and no mention of HTTP. Where should I be
looking for this?
Thanks
-Original Message-
From: Eve Atley [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 03, 2004 9:36 PM
To: Marvin Cummings
Subject: Re: Unable to connect to mysql with phpmyadmin
In the
Ok. I'm using the default config.inc.php file which has 'config' as the
'auth_type'. I change this to HTTP and I'm prompted to enter a username and
password. I try root and its password and get You are not authorized to
view this page. This happens regardless of the account I use. I know I'm
Marvin Cummings wrote:
I'm wondering if someone could help me figure out why I'm getting this error
when attempting to use phpMyAdmin to connect to mysql:
phpMyAdmin tried to connect to the MySQL server, and the server rejected the
connection. You should check the host, username and password in
On Wed, 2004-03-31 at 16:08, Chris Boget wrote:
I have 2 tables (looks best in fixed width font):
test_items
+---+--+
| name | rec_num |
+---+--+
| Book | 1|
| Game | 2|
+---+--+
test_attributes
+---++
|
Hi,
You need to delete using a where clause and column values unique to
that row. Try SELECT * from table limit 10,1 see if you can find some
value(s) which is unique to that record (irrelevant whether its defined
as a primary key). Eg, maybe col2 and col4 can uniquely id
The record you want to
Careful! I should clarify ... before you do the delete,
make sure the columns really do uniquely identify that row with
select * from table where col2='some value'
and col4='some other value'
...without the limit clause.
Delete will delete everything that matches the where clause!
Mike
Patrick Sherrill wrote:
Ensure you have a timestamp(14) field. This will provide the required
Thanks all but I reposted and the problem was my primary key being a BIGINT
which Access can't display. I should have closed off both threads.
--
MySQL General Mailing List
For list archives:
It seems to me you want to retrive n records based on the page number the user is in.
Here is what i use to page $limit records at a time using PHP:
$sql_select = SELECT * FROM myTableName limit $offset , $limit;
$result = mysql_query($sql_select) or die (Queryproblem: . mysql_error());
I
26 matches
Mail list logo