Hi ,
Does mysql support urf-8 ? It is a good question.
Most of the online , even references say mysql does not support utf-8.
But , I have tried this , i am able to insert and get back data with utf-8
format.
Many Utilities , like mysqldump properly extract data in utf-8. Simalarly
mysql ( c
Hi,
I tried to insert some large objects into mysql databse with mysql++. But
the problem aborted after only inserting one large object and there is
always a segmentation fault. Anybody met such problems before? And any
suggestion?
Thanks!
In the last episode (Jun 08), Shoshi & Iphtach Cohen said:
> Hi experts,
>
> I appreciate if you could tell me how many MySQL tables we can open in
> parallel.
>From a client's point of view? Unlimited. Internally, mysql will only
open "table_cache" number of tables at once. If the number of
For the code you posted
> mysql_connect("localhost", "kryste", "***");
> $result = mysql(mydatabase, "select * from Bidder");
> $num = mysql_numrows($result);
> $i = 0;
Try $num = mysql_num_rows($result);
Mike
- Original Message
Oscar,
The file will not get created anywhere until you successfully start
the daemon. Go to the installation and look for the bin subdirectory
and to to that sudirectory and use the command:
./mysqld_safe --user &
If you have your permissions set correctly that should do it. Of course
if
Well, for starters, if you are trying to put data into the database, your
query should use INSERT ... not SELECT.
Here's a snippet from one of my scripts ...
$query_insert="INSERT INTO tablename (column1, column2, textdata) VALUE
('$column1','$column2','$textdata')";
if (!($result_insert = mysq
10, 000 files open at the same time...maybe the OS itself is getting
flustered, you want to make sure that your OS can handle it, on *nix, u can
do a
ulimit -a and see the open files parameter
Beyond that, the system level limit on Linux can be found as
cat /proc/sys/fs/file-max
- Original Me
How do I take input off of web page text boxes and put them on MYSQL
database. This is the page's script. I also named the file Input.phtml.
I'm very new to this... what am I doing wrong?
Input
These are the people I sell to:
n";
echo "n";
Hi experts,
I appreciate if you could tell me how many MySQL tables we can open in
parallel.
In our application (BuildaGate Suite Technology) which is based on PHP &
MySQL, there are strange situations of data loss, and we are looking for
information on what are the limitations of an MySQL datab
JR wrote:
> To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
> I do not believe that mysql will read the foxpro db format. Dump your
> foxpro table data into a text file and use mysqlimport to pull the data
> into your mysql table. See:
> http://www.mysql.com/doc/m/y/mysq
Oscar Mena wrote:
> is not in /etc
> how do I put that soft link?
>
> - Original Message -
> From: "adam" <[EMAIL PROTECTED]>
> To: "Oscar Mena" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Saturday, June 08, 2002 1:47 PM
> Subject: Re: mysql.sock
>
>
>
>>Oscar Mena wrote:
>>
I don't know if this is more of a PHP thing or a MySQL user issue that I'm
having trouble with.
I have this code:
/* Connecting, selecting database */
$link = mysql_connect()
or die("Could not connect:" . mysql_error());
mysql_select_db("my_database") or die("Could not select dat
is not in /etc
how do I put that soft link?
- Original Message -
From: "adam" <[EMAIL PROTECTED]>
To: "Oscar Mena" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, June 08, 2002 1:47 PM
Subject: Re: mysql.sock
> Oscar Mena wrote:
> > Im trying to configure MySQL on a RaQ Coba
The question is kind of *generic*. You can create tables and how u want to
query them will not make a diff during creation. So, what exactly are you
trying to do?
You r probably trying to just grab info out of two different tables. If so,
that does not *require* a join. If that is not what u r
Oscar Mena wrote:
> Im trying to configure MySQL on a RaQ Cobalt
> everything seems fine
> but then I type ./mysql -u root -p
> and type my pass
> and I get ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock'
> (111)
>
> I took a look at mysql.sock and that file is
Hi,
This may be a stupid question how do you create a database with join tables
in mysql?
Chuck Payne
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
On 9/6/02 at 02:32, [EMAIL PROTECTED] (Tom Harris) wrote:
> Dear All,
>
> I am new to the mailing list so I apologise in advance if I am posting
> to
> the wrong place. Please direct me if I am wrong.
>
> With Mac OS 10.1.5:
>
> Configuring like this was okay:
[...]
> Then issuing "make" went
Im trying to configure MySQL on a RaQ Cobalt
everything seems fine
but then I type ./mysql -u root -p
and type my pass
and I get ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
(111)
I took a look at mysql.sock and that file is empty
any ideas how to fix that?
Egor,
Could you let me know when 4.1 will be release ?
I'm building a website and want to decide whether I can use mySQL
instead of SQL Server or not?
The most important factor is support of Unicode.
I also want to know if I can convert an access database or SQL Server
2000 database to mySQL.
Dear All,
I am new to the mailing list so I apologise in advance if I am posting to
the wrong place. Please direct me if I am wrong.
With Mac OS 10.1.5:
Configuring like this was okay:
./configure --prefix=/user/local/mysql
--with-unix-socket-path=/usr/local/mysql/run/mysql_socket
--with-mysql
Victoria Reznichenko writes:
> Hi!
> Sinisa, i tested the following example on 4.0.1 and got the same
> result. If I don't use ORDER BY in the SELECT statement all worked
> fine:
>
> mysql> SELECT u.gender AS gender, count(DISTINCT u.id) AS dist_count,
>(count(DISTINCT u.id)/5*100) AS percentag
On Sat, 8 Jun 2002, Charlie Thunderberg wrote:
Hi.
:I'd like to find out how I could convince mysql to generate warnings
:whenever the data I want to insert is modified by the server.
I believe there's no built-in way of doing that.
I keep a checksum of a data stored. And when i want to write
Hi All,
I'd like to find out how I could convince mysql to generate warnings
whenever the data I want to insert is modified by the server.
E.G. CREATE TABLE test (value real);
INSERT INTO test VALUES ('a1');
I am programming in JAVA using JDBC.
Thanks for any answers!
Charlie
_
In MySql execute the GRANT command to give the necessary permissions to
user@nthost, something like as follows (change the command per your needs,
for different options, look up documentation on mysql.com )
GRANT all on *.* to 'username'@'hostname' identified by 'password'.
You can use IP too, ins
To setup your table see: http://www.mysql.com/doc/C/R/CREATE_TABLE.html
I do not believe that mysql will read the foxpro db format. Dump your
foxpro table data into a text file and use mysqlimport to pull the data
into your mysql table. See:
http://www.mysql.com/doc/m/y/mysqlimport.html
As far a
Our internet provider is starting to host database services. I am the
webmaster of our local church and we have a library of 1000 books, tapes,
etc. in a small Foxpro database.
I need a script to create a MySQL table with the following character
fields:
field length
section 28
autho
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Dion,
Let me repeat back to you the question that I heard you asking:
Can I load a text-file representation of a big, flat, single-table
unnormalized mess into a nicely normalized multi-table MySQL database all
in one fell swoop?
The answer I thought I heard from Bhavinder(?) Vyas was No, you
Hello.
On Sat 2002-06-08 at 11:00:43 +0200, [EMAIL PROTECTED] wrote:
> What would be the best way to store PGP keys for optimal queries in MySQL
> (using search / indexes on the columns)
>
> text / blob??
No storage difference. TEXT/BLOB differ in whether they treat the data
case-sensitive
Hi.
As far as I can see is that you use a condition in your WHERE clause
which MySQL will not (yet?) use indexes for. See
http://www.mysql.com/doc/M/y/MySQL_indexes.html
(seems to be mainly about MyISAM tables)
to see how indexes are used. You use "IS NOT NULL". This page states
nowhere th
Hi.
On Sat 2002-06-08 at 00:58:16 -0400, [EMAIL PROTECTED] wrote:
> First, thanks for your response.
>
> I don't have the error message in front of me, but it's something like:
>
> # myisamchk -r table
> Data rows: 56,402
> Attempting to fix records: 0/0 something something
> Data rows: 0
> #
Hi Chris,
On Sat, Jun 08, 2002 at 11:44:43AM +0200, Chris Knipe wrote:
> Not to long ago, I had a query regarding the best way to store IP addresses
> in a DB, and make sure that they are unique.
>
> It was pointed out to me that I could use four smallint columns instead of a
> varchar to store
Chris Knipe wrote :
>
> Hi again,
>
> Not to long ago, I had a query regarding the best way to store IP addresses
> in a DB, and make sure that they are unique.
>
> It was pointed out to me that I could use four smallint columns instead of a
> varchar to store these numbers, and just implement
Hi again,
Not to long ago, I had a query regarding the best way to store IP addresses
in a DB, and make sure that they are unique.
It was pointed out to me that I could use four smallint columns instead of a
varchar to store these numbers, and just implement a UNIQUE index across all
four column
What would be the best way to store PGP keys for optimal queries in MySQL
(using search / indexes on the columns)
text / blob??
Also, for a PHP & Perl based series of applications, would it be better to
store / validate / compare these values in a database, or should it be
better managing th
Dear there,
I'm Subhash from Bangalore(India).
Can we retrieve the data stored in mySQL database installed on
Linux platform using VB forms installed on WIN-NT. If so
how?
Kindly help me about this in the earliest.
I've also installed the required odbc drivers (MYODBC 3.51) for
Window
36 matches
Mail list logo
