Chris Aitken writes:
> Hi all,
>
>
> Just a real quick question about using mysqldump. Should I shutdown mysql
> before running mysqldump, or can I successfully do a mysqldump of my whole
> database while mysql is still running/processing records.
>
>
> I have a very big database, and want t
Hi all,
I want to connect through ODBC Driver Manager(libiodbc-3.0.5) to MySql
Server.
Can you tell me the MySql driver's Name & path of the file so that I can use it
into odbc.ini file ?
I am running Solaris 2.6.
I have install MySql Source distribution in my Home Directory(/u/premc/my
Hi,
I am creating a database for a university project. I say this because
obviously certain things are not done the professional way due to time
constraints.
I've created a database, and entered the data into files. This is done
because the teacher needs to see the files used for data entry.
In the last episode (Nov 17), Troy Bowman said:
> On Sat, 17 Nov 2001, Sinisa Milivojevic wrote:
> > > mysql> CREATE FUNCTION lookup RETURNS STRING SONAME "libudf_example.so";
> > > ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0
>/usr/lib/libudf_example.so: unsupported file t
Sunday, November 18, 2001, 1:26:23 AM, Sergei wrote:
SG> Or you can emulate UNION with temporary table.
SG> CREATE TEMPORARY xxx SELECT ...
SG> INSERT xxx SELECT ...
SG> SELECT xxx ...
I used this solution for a good reason : it seems cleaner than the
1..200 thing
:) Thank you so much !
> I'm looking for a way to download MySQL tables from a
> remote server to MS' Access 97 in my PC.
>
> Many suggested MyODBC.
>
> Although I was originally told othewise by my hosting
> provider, the provider now tells me that UNIX doesn't
> support ODBC.
>
> How can I then do it?
>
1. UNIX does
Can anyone explain to me what these files are for. If they are related to
innodb why don't they go in my specified ibdata directory. I set innodb to
use 4gig's and when i start mysql it creates this file in the specified
location so why does it need to create bin files when i insert rows into my
d
I am curious, what is your reasoning for being a fan of single-table
databases?
The number of columns a table may have depends on the table type you are
using, this should be in the documentation. Your decision to put 20
judges... 3 rounds... 17 categories into a single table probably is (well
al
I'm creating a table, and because i'm a fan of single-table databases, its turning out
to have many colums. (It will have over 1100). Will this be possible? Will this
cause problems? A note: 1020 of the colums will be a numeric value less than 10.
I'm creating a database that keeps track of
Is there a way to download the latest MySQL manual? The only manual I am
able to
download appears to be an outdated version.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
I'm looking for a way to download MySQL tables from a
remote server to MS' Access 97 in my PC.
Many suggested MyODBC.
Although I was originally told othewise by my hosting
provider, the provider now tells me that UNIX doesn't
support ODBC.
How can I then do it?
Thanks!
Anthony F. Rodriguez
I'm not sure, but isn't it supposed to be
"safe_mysqld" (notice the extra "d" at the end).
Not sure, just curious... (^^;;;
Nick
On Sat, 17 Nov 2001 13:12:14 -0800 (PST)
a a <[EMAIL PROTECTED]> wrote:
> Following the instructions in the INSTALL-SOURCE file
> I can get to the last instructio
Actually, when I checked out the link you posted,
I realized that it was the same interface that my
webhosting service uses for their customers' databases.
Pretty nice interface indeed. Might still take some
time to get used to for people accustomed to Access, but
still a lot easier than using
On Sat, 17 Nov 2001, Sinisa Milivojevic wrote:
> > mysql> CREATE FUNCTION lookup RETURNS STRING SONAME "libudf_example.so";
> > ERROR 1126: Can't open shared library 'libudf_example.so' (errno: 0
> > /usr/lib/libudf_example.so: unsupported file type)
>
> Hi!
>
> Please check a type of the above
Hi!
On Nov 18, boris hajduk wrote:
> SG> Correction - this one is wrong, it will list each entry only once.
>
> confirmed :)
>
>
> >> SELECT position1 as position,title WHERE position1 IN ($_) UNION
> >> SELECT position2 as position,title WHERE position2 IN ($_) ORDER BY position;
> SG> This o
On Saturday 17 November 2001 03:20 pm, Mike Wexler wrote:
> >Description:
> MySQL core dumps with the following trace:
>
> 0x807b83f handle_segfault__Fi + 383
> 0x812bdca pthread_sighandler + 154
> 0x80f5e3f _mi_key_cmp + 575
> 0x80f86e0 _mi_seq_search + 200
>
SG> Correction - this one is wrong, it will list each entry only once.
confirmed :)
>> SELECT position1 as position,title WHERE position1 IN ($_) UNION
>> SELECT position2 as position,title WHERE position2 IN ($_) ORDER BY position;
SG> This one is ok.
what about a way that would work with 3.2
Hello,
I am on a RH 7.1 PC, with the following RPM installed:
php-4.0.4pl1-9
php-manual-4.0.4pl1-9
mysql-server-3.23.36-1
MyODBC-2.50.39-1
unixODBC-devel-2.0.7-1
asp2php-0.75.11-1
mysql-3.23.36-1
mysql-devel-3.23.36-1
php-mysql-4.0.4pl1-9
unixODBC-2.0.7-1
unixODBC-generic-2.0.7-1
mysqlclient9-3.
Hi!
On Nov 17, Sergei Golubchik wrote:
> Hi!
>
> On Nov 17, boris hajduk wrote:
> > Saturday, November 17, Bruce Ferrell wrote:
> >
> > BF> SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
> > BF> (1...200);
> >
> > no, i wasn't clear enough, let's try it again.
> >
> >
Hi!
On Nov 17, boris hajduk wrote:
> Saturday, November 17, Bruce Ferrell wrote:
>
> BF> SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
> BF> (1...200);
>
> no, i wasn't clear enough, let's try it again.
>
> the table book contains :
>
> |-- title -|--position1--|
>Description:
MySQL core dumps with the following trace:
0x807b83f handle_segfault__Fi + 383
0x812bdca pthread_sighandler + 154
0x80f5e3f _mi_key_cmp + 575
0x80f86e0 _mi_seq_search + 200
0x8100872 w_search + 194
0x810099b w_search + 491
Saturday, November 17, Bruce Ferrell wrote:
BF> SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
BF> (1...200);
no, i wasn't clear enough, let's try it again.
the table book contains :
|-- title -|--position1--|--position2--|--lots of other fields---
| bravenewworl
florian writes:
> i have to store a dataset of 20 elements. the data is a int(1).
> i would have about 800 000 datasets. now the question is what performs better
> with mysql?
>
> is it better to have 800 000 rows with 21 columns or 160 000 000 rows
> with 3 columns?
That's 16M rows, not 160
Following the instructions in the INSTALL-SOURCE file
I can get to the last instruction -
/usr/local/mysql/bin/safe_mysql --user=mysql &
I get a No such file or directory file, which is
correct, I dont have safe_mysql anywhere on the system
Did I miss a step somewhere?
Running mysql-4.0.0.0-a
How about a query something like this:
SELECT position, title FROM WHERE position1 IN (1...200) OR position2 IN
(1...200);
Caviats:
1.) I don't do this everyday so that query syntax could be all wet
(probably is in fact). You may have to programaticly generate the IN
clauses to make it work.
hi fellow mysql users :)
i'm programming a little application, and i do the following :
for ($i=0 ; $i<200 ; $i++)
{
$result=mysql_query("select $i, title from book where position1=$i \
or position2=$i"); // this query returns only 1 row
$row=mysql_fetch_row($result);
In the last episode (Nov 17), florian said:
> i have to store a dataset of 20 elements. the data is a int(1). i
> would have about 800 000 datasets. now the question is what performs
> better with mysql?
>
> one table like this: or:
>
> mytable mytable
> -
hi!
i have to store a dataset of 20 elements. the data is a int(1).
i would have about 800 000 datasets. now the question is what performs better
with mysql?
one table like this:
mytable
--
someId
element1 int(1)
element2 int(1)
element3 int(1)
element4 int(1)
...
element20
--
Yeah i almost forgot to mention it.you would have
to configure Apache and install php module...well
its an easy step if he wants some easy to use
graphical interfacei work on it..makes
life a lot easier.moreover database can be edited
from other systems also without any has
Bennett Haselton wrote:
> Row sizes in MySQL tables can't exceed 65535 bytes (BLOB and, presumably,
> TEXT fields are not counted towards this total). That means you can't
> defined a table where the *possible* size of a row might be larger than
> that -- e.g. a column of type VARCHAR(255) gets c
Row sizes in MySQL tables can't exceed 65535 bytes (BLOB and, presumably,
TEXT fields are not counted towards this total). That means you can't
defined a table where the *possible* size of a row might be larger than
that -- e.g. a column of type VARCHAR(255) gets counted as taking up 256
byte
>I have downloaded mySQL from your company's website.
>Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that
>means I can create table very easy. just from window screen. I hope get
>your reply.
You can of course run MySQL.exe, the command line tool that comes with
MySQL. You
Hi,
> -Original Message-
> From: Prasad Valmeti [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 17, 2001 4:31 AM
> To: Nguyen Trong Phuc; [EMAIL PROTECTED]
> Subject: java.sql.SQLException: Cannot connect to MySQL server on
> localhost:3306.
>
>
> Thanks for ur response.
> I am s
> -Original Message-
> From: Nick Ooka [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, November 17, 2001 7:06 AM
> To: MySQL-General
> Subject: Re: about MySQL
>
>
> Correction:
> I meant that he can use the ODBC driver with *MySQL*
> to be able to use Access as a MySQL client... :)
> Is th
Hi.
Don't know whether you got any answer yet, but I did not see any.
On Tue, Nov 06, 2001 at 11:01:55AM -, [EMAIL PROTECTED] wrote:
> Hi folks...
> I've been using the + and the - operators to which seem to work fine in 4.0
> but cannot seem to work out what to do with the *. A truncation o
Hi,
Wouldn't you have to set up a web server with PHP support to
use that? I thought he just wanted a simple GUI client...
What's the best thing to use?
Nick
On Sat, 17 Nov 2001 07:11:22 -0800 (PST)
Deepanshu Shukla <[EMAIL PROTECTED]> wrote:
> Hello,
> you can use phpMyAdmin script for contr
Troy Bowman writes:
>
> System: FreeBSD 4.4-STABLE
> MySQL version: 3.23.43
> UDF code: http://www.aros.net/~lump/udf_int_ip.cc
>
> I've been trying to implement my own loadable function for mysql. I needed
> a function which converts a 4-byte integer into an IP address. I wrote a
> UDF for my
Hello,
you can use phpMyAdmin script for controling MySQL. it
works on http and provides you with graphical front
end. have a look at this link.
http://phpmyadmin.sourceforge.net/
Deepanshu
--- Nguyen Trong Phuc <[EMAIL PROTECTED]> wrote:
> hi Yang !
> You have to control MySQL from command pr
Correction:
I meant that he can use the ODBC driver with *MySQL*
to be able to use Access as a MySQL client... :)
Is this true?
Thx.
On Sun, 18 Nov 2001 00:00:49 +0900
Nick Ooka <[EMAIL PROTECTED]> wrote:
> Hi guys,
> Just curious... Can't he use the ODBC driver with
> Access to use MySQL? I t
Hi guys,
Just curious... Can't he use the ODBC driver with
Access to use MySQL? I think it *might* be possible.
Pretty sure I read about it somewhere... Correct
me if I'm wrong.
Thx.
On Sat, 17 Nov 2001 19:13:10 -0800
"Nguyen Trong Phuc" <[EMAIL PROTECTED]> wrote:
> hi Yang !
> You have to co
Hi,
I have been through a similar case. I am working for a large organization, which
had the Human Resources data scattered through seven different Access databases
counting about 200K records.
The challange was not only to migrate them, but also to unify into one armonized
structure.
I made
Hi.
On Tue, Nov 06, 2001 at 12:34:26AM -0700, [EMAIL PROTECTED] wrote:
> In MSSQL I can aggregate various fields like the [totalRev] field listed
> below:
>
> Does anyone know if or how to do this in MySQL?
You can't. You only can do this in the SELECT clause or make a column
that your applicat
Recently, Stephanie Wall from New Riders posted
a message saying that she'd be willing to give
out a few books in exchange for reviews. I was one of
the lucky people who got to review Matthew Stucky's
"MySQL - Building User Interfaces".
Summary: If you already know your way around a
(My)SQL data
Thanks for ur response.
I am sending code also. Earlier it was connected to data base.
I haven't used it sometime. Now i am trying but unable to connect to Data
base.
Please have look and suggest me some solution to solve this problem.
import java.io.*;
import java.sql.*;
import java.util.*;
pu
Hi Valmeti !
it's general error, have too many reason. how about yr source code.
maybe grant access, mm.mysql driver ...
- Original Message -
From: "Prasad Valmeti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, 17 November, 2001 2:49 AM
Subject: hai
Hai All,
I am using
hi Yang !
You have to control MySQL from command promt. MySQL dont have windows
screen.
r u using windows
c:\[mysql dir]>mysqld
-create table
read mysql manual for more detail.
---
Trong Phuc
- Original Message -
From: "Zhou Jiang Yang" <[EMAIL PROTECTED]>
To: <[EM
On 16 Nov 2001, at 16:14, Bill Platt wrote:
> I am wondering if there is any method available to switch this
> Mysql list to digest mode?
>
> ...this list generates tons of
> email everyday.
You'd probably be better off to use the filtering/filing machinery of
your mail client to stick all of
dear Sir/Madam,
I have downloaded mySQL from your company's website.
Is it possible to use mySQL as Microsoft's Access or SQL server7.0? that
means I can create table very easy. just from window screen. I hope get
your reply.
Thanks for you help.
john
--
Hai All,
I am using Mysql, JDBC on LINUX.
I am unable to connect Mysql from JDBC.
I am getting these errors ::
java.net.ConnectException: Connection refused
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doC
Hi,
At 05:35 PM 15/11/2001 -0800, you wrote:
>I'm having a problem sorting records that are used in a left join statement.
>Basically what happens is that any record that is not in table1 doesn't get
>sorted correctly. It first sorts all the records that have valid 'c2'
>records in both table1 an
I don't now ich language you are using to perform this query.
But as mysql does not know any stored procedures, you will have to do it in
code with different call's.
the value of the id (seed in mssql) can be obtained with the SQL function
LAST_INSERT_ID()
a little hint. in your stored procedur
51 matches
Mail list logo
