stored procedure

[sandra]

Hi:
Can anyone help about how can I create stored procedure to mysql? I took a
look to mylua but it is just to Linux. My server is Windows 2000. In the
MySql documentation I just see some examples in C, but I don't know how can
I do it, and if I done it in C, how I would call it from php?
Thanks in advance
Sandra


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MyLua for Windows exists?

[sandra]

 Can anyone tell me if has used MyLua (MySQL + LUA) for Windows? Or if the
binaries that
 appear in the following URL http://www.fastflow.it/mylua/  can be compiled
 for Windows? MyLua is the only thing that I have found to write stored
procedure for MySQL but I'm using Windows 2000 sever.
 Any suggestion I'll appreciate it.
 Thanks a lot
 Sandra



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

can't use the table. What happen, please!!!!!!!!!!

[Sandra]

Hi all,

I am getting the error when trying to connect server from my client:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in .

I had my tables in test database, but created a new database and passed my
tables to there. Since then I receive that message when I execute my .php
I used GRANT to assing the user privileges.

any answer?

thanks,

Sandra


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

*.index files in MySQL Data directory

[Arnold, Sandra L.]

What are the *.index files in the MySQL Data directory?  I notice a new one is 
created every time that MySQL is stopped and restarted.  My Data directory is 
not in the default location so does that have anything to do with it?

Thanks,

Sandra Arnold
Data Warehouse Administrator
MartinFederal Consulting
Consultant to Oak Ridge National Laboratories
Computational Data Analytics Group
Data Architectures Team
Building 5100,  M/S 6173
OAK RIDGE TN 37831-6173
(865)241-1530

RE: *.index files in MySQL Data directory

[Arnold, Sandra L.]

There are files beginning with 1..  The sequence number is 
01 to 15.  A new file is created every time MySQL is restarted.  The 
1.index file contains a list of these files.  One thing that I have done is 
when I was hardening the security we stopped MySQL and moved the data directory 
to a directory called /var/lib/db/mysql.  I changed the datadir variable in the 
my.cnf file to point to this directory.  This was to be sure that our data 
directory was not on the same partition as our SYSTEM or the Log partitions.  
Everything is working fine except I have the files mentioned above.  

Thanks,

Sandra Arnold
Data Warehouse Administrator
MartinFederal Consulting
Consultant to Oak Ridge National Laboratories
Computational Data Analytics Group
Data Architectures Team

-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net] 
Sent: Wednesday, March 27, 2013 3:14 PM
To: mysql@lists.mysql.com
Subject: Re: *.index files in MySQL Data directory



Am 27.03.2013 19:53, schrieb Arnold:
> What are the *.index files in the MySQL Data directory?  I notice a new one 
> is created every time that MySQL is stopped and restarted.  My Data directory 
> is not in the default location so does that have anything to do with it?

maybe a "ls -lha" of a sample would be nice

never seen one of them from MySQL 3.x to 5.5 nor with MariaDB, indexes are .MYI







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

foreign key

[Sandra Rovena Frigeri]

hi,

which windows mysql version supports foreign key and its "complete" implementation: 
referential integrity constraint, avoid delete parent key, etc.?
or
Which foreign key features that has the best windows mysql version?

thanks,

sandra.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

jdbc

[Sandra Rovena Frigeri]

Hi Peple,

thanks for informations about foreign key in mysql!

Now I need some informations about jdbc driver:
- Are there diferences for jdbc driver for diferent versions of mysql and jbuilder and 
jdk?
- I use jbuilder 2.0 and mysql 3.23.41, which jdbc driver is better? 


thanks

Sandra.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql - java - jdbc

[Sandra Rovena Frigeri]

Hi,

I need some information about jdbc driver for mysql dbms (windows version 3.23.43) for 
use it with jbuilder (version 2 or 3.5).

Thanks for any information.

Sandra.



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php