MYSQL :: How To Add MYSQL Support

PHP Support For MySQL
I am trying to configure PHP for the MySQL support. I am using redhat
8.0 with 2.4.18-14 kernel

[root@Server script]# uname -a
Linux Server 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux

MySQL was installed from the source in /usr/local/mysql/ directory and
the version is 4.1.8
[root@Server script]# /usr/local/mysql/bin/mysqladmin -V
/usr/local/mysql/bin/mysqladmin Ver 8.41 Distrib 4.1.8, for pc-linux
on i686

PHP was installed with OS and the version is
[root@Server script]# rpm -qa | grep php
php-4.2.2-8.0.5
php-imap-4.2.2-8.0.5
php-ldap-4.2.2-8.0.5

Now I want to configure PHP to support MySQL. There are some rpm in the
net for this, but these rpm cannot find mysql. I also tried to
uninstall PHP and install a new version of PHP from source. But PHP has
some dependencies.

Mysql Support OO?
Does mysql provide object oriented functionalities?

MySQL SSL Support
I am working under Microsoft Windows and I require a MySQL server with SSL support. I am running MySQL 5.0.6-beta-nt... my question is: how can I find out if my MySQL server supports SSL?

Somewhere I read that I have to compile it from source with SSL support... and on Windows that is almost impossible.

Mysql Support
if mysql4.1
support: sub-selects,
timestamp with timezones and sequences.

I think that sub-selects is supported.

PHP, MySQL And Arabic Support
I wonder if you could help me with this problem.

I want to store and search Arabic text in MySQL database. I am running MySQL 4.1. and the collation is set to "cp1256_general_ci" for database, tabel and column.

Now, in PhpMyAdmin, if I run the following sql, it works:

Mysql Trigger Support
I would like to know if the following trigger functionality is supported in mySql v4 ?

i) I have one table called organisation, with lots of children tables. When a user
updates one of the children tables, I would like to UPDATE a column in table Organisation, i.e. Organisation.Lastupdate. Is this available in the latest version i.e. 4.*

ii) I would like to delete some child rows, if a row in the parent table is deleted. I can not for historical, schema definition reasons, use a cascade delete constraint.

Can MySQL Support UTF-8 Character Set
I am developing an web application which needs to support all kinds of
languages, like english, european character set, and other asian
character set. Therefore, UTF-8 can include all those characters.
But I am using MySQL4 as my application back-end database. MySQL4
doesn't support UTF-8 character set. How can I do it? Is there any
possible way that MqSQL can support UTF-8?

Does Mysql 3.23.51 Support Sub Queries?
the following:

SELECT customerNo AS Count FROM Customers WHERE customerNo = (SELECT MAX(customerNo ) FROM Customers );

gives:

ERROR 1064 : You have an error in your SQL syntax near '(SELECT MAX(customerNo ) FROM Customers )' at line 1

any ideas or alternatives to the above method? it works fine on mysql 5.0

How Many Database Does MySQL Support?
How many database does MySQL Support?

PHP MySQL And Arabic Support
I want to store and search Arabic text in MySQL database. I am running MySQL 4.1. and the collation is set to "cp1256_general_ci" for database, tabel and column. Now, in PhpMyAdmin, if I run the following sql, it works:

SELECT * FROM Arabic where t1='????'

However, I am also running this SQL in a PHP file, like:

<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());  }

mysql_select_db("ArabicTest", $con);

$result = mysql_query("SELECT * FROM Arabic where t1='????'") or die(mysql_error());

while($row = mysql_fetch_array($result))
  {
  echo $row['t1'];
  echo "<br />";
  echo $row['t2'];
  echo "<br />";
  } ?>

However, when I try to run the above sql from a php file, I get the following error:

Illegal mix of collations (cp1256_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' How can I solve this problem.

Records MySQL Support
i'm doing my research on mysql. but i can't find how many records in 1 table mysql database can handle??

PHP5 And MySQL Support
I am trying to compile apache2 with PHP5 with MySQL support. I run the configure command and everything run OK. I then run make then make install and i get no errors. However when i go to look at the phpinfo page -- with-mysql is not in the configure command and mysql sites are not working properly.

MySQL Support Inheritance
Does MySQL support inheritance?
i.e. I have Teacher, Student, etc. and they all inherit from Person because they share common attributes (name, address, etc).
I believe MySQL is not Object Orientated so it probably wont.
If so, how would I implement this in MySQL (I've been doing it with Oracle in the past and want to change over to MySQL)? Any
websites out there to show you?

Problems With Cyrillic Support On MySQL
I'm trying to insert cyrillic characters in my database but when I do select statement it lists the character as tons of question marks ??????
I'm using phpMyAdmin and my database and table collation are set to utf8_unicode_ci
Is there anything else that I need to set it, I'm I missing something?

Does MySql Support Oracle-like Ref Cursors?
Does anybody know if MySQL supports the ability for a stored procedure to return a "ref cursor" (Oracle term)?

Here is an example of an Oracle procedure that returns a ref cursor:

PROCEDURE my_proc
(a_out_cursor OUT ref cursor)
IS
BEGIN
open a_out_cursor for
select col_a, col_b
from my_table;
END;

I am using Java, so I would call this procedure as follows:

CallableStatement statement = null;
Connection connection = getConnection(); //returns a java.sql.Connection

//Use factory to get statement
statement = CallableStatementFactory.getCallableStatement(connection, "call my_proc(?)");

statement.registerOutParameter(1, OracleTypes.CURSOR);

// Execute the procedure
statement.execute();

I would like to perform this same sort of fetching using MySQL instead of Oracle. Does anybody know if it is possible? Or must all CallableStatements be setup as queries and not stored procedures?

Does MySQL 5.x Support Bit Encoded Strings?
Does mysql support storing bit encoded strings as a data type?

so something like this

10101010 can be stored, and is equivalent in size to a one byte datatype?

Does MySQL Support Binary Strings?
I want to have a sort of switchboard system on my database which tells which features are set and which ones are not...

01010110

That would tell you that some features are enabled and some are not. However when it comes down to storing the value I have two options...

1) Store it as a CHAR(8) value, and then fetch it without decoding it. Simply have a server side code use number.charAt(i) to determine the bit value.

2) Store it as a Decimal (Base10: 0-255) number and then have server side scripts covert it to base2 (binary). Then from there it will take the process that step one takes...

Both these solutions work well, But I would really like to have something in the middle. Say storing a base10 number (already decoded into base 2) but stores as a binary string. Is that possible?

How To Know If The Mysql Server Support Utf8?
how to know if the mysql server support utf8?

and how to know the default charset of the server?
(I have a normal use account)

Does Mysql Support Recursive Queries?
Does mysql support recursive queries?

MySQL Doesn't Yet Support LIMIT & IN/ALL/ANY/SOME Subquer
I try to make Query like this:

SELECT * FROM TABLE2 WHERE TABLE1ID IN (SELECT id FROM TABLE1 ORDER BY id ASC LIMIT 10);

But I get answer: ERROR 1235 (42000): This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

So my guestion is: How I can make same query but with the different way?

Does MySQL Support Oracle-like Ref Cursors??
Does anybody know if MySQL supports the ability for a stored procedure to return a "ref cursor" (Oracle term)?

Here is an example of an Oracle procedure that returns a ref cursor:

PROCEDURE my_proc
(a_out_cursor OUT ref cursor)
IS
BEGIN
open a_out_cursor for
select col_a, col_b
from my_table;
END;

I am using Java, so I would call this procedure as follows:

CallableStatement statement = null;
Connection connection = getConnection(); //returns a java.sql.Connection

//Use factory to get statement
statement = CallableStatementFactory.getCallableStatement(connection, "call my_proc(?)");

statement.registerOutParameter(1, OracleTypes.CURSOR);

// Execute the procedure
statement.execute();

I would like to perform this same sort of fetching using MySQL instead of Oracle. Does anybody know if it is possible? Or must all CallableStatements be setup as queries and not stored procedures?

Does MySQL Support GUID And UUID?
Does MySQL support GUID and UUID column types?

Install MySQL With Support For UTF-8 Unicode
How do I install MySQL on a Windows PC so that it will support characters that conform to UTF-8 Unicode.

Mysql Community Version Support GUI?
does mysql community version support GUI?

MySQL C API Vector Binding Support?
I have a "slight" problem with the mySQL C API. I want to bind vectors
for output/input prepared statements. However, the C API does NOT
support such data binding. Is there ANY other way to do a
bulk-INSERT/DELETE/UPDATE or bulk-SELECT in mySQL C API? I mean, one
can do it with a loop, but obiously the goal is to have a higher
performance.I tried it with a plain-old loop, but it is still slow.
Oracle supports such feature and it is considerably faster than the
usual loop-Insert (appr. 100 times faster for big queries) ! ! !

MySQL Support Cyclic Relationships
does mySQL support cyclic relationships?
E.g. a relationships between Personnel.EmployeeID and Personnel.Manager?

(is this even called cyclic relationships?)

I got a few errors and are not quite sure whether it's due to a table relationship referencing onto itself.

MySQL Support Unavailable When Installing PHP-Nuke
I have mysql and php installed on Windows XP with IIS is configured. I am installing PHP-Nuke and receiving a "MySQL support - Unavailable" flag.

Does MySQL Support Constraints On Attribute Level?
I was wondering if its possible to add a constraint on attribute level.
Something like:

"Create integrity on TABLE is ATTRIBUTE in (0..9);"

meaning Table.Attribute can only be a value between 0 and 9

MySQL 3.23.58 Under Fedora Quad Processor Support...
I'm running MySQL 3.23.58 with my 3.7 version of Ensim Pro for Fedora. I have quite a few busy websites that use the MySQL server, and noticed that my version of MySQL only runs one instance and uses 99% of the CPU that it's running on at peak times and only on one CPU with one instance.

I would like to get several instances of MySQL running, like my apache does for PHP pages in module mode. Is it possible?

I've tried adding the "thread_concurrency" setting to my my.cnf but after that MySQL fails to start.

Does MySQL Support VIEWS, Stored Procedures?
Two questions:

(1) Does MySQL support VIEWS?
(2) Does MySQL support STORED PROCEDURES?

Does MYSQL Support Transactions Like Rollback And Commit Now?
Does MYSQL support transactions like rollback and commit now? How about
stored procedures and subqueries?

Installing Mysql With Openssl Support On Windows
Can anyone point me to a resource which details the process of compiling
mysql server with openssl support on windows using VC++ preferable? If not,
maybe someone has run across this problem and can provide a solution. I have
added HAVE_OPENSSL and HAVE_VIO to the preprocessor definitions and added
the libeay32.lib and ssleay32.lib to the library modules settings. It
compiles fine until it gets to mysqld. Code:

Is Mysql Version 4.1.11 Support Store Procedure
is mysql version 4.1.11 support store procedure?

Does MySQL Support A Boolean Data Type?
I ran a search through the mySQL manual and google and could not find a
satisfactory answer. Does mySQL support the declaration of a boolean
data type? Currently I am using VARCHAR(6)s with either 'TRUE' or
'FALSE' and would like to cut down on the storage.

Does MySQL Support User-defined Data Types?
My group is in the process of migrating our Interbase databases to MySQL. We have numerous SQL scripts that use Interbase's CREATE DOMAIN statement (essentially creating user-defined data types) such as:

CREATE DOMAIN PRIMARY_KEY AS INTEGER;
CREATE DOMAIN FOREIGN_KEY AS INTEGER;
CREATE DOMAIN USERNAME AS VARCHAR(20) DEFAULT USER;
CREATE DOMAIN WHEN_ENTERED AS TIMESTAMP DEFAULT 'now';
CREATE DOMAIN WHEN_MODIFIED AS TIMESTAMP DEFAULT 'now';

CREATE DOMAIN NAME_TYPE AS VARCHAR(50);
CREATE DOMAIN FULL_NAME_TYPE AS VARCHAR(101);
CREATE DOMAIN DATE_TYPE AS CHAR(8);
CREATE DOMAIN TIME_TYPE AS VARCHAR(20);
CREATE DOMAIN COMMENT_TYPE AS VARCHAR(250);

CREATE DOMAIN YES_NO AS CHAR(1) CHECK (VALUE IN ('Y', 'N'));
CREATE DOMAIN TRUE_FALSE AS CHAR(1) CHECK (VALUE IN ('T', 'F'));

I've searched the manual and couldn't find an MySQL equivalent, but it is a large book and I certainly could have missed it. I know we could just do a lot of replacing text and there are workarounds, but my boss wants to keep the original scripts as intact as possible and she asked me to look into this.

Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client In
I have recently upgraded to MySQL 5. Got this error message in my IE Browser. Have read some of the comments on other forums and my choices are: Upgrade all client programs to use a 4.1.1 or newer client library, or

SET PASSWORD FOR
-> 'some_user'@'some_host' = OLD_PASSWORD('newpwd')

Can someone please advise?

Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
Basically I am setting up php,mysql and apache to run an application. While trying to connect I get the following error:

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:sudhirapachehtdocssvgmap est4.php on line 14
Cannot connect to the database.
Client does not support authentication protocol requested by server; consider upgrading MySQL client
I have tried the following message posted earlier by many of you guys i.e
"SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something')
flush privileges

I am trying this from a long time and do not find a way to fix this problem
I request you guys to help me in soughting this out and I appreciate your patience in reading my post.

Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error.

Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?

Does Mysql Support Referencing Files In *.sql Script Files ?
does mysql support referencing to other files inside a .sql file ? for example to include several files into one file for sak of simplicity ?

Utf8 Support
I would like to know the status of the UTF8 support in MySQL 4.1.

I tried to create a table using utf8 charset, and inserting hebrew text
into it. it seems like it still treats this text as binary - for example
the length() function returns 8 on 4 chars string, or when cretting a
column using varchar(4) i can only insert 2 letters to it.

So few questions:
1. Do you plan to support utf8 at this level, with all the string
functions working properly with utf8 (my first impression was that thats
what "utf8 support" is..).

2. What about fulltext search on UTF8 strings?
3. Is there any target date for releasing a stable version of 4.1?

Ipv6 Support
i would like know about mysql's ipv6 support, i installed mysql 5.0.19 from a source dist and no configuration option is provided to enable ipv6.

XML Support In The Future?
I am quite new to MySQL & I have been looking for an XML database solution. I recently checked out the Berkeley DB XML specs, and noticed that the BDB engine is (or was) an optional part of MySQL - apparently used to support transactional capability.

My questions are these:
1. Is the BDB still used in current releases of MySQL for transactional support?

2. Has anyone heard of the addition of XML support to MySQL using the new Berkeley XML APIs to this engine?

Utf8 Support
I would like to know the status of the UTF8 support in MySQL 4.1.

I tried to create a table using utf8 charset, and inserting hebrew text
into it. it seems like it still treats this text as binary - for example
the length() function returns 8 on 4 chars string, or when cretting a
column using varchar(4) i can only insert 2 letters to it.

So few questions:

1. Do you plan to support utf8 at this level, with all the string
functions working properly with utf8 (my first impression was that thats
what "utf8 support" is..).

2. What about fulltext search on UTF8 strings?

3. Is there any target date for releasing a stable version of 4.1?

ODBC Not Support Utf?
my host only gives me ODBC connection to MySQL. i need the table to store some chinese characters and display them to the ASP.NET form. when i tested MySql connector on my dev machine, i added CHARSET=utf8 to the connection string and set the column charset to utf8 and it worked well. i did the same thing while using ODBC 3.51 Driver but all i saw was ????. am i missing anything or ODBC 3.51 Driver simply doesn't support utf?

Ssl Support In MAX Binaries?
Is ssl support provided in the MAX mysql binary distribution. The website lists some of the features provided in MAX that are not provided in the Standard binary. However, the website does not list the full list of features that are supported in the MAX but not in the Standard.

Sub Select Support
does any version of mysql support sub select
for example

for example

select deptno, ename, sal
from emp x
where sal > (select avg(sal)
from emp
where x.deptno = deptno)
order by deptno

if yes then tell me the version.

Mysql's Support
I’m currently administering a small web-based application overseas which uses MySQL 5.0 as its database and running on Windows server OS.
The host computer’s date and time settings have been configured according to the country’s time zone where it is currently hosted and now observing daylight savings time.
My concern is that when the daylight savings time ends and moves back to standard time, will MySQL able to make the necessary changes in the time stamp of the data saved?
I’m just worried that the transition (back to standard time) will overwrite all the data that were saved during the last hour of the daylight savings time.
The application uses the data type DATETIME for storing the date and time stamp of the data being stored and the function NOW() in retrieving the host computer’s current date & time.

Support Authentication
i have installed php4.4 with iis and mysql5 and phpmyadmin is 2.5 version and mysql administration tool too i get the error client does not support authentication protocol,
i will be very pleased if someone suggest a good workin version for all mysql php and phpmyadmin

How To Add MYSQL Support

i want to enable MySQL support in localhost. I am using Apache web server and PHP but i dont know how to enable MySQL support.