Re: Impact of making a stored program transactional while running under transaction manager?

2009-03-09 Thread Al
David Karr wrote: it's supposedly good advice in a multi-step stored procedure to have an explicit "start transaction" and "commit" wrapping the work. What is the impact of doing this if the stored procedure is called from code managed by a transaction manager. For instance, in a JEE appserver

Re: How to get Error Number and Error Message 2nd Try

2009-02-16 Thread Al
Paul DuBois wrote: On Feb 10, 2009, at 11:26 PM, Al wrote: I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL f

How to get Error Number and Error Message 2nd Try

2009-02-10 Thread Al
I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL function" such as in C using " *mysql_errno()" etc. BUT * Surely there is

How to get Error Number and Error Message

2009-02-10 Thread Al
I know that all of the prgramming interfaces have the ability to issue a Function Call to get "error number for the most recently invoked MySQL function" and "the error message for the most recently invoked MySQL function" such as in C using " *mysql_errno()" etc. BUT * Surely there

Database for a library

2008-07-04 Thread Khaled al-Horani
Hello, I'm building a web application for a library but I faced a problem ... NOTICE: This web app includes a feature that you can read the books online ... I have to save the books either in the database (mysql for sure) or on the hard disks ... but I preferred DB choice because of many befits

Newbie Q- Mac OSX install - login to mysql not working...

2007-12-13 Thread Al
(Sorry if this is a duplicate post, email issues w/multiple accts) I have a MacBook Leopard OS 10.5.1 2 GB RAM. I've got a good amount of knowledge of computer systems, but haven't setup or worked with mySQL before. (usually use it preinstalled on my hosting service). I downloaded the package and

Revoking Privileges

2007-04-11 Thread Al Sparks
'localhost' IDENTIFIED BY PASSWORD '*37638FAC6D9ED84696E9504AC8EA4495EA97A908' | | GRANT ALL PRIVILEGES ON `WP_INT_BASEBALL`.* TO 'WP_INT_BASEBALL'@'localhost' | +------

Re: Creating a Table With a Default

2007-03-28 Thread Al Sparks
essed. Sort of weird that ProBIND didn't change the script. === Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Creating a Table With a Default

2007-03-28 Thread Al Sparks
CREMENT, -> PRIMARY KEY (id) -> ); ERROR 1067 (42000): Invalid default value for 'id' I've tried double quotes, changing it to INT(1), and still I get that error. Any hints? === Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

sum with update

2007-02-17 Thread Ahmad Al-Twaijiry
Hi Everyone I have a question regarding SUM and Update. is it possible to use SUM with Update ? for example I have 3 tables table_1: idT1 Price 120 230 350 420 table_2: idCust Total

Re: old-password issue with mysqldump

2006-12-11 Thread Ahmad Al-Twaijiry
Hi Thanks, this is easy and simple if I just have few users :) I have more than 30,000 users :) I think there is no way to do this so I have to use old-passwords option in the new servers :) Thanks On 12/11/06, Daniel da Veiga <[EMAIL PROTECTED]> wrote: On 12/11/06, Ahmad Al-Twaijiry &

old-password issue with mysqldump

2006-12-11 Thread Ahmad Al-Twaijiry
Hi everyone I'm using mysqld with option "old-passwords" in my server (let's call it serverA) and in my application I use "UPDATE . SET USERPWD=PASSWORD('ABCD')" to set the users password now I want to move my database to another server (serverB) and the mysqld in this new server doesn't ru

Re: Deadlock

2006-11-18 Thread Ahmad Al-Twaijiry
YES :) after removing CustomerID and OrderID from Primary index to unique index, every thing is working fine and I don't get any deadlock anymore :) Thanks Everyone :) On 11/16/06, Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi Ahmad, On 11/13/06, Ahmad Al-Twaijiry <[EMAIL PRO

Re: float numbers

2006-11-17 Thread Ahmad Al-Twaijiry
IMAL and DOUBLE in MySQL 5.0.* ? Thanks On 11/18/06, mos <[EMAIL PROTECTED]> wrote: At 03:29 PM 11/17/2006, Ahmad Al-Twaijiry wrote: >Ho everyone > >I have a column in a table defined as float > >mynumber float(20,2) > >if we say mynumber column in a row is 100 ,

float numbers

2006-11-17 Thread Ahmad Al-Twaijiry
Ho everyone I have a column in a table defined as float mynumber float(20,2) if we say mynumber column in a row is 100 , when I run this SQL : UPDATE Table SET mynumber=mynumber-100.15 the mynumber column will be 00 not 999899.85 what is the problem ? -- echo "Hello World :)" --

Re: Deadlock

2006-11-13 Thread Ahmad Al-Twaijiry
Commits a transaction, returning the database connection to autocommit mode until the next call to PDO::beginTransaction() starts a new transaction. That means that autocommit is disabled when you issue $dblink->beginTransaction(); - Original Message - From: Ahmad Al-Twaijiry <[EMA

Deadlock

2006-11-13 Thread Ahmad Al-Twaijiry
Hi everyone, Everyday I got around 10 Deadlock errors in my database : SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction SQL=UPDATE Shop SET Total=Total-125 WHERE CustomerID=1697 AND OrderID=105 I'm using Innodb engine type for my

Re: MAX + SUM in one query

2006-11-06 Thread Ahmad Al-Twaijiry
#x27;offer' and id same for both the tables. Is it so? Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006

Re: MAX + SUM in one query

2006-11-06 Thread Ahmad Al-Twaijiry
test where >> RequestType='offer' group by StockID; Pls have a look into the table and the output for the query. Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTE

Re: MAX + SUM in one query

2006-11-05 Thread Ahmad Al-Twaijiry
rows in set (0.01 sec) Thanks, ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Monday, November 06, 2006 8:58 AM Subject: MAX + SUM in one query > Hi everyone > > I have the following the t

MAX + SUM in one query

2006-11-05 Thread Ahmad Al-Twaijiry
Hi everyone I have the following the table : CREATE TABLE `Request` ( `RequestID` int(10) unsigned NOT NULL auto_increment, `Stock_StockID` int(10) unsigned NOT NULL default '0', `RequestType` enum('Bid','Offer') NOT NULL default 'Bid', `RequestTotal` int(10) unsigned NOT NULL default '0',

transaction in mysql 5

2006-10-31 Thread Ahmad Al-Twaijiry
Hi everyone I have a PHP script that will run every minute and do a lot of SELECT and UPDATE statments All my tables are InnoDB and I'm using PHP 5 and POD class ( http://php.net/pod ) to connect to mysql, in my script I start the transaction (using method beginTransaction() ) in the beginning o

Mysql Timezone

2006-10-21 Thread Ahmad Al-Twaijiry
Hi everyone is it possible in Mysql 5.0.1 to set the timezone for a user ? PS: I don't have root access to mysql, so I'm looking for away to do it as a normal user. --- Ahmad http://www.v-tadawul.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Reports

2006-10-20 Thread Ahmad Al-Twaijiry
Hi everyone do you know any good (free) application that make it easy to generate (with charts) a very nice reports from mysql ? Thanks --- Ahmad http://www.v-tadawul.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EM

list of cols that I need to index

2006-10-16 Thread Ahmad Al-Twaijiry
Hi is there anyway or command to run it against a production table to see if there is any column that I should think about indexing it remember this is a production database, so I can't run it in debug mode and I don't have a root access to the database (I'm just a developer). Thanks -- Ahm

Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-05 Thread Abdullah Ibn Hamad Al-Marri
Heya! This fixed it for me, I didn't set kern.threads.max_groups_per_proc: earlier. What is the max threads can FreeBSD go for? Thanks, -A - Original Message From: Ken Menzel <[EMAIL PROTECTED]> To: Abdullah Ibn Hamad Al-Marri <[EMAIL PROTECTED]>; mysql@lists.mys

FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-03 Thread Abdullah Ibn Hamad Al-Marri
Hello folks, I hope Greg is reading this list I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading. I have a huge app makes alot of connections to MySQL server. The max I could reach is 1500 threads, even I made the max connection in my.cf 5k and I used kern.threads.max_th

FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-03 Thread Abdullah Ibn Hamad Al-Marri
Hello folks, I hope Greg is reading this list I use MySQL 5.0.24a from the FreeBSD ports, with libthr threading. I have a huge app makes alot of connections to MySQL server. The max I could reach is 1500 threads, even I made the max connection in my.cf 5k and I used kern.threads.max_threads

Re: SUM in WHERE

2006-09-25 Thread Ahmad Al-Twaijiry
WHERE total=100 ORDER BY id LIMIT 1,1 Douglas Sims [EMAIL PROTECTED] On Sep 24, 2006, at 3:27 PM, Ahmad Al-Twaijiry wrote: > Hi > > I need the result to be 100 not to more or less than 100 > > here is my query : > > mysql> select version() ; > +-

Re: SUM in WHERE

2006-09-24 Thread Ahmad Al-Twaijiry
ould also do it in the perl/python/php/whatever layer which is sending this query to the database. Can you send a transcript of what you tried, including the "SHOW CREATE TABLE" statement? Douglas Sims [EMAIL PROTECTED] On Sep 24, 2006, at 10:09 AM, Ahmad Al-Twaijiry wrote: >

Re: SUM in WHERE

2006-09-24 Thread Ahmad Al-Twaijiry
doesn't work :( , tested with 4.1.21 On 21 Sep 2006 13:20:37 -, Felix Geerinckx <[EMAIL PROTECTED]> wrote: On 18/09/2006, "Ahmad Al-Twaijiry" wrote: > I want to run SQL query that will return to me the first records that > the SUM of Total field = 100 USE tes

Re: SUM in WHERE

2006-09-24 Thread Ahmad Al-Twaijiry
t; > Using only SQL, your best bet would be a stored procedure, > otherwise its really application logic to select the rows one at a > time and keep a running total. > > HTH > > Quentin > > -Original Message- > From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECT

Rapid application development

2006-09-24 Thread Ahmad Al-Twaijiry
Hi Everyone, I know this isn't the right mail list, but I need your feedback as mysql users What is the best RAD (Rapid application development) do you use with MySQL to develop software or a web-based program ? and in which language is it ? (PHP, Perl, Java, ...etc). I like programming but one

Re: SUM in WHERE

2006-09-19 Thread Ahmad Al-Twaijiry
Information Technology 1700 Pratt Drive Blacksburg, VA 24060 Email: [EMAIL PROTECTED] Phone: (540) 231-4396 -Original Message- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:06 AM To: Edward Macnaghten Cc: mysql@lists.mysql.com Subject: Re: SUM

Re: SUM in WHERE

2006-09-19 Thread Ahmad Al-Twaijiry
I tried it also with 4.1.21-log and still didn't work ! On 9/19/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote: I tried that before and it also doesn't work, is it because I'm using mysql version 4.1.19 ? On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote

Re: SUM in WHERE

2006-09-19 Thread Ahmad Al-Twaijiry
I tried that before and it also doesn't work, is it because I'm using mysql version 4.1.19 ? On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote: Ahmad Al-Twaijiry wrote: > Hi everyone > > SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID > > SELEC

Re: SUM in WHERE

2006-09-18 Thread Ahmad Al-Twaijiry
--- > Von: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 18. September 2006 23:28 > An: mysql@lists.mysql.com > Betreff: SUM in WHERE > [...] > > I want to run SQL query that will return to me the first > records that the > SUM of Total field = 100 > &

SUM in WHERE

2006-09-18 Thread Ahmad Al-Twaijiry
Hi everyone I didn't find any maillist regarding SQL question so I'm posting my question in here. I have a table like this [ ID ][ Total ] [ 1 ][ 20 ] [ 2 ][ 30 ] [ 3 ][ 40 ] [ 4 ][ 10 ] [ 5 ][ 20 ] [ 6 ][ 20 ] I want to run SQL query that will return to me

MySQL 5.0.24 hard time with VB 3.5.4 and 3.6

2006-08-09 Thread Abdullah Ibn Hamad Al-Marri
Hello folks, I'm having hard time with MySQL, I posted this issue t the vb board, and they claimed it's MySQL issue. I have this issue since I upgraded to MySQL 5.0.22 and now it's still I going on since I upgraded to MySQL 5.0.24 too. Database error in vBulletin 3.6.0: Invalid SQL:

Re: Why release 5.0.23 instead of 5.0.24?

2006-07-31 Thread Abdullah Ibn Hamad Al-Marri
- Original Message From: Greg 'groggy' Lehey To: Abdullah Ibn Hamad Al-Marri Cc: Jim Winstead ; mysql@lists.mysql.com Sent: Monday, July 31, 2006 5:54:31 AM Subject: Re: Why release 5.0.23 instead of 5.0.24? On Saturday, 29 July 2006 at 9:53:29 -0700, Abdullah Ib

Re: MySQL 5.0.22 install problem with NetBSD

2006-07-30 Thread Abdullah Ibn Hamad Al-Marri
I guess MySQL should make binary for NetBSD too. - Original Message From: Clay R White <[EMAIL PROTECTED]> To: mysql@lists.mysql.com Sent: Sunday, July 30, 2006 2:01:58 AM Subject: MySQL 5.0.22 install problem with NetBSD From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MySQL 5

Re: Why release 5.0.23 instead of 5.0.24?

2006-07-29 Thread Abdullah Ibn Hamad Al-Marri
That's why I wondered. So when will we get MySQL 5.0.25 for FreeBSD? -A On Sat, Jul 29, 2006 at 08:35:41AM -0700, Abdullah Ibn Hamad Al-Marri wrote: > Why MySQL 5.0.23 while it has serious bug? > > I thought you guys will release 5.0.24 instead. This is still the case. 5.0.

Why release 5.0.23 instead of 5.0.24?

2006-07-29 Thread Abdullah Ibn Hamad Al-Marri
Hello, Why MySQL 5.0.23 while it has serious bug? I thought you guys will release 5.0.24 instead. Security fix: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. However, if the user's privileges on t are subsequently revoked, the user can continu

Newbie wants to load a couple of tables and join them

2006-02-13 Thread Al Sparks
tried was to create a database with mysqladmin create MACARP and the error I get is CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'MACARP'' A similar attempt to create a user ended similarly. Can I get some hints? === Al

error 1064 when trying to create table

2005-12-25 Thread Nabegh Al-Thalji
When I execute the following query CREATE TABLE Sponsor ( sNum INTEGER UNSIGNED NOT NULL, sAdrBlock CHAR(2), sCivil_ID CHAR(12), sDateOfBirth DATE, sDrvLicenseExp DATE, sDrvLicenseNum CHAR(9), sGender ENUM('M','F'), sName VARCHAR(20), sStatus VARCHAR(20), sTelephone CHAR(7), A_areaNum INTEGER UNS

RE: JBoss queries aren't cached by MySQL

2005-10-06 Thread Al Caponi
th MySQL 4.1.1, the query cache also works within transactions when using InnoDB tables (it uses the table version number to detect whether or not its contents are still current).' Regards, Al Send instant messages to your online friends http://asia.messenger.yahoo.com -- MySQL General

RE: JBoss queries aren't cached by MySQL

2005-10-05 Thread Al Caponi
he general log to be sure that MySQL receives unchanged queries and no session variables has been changed. "Al Caponi" <[EMAIL PROTECTED]> wrote: > Hi All, > I didn't see any follow-up on this thread. Hope I can get some hint :) > How to get the query cache to work

RE: JBoss queries aren't cached by MySQL

2005-10-05 Thread Al Caponi
Hi again, It seems that the problem is solved with MySQL 4.1 (and later?). See a posting from the Jboss forum: http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3830750#3830750 Cheers, Al -Original Message- From: Al Caponi [mailto:[EMAIL PROTECTED] Sent: Wednesday, Oc

RE: JBoss queries aren't cached by MySQL

2005-10-05 Thread Al Caponi
,0 Qcache_not_cached,328 Qcache_free_memory,33545632 Qcache_free_blocks,1 Qcache_total_blocks,1 Note: Running queries from MySQL-Front hits the cache - the above counters increase. Regards, Al -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 200

MySQL Remote Connection?

2005-06-24 Thread Badr Al-Muzini
hi, i try to access the MySQL server remotely using Command prompet how can i do so? i mean i want to run all MySQL command on my hosting server ... _ Don’t just search. Find. Check out the new MSN Search! http://sear

RE: Key Buffer Size

2004-03-19 Thread Al Caponi
i did: http://www.mysql.com/doc/en/Server_system_variables.html -Original Message- From: Terence [mailto:[EMAIL PROTECTED] Sent: Friday, March 19, 2004 3:11 PM To: [EMAIL PROTECTED] Subject: Key Buffer Size Hi, Can somebody tell me whether this is good or bad: Our mysql server has key_b

Help optimising a query

2004-01-08 Thread Al
Hi all. Im looking for some help to speed up some queries I have to run. Ill try to briefly describe the setup, but mostly try let my code explain itself. There are three tables described below from a database that describes the execution of a Java program. class_loads records details of each cl

Converting chararacters greater ASCII 122 (não -> nao)

2003-11-05 Thread Al Bogner
Sé Mañana -> Se Manana Ärger -> Aerger a.s.o Could you give me some hints, please? Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Viruses from the list

2003-11-05 Thread Al Bogner
EMAIL PROTECTED])/[EMAIL PROTECTED]) Wake up people, it was time enough to update virus-definitions. Clean your pcs. I will disable my email-adress soon. Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysqldump sorted

2003-11-04 Thread Al Bogner
Is it possible to sort the records, which are created with mysqldump? I didn't find an optioin in man mysqldump. If you cannot do it with mysqldump, what would be the best workaroud for it? into outfile? Al -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Win98 - Work-around to sudden lost connection to database

2003-07-24 Thread Al Caponi
example, restart the Windows and check whether 10055 problem disappeared. There is MS Knowledge Base article which describes the meaning of MSTCP registry entries: http://support.microsoft.com/support/kb/articles/Q158/4/74.ASP My 2 cts worth... I LOVE THIS GUY! HTH, Al. -- MySQL General M

Fulltext search and cumulative relevence?

2003-07-03 Thread Calbazana, Al
Hello, I am interested in utilizing full text search in a way that I have not seen in my run across the various examples and docs. What I'd like to do is create full text indexes on individual columns in order to attain relevancy of the individual search criterion per column. I'd then like to agg

reinstall mysql

2003-06-22 Thread saad al-hajeri
. My Question. 1.How can I remove old mysql. 2.I need clear steps to install it again. Regard Saad al-Hajeri _ Get an email address your friends will never forget... FREE! Become [EMAIL PROTECTED] at

RE: MySQL 3.23.39 shuts down by itself on Win2K

2003-04-02 Thread Al Caponi
Nope. That is not the case here because the connections to the database are autoReconnect=true. > -Original Message- > From: Terrance Win [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 02, 2003 7:42 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: MySQL 3.23.39 shuts d

MySQL 3.23.39 shuts down by itself on Win2K

2003-04-02 Thread Al Caponi
Hi all, (BI've got a java application running with MySQL 3.23.39 on a Win2K server. (BNo other application uses this MySQL server. (BAnd yesterday it just shut down without any reason. This is the second time. (BThe first time was a few months back and I didn't pay attention to it. (BDoes any

problem on installing mysql from mysql-3.23.52-sun-solaris2.8-sparc.tar

2002-11-12 Thread Sultan Salim Humaid AL-Yahyai
7; 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' CXX=gcc Perl: This is perl, version 5.005_03 built for sun4-solaris please help Sultan AL-Yahyai Ministry Of Trasportation and Telecomunicat

Urgent!!

2002-09-29 Thread Ibrahim Al-Tawil
Hi, I have a certain task to be done, which is a Database Driven website based on MySQL operated on Linux, my Question is: Can I develope such a site using ASP (Active Server Pages)? So, I will avoid spending a lot of time in learning other technology instead of ASP. and also if there is specia

Help!! Extreme newbie

2002-09-03 Thread Al Davis
hanged passwords, granted permissions, flushed permissions and yet nothing seems to work... Any suggestions? Thanks, Al Davis AKA extreme mysql/linux newbie - Before posting, please check: http://www.mysql.com/manual.p

Best SQL Statement

2002-05-21 Thread Hayan Al Mamoun
Dear All, I have a table contains airline ticket prices, and I want to get the following data from this table The first 5 records of the lowest price of each airline from each city, and don't want to get a duplicated combination of (airline, city) in this result (even if I didn't see all airlines

Advice for dataupload

2002-04-07 Thread Hayan Al Mamoun
Dear all, I have two design-identical database, one on my intranet, the other on the internet, is there any procedure that Synchronizes the content of two databases? I'm using PHP applications and MySQL Database, WindowsNT4 IIS Please advice Best Regards Hayan -

RE: MySQL Quits in Replication

2002-03-17 Thread Al Johnson
Is anyone else seeing frequent, unexplained restarts of MySQL in a replication (or even standalone) environment? Is this peculiar to NetBSD? Inquiring minds want to know. Al ______ Al Johnson Network Storage Solutions voice 865.675-4070 ext 2 cell 865.604.5869 [

Re: MySQL Quits in Replication

2002-03-14 Thread Al Johnson
. Don't know what you are refering to as the "replication log". There is no binlog for the slave and there are no other logs in the data directory or log directory. Is this something that has to be enabled? Al __

MySQL Quits in Replication

2002-03-13 Thread Al Johnson
? Environment is NetBSD 1.5Y with MySQL 3.23.47 (the latest supported by NetBSD). Al __ Al Johnson Network Storage Solutions voice 865.675-4070 ext 2 cell 865.604.5869 [EMAIL PROTECTED] - Before posting

RE: Inserting strings containing spaces only fails?

2002-03-12 Thread Al Caponi
cters as are needed, plus one byte to record the length. Values are not padded; instead, trailing spaces are removed when values are stored. (This space removal differs from the ANSI SQL specification.) Regards Al > -Original Message- > From: Wout Neirynck [mailto:[EMAIL PROTECT

RE: NULL timestamps not possible?

2002-03-07 Thread Al Caponi
ME.html The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. Regards Al _

RE: encrypt password

2002-03-03 Thread Al Caponi
SELECT with the resulting String. Regards, Al > -Original Message- > From: Manish Mehta [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 2:12 PM > To: mysql > Subject: encrypt password > > > Hi , > > I am working in mysql . with the help of password() f

RE: change column to not null in MySQL

2002-03-03 Thread Al Caponi
. Regards, Al > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 6:00 AM > To: [EMAIL PROTECTED] > Subject: change column to not null in MySQL > > > Is there any way in mysql to change a column that contains data

RE: FULLTEXT error?

2002-02-27 Thread Al Caponi
re problem like these... Regards, Al > -Original Message- > From: Doug Dalton [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 28, 2002 5:02 AM > To: [EMAIL PROTECTED] > Subject: FULLTEXT error? > > > Error > > SQL-query: > > CREATE TABLE

RE: Date Manipulation

2002-02-26 Thread Al Caponi
AFAIK, you'll have to do the conversion before inserting the date into the database because MySQL does not support the MMDD format. Regards, Al > -Original Message- > From: S Aravind [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 26, 2002 5:12 PM > To:

Table Field Size ..

2002-02-12 Thread Hayan Al Mamoun
Hi, I want to ask what difference can be between two MySQL Table CHAR fields the first one's size (In Design) is (10) and the other is (100), but the tow contains the same length of charachters like 3 charachters. Does it effect speed, data size... Please advice Best Regards Hayan -

MySQL.so missing - help!

2002-02-12 Thread AL
Hi I am new to MySQL and PHP, so - please be gentle.. We are running PHP4.0.1 and mysql 9.38 (Distrib 3.22.32) on our development server (Debian Linux). I am trying to setup a database with mysql and PHP. I tried to install phpMyAdmin 2.2.3 and can't access the index page. I get an error abou

MySQL .so missing - help!

2002-02-12 Thread AL
Hi I am new to MySQL and PHP, so - please be gentle.. We are running PHP4.0.1 and mysql 9.38 (Distrib 3.22.32) on our development server (Debian Linux). I am trying to setup a database with mysql and PHP. I tried to install phpMyAdmin 2.2.3 and can't access the index page. I get an error abou

Which is Faster

2002-02-05 Thread Hayan Al Mamoun
Dear all, Which of the following SQL queries is faster and better "select thefield from thetable group by thetable" Or "select distinct thefield from thetable"? and WHY? Best Regards Hayan Get your own "800" number Voicemail, fax, email, and a l

Table Lock

2002-01-28 Thread Hayan Al Mamoun
Hi, Is there a way to lock a table so that only one user can change it and then unlockit? I need to do this coz I want visitors to retrieve some values from a database but each value must be retrieved only by one user and then marked up to be expired, so I don't want two users to retrieve the same

Table Lock

2002-01-28 Thread Hayan Al Mamoun
Hi, Is there a way to lock a table so that only one user can change it and then unlockit? I need to do this coz I want visitors to retrieve some values from a database but each value must be retrieved only by one user and then marked up to be expired, so I don't want two users to retrieve the same

Problem with Load Data InFile

2002-01-27 Thread Hayan Al Mamoun
Dear all, I had a problem with load data infile syntax LOAD DATA INFILE '$file' REPLACE INTO TABLE $table FIELDS TERMINATED BY '|' that the original data has already carriage returns was considered as new records in the database, I solved it by using the following syntax: LOAD DATA INFILE '$file'

Problem with LOAD DATA INFILE

2001-12-31 Thread Hayan Al Mamoun
HI ALL: Happy New Year ;) I have a text file generated from MSAccess database, one of the fields (Long Text) have Carriage returns within the text, So the data of some records falls in more than one line in the text file, when I'm using the SQL statement LOAD DATA INFILE... I have only the fir

RE: Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Al Caponi
> > > > > > > On Dec 10, Al Caponi wrote: > > > > > > > > > > But I keep getting the following error when I try to delete > > some row: > > > > > > > > > > java.sql.SQLException: General error: Incorrect key f

RE: Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Al Caponi
Hi, > > > > > > Hi! > > > > > > On Dec 10, Al Caponi wrote: > > > > > > > > But I keep getting the following error when I try to delete > some row: > > > > > > > > java.sql.SQLException: General error: Incorre

RE: Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Al Caponi
Hi Sergei! Thanks for the reply! That was fast :) > -Original Message- > From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 10, 2001 10:48 PM > To: Al Caponi > Cc: MySQL Mailing List > Subject: Re: Limitation of Full-Text indexing in MyISAM table

Limitation of Full-Text indexing in MyISAM table?

2001-12-10 Thread Al Caponi
or direct me to some resources? (Other than converting all my fields to TEXT :)) Many THANKS!!! Al _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

MySql as an Embedded Java Database

2001-11-03 Thread Al Giacomucci
We are developing an application for commercial distribution using a Java client, JDBC, and an SQL database . It will come in 2 versions - a standalone single-user version that will run on a PC and multi-user version where the database will run on a separate server. For the standalone version we

row security

2001-10-03 Thread Mostafa Al-Mallawani
Hi, I wanted to know if you can allow certain users to edit certain rows. Please, if anyone knows how to do it, then please tell me, thanks.

Access denied

2001-10-01 Thread Sami al flaish
*** NOTICE: This transmission contains information relating to Schlumberger's business activities in Libya. If you are a "United States (U.S.) Person" (i.e., U.S. Citizen; Permanent Resident Alien "green card holder"; emplo

MFC

2001-07-26 Thread Mostafa Al-Mallawani
Hi, I’m new two this list as well, and I was wondering if anyone know how to connect an MFC application to a remote database? It works fine with my local database but when I come to create a file DSN for the remote one using MyODBC, it wouldn’t connect. Any ideas? Thanks.

Build dir vs. execute dir

2001-06-20 Thread Al Begley
the numerous embedded references to where it was originally installed? Thanks - Al - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Mysqld

2001-05-02 Thread Al Green
When I try to run mysqld I get the following message. How do I rebuild the .sock file. It is not where it should be and the one's that are there are 0 bites Any suggestions al -- Al Green Softouch Computer Solutions 2nd Floor 334 53rd Avenue SE Calgary, Alberta, T2H-0N3 Fax: 403-258