>
> Please inform me how to load IMAGES INTO MYSQL TABLES.
You can do so with MySQL-Front - www.mysqlfront.de . Simply paste image from
clipboard into BLOB-Editor.
Greetings,
Ansgar
-
Before posting, please check:
http://ww
yes.
get MySQL/PHP Database Applications. by J. Greenspan and Brad Burger.
enjoy.
p.s. your hotmail email addy doesn't work.
At 2:03 PM -0300 6/21/01, Laura Lía Marcello wrote:
>I need to know if there is a way to create a searchable database that
>returns results as a web page...
>As you c
Does anyone know how to pass a variable from a page embedded with a .swf (flash)
object to a .php file for processing, and pass back the results to the same page
containing the .swf file?
Thanx in advance!
hello
Please inform me how to load IMAGES INTO MYSQL TABLES.
thanks
Palaniappan
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
LS.
This is the text i sent you, the text you have seen was a attachment
C:\mysql\bin>mysqld
Innobase: Assertion failure in thread 4294946135 in file M:
\mysql-3.23\innobase\
os\os0file.c line 187
Innobase: we intentionally generate a memory trap.
Innobase: Send a bug report to [EMAIL PROTECTED
Try "mysqldump -d database_name"...
On Fri, 22 Jun 2001, Juan wrote:
> Can I generate my Database Schema from mySQL? How?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
At 12:46 AM 6/22/01 -0300, Siomara Pantarotto wrote:
>MySQL is a database just like others:
>
>Oracle (Oracle)
>SQL Server (Microsoft - for large systems)
>Access (Microsoft - for small systems)
>DB2(IBM)
>etc...
>
>MDB, as I know, is the termination (extension) given to a database
I mean, the connecting string, what is the different
MySQL. Interbase SQL, ACCESS and MS SQL
is it the same, since, I have coded webstore by using ACCESS's MDB, but,
currently, we need to move to Lynex OS comes with mySQL installed in
server.. so, if program move to lynex, will it work properly?
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: my
And of course, right after I clicked send, I remembered reading about the
mysql gui client. I installed a copy, and it works great. I only had to
tweak it (options dialog) to use the socket name (/tmp/mysql.sock), rather
than it trying to use the IP address.
Regards
Rich
At 10:54 PM 6/21/01
Hi,
Can I generate my Database Schema from mySQL? How?
TIA,
Juan.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this threa
Someone was asking about GUI's for mysql and I saw a number of
responses. Unfortunately, in my case, mysql (on *nix) is limited to
listening to requests only on localhost (security), so I can't use any of
the windows clients.
Are there any gnome front ends to mysql? I'm looking for something
MySQL is a database just like others:
Oracle (Oracle)
SQL Server (Microsoft - for large systems)
Access (Microsoft - for small systems)
DB2(IBM)
etc...
MDB, as I know, is the termination (extension) given to a database generated
by MS Access.
For example: NorthWind.mdb (example
Hi!
We have started doing some rather large replace intos and inserts
(~3MB) using a client written in C. However, these queries are truncating
at around 100k. There is no error returend by the connection, but, the
error log does have errors such as these:
010323 11:15:19 Aborted connection
At 14:32 21/06/2001 -0700, Martin Tunggorono wrote:
Hi!
>Hi everyone,
>
>I'm kinda new with MySQL and I have a question about upgrading MySQL to a
>newer version on Windows 2000 OS. Is there any special command that I
>should run or should I just re-install the latest version 3.23.39. Will it
>ove
Yes, just stop the mysql service before you begin installation by running
something like
net stop mysql
from a command prompt.
> Hi everyone,
>
> I'm kinda new with MySQL and I have a question about upgrading MySQL to a
> newer version on Windows 2000 OS. Is there any special command that I
> s
I am running mysql-3.23.39 and I can't get it to use the tmpdir I specify.
Is there a minimum size it needs to be?
-
Gabe E. Nydick
Project Manager
ClubPhoto, Inc.
P - 408.423.6611
F - 408.557.6799
-
--
No, this isn't spam. I was publicly thanking someone for advice given. :/
On Thu, Jun 21, 2001 at 08:25:37PM -, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of th
phpMyAdmin is part of PHPTriad, which has MYSQL, PHP, and the apache
webserver. There is a windows binary avalible via download.com
- Original Message -
From: Alan Cox <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 9:38 PM
Subject: Re: gui
> I like webmin. htt
Forgot to add
Can connect from a different host by using both the hostname and FQN,
For example the name of the host with the mysql server is sparky.
>From sparky
-h localhost
-h sparky
-h [EMAIL PROTECTED]
All fail
>From another host both sparky and [EMAIL PROTECTED] let me in, and
Of cours
on 6/21/01 16:04, Van at [EMAIL PROTECTED] wrote:
> Angela Neff wrote:
>>
>> I have tried numerous methods as instructed in the mySQL listerserv e-mail to
>> get off this list
>> but am still on it. Can somebody help me out? I got 779 e-mails today.
>>
>> Thanks, Angela
>>
> Angela:
>
> It's
Hi everyone,
I'm kinda new with MySQL and I have a question about upgrading MySQL to a
newer version on Windows 2000 OS. Is there any special command that I
should run or should I just re-install the latest version 3.23.39. Will it
overwrite the old version automatically while preserving all the
I have made an Access 2000 application for a real-estate company.
My client will be exportign his Access data in a MySql database which will
produce dynamic HTML pages (with some scripting) in an ISP server. So, his
data will be published at the Internet, this way.
My client will need to just cl
> > is it possible to update fields of a table with values taken
> from another
> > table? Like this (illegal) command would do:
> > UPDATE b SET b.v = a.v WHERE b.id = a.id;
>
> Not yet.
>
> Multi-table deletes/updates are planned for MySQL 4.0, AFAIK.
Then I have to stick to the method I am cur
there is also a programme called JSPerm (JSP Enterprise relational manager)
search for it on google...
it's very good
-Original Message-
From: j.urban [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2001 10:36
To: Ricardo Striquer Soares
Cc: mysql
Subject: Re: gui
For the Windows platform,
on my box, apache is compiled with dso support (and php & many other
mods). is there any way to bring in mysql support with out having to
recompile apache or php. normally, i would just recompile php and
everyone would be happy, but i'm running a cobalt xtr, and recompiling
php breaks some of su
>Description:
MySQL Crashes with BDB Tables and replace into in some cases
>How-To-Repeat:
mysql> create table test (sessionid varchar(80) not null primary key, sessionval blob,
lastopen timestamp not null) type=bdb;
Query OK, 0 rows affected (0.88 sec)
mysql> alter table test
Hi fellow mysql'ers
Here my "simple" problem
I can connect to the mysql server host from any other host, but I cannot
from the host with the mysql server.
More detail
Mysql 3.23.30-gamma (yea I know I need to update it)
Example user is foo, password is bar
Columns_priv, func, and host are em
Nope.
On Thu, 21 Jun 2001 16:04:03 -0400, md <[EMAIL PROTECTED]> wrote:
>Is this the same alan cox who has been involved
>with the linux kernel for the last 5 years?
>
>Just checking...
>
>Mark Diener
>
>
>Alan Cox wrote:
>>
>> I like webmin. http://www.webmin.com phpMyAdmin is another good
on
check out mysqlfront. You can download it from download.com and it kicks
some major ass..
Matt "TrollBoy" Wiseman
Webmaster: Shoggoth.net
Site Designer: phpslash.org
The oldest and strongest emotion of mankind is fear,
and the oldest and strongest kind of fear is fear of the unknown.
-H.P. Lovec
> Just a couple of questions regarding indexes...
>
> Can I have multiple indexes on the same column?
Yes, but it's kind of pointless.
> Will this decrease performance when inserting?
Yes.
> Can you create and remove indexes after the creation of the table?
Yes.
---
You have some 'odd' options in your configuration
line...Have you tried using a 'simple' configuration to see if it will
buildproperly ? ./configure
--prefix=/apps/mysqlAre you in the "/apps/mysql" directory when you run
"mysql_install_db" ??(you should actually be typing "./bin/mysql_inst
For the Windows platform, have a look at urSQL --
http:/www.urbanresearch.com/ursql
You might also want to have a look at the MySQL documentation ("very
friendly" is a subjective and vague requirement):
http://www.mysql.com/doc/n/o/node_17.html
http://www.mysql.com/doc/S/E/SEC592.html
On Thu
I like webmin. http://www.webmin.com phpMyAdmin is another good one,
but I'm not sure where you can go to download it.
alan
On Thu, 21 Jun 2001 16:55:22 -0400, Ricardo Striquer Soares
<[EMAIL PROTECTED]> wrote:
>does enyone knows a GUI to use with mysql wich is verry friendly one?
>
>thanks ad
Angela Neff wrote:
>
> I have tried numerous methods as instructed in the mySQL listerserv e-mail to get
>off this list
> but am still on it. Can somebody help me out? I got 779 e-mails today.
>
> Thanks, Angela
>
Angela:
It's not:
Date: Thu, 11 Aug 1904 15:17:05 -0700
Might want to check
Just a couple of questions regarding indexes...
Can I have multiple indexes on the same column?
Will this decrease performance when inserting?
Can you create and remove indexes after the creation of the table?
Thanks... :)
---
Daniel Åkerud, [EMAIL PROTECTED]
---
does enyone knows a GUI to use with mysql wich is verry friendly one?
thanks advanced.
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
-
B
I am having a problem with mysql. I am running a php web site that uses a (mysql Ver
11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database. Whenever i get a load of
about 100 simultaneous users, mysql begins to spawn D stat processes and the site
dies. Everything works very well with smaller
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 3:31 PM
To: Aditya Dhekney; [EMAIL PROTECTED]
Subject: Re: mysql installation from source
I think mysql.sock gets created once you start the server. Have you tried
starting it and then looking i
-Original Message-
From: Steve Brazill [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 3:38 PM
To: Aditya Dhekney
Cc: [EMAIL PROTECTED]
Subject: Re: mysql installation from source
Could you list (exactly) what commands you are using to 'unpack',
'configure', 'build', and 'insta
Heikki,
> when you try to create the table test with type = innodb,
> does the server print into the error log or to the screen:
> Innobase: error: table test/test already exists in Innobase data
dictionary
Yes, indeed. I missed that line between all the stack backtrace output.
> If so, then yo
Could you list (exactly) what commands you are using to 'unpack',
'configure', 'build', and 'install' the distribution (which package have you
downloaded ?) ??
- Original Message -
From: "Aditya Dhekney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 12:19 PM
Su
I think mysql.sock gets created once you start the server. Have you tried
starting it and then looking in /tmp?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: "Aditya Dhekney" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, J
Hi,
I have been trying to install mysql on my server for way too long now! my
system specs are: intel i686, with linux 6.2 loaded.
I think i once did get the installation to work almost correctly, or at
least more correctly than it does now...
the problem: when i compile/make etc., i get no
On 21-Jun-01 Chris Petersen wrote:
>> here, @ids is the array, delete in chunks of 64:
>> while ( my(@id)= splice(@ids,0,64)) {
>> $qry="DELETE FROM master WHERE master_id in (".join(',',@id).")";
>> SQLQuery($qry);
>> }
>
> I thought about this, too.. But Mark said that he needed to delete
Well, I successfully solved our 2 gig file limit problem with RAID
tables without too much hassle, despite a dearth of documentation.
However, it has introduced another significant problem. It would seem
mysqldump isn't smart enough to look for raided tables. Taking the
server down to do night
Hi
I have installed/configured Oracle under HPUX, but
thinking of moving to mySQL. But finding that a
little difficult.
First of all, document talks about (including
throughout the Internet) a depot file (i.e.
mysql.full) to be run with swinstall utility. But I
have yet to find it.
I wa
I have just installed Suse Linux 7.1 and I am trying to configure the mysql
database on it.
I new that I was going to be using mysql on this system so I set it up with
its own filesystem. By default it is installed in /var/lib/mysql.
in this directory is the ./mustang-bin.index and also ./mysql/m
I am trying to get MySQL version 3.23.3x running on my AIX 4.3.3 system. I
have tried the following:
1. Binary distributions from bull and mysql sites. I get problems with
the readline shared libs on these distributions. I have the GCC versions of
readline install.
2. Source compiled w
On Thu, 21 Jun 2001, Laura La Marcello wrote:
> I need to know if there is a way to create a searchable database that
> returns results as a web page...
> As you can see, I'm just begining, so I would really apreciate an answer,
> even if it's short.
>
> Thanks!
Yes, but the web page will more
> here, @ids is the array, delete in chunks of 64:
> while ( my(@id)= splice(@ids,0,64)) {
> $qry="DELETE FROM master WHERE master_id in (".join(',',@id).")";
> SQLQuery($qry);
> }
I thought about this, too.. But Mark said that he needed to delete from the
table where the ID's don't match.
You'd probably be interested in PHP:
www.php.net
Tyler
- Original Message -
From: Laura Lía Marcello <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 12:03 PM
Subject: Connect mySQL with HTML or something
I need to know if there is a way to create a searchable d
just do:
mysqldump db_name > db_name.sql
Your database tables and contents will be dumped into db_name.sql
Tylre
- Original Message -
From: ah <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 21, 2001 12:19 PM
Subject: constraint question
> hi
>
> I am using mysql 3.2
I have tried numerous methods as instructed in the mySQL listerserv e-mail to get off
this list
but am still on it. Can somebody help me out? I got 779 e-mails today.
Thanks, Angela
Gerald Clark wrote:
> I don't recall you identifying the file you are installing from, but
> it sounds like a
I need to know if there is a way to create a searchable database that
returns results as a web page...
As you can see, I'm just begining, so I would really apreciate an answer,
even if it's short.
Thanks!
Laura Lía Marcello
Web Development
hi
I am using mysql 3.23.29 under windows 2000.I have a table:
create table
raries(
libID bigint NOT NULL AUTO_INCREMENT ,
lib_datsvrID bigint null,
primary key (libID),
constraint FK_LIBRAR_REF_584_DATASE foreign key (lib_datsvrID) refe
On Thu, 21 Jun 2001, you wrote:
> I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to
> the new version 3.23.39 what steps or precautions should I take when doing
> this.
> Do I just download the new RPM and run a "rpm -i MySQL-3.23.39-1.i386.rpm"
> and thats it or is ther
"Mike Jimenez" <[EMAIL PROTECTED]> writes:
> Do I just download the new RPM and run a "rpm -i MySQL-3.23.39-1.i386.rpm"
> and thats it or is there more to it?
"rpm -Uvh" should be used instead of "rpm -i", as this is an upgrade,
not install (the "vh" is added to be more verbose).
--
Trond Eivi
Thanks, Don. However, this is sort of the opposite of what we need. We
need to delete from master where master_id NOT IN the array. If we do that
in chunks, after the first chunk, we would have wiped out all of the records
outside the array.
It seems like with Chris's suggestion, along with B
Hello.
This is (only) changeable when starting the server:
> /usr/sbin/mysqld --help
[...]
--skip-name-resolve Don't resolve hostnames.
All hostnames are IP's or 'localhost'
[...]
Bye,
Benjamin.
On Thu, Jun 21, 2001 at 12:52:30PM +0200, [EMAIL PROTECTED] w
I don't recall you identifying the file you are installing from, but
it sounds like a source file, not a binary file.
Michael Kirschenbaum wrote:
> That did not work. I am doing a clean install by following the
> instructions from http://www.mysql.com/doc/I/n/Installing_binary.html.
> Did I mis
I currently have MySQL-3.23.38-1.i386.rpm installed and I want to upgrade to
the new version 3.23.39 what steps or precautions should I take when doing
this.
Do I just download the new RPM and run a "rpm -i MySQL-3.23.39-1.i386.rpm"
and thats it or is there more to it?
Thanks
Mike
--
Hallo Jason,
my problem is that the mysql 'auto_increment' behaviour
will increase the 'sequence' always to the maxnumber +1.
We now have p.e. a table with customers.
Every new customer will of course get a customer_id.
We now have 2 different id_ranges.
Some customers should get their id ran
Hello.
mysql_store_result stores the result set in a linked list (for memory
efficiency). With older versions mysql_data_seek always starts from
the beginning of the list and therefore has an O(n) complexity even
for sequential traversal.
IIRC, this was fixed with newer MySQL client libs, you ei
On 21-Jun-01 Craig Atkins wrote:
> Hello,
> _
> I am a little stumped on how to create the select statement that I need.
> _
> I have a_table of items, with a column called price, which contains a
> price in Spainish Pesetas.
> I have another table, with 1 record, that contains an 'exchange rate'
On 21-Jun-01 Sebastiaan J.A. Kamp wrote:
> As I tried to find out how many entries are written to a 'log' table in the
> past 10, 5, 2 and 1 minute(s), I got some odd results. Since I haven't been
> able to find any reason (NOW()-60) should result in something completely
> different from (NOW()-1
You need to have log-slave-updates in my.cnf
On Thu, Jun 21, 2001 at 11:14:54AM -0400, Brian Reichert wrote:
> I hope I've merely misread instructions.
>
> I've successfully set up replication, a master to one slave.
>
> However, even though the slave was comfigured to maintain both a
> 'class
Hello,
We are using mysql 2.22.32 (yes antique, but ISPs)
I need an sequence table.
Every time a client reads, the value shall be incremented.
A single row, integer value would be an ideal sequencen I think.
CREATE TABLE sequence(
id int4;
);
now, is this the correct way to emulate a sequ
On 21-Jun-01 Chris Petersen wrote:
> Why not do something like:
>
> my $q = "DELETE FROM master WHERE master_id NOT IN (";
> $q .= join(',', @masteridarray);
> $q .= ')';
> $dbi_dbh->do($q);
>
> Though this will obviously fall into the same size limitations that you were
> doing
At 10:54 AM -0400 6/21/01, Peter H. Burris wrote:
>Lately, I have been suffering the winds of misfortune with respect to user
>AND root password acceptance. It seems I have granted the root password
>correctly finally, but to date, though the SQL syntax gets accepted for
>changing the user passwo
That did not work. I am doing a clean install by following the
instructions from http://www.mysql.com/doc/I/n/Installing_binary.html.
Did I miss something?
-Mike
-Original Message-
From: Sebastiaan J.A. Kamp [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 10:13 AM
To: Michael
Is there a way to relate the items table to the exchange table? i.e. does
your item have an excahngeID? (probably not) Does you item have a FK
relationship into a Vendor/Mfgr who has a FK into exchange? (this would make
more sense.)
If so, we can probably figure it out, If there is no way to rel
Wouldn't something like this work?
SELECT a.price AS pesetas_price, b.rate AS exchange_rate,
ROUND(a.price*b.rate) AS pound_price
FROM prices AS a
LEFT JOIN rate AS b ON 1 = 1
--
Aigars
- Original Message -
From: "Simon Green" <[EMAIL PROTECTED]>
To: "'Craig Atkins'" <[EMAIL PROTECT
I hope I've merely misread instructions.
I've successfully set up replication, a master to one slave.
However, even though the slave was comfigured to maintain both a
'classic' update log, as well as a binary log, none of the stuff
it's replicating are reflected in the logs. Said logs are creat
Hi
If I am right you can not do this in one move..
You can use temp tables to help thow
Hope this helps a bit
Simon
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: 21 June 2001 15:48
To: '[EMAIL PROTECTED]'
Subject: Creating the correct SQL statement
Hel
Lately, I have been suffering the winds of misfortune with respect to user
AND root password acceptance. It seems I have granted the root password
correctly finally, but to date, though the SQL syntax gets accepted for
changing the user password, the user can not log in WITH the -p switch;
she CA
Hello,
I am a little stumped on how to create the select statement that I need.
I have a table of items, with a column called price, which contains a
price in Spainish Pesetas.
I have another table, with 1 record, that contains an 'exchange rate' to
convert Pesetas to Pound Stirling. ( divide
"show tables" returns only small letters "tab1 , tab2" but in the database all tables
are wir big letter "Tab1, Tab2"
the linux version works all right...
but this ist a realy problem. that the reasan ,i think, that the revoke not works
correkly
If i set a Col - Right or a Tab Right , it
Hello Delphi/C++Builder developers,
1. MySQLDAC v.1.3.3 (MySQL Direct Access Components for
Delphi/C++Builder) just released. Download:
http://www.microolap.com/trials/md.zip
2. Support mail lists:
http://www.microolap.com/newsletter.htm
You are welcome!
---
Best regards,
Edward Smirnov
micro
when using gui passes my whole address = '[EMAIL PROTECTED]' and I only need
the user name "sti" to be sent
therefore I get the message shown below.
Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
ok, good call :)
Ran the mysql-test (it failed some), details below:
FAILURES:
$>./mysql-test-run --force 2>/dev/null | grep "\[ fail \]"
rpl01 [ fail ]
rpl04 [ fail ]
rpl07
Seems your installing on a Linux / Unix system...
In te directory where your mySQL setup (such as mysql_install_db) is, run
"make install" ... just type it at the command line.
F.Y.I.: read 'man make'
> I am trying to set up a server. When I try to run the file
> mysql_install_db
> I get the e
> Hi. Can anyone tell me how this [viz. compiling MySql on Windows] is
done? There doesn't seem to be any
> documentation on how to do this under Windows, and when I tried running
> the make_all batch file, it didn't seem to work with my version of
> nmake.
>
> Does anyone have any guidance - wha
I am trying to set up a server. When I try to run the file
mysql_install_db
I get the error message "You need to do a 'make install' before
exectuing the script." Does anyone know what I should do? Please
help. Thanks.
-Mike
--
On Wed, 20 Jun 2001 15:22:22 -0700
"Ryan Knopp" <[EMAIL PROTECTED]> wrote:
> I'm trying to use the Full text Search with the japanese language using
> either doublebyte or singlebyte character. The problem is it doesn't
> seem
> to be working at all for any searches. I use a sql statement like t
find / -name mysqld -print
should tell you where it is.
locate mysqld may work also.
Guillaume Denizot wrote:
> I have installed mysql 3.23.39 on Linux Mandrake 8.0.
> I have created a database but today I can't execute safe_mysqld.
> Mysql tell me:
> << The file /usr/local/mysql/libexec/mysql
wendorf, pat writes:
> I'm not entirely familiar with how the daemon stores these values for the
> entire database, but I'm guessing it's done in memory. Is it not possible
> to allocate storage for these values in memory for each table that has been
> opened?(they'd be removed once the table is
The idea is to have backups.
Backups of unchecked data are not useless.
Backups of truncated data files are.
People have lost data when the disk became full during isamchk, or the
index had been crashed because it reached filesystem size limits.
If you blow the data away with a failed [my]isamch
Unix:
Create a cron job that executes a shell script to do it.
Win:
Create a scheduler job that runs a batch file.
You should be able to write a generic SQL statement that deletes all records
older than X time units. Your shell script/batch file should call mySql and
pump the script into it.
(i
As I tried to find out how many entries are written to a 'log' table in the past 10,
5, 2 and 1 minute(s), I got some odd results. Since I haven't been able to find any
reason (NOW()-60) should result in something completely different from (NOW()-120),
could somebody clarify what's going on her
How can i set a date or a number of seconds/hours/minutes/days, after the date
expired, that mysql deletes the entry. I want a entry that is only shown a week, after
the wekk the entry should be deleted.
Is there a way?
Hello,
Where can I find a table that compares between MySQL data types and java types.
Is there a table in the documentation? If there is, where can I find it?
Thanks
Meital
Greg Cope wrote:
>
> Dear All
>
> I want to bind mysqld to one IP address on a multi-homed host.
>
> A search of the manual has not revealed anything - have I missed
> something or is this not an option ?
>
> If its not an option can it be added ?
>
> Thanks
>
> Greg
>
Hi,
You can do that
Please run mysql-test and sql-bench in order to verify that all is
working well.
Please let us know the result.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/
My name is Thanatip Tantulavanich.I study computer sience
Burapha University in Thailand.
I do the Project to topic Sort Thai Language in MySQL.I can
Sort Thai Language but I don't know module for Sort in MySQL.If I
command order by for sort Thai-database.
Project for use
database
Hi there
Is there anyway to see what tables are locked and by who? I have a problem
where tables are locked but I am not sure who or why they are.
Thanks
Warren
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd t/a RedTie
Durban, South Afr
database
Hi there
I remember seeing somewhere that there is a way to skip resolution of names
when conneting to the DB, can someone tell me how. I can't seem to find it
in the manual.
Regards
Warren
~
Warren van der Merwe
Software Director
PRT Trading (Pty) Ltd
Dear All
I want to bind mysqld to one IP address on a multi-homed host.
A search of the manual has not revealed anything - have I missed
something or is this not an option ?
If its not an option can it be added ?
Thanks
Greg
---
My code generates a large query. I had to increase the size of
"max_allowed_packet" so that this query would work.
I have this in my /etc/my.cnf file:
set-variable = max_allowed_packet=2097152
-bill
-
Before posting, please
1 - 100 of 107 matches
Mail list logo
