Hello John,
Friday, June 7, 2002, 1:54:52 AM, you wrote:
JK> Num refers to the text file from which the data is read. It contains the count of
JK> records shown in the Records column, followed by the total number read in to that
point.
JK> The time in seconds to insert these records is under t
On Thu, Jun 06, 2002 at 02:24:06PM -0700, Matt Rowe wrote:
> Dear list,
>
> After doing a good bit of reading, the details are still hazy.
>
> I have a web-based application (about 20 tables, with up to 100,000
> records per table - but most tables are much smaller). 99% of
> "select" queries a
First of all, there are many aspects of your problem.
1. The InnoDB uses transaction safe table types, and uses the log files to
restore if anything goes wrong during the tsanasction. So it is almost
impossible to have a permanent database error, that cannot be repaired by
InnoDB itself. If My
On Thu, Jun 06, 2002 at 10:03:54AM -0400, Dave Swindell wrote:
> What I'd like to do is to set up a mechanism where every week I
> rotate my replication log files and delete (or archive) the ones I
> no longer need. Can anyone point me to some docs where I can learn
> how to do this?
Here's the
Hello [EMAIL PROTECTED],
We have received your request to join the ltsp-id
group hosted by Yahoo! Groups, a free, easy-to-use community service.
This request will expire in 21 days.
TO BECOME A MEMBER OF THE GROUP:
1) Go to the Yahoo! Groups site by clicking on this link:
http://groups
I just installed PHPMyAdmin and it looks terrific. The only thing that it's
missing is a Check Table on the selected tables. People could check to see
if their tables are in good working order or are corrupted. They could
specify what type of Check Table to perform (Quick, Extended etc.) By
Now, that screwed up allot of MUAs!!!
- Original Message -
From: "Joel Rees" <[EMAIL PROTECTED]>
To: "Dvoracek Michal" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 6:17 AM
Subject: Re: to_asci
> Hello to you too.
>
> > i
-
Doesn't this need to be in ld's path? /etc/ld.conf ?
I'm not to sure Not on *nix at the moment, but I believe the proper way
to add it would be through /etc/ld.conf and running ldconfig to update the
paths.
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 706
> > describe CL0420;
> > +--+-+--+-+-+---+
> > | Field| Type| Null | Key | Default | Extra |
> > +--+-+--+-+-+---+
> > | ID | int(11) | YES | | 0 | |
> > | Producer | char(255)
Hello to you too.
> i need function that will convert non-english characters ($Bwzpz\boq
(B
> to english.
What were those? Can you give us some idea what the language (character
encoding) and the values (code points) were?
> Some values in table contains non-english characters and i need sear
or aalternatively, u can also do a echo $PATH and put the library in one of
those path. eg: /usr/lib or someplave OR
do PATH=$PATH:/usr/lib/mysql, if it work, put that command in your
'.profile' so that it loads every time you log in.
- Original Message -
From: "Chris Knipe" <[EMAIL PROTEC
This is a long response. I trimmed as much as I thought I could.
Hmm. The short story is that you might want to invest some time going
through the table by hand and editing the place names to a standard form.
Note that I'm not going to suggest a standard form. Check Google. I
suspect you'll want
Hello All:
I am using
mysql Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu
on RH 7.2
I would like to sort on multiple columns, but Mysql
tells my that the specified key would be too long
(error 1071).
If this is the case, what might be an alternative
strategy?
It may be looking for the library in a different location, such as
/usr/local/lib/mysql
ldd
Should show you where exactly it is looking for the library, then you can
try to symlink the library to that location. Alternatively, recompiling the
application may also help.
Kind Regards,
Chris
Hi, all
I am using mysql - 3.23.46, Intel, Solaris 8
Some questions:
1) Why cardinality value don't automaticly change when query change set of
unique values in index ( insert or update ) ?
Example:
mysql> create table a ( a int not null, index ( a ) );
Query OK, 0 rows affected (0.02 sec)
Two immediate options I can think of...
1) Install PHP on IIS and use PHP's database routines for MySQL
2) Use ASP, and connect to MySQL via the ODBC Driver for MySQL that is on
the mysql.com web site.
If you come from a ASP background, I'd really recommend option 2 for you.
It will save you the
Hello all,
I am having one application in which i am using mysql as database.
When i run my application it gives following error.
"error:loading shared libraries libmysqlclient.so.10 (No such file or
directory)"
I am having that library in /usr/lib/mysql/
Still it gives this error.Why is it s
i'm still going through the mysql documentation and am trying to
jump ahead.
i have written some perl based application. On NT it was easy to set up
NTFS permissions on files for my security.
the process for example is opening a new request ticket. While all the
tickets are visible(that in
Hi,
I'm new to this stuff. I first tried to install the binary distribution
but it failed because of not finding libz.so,
then I am trying to install with the source code,
./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49
make was okay, mesgs. were given about not finding libz.so but sai
I'm talking under correction here, but
SET('y'.'n') default 'n' NOT NULL - should work. I normally just do all
this stuff via phpmyadmin, it works really great...
--
me
- Original Message -
From: "Jason Soza" <[EMAIL PROTECTED]>
To: "MySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Frida
All sorted, thanks a million to Kevin Fries
For archives purpose and anyone else that ever want to do anything like
this... The query I was looking for apparently (Tested and working so far -
I will test it a bit more later when I have more data in the tables):
select monitorhosts.HostID, monito
I would like to set up a MySql database that will
store distance information for a milage lookup
program. The user will enter the origin city and the
destination city for some predefined trips. Then the
query will need to return the milage broken down by
state. For example, for an origin city i
Hoping someone can help me here:
I've made a column using SET("y","n") NOT NULL - I want the default value in
that column to be "n", so if no data is entered for that column, it'd be "n"
automatically.
How do I do that? Not sure what to search for in the manual.
Jason Soza
filter fodder: sql,
Hi.
On Fri 2002-06-07 at 01:55:18 +0200, [EMAIL PROTECTED] wrote:
[...]
>
> > Chris,
> >
> > sounds like you're looking for an exclusive left outer join.
> > You want to see records from monitorhosts, where there is no corresponding
> > record
> > in monitorhostgroupdetails, right?
>
> Yes - an
Hi.
On Thu 2002-06-06 at 19:17:10 +0200, [EMAIL PROTECTED] wrote:
[...]
> But... is this the only feature of mysql which is dependant on the
> processor architecture?
See it the other way: You are not garantueed more than 31 tables in a
join. If you happen to have a 64Bit architecture, you can
this is weird.
I have been running mysql 3.23.40 for a long time, no problems.
I attempted an upgrade to 3.23.49, but mysql segfaults when I
load safe_mysqld as uid root.
my typical startup for mysql would be:
/usr/local/mysql/bin/safe_mysqld --user=mysql -O key_buffer=128M -O
table_cache=512 -
Use TASK MANAGER in windows 98
It does what u wantjust run mysql < scriptname;
R.B.Roa
Traffic Management Engineer
PhilCom Corporation
Tel. No.(Office) 858-1028
(Home) 858-8889
Mobile No. (63) (919-3085267)
-Original Message-
From: Rubylinda F Otero [SM
i want to know where a can write my script in running and use mysql.
recently i save in a file a two statement and it work what i expect to be done,
i'm wondering what is the most easiest programming language could i use to write my
script.
for ur info
i'm using win98
mysql 3.29.49
___
i want to know where a can write my script in running and use mysql.
recently i save in a file a two statement and it work what i expect to be done,
i'm wondering what is the most easiest programming language could i use to write my
script.
for ur info
i'm using win98
mysql 3.29.43
__
Hello,
I want to set quota to mysql database by every database or by every user, I
can not find any issues from mysql official website, and I don't think the
Linux or FreeBSD File System quota solution is effective, who can help me?
Thank you in adanced.
Regards,
Asong.
--
- Original Message -
From: "Kevin Fries" <[EMAIL PROTECTED]>
To: "'Chris Knipe'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 07, 2002 12:38 AM
Subject: RE: sub-queries
> Chris,
>
> sounds like you're looking for an exclusive left outer join.
> You want to see records fro
Chris,
sounds like you're looking for an exclusive left outer join.
You want to see records from monitorhosts, where there is no corresponding
record
in monitorhostgroupdetails, right?
Use:
Select *
from monitorhosts left join monitorhostgroupdetails on
monitorhosts.HostID = monitorhostgroup
Hi all,
I ve got some errors while making a query that managing match (full text)
and union,
both on boolean mode and the other mode.
When I m working with "like" i get no error.
I m working with mysql 4.01 4.02.
Tables have the sames number of fields ...
Indexes seems to have been created ...
On Thu, Jun 06, 2002 at 02:49:05PM -0700, Shakeel Sorathia wrote:
> we start up mysql. Mysql binds to the port, then it takes about 15
> seconds for innodb to startup and get ready to start serving requests.
> Problem is that in this 15 seconds a few hundred connections have
> queued up to my
We have a situation that I was wondering if anyone had an answer to. We
have a situation where we have multiple mysql boxes being used in random
order for load balancing and fault tolerance. Basically the app chooses
one of the machines at random, and if it can't get a connection, it
tries a
You are very welcome. I am glad I was able to help.
Charles Q.
At 03:58 PM 6/6/2002 -0500, k wrote:
>Thanks Charles for your patience and help. I removed winmysqladmin from
>startup and ALL problems went away! When winmysqladmin started up on the
>other user accounts it would somehow blo
> Hi
> I have a mysql database with 3 table
> books (idbook and other fields)
> authors (idauthor, name and other fields)
> booksauthors (idauthor, idbook)
> If I have a book with 3 authors I will have three rows on booksauthor. And
> it works
> But how can I get on a row the name of the book and
Chuck,
The way to do this is to create a primary key (PK) in your main table. (I
usually use bigint auto_increment with a name of tablenameID)
Then in your child table, you put the same field in and store the key to the
parent record.
i.e.
movie
-
movieID
=
title
-
actor
-
act
Dear list,
After doing a good bit of reading, the details are still hazy.
I have a web-based application (about 20 tables, with up to 100,000 records
per table - but most tables are much smaller). 99% of "select" queries are
very very fast.
However, there is the occasional "select" query tha
Can you backup/restore just one MySQL database with InnoDB hot backup? From
what I gather it's an all or nothing proposition. As I understand it,
there's only one "tablespace" (with any number of data files) and all
database tables of type 'InnoDB' are comingled in the one tablespace.
Therefore, i
Strange indeed...
Might be worth checking if this can be reproduced... This can perhaps be
something worth mentioning in winmysqladmin (possible bug?)
- Original Message -
From: "Kirk Brannan Babb" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 06,
Thanks Charles for your patience and help. I removed winmysqladmin from
startup and ALL problems went away! When winmysqladmin started up on the other
user accounts it would somehow block connections to MySQL (since before I
uninstalled, on normal [non-admin] user accounts, I could not conne
Ok, I spoke to soon... And this is starting to drive me up the walls now...
i.e. getting REALLY irritating and frustrating.
mysql> DESCRIBE monitorhosts;
+--+--+--+-+-+--
--+
| Field| Type | Null | Key | Default |
Hi,
I have a design question for mysql database that I am wanting to create a
my movies collection. I was going to do as one-to-one database, but I see
now that I need to do as a one-to-many. I have never done a one-to-many but
I see that is the way to go.
I guess then is can someone show me wh
Hey all,
I've been searching for references on the web and even been to stores ;)
regarding the above subject. But I am reluctant to purchase ATM because there
are so many books out there on the subject.
So I figured I'd go to the list and ask the question. What are peoples
opinion's on the
*MWAH*!!!
Thanks a million, tested and working beautifully Can't believe in two
days I didn't think of this...
--
me
- Original Message -
From: "Sabine Richter" <[EMAIL PROTECTED]>
To: "Chris Knipe" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 1
Select monitorhosts.HostID
from monitorhosts left join monitorhostgroupdetails on
monitorhostgroupdetails.HostID = monitorhosts.HostID
where monitorhostgroupdetails.HostGroupID !='1';
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
SELECT monitorhosts.HostID
FROM monitorhosts, monitorhostgroupdetails
WHERE monitorhosts.HostID = monitorhostgroupdetails.HostID
AND monitorhostgroupdetails.HostGroupID != '1');
Gruss
Sabine
Chris Knipe wrote:
>
> Lo all,
>
> are sub-queries supported on mysql-max 3.23.49 ??
>
> If they are,
Fair enough (and also what I thought)
Does anyone have any idea how I can implement the below in a similar
"fashion" then?
I have a list of items, and a list of groups. I want to retrieve all the
items from a table that is not in a specific group...
- Original Message -
From: "Kis
I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL
version, yet.
You can read the MySQL manual about it. You can find there when and how it
will be implemented.
Bye
Daniel
At 21:39 2002.06.06. +0200, you wrote:
>Lo all,
>
>are sub-queries supported on mysql-ma
Lo all,
are sub-queries supported on mysql-max 3.23.49 ??
If they are, what's wrong with the following statement?
SELECT monitorhosts.HostID
FROM monitorhosts
WHERE monitorhosts.HostID NOT IN
(SELECT HostID
FROM monitorhostgroupdetails
WHERE monitorhostgro
Problem Solved.
Thx!
Mateus Begossi
- Original Message -
From: Mateus Begossi <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; MySQL List <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 10:27 PM
Subject: SQLPrepare problems
> Hello everyone,
> I´m writing a VC++ 6.0 App that among many
Hello world,
I'm pretty new at SQL. I'm just trying to build a simple document
index. I'm hoping there is a better way to do things than what I've
got here.
Here's what I've got for a table definition:
>mysql> create table main_index(
> sequence int unsigned primary key auto_increment n
Okay, I think I understand now.
If you notice, tcp port 3306 is "listening" when you are logged in as both
the administrator and as a "regular user". Port 3306 is the MySQL
server/daemon.
Your problem isn't with the MySQL server. Your MySQL server is started and
waiting on connections.
You
> FOR MY ADMIN ACCOUNT
> C:\>netstat -a -p tcp
> TCPdynamic:3306 dynamic:0 LISTENING
> FOR THE REGULAR USER ACCOUNT
> C:\>netstat -a -p tcp
> TCPdynamic:3306 dynamic:0 LISTENING
It would seem strange to implement one and not the other? The help does say
that you can use it and does keep the create options now.
Does anyone know if this will be implemented in the next .5x release?
Ross
Me& writes:
> Hi!
>
> don't think ON UPDATE is supported.
>
> The manual :
I don't think this makes sense either, but you will see what I mean:
FOR MY ADMIN ACCOUNT
C:\>netstat -a -p tcp
Active Connections
Proto Local Address Foreign AddressState
TCPdynamic:http dynamic:0 LISTENING
TCPdynamic:epmap dynami
Hello Greg,
maybe it can be of some help:
- Try ( if memory is not a problem ) to read the entire file in memory,
inside an array, and use foreach() in the array. It is quicker than
reading line by line from the HD;
- And you may try to mount your U
>No you can't, but check out LIMIT.
Ops, but I did it!
Using a variable and a temporary table as Benjamin and Keith wrote in the
prev. messages
ciao ciao!
MAS!
--
I love MySQL :-)
-
Befor
Only users of the "Administrators" group on NT can start system services by
default.
Have a look in your user manager for domains, policies, user rights
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
- Original Message -
From
Summary: On AIX 4.3.3, using xlc_r/xlC_r compiler, configured with
--with-debug, make all in client directory fails with:
ld: 0711-317 ERROR: Undefined symbol: ._db_enter_
ld: 0711-317 ERROR: Undefined symbol: ._db_return_
ld: 0711-317 ERROR: Undefined symbol: _db_on_
ld: 0711-317 ERROR: Undefine
* Victoria Reznichenko
[...]
> RB> So... is the crashme report wrong? Or was the limit really 32
> RB> in 3.22.39, got lowered to 31 in later versions (like 3.23.30-
> RB> gamma), raised to 63 in version 3.23.39, and then lowered to
> RB> 31 again (at least in versions 3.23.47 and 4.0.1)...?
>
> R
[snip]
Thanks so much. There was a slight syntax change, replacing your first ORDER
BY with a GROUP BY, but it worked.
[/snip]
Yep *slapping forehead* I saw that I had one too many ORDER BY's there and
forgot to send an update. :)
Glad it helped!
Jay
mysql, sql, query
"It's hip to snip!"
[snip]
WHERE ap_type='Original Movie Poster'
ORDER BY sort_title ASC
HAVING sort_title LIKE 'G%'
ORDER BY sort_title ASC
You may have to swap the HAVING and ORDER BY lines of the query,
[/snip]
Thanks so much. There was a slight syntax change, replacing your first ORDER
BY with a GROUP BY, but i
[snip]
In SQL DDL, what are the maximum sizes of the various BLOB and TEXT column
types? TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB and the corresponding TEXT
types? I've searched the
manual but couldn't find these specs. At what point should I choose BLOB
over TINYBLOB, and so on?
[/snip]
http://ww
I'm a bit confused by what you mean here; are you just updating the
'ktjnews' column, or are you attempting to reset the 'email' column as well?
(The source says the first, your comments suggest the second.)
Further, exactly which part of this is too slow? Obviously, each query will
require scann
Kirk,
I am somewhat confused by your question.
I must misunderstand what it is that you are trying to ask, because what it
appears that you are asking makes no sense. Once MySQL was installed as a
service, why does it matter which account starts it? Are you not the admin
on the box? Are y
In SQL DDL, what are the maximum sizes of the various BLOB and TEXT column
types? TINYBLOB, BLOB, MEDIUMBLOB and LONGBLOB and the corresponding TEXT
types? I've searched the
manual but couldn't find these specs. At what point should I choose BLOB
over TINYBLOB, and so on?
TIA,
Arthur
---
[snip]
All of this is occuring on the same W2K machine (with Apache, MySQL, etc).
When
I log off admin and log on as a power user (same machine) I have the
aforementioned problems.
[/snip]
Kirk,
OK, this makes sense. The "power-user(s)" needs to be given permissions to
start and stop services on
hello,
I hav compiled and installed mysql++ without "automake" or "autoconf" just
by typing
./configure
make
make install
(Typing "auto..." bevore compiling makes everithing worse and "make" does not
work - I don't know if that is the reason for following issues...)
I want to build a program
in the DSN settings, each datasource has a different username and password.
and looking over the DSNs, none of them should be using the username
ODBC@localhost.
On Thursday 06 June 2002 9:18, you wrote:
> Ray,
> Thursday, June 06, 2002, 4:39:11 PM, you wrote:
>
> R> Error Occurred While Proce
[snip]
I've asked this question once before with no response (and have asked on
other
lists), I'll give it one more try before giving in to semi-Gates domination
(my
last holdout is the Apache server I'm running):
Upon installing MySQL as a service, why will it not start for all users?
Only
my ad
On Thursday 06 June 2002 08:53 am, you wrote:
> On Thursday 06 June 2002 9:51 am, Greg D. wrote:
> > I was wondering if there was a better way to speed up
> > my update statement in my perl script. It goes through all the
> > entries in the database , which is around 800, 000, and then upda
On Thursday 06 June 2002 9:51 am, Greg D. wrote:
> I was wondering if there was a better way to speed up
> my update statement in my perl script. It goes through all the
> entries in the database , which is around 800, 000, and then updates the
> email field. The problem is that it takes t
Hello,
I am trying to develop a back-up procedure for our MySQL database.
The database is housed on our production Web server. My thought is to
simply make a slave on our file server that is backed up. I use InnoDB
type tables and my application uses transactions. I am wondering how
table/ro
Hello,
I was wondering if there was a better way to speed up
my update statement in my perl script. It goes through all the
entries in the database , which is around 800, 000, and then updates the email
field. The problem is that it takes to long.
thanks in advance for any help
here t
Dear listmembers,
I've got 2 hosts running Linux: hostnames are 'hegel' and 'fidel'
me@hegel:~>mysqladmin version
mysqladmin Ver 8.21 Distrib 3.23.39, for pc-linux-gnu on i586
me@fidel:~>mysqladmin version
mysqladmin Ver 8.23 Distrib 4.0.1-alpha, for pc-linux-gnu on i686
When logged in to 'h
[snip]
I need to run an extract of some data from our Oracle DB's. One of the
restrictions is that I need to write a SQL script that will parse through a
particular field for a "/"
and if found, I have to remove it and output the data without the slash.
I have minor experience with selecting data
Hi Everyone.
I need to run an extract of some data from our Oracle DB's. One of the
restrictions is that I need to write a SQL script that will parse through a
particular field for a "/"
and if found, I have to remove it and output the data without the slash.
I have minor experience with selectin
It appears the v4.0.1 mysqlhotcopy perl script has been modified and broken.
When using cp for the backup it's passing a null value for the file(s) to be
copied. Below is a session clipping of an execution with --debug turned on:
# /u0
This problem is already solved in Oracle. It it the CONNECT BY PRIOR
statement which recursively queries a table.
The good news is that I read in the MySQL manual, that this feature will be
implemented in MySQL in the Real Near Future :-).
(MySQL manual: "1.8.2 Things That Must be Done in the Re
¼ÛÅÂÈ£,
Thursday, June 06, 2002, 1:08:07 PM, you wrote:
¼> I will attempt to give you as much information about the software as I can
¼> before I ask the question.
¼> OS : RedHat 7.1
¼> MySQL : Version 3.23.49a for Linux -> binary distribution for pc-linux
¼> I want to insert into longblob colu
Ray,
Thursday, June 06, 2002, 4:39:11 PM, you wrote:
R> Error Occurred While Processing Request
R> Error Diagnostic Information
R> ODBC Error Code = S1000 (General error)
R> [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
R> The error occurred while processing an el
Roger,
Thursday, June 06, 2002, 12:08:13 PM, you wrote:
>> I just tried a multiple self join on 4.0.1 and got the following
>>
>> DBD::mysql::st execute failed: Too many tables. MySQL can only
>> use 31 tables in a join at ./x2.pl line 47.
RB> Me too, running 3.23.30-gamma on w2k:
mysql>> desc
Morris,
Thursday, June 06, 2002, 6:17:57 AM, you wrote:
MF> I am having a problem installing version 3.23.50
MF> on AIX 4.3.3. When I execute mysql_install_db or
MF> try to start mysqld I get errors like
MF> 0509-036 Cannot load program
MF> ./bin/my_print_defaults because of the following
MF> er
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a
user "ODBC@localhost" fixed it.
all off a sudden i need a user named ODBC@localhost, and last i checked, i'm
the only one here that knows anything about how to use mysql here at the
office. so what might have been chang
I have a question about how to rotate replication logs in MySQL V 3.23.49.
I've tried to use the command "purge master logs to 'logname'", however, I'm
unclear what to specify for 'logname'. On my master, I have several "old"
log files which are no longer being used (by issuing the command "show s
Hello
I think, there's a better solution:
Use one database - field for sorting (for example SORT). Then you need
to fill in
values in this field, that satisfy your needs:
Root - Item
1. Hello You
1.1. test1
1.2. test2
2. cool
2.1 cool i
2.2 cool ii
...
The values of the s
Hi all,
I have tried several times to integrate the
lookup functiction into mysql but with no luck. :(
I have REDHAT 7.3
with
gcc 2.96
and with
mysql-3.23.49
I compiled udf_example.so and copied into /usr/lib folder.
When I try to do
CREATE FUNCTION lookup RETURNS STRING SONAME "udf_exampl
Hi,
I've observed some table corruption:
How-To-Repeat: no idea, but maybe you might have one ;)
$ mysql -hxxx Escherichia_coli_O157_H7
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in t
hello,
I hav compiled and installed mysql++ without "automake" or "autoconf" just by
typing
./configure
make
make install
(Typing "auto..." bevore compiling makes everithing worse and "make" does not
work - I don't know if that is the reason for following issues...)
I want to build a progra
Hello
I think, there's a better solution:
Use one database - field for sorting (for example SORT). Then you need to fill in
values in this field, that satisfy your needs:
Root - Item
1. Hello You
1.1. test1
1.2. test2
2. cool
2.1 cool i
2.2 cool ii
...
The values of the s
Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)
[TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO)
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document pos
No you can't, but check out LIMIT.
Marco Stagno wrote:
>>IMHO, The Right Thing to do this, is to create the additional data in
>>your application (as you said you won't change the table).
>>
>
>(...)
>
>thank you!
>
>>If you want this with SQL for sure, using user-defined variables will
>>work:
Maybe
if (!($result)) {
Try
print STDERR "RESULT=$result\n";
to see what you are comparing to.
Chris Hohimer wrote:
> thanks for all the replies!! but it is not working.
> here is the loop:
>
> if($result == EMPTY SET){
> $Scheduled = NULL;
> }
> else{
> $Tech = mysql_result($result,
Borus,
Thanks for responding. I am attempting to
install a binary release not build from source.
Do you have any information regarding the errors
in my original post?
Thanks
Morris Ford
--- é¾?æf æ¨?(Borus.Kung)
<[EMAIL PROTECTED]> wrote:
> FYI
>
> this may help
>
> Borus
>
> - Ori
[snip]
I've asked this question once before with no response (and have asked on
other
lists), I'll give it one more try before giving in to semi-Gates domination
(my
last holdout is the Apache server I'm running):
Upon installing MySQL as a service, why will it not start for all users?
Only
my ad
I studied the MySQL and InnoDB manual, but I did not find anything about
the internal usage of foreign keys.
I mean if I define a foreign key it is good for me, because the InnoDB
engine does not let the database to get integrity errors. But I think the
foreign key definitions could be used in
I've asked this question once before with no response (and have asked on other
lists), I'll give it one more try before giving in to semi-Gates domination (my
last holdout is the Apache server I'm running):
Upon installing MySQL as a service, why will it not start for all users? Only
my admin
hello,
I hav compiled and installed mysql++ without "automake" or "autoconf" just by
typing
./configure
make
make install
(Typing "auto..." bevore compiling makes everithing worse and "make" does not
work - I don't know if that is the reason for following issues...)
I want to build a progra
1 - 100 of 135 matches
Mail list logo
