Hi group,
Does anyone know of a simple way of knowing the real size of a column.
Currently I am interested in knowing the size of data stored in a BLOB column.
I have tried BIT_LENGTH() but this one does not seem to return the real size.
Thanks,
__
NZEYIMANA Emery
Hi!
I am trying to connect MySQL Database to COBOL. I have made it possible to some stages
by the way
as follows; I have developed this under;
Client: Microsoft Windows 2000 Service pack 4.
CA-Realia COBOL Compiler Version 6.0.45
Microsoft (R) Incremental Linker Version 6.00.8168
MySQL server 4.
Does anyone know how the open source database rank in terms of deployments
and users worldwide? I saw something today
(http://story.news.yahoo.com/news?tmpl=story&u=/cmp/20040106/tc_cmp/17200310
) that had SQLServer at 1, Access at 2, and MySQL at three, with no mention
of PostgreSQL. Seems to be f
. In absence of this kind of technique I was struggling with the idea of
multiple "SELECT FROM's" within a single "INSERT" (is that even possible?)
I'm not sure what you mean here.
Will something like this work (with a correction of syntax which is unknown
to me)?
INSERT INTO webpages(autho
. In absence of this kind of technique I was struggling with the idea of
multiple "SELECT FROM's" within a single "INSERT" (is that even possible?)
I'm not sure what you mean here.
Will something like this work (with a correction of syntax which is unknown
to me)?
INSERT INTO webpages(autho
At 21:00 -0800 1/7/04, EP wrote:
Paul DuBois wrote:
By the way, you may want to visit http://www.kitebird.com/mysql-cookbook
and grab a copy of the "recipes" distribution.
In net style led me to:
http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index2.html?page=1
Much appreciated strategy
Paul DuBois wrote:
By the way, you may want to visit http://www.kitebird.com/mysql-cookbook
and grab a copy of the "recipes" distribution.
In net style led me to:
http://www.onlamp.com/pub/a/onlamp/excerpt/mysqlckbk/index2.html?page=1
Much appreciated strategy advice.
Is the Python API menti
At 05:26 8/1/2004 +0100, Morten Gulbrandsen wrote:
Hi,
I wasn't able to repeat:
Microsoft Windows XP [versão 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
c:\>cd\mysql\bin
C:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to
MySQL 5.0.0-alpha-max-nt under win2k
a small problem:
If I have a foreign key with reference to the same table,
I get an error,
ERROR 1146 (42S02): Table 'mysql.proc' doesn't exist
what can I do ?
Yours Sincerely
Morten Gulbrandsen
USE test;
DROP TABL
Greetings, I am wandering under what circumstances it is sensible/beneficial
to use multiple databases for a single "project," and why.
The reason I ask is because I am re-developing an existing database with
MySQL that someone else created with another engine (DBISAM) and chose to
have 5 separate
At 22:30 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Paul DuBois wrote:
>> At 20:39 -0500 1/7/04, Asif Iqbal wrote:
>> >-BEGIN PGP SIGNED MESSA
Hi folks,
I'm familar with using myisamchk to check/repair myISAM databases; how do I
do consistency checks and repair operations on an InnoDB database?
Thanks,
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In theory there is no differen
msg.pgp
Description: PGP message
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 31 January 2004 7:57 pm, Kenneth Letendre wrote:
> Hello,
>
>I'm trying to get the difference (in days) between dates stored in two
> date fields.
You should be able to do this with the TO_DAYS() function, e.g.:
SELECT ID, (TO_DAYS(fi
At 21:35 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paul DuBois wrote:
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>Hi All
>
>I have been using mysql database to collect my syslog data. It was
>working fine. H
At 11:25 +0900 1/8/04, Dave G wrote:
Paul,
>(Unix timestamps are ten digits, aren't they?).
No, they're fourteen digits: CCYYMMDDhhmmss
I think we might be talking about different things. A UNIX time stamp is
ten digits long:
http://www.unixtimestamp.com/
How MySQL stores it's own TIMESTAMP col
msg.pgp
Description: PGP message
Paul,
> >(Unix timestamps are ten digits, aren't they?).
> No, they're fourteen digits: CCYYMMDDhhmmss
I think we might be talking about different things. A UNIX time stamp is
ten digits long:
http://www.unixtimestamp.com/
How MySQL stores it's own TIMESTAMP column is the format you describe.
Hi ,
Kindly get the tool (Navicat version 5.1.1 - trial version) in
http://www.mysqlstudio.com. - I'm Using now..
-Aman.
Mike Brickman wrote:
Where can I get navicat-pro? I have downloaded a copy of navicat from
the www.navicat.com but this is a gui and does not seem to have the
functionality
At 9:57 +0900 1/8/04, Dave G wrote:
MySQL Gurus,
Because of time zone differences between my web site's intended
audience (Japan) and my server's location (Nevada), I've found that it's
most efficient, or at least most simple, to do all my time calculations
in PHP.
Up to now, I've s
At 20:39 -0500 1/7/04, Asif Iqbal wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi All
I have been using mysql database to collect my syslog data. It was
working fine. However recently I had few logs that had apotrophe and I
failed to insert those lines into my database. It said syntax erro
At 1:18 +0100 1/8/04, Martin Hampl wrote:
I did.
'show databases;' doesn't work as well. I can choose a database
('use test'), create a table, but I can't either fill the table nor
drop it.
I am not sure which privileges my user has, but it worked with
earlier versions of MySQL and I don't thi
Hello marc,
Look at the URL: www.mysql.com/training/courses/using_and_managing_mysql.html
There are courses coming soon at Boston and another one in Washington DC which I think
is fairly in the Northeast of the US.
Regards,
Bernard
Marc Dver <[EMAIL PROTECTED]> wrote ..
> This might be a bit
msg.pgp
Description: PGP message
This might be a bit of a repeat, but I didn't get too many responses.
Can someone recommend a course in the Northeast of the US that teaches
the details of the use of mysql?
Sincerely,
Marc DVer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Fatal error: Can't open privilege tables: Can't find file:
'./mysql/host.frm' (errno 13) ...
Well, since I failed to use RPM to install MySQL 4.0 over 3.23 -- I am
not sure if I have to unstall the latter before I install the former,
the manual does not mention that, I went ahead to do a fresh bi
MySQL Gurus,
Because of time zone differences between my web site's intended
audience (Japan) and my server's location (Nevada), I've found that it's
most efficient, or at least most simple, to do all my time calculations
in PHP.
Up to now, I've still been storing all my dates in na
I've got the following query:
select oafs.person.*, oafs.biography.*, oafs.address.position1 from
oafs.person
left join
oafs.biography
on
oafs.person.person_id = oafs.biography.person_id
left join
oafs.address
on
oafs.biography.person_id = oafs.address.person_id
where
oafs.address.preferred = '
Sorry, I didn't look closely enough at your two queries. I don't believe that you will
be able to get your desired results from one query. Besides it is usually better to
execute 2 queries that are simplier than one that is very complex.
Robert Rowe
--- Aleksander Wang-Hansen <[EMAIL PROTECTED]
I did.
'show databases;' doesn't work as well. I can choose a database ('use
test'), create a table, but I can't either fill the table nor drop it.
I am not sure which privileges my user has, but it worked with earlier
versions of MySQL and I don't think I'm doing anything differently.
Did any
Exactly.. it's like disk inodes.. So instead of a larger query and the
database having to transmit the big resultset over the network to the
webserver (assuming a multi-tier architecture), using up memory, you break
it down into smaller queries so the webserver keeps asking for chunks as
they are
On 7 Jan 2004, at 22:24, Rob Brahier wrote:
I made an online file manager using PHP and MySQL some years ago, and
am
now embedding something similar into my office's database front-end. I
decided to store our files in the file system rather than the database
in order to keep the DB size low. A
On 7 Jan 2004, at 21:51, [EMAIL PROTECTED] wrote:
This article discusses it briefly:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
That's an interesting article. Thanks. A similar table design to what
I had in mind (hmmm... how different can these things be! :)
I like the idea of splitting
Hi there. I want to know what mysql provides.
I want to start mysql manually so i write
/etc/init.d/mysqld restart
The mysql stops running succesfully but what it's time to start the mysqld i get a
failed message.
I am at loss because i can connect to the database remotely and insest, select
r
Hi,
IIRC, ISAM files are not portable between platforms, but MyISAM ones
are. So I think you'll be fine if they work. :-)
Matt
- Original Message -
From: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 3:39 PM
Subject: ISM/ISD file compatibility fo 64bit myqsl? no?
>
> Are ISM
You're right. The LIKE comparison only works properly with the Latin
letters in utf8. MySQL hasn't yet fixed it to work with the rest of Unicode
yet. I believe there is a valid LIKE comparison for ucs2. From what I
remember, however, it has problems too if you start putting wildcards at the
Did u choose a database before that?
Martin Hampl wrote:
Hi,
I just installed version 4.1.1 on Mac OS X.
If I enter 'show tables;' after starting mysqld_safe it just says
ERROR:
No query specified
The same happens if I try 'CREATE DATABASE menagerie;'
Why?
Thanks,
Martin.
--
MySQL General
Hi,
I just installed version 4.1.1 on Mac OS X.
If I enter 'show tables;' after starting mysqld_safe it just says
ERROR:
No query specified
The same happens if I try 'CREATE DATABASE menagerie;'
Why?
Thanks,
Martin.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
On Wednesday 07 Jan 2004 21:06, Ian O'Rourke wrote:
(B> Original Message -
(B> From: "Steve Folly" <[EMAIL PROTECTED]>
(B>
(B> > At work we are currently investigating ways of filing all our
(B> > electronic documents.
(B>
(B> I don't know the answer, but it's an interesting questio
I made an online file manager using PHP and MySQL some years ago, and am
now embedding something similar into my office's database front-end. I
decided to store our files in the file system rather than the database
in order to keep the DB size low. A benefit of this is it takes less
time to resto
I would have to agree with you. The kinds of applications you mentioned need every
scrap of speed possible. All I was saying is that stored procedure use is a trade off
of flexibility vs. performance. In many applications the flexibility is more important
than the performance gain and that the
Hello and sorry for a dumb question, but this is my third day of experimenting
and surprisingly no luck with archives, so:
Is UTF-8 case insensitive search OK?
set @@character_set_client=utf8;
set @@character_set_server=utf8;
set @@character_set_connection=utf8;
set @@character_set_results=utf8;
This article discusses it briefly:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
I am using this type of design/technology for quite a few clients. Some
storing gigs and gigs of data (images, documents, pdf, anything) over
multiple servers.
The scalability and performance of a well designed
mysqladmin isn't interactive -- it expects a command to process. With
no command, mysqladmin prints a help message then quits. It doesn't
need a password for that.
For example, to tell the mysql server to shut down, you enter
mysqladmin -u root -p shutdown
You should be prompted for the pa
Are ISM/ISD files supposed to be binary compatible from 32bit to 64bit
mysql? both isamchk and the mysqld are segv when trying to use ISM/ISD
files from an i386 v4 mysql install in a x86_64 mysql install.
MYD/MYI appear to work when moved, but now I am concerned about that as
well :)
thanks
--
One solution might be concurrant storage of different versions of the same
file in different blobs. Text-based formats (SGML, rtf, HTML, XHTML, plain
text) can be stored in TEXT columns, while Binary formats (PDF?, GIF/PNG,
Media) can be stored in BLOBs.
A nice side effect of this is being able
I've MySQL-3.23.54a-11 installed and running on RH 9.0 via the RedHat
rpm's. I'm trying to upgrade to MySQL-4.0.17-0 via rpm's from MySQL.com. I
found references from web searches and through the archives from this list
that suggest that it's as easy as:
shell> rpm -Uvh --nodeps MySQL*
but t
May be there is an option on the Commercial Market, BasisPlus from OpenText.
I worked quite a lot with it but, sincerely, I prefer a MySQL table with
references to files on the File System. A lot faster, and cheaper
Now there is true that I use to work with sgml files and I still prefer
them.
Original Message -
From: "Steve Folly" <[EMAIL PROTECTED]>
>
> At work we are currently investigating ways of filing all our
> electronic documents.
I don't know the answer, but it's an interesting question. We are currently
looking at using more and more SQL (we use MySQL now in places),
Hi,
(disclaimer - this thread could easily go off topic; I'm interested
only in the MySQL aspects of what follows...)
At work we are currently investigating ways of filing all our
electronic documents.
There is commercial software that will do this I know, but I was
wondering whether MySQL wo
>Description:
Boolean mode fulltext searching returns zero hits for valid queries.
>How-To-Repeat:
Create a database with a Text column. Add a fulltext index on it.
Try to search for multiple words with AND or phrase syntax.
Here are examples:
mysql> select Notic
Hi, ALL:
I have a question about running MySQL. How to run it in debug mode,
something like gdb so that I can advandce one line or one method at
a time so that I can see a path that a query from a client goes
through all the necessary functions (modules) to the server and back
to it?
Thanks in
Hi ya,
Is it dissolved in the new versions ?
Only three posting so far on that.
I just keep forgetting 1142 and always endup digging the source!! root
as user solves the problem.
--
Aftab Jahan Subedar
CEO/Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhak
Hi!
On Dec 19, Matt W wrote:
> > >
> > > Just have a couple more full-text search inquiries here. :-)
> > >
> > > I'm not exactly clear on how matching rows are found when searching for
> > > 2 or more required words: '+word1 +word2'. I understand that it can't
> > > currently know which word occ
I tried doing this when I first got MySQL installed on the new machine, but when I did
"SHOW DATABASES;" through mysql it was not listed. Is there something I need to do to
let MySQL know that the database is there?
Ryan Sinnwell
Regional IT Engineer
The Weitz Company
515-698-4281
515-229-5517
The fundamental reason for using stored procedures is performance.
Stored procedures are compiled code. This means the database has reviewed the SQL,
came up with the most efficient plan of action (often sorting through thousands of
permutations when multiple table joins are concerned), and (giv
[snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
[/snip]
Sorry, I pulled the send trigger too fast. My bad.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Both mysql and mysqladmin get user info for login purposes from the same
place: the mysql.user table.
Mysql doesn't have a root password set by default after installation.
It's very easy to overlook this and not set a password. One might think
that the user you're logging into mysql with will
Michael:
You were correct. My problem was that I had set a password for mysql
but didn't realize that I had successfully done so (newbie confusion).
I can now create a database. Unfortunately, there is an additional
issue: it appears as though I didn't set a password for mysqladmin (or
I did s
Jay Blanchard wrote:
[snip]
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Please help. Thanks in advance.
[/snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
That's an excellent page to
Ralph McCarthy wrote:
Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a
database. When I try to do so, I get the following error message:
I have the same setup.
mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database 'mydatabase'
Se
[snip]
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)'
Please help. Thanks in advance.
[/snip]
Please RTFM at http://www.mysql.com/doc/en/GRANT.html
--
MySQL General Mailing List
For list archives:
Hi:
I've just installed MySQL on Mac OS X 10.2.8. I'm unable to create a
database. When I try to do so, I get the following error message:
mysql> CREATE DATABASE MYDATABASE;
ERROR 1044: Access denied for user: '@localhost' to database
'mydatabase'
I suspect that the problem may be that I never
We have started using http://www.datahive.ca/ and they've been great and
can't beat the prices.
Travis
EP wrote:
is it just me, or do hosts underestimate how much data we might want
to put in a MySQL database? For instance, 250MB, the largest plan
from that host would not come close to holdi
I have a brand new fresh install of SUSE 9, 64 bit and am trying to
install mysql 64 bit, but I get the following output: I've bolded the
important lines (or at least what i think is important). Has anybody
experienced this?
linux:~ # rpm -i --force MySQL-server-4.0.17-0.x86_64.rpm
warning: M
# [EMAIL PROTECTED] / 2004-01-06 10:57:52 +0200:
> From: "Roman Neuhauser" <[EMAIL PROTECTED]>
> > My first question is: what is the interaction between MySQL's
> > *_buffer_size and InnoDB's innodb_buffer_pool_size?
> > IOW, are *_buffer_size tunables applicable to InnoDB tables? Would I
> > need
Are you wanting to do this in one query? You could put an order by on your second
query. The first row returned by it should be what you are after.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Just copy the database folder to your new server. If they are not corrupt then they
should be accessible from your new server.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We do not allow SSH access to our virtual hosts but we have dedicated
servers starting at $49 per month.
JR
--
RHCE #808003122507415 MySQL #206067847
Ask Me About Top Notch Web Hosting & Programming!
--
"Computers are like air conditioners:
They stop working properly if you open windows."
--
On Wed, Jan 07, 2004 at 08:09:50AM -0600, Chris W wrote:
> I was wondering if anyone could recommend a good web hosting company for
> an Apache - php - MySQL project. I don't need much bandwidth or disk
> space to start out, but may need more if the site gets big. I would
> also like to have s
On Wed, 2004-01-07 at 10:38, [EMAIL PROTECTED] wrote:
> Hi all,
> does anyone know if it's possible to compile MySQL under Linux so that
> mysqld doesn't rely upon LinuxThreads, but makes direct call to fork()
> or clone() system calls instead?
As far as I know and can tell from reading docs, Linu
This'll probably show my ignorance, but can someone explain why this
select uses index on ob_vl_parametry.info_cs when that column is not
used anywhere in the query?
mysql> EXPLAIN SELECT vp.id
-> FROM ob_vl_parametry_zbozi zp, ob_vl_parametry vp,
-> ob_vl_parametry_kategorie vpk
-
Marc, this SP section of the docs did not come with the 5.0 downlaod, thanks
for the url! PB
- Original Message -
From: Mechain Marc
To: Peter Brawley ; [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:09 AM
Subject: RE: MYSQL 5 Stored Procedure
Docu
Hi all,
does anyone know if it's possible to compile MySQL under Linux so that
mysqld doesn't rely upon LinuxThreads, but makes direct call to fork()
or clone() system calls instead?
I'm looking for a way to avoid the exploitation of pthreads under
Linux.
Is this feature provided by MySQL?
Many Tha
Hi,
I am trying to port a postgreSQL database to mysql. I am really not that
familiar with postgreSQL so I need some help. It seems that in postgreSQL
one may defin auto-increment fields called sequences. Typical snippet I
have is this:
=
create sequence service_action_seq;
drop table if
Documentation:
http://www.mysql.com/doc/en/Stored_Procedures.html
Marc.
-Message d'origine-
De : Peter Brawley [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 7 janvier 2004 16:32
À : [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet : Re: MYSQL 5 Stored Procedure
Matthew,
You need to run the s
Sharma and Terry,
I believe MySQL only supplies setup.exe files with the versions that have
production status. However, if you download the appropriate .zip file from
the website, then that will contain all the files that you need. Simply
extract it to the default location (C:\mysql in Windows
Howdy MySQL Subscribers.
I'm hoping some MySQL users more experienced than myself can shed light on
a work-related question that has recently arisen. We have a database with
24 meter tables similar to meter1 below.
mysql> explain meter1;
++--
onsdag 07. januar 2004, 16:42, skrev EP:
> is it just me, or do hosts underestimate how much data we might want to put
> in a MySQL database? For instance, 250MB, the largest plan from that host
> would not come close to holding all my data.
>
> I guess what I'm really curious about: do others con
Using Mysql 4.0.12
I know that 'show warnings' isn't implemented until 4.1.* but is there
something else that I can do to view warnings?
thanks,
craig.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What?!?! That wasn't called for. I am in no way
affiliated with them and do not stand to gain anything
if anyone would choose to host with them. I've worked
with over a dozen ISPs and SonicCommerce is my
favorite. That's it, plain and simple.
-Original Message-
From: Jeremy Weaver
[mailto
On Wed, 2004-01-07 at 07:09, Chris W wrote:
I was wondering if anyone could recommend a good web hosting company for
an Apache - php - MySQL project. I don't need much bandwidth or disk
space to start out, but may need more if the site gets big. I would
also like to have ssh access to the ser
I have downloaded the correct windows zip file, but unlike previous
Windows downloads, this does not include a setup.exe file, but hundreds of
other (source?) files.
Yes, I have RTFM, which merely tells me to extract to a temporary
directory the run the setup.exe file, which is non-existent.
H
is it just me, or do hosts underestimate how much data we might want to put
in a MySQL database? For instance, 250MB, the largest plan from that host
would not come close to holding all my data.
I guess what I'm really curious about: do others construct large (GB)
databases in MySQL? Is there
On Wed, 2004-01-07 at 07:09, Chris W wrote:
> I was wondering if anyone could recommend a good web hosting company for
> an Apache - php - MySQL project. I don't need much bandwidth or disk
> space to start out, but may need more if the site gets big. I would
> also like to have ssh access to
Matthew,
You need to run the script mysql_fix_privilege_tables.sql. It's not included in some
binaries, but it is in 5.0 source archives. Once you run this script, you can execute
Create Procedure ... as a SQL cmd.
How you execute them, though, is not mentioned yet in the docs :-).
PB
- Or
i really love 'em. how often do you hear that about an ISP?
Usually everytime someone is looking for an ISP and an
owner/person-with-something-to-gain happens to sniff out the opportunity.
-J
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January
Title: Problem while installing MySQL
Hi
I am trying to install MySQL for practice on my PC (Windows XP). I have all the administrative rights
I downloaded the zip file mysql-4.1.1a-alpha.zip from the downloads.
I extracted the zip file in a temporary folder.
The manual says run setup.exe for
> Loosing one table [one data file] is less affecting than 10.
> My view is that MySQL is good because it uses different data files. If one
> data file gets corrupt, you will loose less information since it is only
one
> table [meaning one data file] that is affected.
>
> I am not an expert thoug
Loosing one table [one data file] is less affecting than 10.
My view is that MySQL is good because it uses different data files. If one
data file gets corrupt, you will loose less information since it is only one
table [meaning one data file] that is affected.
I am not an expert though!! J
I have a table 'table1' with fields, 'key' and 'number'
There is another table 'table2' with fields 'key1' and 'key2'
'table2.key1' corresponds to 'table1.key'.
Now, I need to find, in one query, the sum of all 'table1.number' fields for
a given 'table2.key2' AND the highest sum of 'table1.number'
I'm using it with PHP, but what I'm looking for is, the query syntax, not
the language feature.
Thanx anyway
- Original Message -
From: "robert_rowe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 9:04 PM
Subject: Re: How to find if the value returned is nu
I have a MySQL installation that went terribly wrong so I changed to a different
server, reset everything up and am up and running again. The problem is, I'm so new
to this I didn't know how to move my databases, and since there wasn't much
information in them (about two weeks worth of posts to
You have to use Load Data Local. See this section of the manual:
http://www.mysql.com/doc/en/LOAD_DATA.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
This is a known bug. You'll have to create a link in
/usr/local/include/openssl. Also, you'll want to use this configure:
$ ./configure --with-openssl
--with-openssl-includes=/usr/local/ssl/include
--with-openssl-libs=/usr/local/ssl/lib --with-vio
Doing --with-openssl=/path/to/openssl seems t
That depends on what language you are using to return the query results. Visual Basic
is an IsNumeric function. I'm sure other languages have something similiar. What are
you using?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
www.soniccommerce.com
They're awesome, all linux, and expect you to grow
over time so they make upgrading your plan simple. i
really love 'em. how often do you hear that about an
ISP?
-dan
-Original Message-
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 8:10 A
The concept of n-tier design is mainly one of flexibility. A proper n-tier design
should allow you to change either the front-end, business logic or back end (database)
with no (or minimal) changing of the other layers. This means that the user interface
(front end) is one layer (local exe, web
I was wondering if anyone could recommend a good web hosting company for
an Apache - php - MySQL project. I don't need much bandwidth or disk
space to start out, but may need more if the site gets big. I would
also like to have ssh access to the server, preferably a linux server.
Chris W
--
Do a search on this list ... this has been covered within the last two weeks
several times.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 5:40 AM
Subject: MYSQL 5 Stored Procedure
> Hello
> I've installed Mysql 5 and have create
1 - 100 of 118 matches
Mail list logo