Date |Mon, 27 Aug 2001 15:31:26 -0700
>From |John Meyer <[EMAIL PROTECTED]>
Hello!
JM> At 09:15 AM 8/28/01 +1200, you wrote:
>>Hi there,
>>
>>I treat image data type as text, does anyone know how to insert an image
>>into the table?
>>
JM> the image data type is actually a BLOB, not text. Usua
Date |Mon, 27 Aug 2001 14:14:22 -0700
>From |PR <[EMAIL PROTECTED]>
Hello!
P> I was wondering if anyone could point me to a message board (perl or php)
P> that has a very efficient database design to handle threaded views. I know
P> that this is a difficult task under mysql and have seen the th
Date |Mon, 27 Aug 2001 18:16:43 -0400
>From |"alexus" <[EMAIL PROTECTED]>
Hello!
A> hi
A> i'm trying to setup mysql w/ InnoDB
A> i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html
A> and i'm end up with this in my log every time i run mysql and in addition it
A> ends
A>
hello.
with a lot of help from many of you and some very nice folks, i have
been able to build some example/experiment/'mess around' type of dbs.
yay.
i'd like to ask...
if any of you are familar with (File Maker Pro, most recent
versions)... how does one go about using MySQL to create a pr
Date |Mon, 27 Aug 2001 18:32:57 -0500
>From |"Tyler Longrne" <[EMAIL PROTECTED]>
Hello!
TL> Hello everyone,
TL> Is there any way to make selections in groups of 5. I want to get 5 record
TL> sets at a time until we get to a point that there's 4 or less records.
TL> Thank you everyone,
TL> Tyl
Date |Tue, 28 Aug 2001 03:16:59 -0230 (NDT)
>From |Neil Zanella <[EMAIL PROTECTED]>
Hello!
NZ> RedHat 7.1 users:
NZ> The command used to start mysqld on this platform is simply (as root):
NZ> # /etc/init.d/mysqld start
NZ> This is _all_ that is required.
NZ> Once that works you can set
NZ>
RedHat 7.1 users:
The command used to start mysqld on this platform is simply (as root):
# /etc/init.d/mysqld start
This is _all_ that is required.
Once that works you can set
the mysql root user's password
with mysqladmin if you are
concerned about security
on your intranet.
Neil
---
>Description:
Can't run the mysql deamon at all. When I try running safe_mysqld (with root
permission) i get the following message
Starting mysqld daemon with databases from /var/lib/mysql
010828 15:18:22 mysqld ended
When I attempt this as not the root user, I get permission problems.
The
Is there any reason why a replicating master won't write some incoming
write-queries to the binlog for slaves to pick up?
I have a php script which dynamically builds an sql string and sends it to
mysql - the query works fine, the data is inserted, but it's never written
to the binlog as long as
With out knowing the exact error im guess its because you're trying to
start the server as root.
Sheena Sidhu wrote:
>
> Hi All,
> I have installed mysql-max. Previously I had the mysql verion 3.23.40
> without max libraries on the same machine. When I start the server , I get
> the fol
Hi All,
I have installed mysql-max. Previously I had the mysql verion 3.23.40
without max libraries on the same machine. When I start the server , I get
the following messages:
Please help ! Urgent!
***
> [root@arulacc mysql-max-3.23
Every mail on this list has the following header:
List-ID:
I use maildrop with the following filter:
if ( /^List-ID\: \/)
{
to "Maildir/.mysql"
}
hope this helps,
dpk
- Original Message -
From: "Glyndower" <[EMAIL PROTECTED]>
To: "George Pitcher" <[EMAIL PROTECTED]>; <[EMAIL PROTEC
I just use the "[EMAIL PROTECTED]" in the To field of the email. Works
like a charm.
--Daniel Von Fange
-Original Message-
From: Glyndower [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 8:56 PM
To: George Pitcher; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: sorting this egro
i deleted everything and re-run again and it started fine now..
weird..
- Original Message -
From: "ryc" <[EMAIL PROTECTED]>
To: "alexus" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 7:56 PM
Subject: Re: MySQL+InnoDB
> Yes. delete all ib_ files and all data f
Maybe I overlooking the obvious here, but hey it won't be the first time.
How does everyone sort this group in their email client? I have yet to find
a way to manage these emails because of the lack of a consistent item in
each email. i.e MySql in the subject line etc
Suggestions?
Hi all,
I know this might be slightly off topics.
I was trying to make JBoss/MM-MySQL_JDBC/MySQL to work together.
However, I found the following problem. With MyISAM type, the
container-managed persists ok; but,
with INNODB type, JBoss doesn't able to persist the data back to the I
Yes. delete all ib_ files and all data files specified in my.cnf... and then
run mysql again.
ryan
- Original Message -
From: "alexus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 5:16 PM
Subject: MySQL+InnoDB
> hi
>
> i'm trying to setup mysql w/ InnoDB
>
Select * from yourTable limit 0,5
gets you the first 5. After that:
Select * from yourTable limit 5,5
gets you the next five...etc.
Cal
http://www.calevans.com
-Original Message-
From: Tyler Longrne [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 27, 2001 6:33 PM
To: MySQL List
Subj
Hello everyone,
Is there any way to make selections in groups of 5. I want to get 5 record
sets at a time until we get to a point that there's 4 or less records.
Thank you everyone,
Tyler
database,sql,query,table
-
Before po
Try putting a space between mysqld and --standalone (mysqld --standalone)
- Original Message -
From: "S K Bryan" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 2:54 PM
Subject: Need Help Setting Up MySQL on Win98
Hello -
I'm very new at this, so pleas
hi
i'm trying to setup mysql w/ InnoDB
i followed all steps from http://www.mysql.com/doc/I/n/InnoDB_start.html
and i'm end up with this in my log every time i run mysql and in addition it
ends
here is log file from first time i run mysql
010827 17:07:07 mysqld started
InnoDB: The first speci
On 27 Aug 2001, Trond Eivind Glomsrød wrote:
> Neil Zanella <[EMAIL PROTECTED]> writes:
>
> > 4. Are the Linux versions shipped with Red Hat 7 and 7.1 entirely
> >distributed under the GPL?
>
> Yes.
This appears to be true after noticing the following file
under Red Hat 7.1: /usr/share/doc/
At 09:15 AM 8/28/01 +1200, you wrote:
>Hi there,
>
>I treat image data type as text, does anyone know how to insert an image
>into the table?
>
the image data type is actually a BLOB, not text. Usually, it's more
efficent to have the field be text, and just store the path to the image
(C:\my\p
On Mon, Aug 27, 2001 at 03:42:44PM -0400, Andrew Gideon wrote:
>
> I'd this problem too (and I didn't note lines to be removed in the
> documentation). It turns out that there is in the configure script
> an assumption that the inability to produce a working executable
> implies that cross compi
On 26-Aug-2001 [EMAIL PROTECTED] wrote:
> Hi
>
> I need to set the max_allowed_packet to 16M. below is my
> 01mysql-server.sh file. I use DBI and I know that I have to start this
> before the DBI program and I did but if I use ./mysqld --help it shows
> that my max_allowed_packet is still 1M. An
I was wondering if anyone could point me to a message board (perl or php)
that has a very efficient database design to handle threaded views. I know
that this is a difficult task under mysql and have seen the threads on
recursive queries, but I'd like to find some real life examples rather than
s
Hi there,
I treat image data type as text, does anyone know how to insert an image
into the table?
Thanks
Qingmin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
>Hi Paul,
> Will not contest your claim at all since you must have tried it to make
>that claim. So if I agree with you, then don't you think that the statement
>which is posted earlier :"Berkeley DB does not support SQL queries. All
>access to data is through the Berkeley DB API." is mislead
Hi Paul,
Will not contest your claim at all since you must have tried it to make
that claim. So if I agree with you, then don't you think that the statement
which is posted earlier :"Berkeley DB does not support SQL queries. All
access to data is through the Berkeley DB API." is misleading es
At 1:23 PM -0700 8/27/01, Sheena Sidhu wrote:
>Hi Paul,
>Thanks for responding. I am not sure if I understand you fully here. SO
>you mean to say that BDB DOES support SQL, meaning that I send statements
>like 'Select * from user' to a BDB table from my C++ code? If that is
>possible, then gr
Hi Paul,
Thanks for responding. I am not sure if I understand you fully here. SO
you mean to say that BDB DOES support SQL, meaning that I send statements
like 'Select * from user' to a BDB table from my C++ code? If that is
possible, then great. If not, then kindly let me know if Innodb has t
At 11:10 AM -0700 8/27/01, Sheena Sidhu wrote:
>Hello,
>I am looking into choosing between Innodb and BDB. One thing about BDB which
>I am quoting from the official site :"
>Berkeley DB does not support SQL queries. All access to data is through the
>Berkeley DB API. Developers must learn a new se
At 12:54 PM 8/27/01 -0700, you wrote:
>Hello -
>
>I'm very new at this, so please pardon the very beginner questions...
>
>I'm attemtping to install MySQL to my local machine running Win98. The
>install seems to go alright, but when I try "mysqld--standalone" it
>gives me an error. Then I tried "m
On Mon, Aug 27, 2001 at 02:40:51PM +0200, [EMAIL PROTECTED] wrote:
>
> I've installed MySQL on a Sun Ultra1 with Solaris 8 and it works
> fine. But as soon as I unplug the network cable none of the MySQL
> binaries seem to work any more. If I start MySQL is prints nothing
> and the process seems
Hello -
I'm very new at this, so please pardon the very beginner questions...
I'm attemtping to install MySQL to my local machine running Win98. The
install seems to go alright, but when I try "mysqld--standalone" it
gives me an error. Then I tried "mysqld -standalone", which seemed to
work.
Th
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Sinisa Milivojevic) writes:
>>
>> What can I do to fix/debug this problem?
I'd this problem too (and I didn't note lines to be removed in the
documentation). It turns out that there is in the configure script an
assumption that the inab
)-Original Message-
)From: Jeff Tanner [mailto:[EMAIL PROTECTED]]
)Sent: Monday, August 27, 2001 12:08 PM
)To: '[EMAIL PROTECTED]'
)Subject: SQLDriverConnect
)
)
)If the connection string for SQLDriverConnect is "DSN=foo", and DSN foo is
)defined within the odbc.ini file, then connection s
So sprach »Neil Zanella« am 2001-08-27 um 16:50:11 -0230 :
> I would like to know some more details here. In particular:
>
> 1. What was the name of the first GPL file release of MySQL?
Is that some sort of trivia? :)
> 2. Which portions are not distributed by mysql.com as part of MySQL?
Don't
On Mon, Aug 27, 2001 at 09:43:23PM +0300, Sinisa Milivojevic wrote:
>
> Jeremy,
>
> In our manual, chapter on Solaris, there are instructions on which
> lines to delete from configure script in the case like above.
Right. I've looked at:
http://www.mysql.com/doc/S/o/Solaris.html
http://w
I would like to discuss the MYSQL licensing policy.
Please do not take anything personally. I do think
that MySQL is one of best database management
systems out there.
Pertaining to the FAQ on the mysql.com site:
--- begin snip
Q:Does MySQL AB devel
Hi,
I have mysql version 3.32.40 installed on my system. Please let me
know what I need to take care of (besides the db backup) if I need to
upgrade to mysql-max?
I need this on an urgent basis, so please help!
Thanks,
Sheena.
If the connection string for SQLDriverConnect is "DSN=foo", and DSN foo is
defined within the odbc.ini file, then connection succeeds.
However, if the connection string for SQLDriverConnect is
"DRIVER={MySQL};SERVER=foo_host;USER=foo;PWD=bar;DATABASE=foo_db",
then error condition is returns wit
On Monday 27 August 2001 12:30, Martin MOKREJ? wrote:
> >
> > Sorry about that - we have now fixed the problems with our anonymous FTP
> > upload, and it should be working.
>
> lokk in pub/mysql/secret/ for:
>
> 15593452(size) cogs_data.tgz
>
> But same file should be accessible already via
Jeremy Zawodny writes:
> I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm
> trying to build the MySQL client libraries. According to the
> INSTALL-SOURCE file, I need to use a command-line like this:
>
> CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-except
[EMAIL PROTECTED] writes:
> >Description:
> I downloaded the lated AIX binary from mysql.com, and unpacked it to
>/usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db
>per the INSTALL-BINARY file. This is the error I recieve:
>
> exec(): 0509-036 Cannot loa
I have a fairly new Solaris 2.8 (Ultra Sparc) machine on which I'm
trying to build the MySQL client libraries. According to the
INSTALL-SOURCE file, I need to use a command-line like this:
CC=gcc CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions
-fno-rtti" ./configure --wi
>
> Sorry about that - we have now fixed the problems with our anonymous FTP
> upload, and it should be working.
lokk in pub/mysql/secret/ for:
15593452(size) cogs_data.tgz
But same file should be accessible already via the 2 web links I've sent
to you via personal e-mail. Thanks.
--
Martin
>Description:
I downloaded the lated AIX binary from mysql.com, and unpacked it to
/usr/local/mysql. I then cd'd to /usr/local/mysql and ran scripts/mysql_install_db
per the INSTALL-BINARY file. This is the error I recieve:
exec(): 0509-036 Cannot load program ./bin/my_print_defaults
Jason A. Vest writes:
> Dear Sir,
>
> Ihave encountered an error with the windows version of the MySQL GUI. This
> error happens only when I try to pull data from the this table in the GUI.
> I can pull information from other sources. The GUI program will initiate a
> memory error message and q
Hello,
I am looking into choosing between Innodb and BDB. One thing about BDB which
I am quoting from the official site :"
Berkeley DB does not support SQL queries. All access to data is through the
Berkeley DB API. Developers must learn a new set of interfaces in order to
work with Berkeley DB. A
>
> mysql> repair table cogs_data;
> ERROR 2013: Lost connection to MySQL server during query
> mysql> quit
>
> 0x807b1b8 handle_segfault__Fi + 380
> 0x812af8a pthread_sighandler + 154
> 0x81517df free + 39
> 0x8114a6c my_no_flags_free + 16
> 0x8109304 mi_repair + 2236
> 0x80c4768 repair__9ha_m
On Monday 27 August 2001 19:43, Dave Mittner wrote:
> I'm running into a snag... here's an example of the query I'm making
> from within Perl:
>
> SELECT * FROM table1,table2
>
> I know it's not a nice way to do it, but I'm making an SQL webpage
> frontend which I'd like to support it just in case
At 10:43 AM -0700 8/27/01, Dave Mittner wrote:
>I'm running into a snag... here's an example of the query I'm making
>from within Perl:
>
>SELECT * FROM table1,table2
>
>I know it's not a nice way to do it, but I'm making an SQL webpage
>frontend which I'd like to support it just in case. I'm
>usi
nsabbi writes:
> ... you are really very kind and helpful!
>
> Now I can avoid managing temp tables.
>
> Thanks very much,
>
> Nico Sabbi
>
You are welcome.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL
On Mon, 27 Aug 2001, Martin MOKREJŠ wrote:
> > ftp://support.mysql.com/pub/mysql/secret
Hmm, I can already login as ftp, but can only chdir to /pub/mysql, there's
no secret directory. ;(
> http://pednew.gsf.de/cogs_data.tgz
Hmm, try out http://kulan.gsf.de/cogs_data.tgz , but I'm sure the prev
I'm running into a snag... here's an example of the query I'm making
from within Perl:
SELECT * FROM table1,table2
I know it's not a nice way to do it, but I'm making an SQL webpage
frontend which I'd like to support it just in case. I'm
using fetchrow->hashref to pull it out and display it. Th
Hi,
1. Please excuse my English mistakes I am a Swiss with Swiss German as
mother language.
My problem is related to using MySQL under Windows98 I have installed
MySQL 3.23.41
MyODBC 2.50.38-win95
and Microsoft ADO 2.0 is used.
I often get an error -2147217887 when a
On Mon, Aug 27, 2001 at 07:28:24PM +0200, Bruce Stewart wrote:
>
> >>- The function UNION to connect 2 select queries also doesn't
> >>seem to work in MySQL. Any workarounds?
>
> I believe, not yet supported in MySQL.
It's was in the 4.0 tree last I looked, so it won't be long. :-)
Jeremy
FWIW,
I am using INNODB tables in production without a problem.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Sheena Sidhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 12:24
Subject: Choosing between data
Hi,
>> - In oracle you have outer joins, where you have to use a (+)
>>to find rows with null values and stuff like that. Any suggestions on
>>how to do this in MySQL?
You must use the Left Join type syntax in the FROM clause of your query.
>> - The function UNION to connect 2 select
Hello,
I am very new to mySQL and researching on the various databases
options. Since I needed transactions enabled, so after a lot of research, I
narrowed down to innodb and Bdb. But realized that Innodb is in alpha but
BDB is very stable. Although I like the features that innodb has
Hello,
My ISP suppports iASP. I've moved my site from running on Windows 2000
Server to a linux zeus web server. Everything runs fine from querying the
mySQL database and returning records. But after about 5-10 queries of the
database returning 20 records at a time the iASP engine slow right
Dear Sir,
Ihave encountered an error with the windows version of the MySQL GUI. This
error happens only when I try to pull data from the this table in the GUI.
I can pull information from other sources. The GUI program will initiate a
memory error message and quit. Is this a bug?
This is the
What would be the best way to do this because I am working on a mysql
replacement to an old foxpro database and I can import the table once but I
am worried that if I try to import it again it will make duplicate records.
Another issue is that I have added an extra field to the table which is
At 9:38 AM -0600 8/27/01, Jeff Shipman - SysProg wrote:
>I have two tables and that have a couple of
>identical columns. I would like to find out
>what of a certain column is in one table and
>not in another. I've tried the following, but
>I get errors:
>
>select col1 from tab1 where col1 not in (
I used to be a Lasso/FileMaker programmer. The day I decided to
switch to the all-unix MySQL/PHP/Perl platform was very telling. I
was attempting to parse log files with Lasso's file tags. Everything
was working quite well, but once the log file was bigger than about
500k, it would "hang"
>Michael Beaucourt wrote:
>>
>> Hi all,
>>
>> I was wondering if it is possible to perform an inner select in MySQL.
>> I have a database called EMP and when i enter the following query, I
>> keep getting error 1064:
>>
>> select ename,deptno from emp where deptno in (select deptno from emp
>
Jeff,
If the result table from the inner select is not huge, I usually issue the
inner query by itself first, then build (in my scripting language of choice)
a comma-delimited text field containing the results that I don't want in my
final table. I then expand that text field into the 'NOT IN' c
Is there any specific reason you are compiling MySQL? I use MySQL on
LinuxPPC, and never have compiled it due to the great rpm's available
here: http://www.linuxppc.org/ (right side of the page)
>Hi all,
>
>Frustrated by failing compile: This is the message I get:
>
>c++: Internal compiler e
Hi,
sorry I did not send the last e-mail to the whole list, so here it is.
--
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
<[EMAIL PROTECTED]> Faculty of Science, The Charles University
-- Forwarded message --
Date: Mon, 27 Aug 2001 17:39:07 +0200 (ME
Can you upload a copy of blast_data to
ftp://support.mysql.com/pub/mysql/secret after verify first that what you
plan to upload will crash a separate MySQL server on REPAIR?
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ _
I have two tables and that have a couple of
identical columns. I would like to find out
what of a certain column is in one table and
not in another. I've tried the following, but
I get errors:
select col1 from tab1 where col1 not in (select col1 from tab2);
select tab1.col1 from tab1,tab2 where t
no mysql right now (3.23) does not support inner selects.
however, it looks like you could join the 2 tables to get the result you
want
I'm assuming there are 2 tables inside the emp database ? or is emp the
table ?
anyway here is an idea:
select d1.ename, d1.deptno FROM emp.table1 d1, emp.t
Michael Beaucourt wrote:
>
> Hi all,
>
> I was wondering if it is possible to perform an inner select in MySQL.
> I have a database called EMP and when i enter the following query, I
> keep getting error 1064:
>
> select ename,deptno from emp where deptno in (select deptno from emp
> where enam
... you are really very kind and helpful!
Now I can avoid managing temp tables.
Thanks very much,
Nico Sabbi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hi all,
I was wondering if it is possible to perform an inner select in MySQL.
I have a database called EMP and when i enter the following query, I
keep getting error 1064:
select ename,deptno from emp where deptno in (select deptno from emp
where ename = 'SCOTT')
The error message reads as
Chris M wrote:
>
> Does anyone know how I can go about troubleshooting what is wrong here? This
> is mysql on a Linux system
>
> I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file
> can't be opened, I need some hints.
>
That means that the table has crashed. Repair it with
Hi all.
I am relatively new to mysql and brand new on this list :)
Please help me with this:
I have to backup a database and the simplest way to accomplish this is
SELECT * FROM mytable INTO OUTFILE '/nobody_directory/mytabledump.txt';
The problem is that when I do this, the server response is:
Er
Error: 45
145 = Table was marked as crashed and should be repaired
>>On Mon, 27 Aug 2001 08:50:45 -0600, Chris M <[EMAIL PROTECTED]> wrote:
>>Does anyone know how I can go about troubleshooting what is wrong here? This
>>is mysql on a Linux system
>>
>>I have no idea how to begin troublesh
=?iso-8859-2?Q?Martin_MOKREJ=A9?= writes:
> On Mon, 27 Aug 2001, Sinisa Milivojevic wrote:>
> If I should try also your binary distribution, please let me know.
>
> --
> Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
> <[EMAIL PROTECTED]> Faculty of Science, The Charles U
Hi,
use "mysqladmin variables" command to see current settings. I guess
your mysqld does not read the config file you have edited. ;-) It
happened to me me also few days ago. Remember mysqld looks for
/etc/my.cnf and $DATADIR/var/my.cnf if I remember well. Maybe put the
path to config file just
>Description:
I use the MM JDBC driver version 2.0.4 to access my MySQL database from my
Java app. If I do "SELECT NOW()", it returns a String object and not a Date object.
I tried to call different functions (e.g. "SELECT DATE_ADD(NOW(), INTERVAL 0 SECOND)")
in order to have a Date i
On Mon, 27 Aug 2001, Sinisa Milivojevic wrote:
Hi!
> Try to repair the same table with 3.23.41.
>
> If it fails, please let us know, so that we can give you upload
> instructions.
kulan$ ls -la /home/mysql/Mbovis/cogs_data*
-rw-rw1 pedant users54195408 Jul 4 03:52
/home/mysql/M
Does anyone know how I can go about troubleshooting what is wrong here? This
is mysql on a Linux system
I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file
can't be opened, I need some hints.
Thanks,
Chris
Fatal Error
A serious problem was encountered:
Execute failed fo
Corelli, Wayne writes:
> All,
>
> Has anyone installed / used MySQL on TRU64 UNIX?
>
> I just had to hack up the code to install it and I was curious if anyone
> else had this problem
> Or perhaps I am missing a switch on the configure line.
>
> In particular the choice of gethostbyname functio
All,
Has anyone installed / used MySQL on TRU64 UNIX?
I just had to hack up the code to install it and I was curious if anyone
else had this problem
Or perhaps I am missing a switch on the configure line.
In particular the choice of gethostbyname function does not seem to have the
proper defini
Upcoming Seminar: How to Set Up E-Commerce for Your Business
SPEAKER: George Dubec
Vice President of Corporate Sales
WebStream Internet Solutions
[EMAIL PROTECTED]
http://www.webstream.net
(888) 932-2333 Toll-Free
(954) 730-7127 Local
On Mon, 27 Aug 2001, Betto McRose G, wrote:
> I want to know if it's possible to put a "format" to a Date Field into the
> DB. For example: I have a data only JUN/2001 for a table, but the field
> FechaINI format is -00-00, so I want to put just -00 but I cannot.
Let MySQL store its form
Hi!
Try to repair the same table with 3.23.41.
If it fails, please let us know, so that we can give you upload
instructions.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Devel
I've got a large table with, amongst other things, two indexed varchar
fields. Individual queries,
SELECT count(*) FROM orders WHERE email != 'control';
is fast (0.01 sec), and
SELECT count(*) FROM orders WHERE distdate LIKE '07/%/2001';
is fast (0.02 sec). But,
SELECT count(*) FROM or
>Description:
010827 16:24:44 Warning: Retrying repair of: './Mloti/blast_data' with keycache
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly built,
or misconfigured. This error can
Rafal Jank writes:
> Hi,
> I've noticed, that bin logs names are followed by three digits: 001,002 and so
> on. What will happen when I reach 999? Will it start to overwrite my first logs?
>
> magic words: MySQL, table, sql
> --
> _/_/ _/_/_/ - Rafa³ Jank [EMAIL PROTECTED]
I've installed MySQL on a Sun Ultra1 with Solaris 8 and it works fine. But as soon as
I unplug the network cable none of the MySQL binaries seem to work any more.
If I start MySQL is prints nothing and the process seems to hang. If I reconnect the
cable and try starting MySQL again, everythi
Hi
I want to know if it's possible to put a "format" to a Date Field into the
DB. For example: I have a data only JUN/2001 for a table, but the field
FechaINI format is -00-00, so I want to put just -00 but I cannot.
thanks
Betto McRose G,
-
I tried that, all it did was change my password for mysql
completelyhowever, i could have done something wrong...
- Original Message -
From: "Gerald R. Jensen" <[EMAIL PROTECTED]>
To: "Mark Johnson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, August 27, 2001 5:35 AM
Subject
On 27 Aug 2001 13:27:17 +0300, noe wrote:
> Hi my name is Nejat from Turkey and i am very new in databases .I have got a
> database in linux which is mysql and i want to carry this database to a
> windows system how can this be done.Any help needed.Thankyou!
>
Search in manual for "mysqldump"
--
Hi my name is Nejat from Turkey and i am very new in databases .I have got a
database in linux which is mysql and i want to carry this database to a
windows system how can this be done.Any help needed.Thankyou!
_
Do You Yahoo!?
Get you
This is probably heresy here, but we use Filemaker for our web-database
solution. The main reason why we use that in preference to more 'robust'
SQL-based DBs is that we have a team using Filemaker clients updating
information constantly and Filemaker is the most efficient db we have found
to do t
Dear members,
I know you are MySQLer but be honest, what is the the most used Database in
ISP of webhosting, and the reasons. And fornyou, after MySQL what is the DB
the you prefer in webhosting.
thanks to all
-
Before post
hello all, I'm now developing with MySQL and VC. And I have a question with the field
which type is TEXT. I cann't insert the value with AppendChunk. Here is part of my
code.
HRESULT hr;
_RecordsetPtr pRS;
_bstr_t G_CONNECTSTRING =
L"Persist Sec
1 - 100 of 113 matches
Mail list logo
