<%@ page import="java.sql.*" %>
Connection connection = null;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(
"jdbc:mysql://localhost/sherzodr_cdbaza?user=sherzodr_cdbaza&password
Hi All
How do i connect to mysql on a remote machine..
Is there any client tools available
Regards,
-Arul
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
> -Original Message-
> From: TH Leung
> Sent: Friday, June 14, 2002 11:55 AM
> To: '[EMAIL PROTECTED]'
> Subject: MyODBC 3.51 - Transaction is not enabled
>
> Hi,
>
> I have installed the newest version of MyODBC 3.51 in my PC with Win98,
> but do not install the MyOD
mysqld and msqladmin are completely nonfunctional.
mysqladmin does not parse ANY option (hence cannot run shutdown,
report status, etc.)
mysqld breaks on ALMOST EVERY option in my.cnf, and aborts with
"signal 11" when run from the command line with ANY OPTION, like
--datadir.
3.23.49 worked fi
Hi,
I have installed the newest version of MyODBC 3.51 in my PC with Win98, but
do not install the MyODBC 2.50. After I start the MySQL and open the
MySQLAdmin, the box titled "MyODBC" in the "Environment" page shows "Not
Found". However, all databases are shown on the "Database" page. Later when
In the last episode (Jun 13), Phil Reardon said:
> I've been trying to "select * table" as a way to review a large table
> in mysql. But only 1000 rows are returned, whereas there should be
> about 1200 rows in all. Is this a limitation in mysql? Is there a
> configuration file where it can be
I solved the problem, it was application problem.
but, Joseph, your method doesn't work
becos application is not continually logged in to the DB.
if the process is newly login, last_insert_id is 0
then the update will update the auto increment field to 0
becos select last_insert_id() returns 0.
I've been trying to "select * table" as a way to review a large table in
mysql. But only 1000 rows are returned, whereas there should be about 1200
rows in all. Is this a limitation in mysql? Is there a configuration file
where it can be reset to a higher value? Thanks in advance. Phil Rear
On Fri, 14 Jun 2002, [GB2312] ³Â׿ wrote:
> mysqlmysql 3.23.41
> phpMyAdmin 2.2.3
> os :Linux server 2.4.9-31
>
> In order to remove the first character '0' of the field 'number',
> I want to use the following sql query to select the field from my database.
>
> select right(number,
>if(locate(
Yes, I figured it out right after I posted that, doh!
-Original Message-
From: Bhavin Vyas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 11:09 PM
To: Jason Lane; [EMAIL PROTECTED]
Subject: Re: How can I get a top ten total count from a table?
I guess this is what you want:
I wish to do a query and inside that I wish to grab all records
That are before todays date/time
Would this work?
$now = date("YmdHi")
Select * from yadda where 'yadda_year,yadda_month,yadda_day,yadda_hour,yadda_min' <=
$now
---
I guess this is what you want:
SELECT count(*) as syscount FROM events WHERE alert='1' GROUP BY sysid ORDER
BY syscount LIMIT 10;
- Original Message -
From: "Jason Lane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 6:54 PM
Subject: How can I get a top ten total
This seems like a dumb question--sorry. Looking at my table it shows
'MUL' instead of 'PRI' like the other tables. Did I forget to code
unit_id as primary? Thanks, Justin
mysql> desc property_units;
++-+--+-+-++
| Field | Typ
I'm trying to retrieve the top ten entries of a total count from a
table. If I use the following select statement without the 'ORDER BY'
clause it returns the totals but not in any sort of order. But when I
add the 'ORDER BY' clause in it returns nothing.
Is there a way to structure the query to
mysqlmysql 3.23.41
phpMyAdmin 2.2.3
os :Linux server 2.4.9-31
In order to remove the first character '0' of the field 'number',
I want to use the following sql query to select the field from my database.
select right(number, if(locate('0',length(number))=1,length(number)-1,length(number)))
as '
- Original Message -
From: "MikeParton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 8:21 PM
Subject: [PHP-INST] Search Field
Environment:
Win NT 4.0 SP6a
Apache 2.0.36
MYSQL 4.0.1a
PHP 4.2.1
I'd like to create a search capability again
Monty:
Excellent idea.
Gerald Jensen
- Original Message -
From: "Michael Widenius" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Cc: "Gerald Clark" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 7:09 AM
Subject: Spams on MySQL mailing l
I have a rather longer query which I would like to get all records past todays date.
Here is my query
$ttwo = date("YmdGi");
$abc = "
select
detail.*,
type.type_name,
status.status_name,
staff.staff_name,
If you have mutli-date fields, can you set one date format in mysql sql
statement for all fields? I have 9 date fields, that like to have the same
format. Also I don't want it to work fields that have -00-, can I
tell not to show those?
---
Anyone know of any nice tools for porting a database from FileMaker Pro to MySQL? I've
searched around a bit, and haven't seen anything in the usual FMP places.
I think I could figure out moving the data, but I don't want to have to re-create the
schema if there's an easier way -- I've got 189
Thanks for the help. Got that to work no problem.
Mike
- Original Message -
From: "Harrison C. Fisk" <[EMAIL PROTECTED]>
To: "Mike" <[EMAIL PROTECTED]>
Cc: "mysql list" <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 5:48 PM
Subject: Re: Need Help with JOIN
> Mike,
>
> With the way
bin cai wrote:
>Hello,
>I am trying to help my friend to solver her problem.
>but failed. I need your help. Thanks in advance.
>I have a mysql database on my machine. the version is
>3.23.49.
>My friend is trying to get access to the database in
>my computer. She is working on another machine w
NW> Ooops, reserved word! Works great ;-)
NW> Any way to add something to it like "" or should I do that in my
NW> php?
concat() is your friend!
- Julie
--> Julie Meloni
--> [EMAIL PROTECTED]
--> www.thickbook.com
Find "Sams Teach Yourself MySQL in 24 Hours" at
http://www.amazon.com/exec
>> SELECT datefield, SUBSTRING(textfield, 1, 30) as description FROM
>> tablename WHERE id = 2;
single quotes around textfield...
- Julie
--> Julie Meloni
--> [EMAIL PROTECTED]
--> www.thickbook.com
Find "Sams Teach Yourself MySQL in 24 Hours" at
http://www.amazon.com/exec/obidos/ASIN/06723
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
> You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1
Ooops, reserved word! Works great ;-)
Any way to add something to it like "" or should I do that in my
php?
Many thanks g
Hi All,
some body knows mysql statistics:
# Programers in the world
# sites with MySQL database
# Companies to support MySQL
# sites in with MySQL database
Thanks for your help
Mario
-
Before posting, please check:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Julie Meloni declared
> Start with position 1.
>
> SELECT datefield, SUBSTRING(textfield, 1, 30) as description FROM
> tablename WHERE id = 2;
Hi again Julie and thanks for 'cross list' help!
The problem is not that, at least not fir
should it not be:
SELECT date, substring(text,1,30) as
string length starts at position "1". substring, therefore, would consider
the first character of the string as position 1, not 0.
- Original Message -
From: "Nick Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
On 14 Jun 2002, at 0:03, Nick Wilson wrote:
> SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id
> = '2';
You can't assume that MySQL is like Perl, PHP, or any other language
you may be used to. Note this: "For functions that operate on string
positions, the first position
Hi -
NW> I have a table (for example) with three cols 'id' | 'date' | 'text'
NW> I want to return just 'date' and the first 30 chars from 'text'
NW> I've tried this sql:
NW> SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id =
NW> '2';
Start with position 1.
SELECT datefi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all,
I'm having a spot of bother with the SUBSTRING() function, I don't think
I understand it properly...
I have a table (for example) with three cols 'id' | 'date' | 'text'
I want to return just 'date' and the first 30 chars from 'text'
I've t
hi all,
i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's
BerkeleyDB 4.0.14.
i note the "--with-berkeley-db" options in configure, but am stumped as to
if/how to allow support for the bdb 4.0.14 version. mysql (in configure,
acinclude.m4 & aclocal.m4) seems to limit to bd
Mike,
With the way you have it written below, all of the pic1_id, pic2_id,
pic3_id, and pic4_id must be equal (because they all equal pic.pic_id).
Since this wasn't true for any of the rows, that is why you were
getting no results.
To get each picture value seperately, you will have to do on
Hello,
I have 2 tables(pics and outings)
pics
pic_id, tinyint
path, varchar
outings
outings_id, tinyint
pic1_id, tinyint
pic2_id, tinyint
pic3_id, tinyint
pic4_id, tinyint
When i try to do a join like this
mysql_query("SELECT * FROM pics inner join outings on
outings.pic1_id=pic.pic_id and ou
Hello,
I am trying to help my friend to solver her problem.
but failed. I need your help. Thanks in advance.
I have a mysql database on my machine. the version is
3.23.49.
My friend is trying to get access to the database in
my computer. She is working on another machine with
tomcat server 4.0.
At 14:54 -0500 6/13/02, Gerald Clark wrote:
>CREATE TABLE X (FLD1 INT PRIMARY KEY);
>or
>CREATE TABLE X (FLD1 INT, UNIQUE(FLD1));
>
>UNIQUE applies to an index, not a field.
That latter statement is equivalent to the one he used.
The problem is that the column isn't declared NOT NULL.
Your PRIMAR
At 3:35 +0800 6/14/02, Andy Sy wrote:
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Andy Sy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Friday, June 14, 2002 2:45 AM
>Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
>
>
>> At 2:03 +0800 6/14/02,
On 13 Jun 2002, at 13:22, justin cunningham wrote:
> i found alter table properties drop bulletpoints; then, alter table
> properties add bulletpoints text not null after cities; in a book.
It's hard to tell for sure, but it seems that you may be using "row"
to mean what's generally called a
Hi Gary,
According to this from MySQL manual:
"2.5.5 Upgrading to Another Architecture
If you are using MySQL Version 3.23, you can copy the
`.frm', `.MYI', and `.MYD' files between different
architectures that support the same floating-point
format. (MySQL takes care of any byte-swapping
issue
>
> > SELECT * FROM myproducts ORDER BY sales LIMIT 11,10
> >
> > will show place 11 to 20
>
> Actually you want "LIMIT 10,10" for places 11 to 20, at least the way
> most people count places. The LIMIT offset starts numbering the
> records at 0, not 1.
>
> http://www.mysql.com/doc/S/E/SELE
Responding to my own post.
i found alter table properties drop bulletpoints; then, alter table
properties add bulletpoints text not null after cities; in a book.
I don't know what the low priority etc is for on the mysql manual.
Now I'm repopulating the data, this time first editing it in n
Justin,
delete from table_name where field = 'search criteria';
example:
delete from properties where some_field_in_properties = 'search criteria'
-Original Message-
From: justin cunningham [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 12:46 PM
To: 'mysql'
Subject: deletei
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib.
Put this in your .profile file or the global .profile file so that it's
executed evertime you log in.
- Original Message -
From: "Hoa Doan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 11:34
On 13 Jun 2002, at 21:36, Peter Romianowski wrote:
> SELECT * FROM myproducts ORDER BY sales LIMIT 11,10
>
> will show place 11 to 20
Actually you want "LIMIT 10,10" for places 11 to 20, at least the way
most people count places. The LIMIT offset starts numbering the
records at 0, not 1.
ht
How do I delete data from a table? I tried the man pages for delete and
replace but there not working. I have a table with 8 rows. The table
is called properties. The row is called bulletpoints. i tried deleting
and replacing the fuged data and sql says ok bla but when I select
bulletopints f
Err, I don't know what I was thinking.
You can simply do a select into dumpfile like:
select data from test where id=1 into dumpfile "/tmp/test2.gif";
That is designed for writing blobs to a file.
Harrison
Harrison C. Fisk wrote:
> The data isn't actually being corrupted. The problem here is
seems I may need to upgrade to .51, but as the server I am running on is
hosted and I may not be able to get them to install the latest mysql
version, I have come up with the following hack...
to recap my problem:
I am getting a corruption when I update a table that uses two fulltext and
one PK
CREATE TABLE X (FLD1 INT PRIMARY KEY);
or
CREATE TABLE X (FLD1 INT, UNIQUE(FLD1));
UNIQUE applies to an index, not a field.
Andy Sy wrote:
>- Original Message -
>From: "Paul DuBois" <[EMAIL PROTECTED]>
>To: "Andy Sy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
>Sent: Friday, June 14, 20
SELECT FROM MountainRanges ORDER BY MountainHeight DESC LIMIT 10
- Original Message -
From: "Yrjö Mäenpää" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 1:29 PM
Subject: Any way to make a "top ten" query?
> As there is no TOP operator nor nested selects in My
ORDER BY mountainheight DESC LIMIT10
Yrjö Mäenpää wrote:
>As there is no TOP operator nor nested selects in MySQL, I wonder if there
>still exists some clever way to make"top ten" type of a query , i.e. to
>select ten best selling products or ten highest mountains for example.
>
>thanks
>
>
>
[EMAIL PROTECTED] wrote:
>
> As there is no TOP operator nor nested selects in MySQL, I wonder if there
> still exists some clever way to make"top ten" type of a query , i.e. to
> select ten best selling products or ten highest mountains for example.
SELECT name, height FROM mountain ORDER BY he
[snip]
As there is no TOP operator nor nested selects in MySQL, I wonder if there
still exists some clever way to make"top ten" type of a query , i.e. to
select ten best selling products or ten highest mountains for example.
[/snip]
Have you tried
SELECT product, MAX(quantity)
FROM productTable
Couldnt you do. SELECT * FROM tbl ORDER DESC LIMIT 10
> As there is no TOP operator nor nested selects in MySQL, I wonder if
> there still exists some clever way to make"top ten" type of a query ,
> i.e. to select ten best selling products or ten highest mountains for
> example.
>
> thanks
>
>
>
Simply use LIMIT which is even more powerful than top, because you
cannot only select the top ten best selling products but the number
11 to 20 as well :)
Example:
SELECT * FROM myproducts ORDER BY sales LIMIT 10
will show the top ten, and:
SELECT * FROM myproducts ORDER BY sales LIMIT 11,10
w
Strange, there shouldn't be any difference between MySQL
query behaviour under Win2K or Linux or BSD or Win98. It
could be more to do with the version of MySQL you are
using.
- Original Message -
From: "bob" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 3:18 AM
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Andy Sy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 14, 2002 2:45 AM
Subject: Re: Why does Key==Mul in DESCRIBE TABLE for unique key?
> At 2:03 +0800 6/14/02, Andy Sy wrote:
> >mysql> CREATE TABLE X (FLD1
As there is no TOP operator nor nested selects in MySQL, I wonder if there
still exists some clever way to make"top ten" type of a query , i.e. to
select ten best selling products or ten highest mountains for example.
thanks
-
Hi
SELECT b.* //all fields from builder
FROM
builder b //define tables and aliases
, builder_category_link l
, category c
WHERE
(b.builderID = l.builderID) //linking builder to link table
AND (l.categoryID = c.categoryID)
mysqld.cc: In function `void* handle_connections_sockets(void*)':
mysqld.cc:2394: invalid conversion from `size_socket*' to `socklen_t*'
mysqld.cc:2460: invalid conversion from `size_socket*' to `socklen_t*'
make[3]: *** [mysqld.o] Error 1
I am using gcc-3.1 on Solaris 8(SPARC) and attempting to
Thanks for all the input:
My code was correct when I compared it to the responses I received. I'm
pretty new to mysql, so I was totally blaming my coding for the errors I was
getting:
This is what I found I will stop using Microsoft for development of
mysql. I was running the queries locally
The data isn't actually being corrupted. The problem here is that
SELECT INTO OUTFILE wants to escape all of the line breaks as to make it
easy to reimport the data using LOAD DATA INFILE. You could work
around that by setting the escape character using: FIELDS ESCAPED BY '';
The total query
Hello to all!
I am currently working on a GUI Application in Borland C++ Builder, and
must use an embedded MySQL server in it. I am having difficulties,
however, because whenever I create an instance, and destroy it, then
try to make another instance of an embedded server, the second time it
tri
At 2:03 +0800 6/14/02, Andy Sy wrote:
>mysql> CREATE TABLE X (FLD1 INT UNIQUE);
>Query OK, 0 rows affected (0.05 sec)
>
>mysql> DESCRIBE X;
>+---+-+--+-+-+---+
>| Field | Type| Null | Key | Default | Extra |
>+---+-+--+-+-+---+
>|
Hello there,
I have a problem that I need some help with. I am trying to insert binary
data into a mysql database and simply retrieve it. each time I retrieve the
data, it is corrupt. What am I doing wrong?
I am running mysql 3.23.41 on Red Hat Linux release 7.2 (Enigma) Kernel
2.4.7-10 on an
Thanks for you help so far.
I do have the libodbcinst.so.1. It's located in the directory
/usr/local/lib, but the program doesn't know that. How do I make it see
that libodbcinst.so.1 is in /usr/local/lib?
-Hoa
>From: Bhavin Vyas <[EMAIL PROTECTED]>
>To: Hoa Doan <[EMAIL PROTECTED]>, [EMAIL
The EMS HiTech company is very glad to inform you that today we uploaded the
MySQL Manager User's guide. It's a 58 page PDF document with pictures
contained detailed information about all the MySQL Manager features.
You can download this file from
http://www.mysqlmanager.com/download.phtml
The E
mysql> CREATE TABLE X (FLD1 INT UNIQUE);
Query OK, 0 rows affected (0.05 sec)
mysql> DESCRIBE X;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| FLD1 | int(11) | YES | MUL | NULL|
[EMAIL PROTECTED] wrote:
>The GPL has no such restriction.
>
>Mark R. Andrachek, Jr.
>Analyst I
>Federal Reserve Bank of Richmond
>[EMAIL PROTECTED]
>(804) 697-7971
>
>
>
>
>
>
>Francisco Reinaldo <[EMAIL PROTECTED]>
>06/13/2002 09:36 AM
>
>
>To: [EMAIL PROTECTED]
>cc: My
Nick,
ok, so that kills my working theory. Also, glad to see you have an ID field.
Upgrade your Linux MySQL server. I seem to remember a recent version being
compiled against a bad library or something and it was causing problems only
on the Linux version. The latest (.51) does not have this i
mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686)
i have been using both the mysql CLI and a php script using the
mysql_query() function.
here's how this error is being tested:
insert a record
(php) insert into Works (id,Title,Desc,HTML) values ('39b81e034','Test
123','','');
(php) ins
Hi Ralf,
yes, but which one? I expressed it poorly. Without a PK, you cannot delete
a SPECIFIC record. I'm unclear how even a FE using ODBC would be able to
identify and delete a specific record in these conditions. Unlike FoxPro and
(UGH) Access, MySql does not (to the best of my knowledge) m
[EMAIL PROTECTED] wrote:
>What version of MySQL?
>What interface are you using to execute the delete?
>
>How do you know you only deleted one of the records? From a CLI, without a
>PK, there would be no way to delete only one. Delete from Works where title
>= something would delete both of them
What version of MySQL?
What interface are you using to execute the delete?
How do you know you only deleted one of the records? From a CLI, without a
PK, there would be no way to delete only one. Delete from Works where title
= something would delete both of them.
=C=
*
* Cal Evans
* Techno-Mage
Actually, it might help if you install MyODBC
(http://www.mysql.com/products/myodbc/index.html) on the win32 machine.
Mark R. Andrachek, Jr.
Analyst I
Federal Reserve Bank of Richmond
[EMAIL PROTECTED]
(804) 697-7971
Francisco Reinaldo <[EMAIL PROTECTED]>
06/13/2002 10:37 AM
To:
The GPL has no such restriction.
Mark R. Andrachek, Jr.
Analyst I
Federal Reserve Bank of Richmond
[EMAIL PROTECTED]
(804) 697-7971
Francisco Reinaldo <[EMAIL PROTECTED]>
06/13/2002 09:36 AM
To: [EMAIL PROTECTED]
cc: MySQL <[EMAIL PROTECTED]>
Subject:
As Cal stated, there is actually a very important reason. MySQL is
lacking in fine-grained security. I can give a user the ability to add
databases. But can I give that user the ability to only drop databases
he/she created? I sure haven't found any documented method.
So, if you're in a larg
Hi, I don't want to get in the way, but I am experiencing similar issues. Here's the
problem I'm trying to find a resolution to:
We have one instance of MySQL (it was configured and installed once). This instance
has
one 'test' 'database', and one 'mysql' 'database'. The mysql database contai
- Original Message -
From: "Vandana" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 3:32 PM
Subject: What does the error mesg mean
>
> I am using mysql's C API in my program. I am using a connection to
> run many queries, but I am running these queries sequenti
sql query
once again...
I am using PHP.
i have a table (called Works) with two fulltext indices, one (Title) is a
varchar(64) and the other (Desc) is a longtext.
when there are two records having the same value in Title and I delete one
of the records i recieve the following result from "check
Hiho hiho!
bob wrote:
>Hi,
>
>I'm very new to mysql and I'm having a problem getting my joins to work. I
>have 3 tables:
>
>builder
>category
>builder_category_link
>
>The builder table has a an id field and then several other fields (name,
>address etc)
>The category table has an id field and t
> We are developing a benchmark (only querying) between
> MySQL, SQLServer2000, and Access 2000
> We are using as base, the Database propose by TPC.org (www.tpc.org)...
> With the records they propose and the indexes they proposed
>
> But for the testing we are using INNODB tables, with t
Hi,
I'm experiencing exactly the same problem than you.
For example, if I take phpMyAdmin and I want to add an index on a huge
table, after a while the phpMyAdmin page will be reloaded, and the ALTER
TABLE ADD INDEX reexecuted. (I can see then "ALTER TABLE ADD INDEX ..." on
the mysql processlist,
Hi,
I'm very new to mysql and I'm having a problem getting my joins to work. I
have 3 tables:
builder
category
builder_category_link
The builder table has a an id field and then several other fields (name,
address etc)
The category table has an id field and then one other field (type of
busines
This works for me:
> mv /mysql/log /mysql/Oldlog
> mysqladmin flush-logs
MySQL follows the oldlog, keeps writing to it until the flush, when it
closes its Oldlog,
and open/create-s its logfile.
Cheers,
Kent
-
Before posti
Hi!
I was going through some of the old emails on the MySQL mailing list
and noticed the many threads that discussed spams.
(There seemed to be more emails discussing spams than true spams, but
this is a separate issue).
We here at MySQL AB do a lot of work to avoid spam and we are working
on n
Hi.
I have a MySQL-server running Innodb. We have installed ~ 1.7GB of
memory in the server. In spite of this MySQL keeps crashing due to
out-of-memory errors. The server is a dual i686 running kernel Linux
2.4.18 (no patches - 4GB RAM supported).
I've enabled overcommit_memory (/proc/sys/vm/ov
We are developing a benchmark (only querying) between
MySQL, SQLServer2000, and Access 2000
We are using as base, the Database propose by TPC.org (www.tpc.org)...
With the records they propose and the indexes they proposed
But for the testing we are using INNODB tables, with the appropia
I'm using the mm.mysql JDBC Driver, and can log in just fine and select
from a table. When I do it programmatically through Java I get:
Error during query: Unexpected Exception: java.sql.SQLException message
given: General error: select command denied to user: 'user@host' for table
'LOGSQLSTATEM
At 16:39 +0200 6/13/02, Oliver Vecernik wrote:
>Hi,
>
>I imported a text file and got following results:
>
>mysql> load data local infile 'update.txt' into table PLZV lines
>terminated by '\r\n' ignore 2 lines;
>Query OK, 46658 rows affected (0.66 sec)
>Records: 46658 Deleted: 0 Skipped: 0 War
Also, if you initialise a TIMESTAMP field with NULL, MySQL puts the current
time into it - for the first such field in the record only. (p109 of Paul
DuBois book - sorry, www.mysql.com seems to have gone down so I can't get a
documentation URL).
Alec
> >Is there a way to have the timestam
At 08:59 AM 6/13/2002, you wrote:
>Hello,
> I am sure this is an easy question but I am not thinking clearly for
> some
>reason. :^)
>
> If you set a column to auto_Increment. You do not have to put the
>auto_increment # in the insert statement to get it to be inserted. Mysql
>does t
At 05:03 AM 6/13/2002, you wrote:
>Hello,
>
>Is there any database modelling tool for mysql?
Try Visiomodeler from MS. Download at
http://download.microsoft.com/download/visio2000enterprise/ORMtool/3.1/WIN98/EN-US/msvm31.exe.
Use ODBC to access MySQL. It can reverse engineer your MySQL database
Hi,
I imported a text file and got following results:
mysql> load data local infile 'update.txt' into table PLZV lines
terminated by '\r\n' ignore 2 lines;
Query OK, 46658 rows affected (0.66 sec)
Records: 46658 Deleted: 0 Skipped: 0 Warnings: 4
Where are the warnings stored? Can I find out
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
> I'm having some weirdness when inserting from the php api, I do not get
> the same results if I use the mysql server directly. Here is the code:
Please disregard. It appears to be some bizzare Apache/http thing,
Thanks a lot Chris for the tip, but that precisely
what I am trying to avoid so my users don't have to go
through import and exports. I am kind of lazy too and
I don't want to create an application to do that :-).
Wouldn't be nice that we could just copy the database,
modify permissions and go?
Hi Chris,
I am Tom, you know your manager, did you say that I am
wrong!!!
Just kidding :-).
Well I cannot find any good reason for having two
databases in two different instance. Do you have two
Oracles or Microsoft SQL Server instances in the
computer? Nope.
The only reason when that is accep
chad kellerman wrote:
>Hello,
> I am sure this is an easy question but I am not thinking clearly for some
>reason. :^)
>
> If you set a column to auto_Increment. You do not have to put the
>auto_increment # in the insert statement to get it to be inserted. Mysql
>does this automat
MySQL: 4.0.1 alpha
Computer: MAC iBook
OS: Mac OS X v10.1.2 (Darwin 5.1 or thereabouts)
memory: 384 M
Compiler: I am not sure what compiler I am using... It is the one
that comes in the MAC OS X developer tools cd.
Problem:I have been trying to run mysqld_safe, as instructed, but am
unable to
On 13 Jun 2002, at 2:07, Jeff Field wrote:
> I would like to have a column returned in a query that tells you which
> record I'm looking at? Sort of like an auto_increment? IOW, the
> query results would look like:
>
> record first last
>
> 1 johndoe
> 2 joe blow
>
Hi,
I have installed mysql 4.0 in redhat 7.2 now. I have two such servers with mysql on it
and I am now trying to configure them for replication.
1. I could not find my.cnf or my.ini on the box after installing mysql. Won't mysql
create those file during installation or do I need to create m
1 - 100 of 133 matches
Mail list logo
