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
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
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
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 a
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
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
#
Next
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
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 in
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,
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
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
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
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,
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
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
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 percentage from
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
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.
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?
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 fine and
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/
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 empty
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
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 Cobalt
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
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:
Im trying to configure
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:
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
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?
HTML
HEAD
TITLE
Input
/TITLE
/HEAD
BODY
PThese are the people I sell to:/P
TABLE BORDER=10
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
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 =
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 rootuser
If you have your permissions set correctly that should do it. 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 -
From:
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 open
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!
35 matches
Mail list logo