On 13 Jun 2002 at 7:25, [EMAIL PROTECTED] forced electron
flow into:
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 the following words in your message:
sql,query
If you just reply to
On Thu, 13 Jun 2002, Patrick Hsieh wrote:
Hello,
I want to raise the max connections in mysql. Due to the linux limix
thread limitation, I can only increase the number to around 1024. How
can I break the limitation?
This is topic of glibc (assuming you are using kernel 2.4 at least).
Steve,
- Original Message -
From: Orr, Steve [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 3:27 AM
Subject: RE: MySQL/InnoDB Hot Backups - What's a binlog segment?
Thanks Heikki,
I knew about the binlogs but that segment word
Andy Sy a écrit :
In MySQL,
I want to use an auto-incrementing value that works
across multiple tables. For example I have 3 tables
forumA, forumB, forumC, each of which has a primary
key field called 'msgnum'. However, if I declare
'msgnum' auto_increment, 'msgnum' will not be
unique
hi all,
this will sound very stupid, but i guess it will be helpful to mysql newbies
like me.
Here's my Qu : What's the use of using indexes in mysql ? Why do we create
an index anyway ?
thank you,
regards
ally
-
Before
Maybe you should say
WHERE category LIKE 'Gambling'
- Original Message -
From: Jeff Field [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 11:42 AM
Subject: ENUM query question
I have a quick question regarding queries that involve values in ENUM
columns.
The volume on this list is so big that it desperately
needs to be available as a newsgroup. I was able to
find one on Google groups as mailing.database.mysql but
does anyone know of a publicly available NNTP server
which carries this?
See www.mysqlfront.de. This program will convert
Access databases to mySQL fairly painlessly.
- Original Message -
From: Wouter van Vliet [EMAIL PROTECTED]
To: N. Ott [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: Wouter @ Witbier [EMAIL PROTECTED]
Sent: Wednesday, June 12, 2002 3:26 AM
Consider the usefulness of a book's index. Instead of
scanning several hundred pages of text to find a particular
word you look at an alphabetical list that tells you the
locations in which the word is found. It's a lot faster, yes?
Here's my Qu : What's the use of using indexes in mysql ? Why
I've installed binaries files of mysql on my AIX 4, I've also intalled
zlib-1.0.4.0.bff, when I run mysqld daemon it return me an error:
I convert from italian language...
0509-036 Impossible load ./mysqld
0509-027 Cannot find ember shr.o
0509-022 Impossible load libz.a[shr.o]
can anyone to
Hello,
Is there any database modelling tool for mysql?
--
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.com/
-
Hello list!
While monkeying around with my testserver I noticedm
that giving goofy parameters to mysqladmin causes it
to segfault and dump core :
(haven't got mail configured on the server, so I
just snatched the info I thought was of importance)
bash-2.03# uname -a
SunOS simon 5.8
As far as I understand the concept of Open Source / GPL you don't need a
license for it if you do not alter the Code and/or provide the full
Sourcecode.
For example:
You develop a win32 application using MSVC++ that accesses a MySQL database
on a linux-server through ADO / ODBC.
You need
hi,
there is such a tool from thekompany (i think www.thekompany.com) but it
is commercial.
Am Don, 2002-06-13 um 12.03 schrieb Veysel Harun Sahin:
Hello,
Is there any database modelling tool for mysql?
--
Your favorite stores, helpful shopping tools and great gift ideas.
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
Hello Tonu Samuel [EMAIL PROTECTED],
Thanks, but my Debian woody did not install glibc package.
Should I get the package source, modify the PTHREAD_THREADS_MAX value
and rebuild glibc package for further installation?
On Thu, 13 Jun 2002 08:55:35 +0200 (EET)
Tonu Samuel [EMAIL PROTECTED]
Hello Tonu Samuel [EMAIL PROTECTED],
home:~# dpkg -l | grep libc
ii libc6 2.2.5-6GNU C Library: Shared libraries and Timezone
ii libc6-dev 2.2.5-6GNU C Library: Development Libraries and Hea
I think I have to rebuild one of them and reinstall the package again.
Try the Zeos Database Designer.
It could be pretty good, but unfortunatelly it's full of bugs, and there's
no newer version a long time ago.
http://sourceforge.net/projects/zeoslib/
At 13:03 2002.06.13.s +0300, you wrote:
Hello,
Is there any database modelling tool for mysql?
--
Your
Hello Tonu Samuel [EMAIL PROTECTED],
In my Debian woody, I found relative definition in
/usr/include/bits/local_lim.h
/* The number of threads per process. */
#define _POSIX_THREAD_THREADS_MAX 64
/* This is the value this implementation supports. */
#define PTHREAD_THREADS_MAX 1024
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
olinux --
...and then olinux said...
%
% check out this article and try a google search for
% database normalization.
Normalization, eh? That's come up in another response; time to go and
really learn what it means :-)
%
%
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 sequentially. There are
about 15 queries that I issue through this connection at different parts
of my program. It works successfully most of the times, but fails at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everyone,
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:
$qry=INSERT INTO news VALUES(NULL, NULL, \a value\, \b value\);
mysql_connect(localhost,
1 reason and 1 reason only. To speed up queries. The flip side of that is
if you have an index that is not being used by a query somewhere, get rid of
it.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: ally [EMAIL PROTECTED]
To: [EMAIL
try
tail -n 10 /mysql/why.log /tmp/why.log
echo /mysql/why.log
-Original Message-
From: Van [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 12, 2002 6:01 PM
To: Paul DuBois
Cc: MySQL
Subject: Re: Irritating Discovery
Paul DuBois wrote:
At 13:12 -0700 6/12/02,
Hi
I run mysql3.23.49/myisam with linux 2.4.18/libc2.2.5.
Some time ago I've hardware crash. Myisamchk didn't report
any problems but after some time mysql got SIGSEGV.
From that time mysql finished with SIGSEGV in the same place
a few times.
0x80cb554 handle_segfault__Fi + 428
0x40021f54 _end +
Hi,
I already got something similar.
it was a case where I made a call to mysql_query() but I never made the call
to mysql_store_result().
On the next call to mysql_query(), I was getting this error.
Frederic
- Original Message -
From: Vandana [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
ally,
Thursday, June 13, 2002, 10:59:00 AM, you wrote:
a this will sound very stupid, but i guess it will be helpful to mysql newbies
a like me.
a Here's my Qu : What's the use of using indexes in mysql ?
Indexes are used for query optimization. Rows in the table are
unodered and if there are
Nick,
Thursday, June 13, 2002, 12:14:16 AM, you wrote:
NB This is a new area for me, so it may sound like a stupid question, but
NB what do you mean by FULLTEXT indexes?
In MySQL you can use full-text search on varchar or text columns. You
can find more info in the MySQL manual:
* [EMAIL PROTECTED]
1 reason and 1 reason only. To speed up queries.
I would say there are three reasons to use indexes:
1) To speed up queries
2) To create constraints
3) To maintain a sort order
If you have an order table and an order_line table, it is important that
line no 1 only exists
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 automatically.
Is there a way to
This may not be entirely a database question, but it certainly involves
MySQL databases.
BACKGROUND:
I'm working with a small business that hosts their own web site for order
taking/managing orders via internet. It only consists of one DSL line, one
web server (apache/bind/tomcat) and one
Is there a way to have the timestamp automatically inserted when an
insert statement is run? The timestamp of the insert statement.
Try now()
Hisseine
- Original Message -
From: chad kellerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 9:59 AM
Subject:
Hi all
is it possible to perform a query which points out a record with a unique ID
and then return the previous record and the next record also?
I want to make 'show next' and show 'previous' buttons on my websitepage
showing the contents of the current record, and I'm looking for a clever
Hi,
I've been able to connect from an Windows XP to a HP
Solaris and LINUX. Make sure that you can ping the
UNIX computer from yours. Then replace the computer
name in the connection string (most of the time is
localhost) for the UNIX computer's ip address (you can
use the name if you have DNS
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
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
3
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
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
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
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?
-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,
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
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
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 this
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 timestamp
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 Warnings: 4
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
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
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
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
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
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
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,
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
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 then one
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
- 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 sequentially.
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
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
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:
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:
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
*
[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.
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)
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)
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
[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: MySQL [EMAIL
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|
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
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
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
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 |
+---+-+--+-+-+---+
| FLD1 |
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
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
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
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
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)
As there is no TOP operator nor nested selects in MySQL, I wonder if there
still exists some clever way to maketop ten type of a query , i.e. to
select ten best selling products or ten highest mountains for example.
thanks
-
- 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 INT UNIQUE);
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
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
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 maketop ten type of a query ,
i.e. to select ten best selling products or ten highest mountains for
example.
thanks
[snip]
As there is no TOP operator nor nested selects in MySQL, I wonder if there
still exists some clever way to maketop 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
[EMAIL PROTECTED] wrote:
As there is no TOP operator nor nested selects in MySQL, I wonder if there
still exists some clever way to maketop 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 height
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 maketop ten type of a query , i.e. to
select ten best selling products or ten highest mountains for example.
thanks
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 MySQL, I
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, 2002 2:45 AM
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
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
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
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.
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 AM
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:
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
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/SELECT.html
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
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, Andy Sy wrote:
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 PRIMARY
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.
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
1 - 100 of 130 matches
Mail list logo