triggering

2002-09-18 Thread Hytham Shehab

hi guys,
is it possible to write triggers and procedures in mysql?


thx
sql
--
Hytham Shehab


-
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




hebrew/arabic language

2002-07-25 Thread Hytham Shehab

hi guys,
 am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
 characters of language such as hebrew/arabic?

 thanks for help

 sql
 --
 Hytham Shehab


-
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




hebrew/arabic language

2002-07-24 Thread Hytham Shehab

hi guys,
am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
characters of language such as hebrew/arabic?

thanks for help

sql
--
Hytham Shehab




-
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




Re: innodb is disabled, how can i make it yes?

2002-07-03 Thread Hytham Shehab

 at last,
 i got an error 5 'Access Denied', then after some blah,blah, etc, etc,
 it got started with InnoDB.
 not InnoDB is yes.
 
now i can write a good SQL QUERY ;)
 special thanks to Heikki and Bert
 --
 Hytham Shehab



-
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




innodb is disabled, how can i make it yes?

2002-07-02 Thread Hytham Shehab

hi guys,
i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and
c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be :
innodb_data_file_path=c:/mysql/data/ibdata:300M
then, when i restart the server and start the client, i type:
show variables like have_%;
---
variable_name  |   value
---
have_bdb|  yes
have_innodb| disabled
have_openssl   | no
...
---

why the innodb is disabled ?

thanks in advance
sql
--
Hytham Shehab


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002


-
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




Fw: innodb is disabled, how can i make it yes?

2002-07-02 Thread Hytham Shehab


 hi guys,
 i use mysql 3.23.44-max-nt server, i edit c:\windows\my.ini and
 c:\my.cnf and c:\mysql\data\my.cnf to include the manadatorey line to be :
 innodb_data_file_path=c:/mysql/data/ibdata:300M
 then, when i restart the server and start the client, i type:
 show variables like have_%;
 ---
 variable_name  |   value
 ---
 have_bdb|  yes
 have_innodb| disabled
 have_openssl   | no
 ...
 ---

 why the innodb is disabled ?

 thanks in advance
 sql
 --
 Hytham Shehab


 ---
 Outgoing mail is certified Virus Free.
 Checked by AVG anti-virus system (http://www.grisoft.com).
 Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002


-
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




Re: innodb is disabled, how can i make it yes?

2002-07-02 Thread Hytham Shehab

hi Paul:
 
 Make sure it's not being started with --skip-innodb.
 
i am sure that the --skip-innodb is not in any of my configuration files.

sql
--
Hytham Shehab


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002


-
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




Re: innodb is disabled, how can i make it yes?

2002-07-02 Thread Hytham Shehab

hi Heikki,
i do what u said:
 yourpathtomysqlbindir mysqld-max-nt --console
cannot initialize innodb as 'innodb_data_file_path' is not set
...
i sword in god that i have set this data file path as:
innodb_data_file_path=c:/mysql/data/ibdata:300M
and this is a valid directory, and some times i get another error message:
os error number 123 in a file operation ???!!!

thanks

--
Hytham Shehab


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002


-
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




Re: innodb is disabled, how can i make it yes?

2002-07-02 Thread Hytham Shehab

 hi Heikki,
 i do what u said:
  yourpathtomysqlbindir mysqld-max-nt --console
 cannot initialize innodb as 'innodb_data_file_path' is not set
 ...
 i sword in god that i have set this data file path as:
 innodb_data_file_path=c:/mysql/data/ibdata:300M
 and this is a valid directory, and some times i get another error message:
 os error number 123 in a file operation ???!!!
 
 thanks
 
 --
 Hytham Shehab



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2005


-
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




innodb @ windows xp

2002-07-01 Thread Hytham Shehab

hi guys,
i have installed mysql v 3.23.44-nt on my XP using *Binary*
distribution, how can i now develop an InnoDB tables?

thanks very much
sql
--
Hytham Shehab


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/2002


-
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




Fw: insert BLOB values

2002-06-22 Thread Hytham Shehab


- Original Message -
From: Hytham Shehab [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 12:15 AM
Subject: Fw: insert BLOB values



 - Original Message -
 From: Hytham Shehab [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, June 21, 1999 11:06 PM
 Subject: insert BLOB values


  hi all of you,
  i have a column of type blob, that i wish to store images in it, but
 how
  can i right the sql statement to insert the image?
  i mean :
  insert into tblImages set imageField = ??? where id=999
 
  now what the ??? should be ?
 
  thx guys.
 
  --
  Hytham Shehab
 
 



-
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




Arabic Support

2002-04-01 Thread Hytham Shehab

hi guys,
how can i use arabic language in the mysql tables data, my data in the
table looks like Extended Ascii, and it is re-interpreted in windows
programs - as MySQLMaker - into arabic, how can i let MySQL itself
understand arabic?

thx
--
Hytham Shehab


-
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