Heikki Tuuri wrote:
Kannan,
please upgrade to 3.23.49a or 4.0.1.
101 used to mean lock wait timeout. It has been replaced by a
clear-English error code.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com
hii all,
I want to knowledge about blob.
how can write or read image(jpeg,gif or tiff) to/from MYSQL database by
using Visual C++. MySQL++ seems too confused.
Can any body say me more basic and understandable way to do this..
Thanks...
Ibrahim Kivanc Cihan
Anadolu University -
Dear friends,
I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my
/usr/local directory and uncompressed it.
Now I can get the target directory but I don't know how to start the server.
I tried:
./bin/safe_mysqld --user=root
but it doesn't work for me.
Any help is
On Wed, Apr 03, 2002 at 05:18:30PM +0800, Hammer wrote:
Dear friends,
I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my
/usr/local directory and uncompressed it.
Now I can get the target directory but I don't know how to start the server.
I tried:
Hello
I am trying to configure mysql on solaris 2.6
when I run the configure command I use
./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql
--enable-thread-safe-client --with-mysql-user=mysqldba
configure reports back the following error
configure: error: No
usr/local/mysql/bin/safe_mysqld --user = mysql
or ./safe_mysqld --user = mysql
Have a look at /mysql/bin/var/hostname.err.log
Hope this helps
Simon
-Original Message-
From: Hammer [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 10:19
To: [EMAIL PROTECTED]
Subject: How to start the
Check out http://www.mysql.com/doc/I/n/Installing.html.
BTW, are you downloading the binary distribution or source distribution?
Hammer wrote:
Dear friends,
I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my
/usr/local directory and uncompressed it.
Now I can get
Hi,
See linuxconf, mysql is installed as a service which can be started
manually or automatic via linuxconf.
JvD
[EMAIL PROTECTED] 3-4-02 11:25:19
On Wed, Apr 03, 2002 at 05:18:30PM +0800, Hammer wrote:
Dear friends,
I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file
Have you got your LD_LIBRARY_PATH set correctly?
Andrea Soracchi wrote:
Hello,
I have a Sun Os 5.8 with gcc version 2.95.3.
When i try to compile mysql with the following command:
CC=gcc CFLAGS=-O6 CXX=gcc
CXXFLAGS=-O6 -felide-constructors -fno-exceptions -fno-rtti
./configure
you need to set LD_LIBRARY_PATH.
MySql Dba wrote:
Hello
I am trying to configure mysql on solaris 2.6
when I run the configure command I use
./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql
--enable-thread-safe-client --with-mysql-user=mysqldba
My DB has many update queries and a few select queries.
Sometimes select queries take very long time so update can't
proceed. I can kill the select query manually. But I can't check
the status all the time.
Are there any ways to kill slow query automatically? If you know,
please let me know.
-Original Message-
From: pwxgao [mailto:[EMAIL PROTECTED]]
Subject: PERL/SQL, again? - Re: Procedures
I have been using languages like Smalltalk, Perl and Java for
about xx years. I am a huge fan of putting one in the DB for
embedded server procedures.
I also beleive the best
On Wed, 3 Apr 2002 19:28:13 +0900
°í¼ø¹Î [EMAIL PROTECTED] wrote:
My DB has many update queries and a few select queries.
Sometimes select queries take very long time so update can't
proceed. I can kill the select query manually. But I can't check
the status all the time.
Are there any
Dicky Wahyu Purnomo wrote:
On Wed, 03 Apr 2002 18:53:00 +0800
Adrian Hoe [EMAIL PROTECTED] wrote:
Hi,
My department is migrating our application from MySQL-3.22.x to 3.23.49.
I am
interested in the new replication function and I have question about
using this replication
On Wed, 03 Apr 2002 19:19:36 +0800
Adrian Hoe [EMAIL PROTECTED] wrote:
Dicky Wahyu Purnomo wrote:
We are planning to migrate (to be precise).
Where can I find the documentation on setting up replication? I could
not find any or I may have overlook.
well you can find on MySQL
Hi,
When I try to install the Msql-Mysql module it throws up a list of
questions.One of them is :
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local]
I had installed MYSQL 3.23.49a using the rpm technique.I checked out in my
/usr/local
From: David McInnis [EMAIL PROTECTED]
Could you share your script for doing the date thing with the rest of
us? That sounds useful.
Isn't there a perl script around for backuping?
Something like:
mysqldump DB --add-drop-table --opt \
|gzip DBdump.`date +%Y-%m-%d`.gz
should even
Hi all,
I want to get the difference between 2 tables.
table_1:
column_1
A
B
C
D
table_2:
column_2
B
C
What is the sql select syntax to get as result A,D or B,C?
Thanx for your help.
Regards,
Bernd
-
Before
You can try something like this:
DateDir=Directory where you want your backups saved
print $output-printheader;
my ( $sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst )=
localtime(time);
$year = $year + 1900;
$mon++;
mysql select table1.* from table1
LEFT JOIN table2 ON table1.column_1=table2.column_2
where table2.column_2 is NULL;
try this to select row of table 2 not in table 1, i think.
Hi all,
I want to get the difference between 2 tables.
table_1:
column_1
A
B
C
Hi David,
On Wed, Apr 03, 2002 at 02:10:03PM +0200, David yahoo wrote:
mysql select table1.* from table1
LEFT JOIN table2 ON table1.column_1=table2.column_2
where table2.column_2 is NULL;
try this to select row of table 2 not in table 1, i think.
Yes, it's working.
I have :
mysql select version();
+---+
| version() |
+---+
| 4.0.2-alpha-debug |
+---+
1 row in set (0.00 sec)
But an error too :
mysql delete
- from
- externallink as link,
- topic as topic,
- topiclink as joiner
-
I search mySQL-MAX on the mySQL web site and just found mySQL binaries (not
mySQL-MAX binaries). Is InnoDB table handler compatible with HPUX (10.20 or
higher) ?
Friendly.
-
Before posting, please check:
Description:
When using a replication between two MySQL servers (v3.23.48) on FreeBSD the
ALTER TABLE command is not replicated. It is present in the bin-log, but the slave
seems to ignore it. This seems to be fixed in MySQL version v4.0.1
How-To-Repeat:
Set-up a replication
Hi,
There is no way to kill slow queries autmatically unless you were to
write a script (maybe in perl or php?) to do this job. I have a
similar problem and am thinking of replicating the database just to
avoid this problem. I would then direct certain type of queries to
the replicated
My best code is this:
SELECT SUM(invoice_amount), state, statement_date
FROM invoice
GROUP BY state, statement_date
The results are have followed:
+-+---++
| SUM(invoice_amount) | state | statement_date |
From: Danis Stéphane (NHQ-AC) [EMAIL PROTECTED]
My best code is this:
SELECT SUM(invoice_amount), state, statement_date
FROM invoice
GROUP BY state, statement_date
The results are have followed:
snip
The main problem is the layout and the order of the results set. I will
have
9 state
I don't know about making 100 tables for 100 users, that doesn't sound
like a good idea to me. Not that it won't work, it will work, but if you
ever have to change the structure of your database due to a program
change
on the client end, you have to change 100 tables.
I wrote something that goes
Hi,
would anyone please explain me what are these error messages?
020327 12:29:26 mysqld started
020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
/usr/local/mysql/bin/mysqld: ready for connections
/usr/local/mysql/bin/mysqld: ready for connections
020327 12:29:26 Error in
Howdy All -
I am using MySQL 3.23.46-Max under Red Hat 7.2
I am trying to use DECIMAL type columns to work with huge numeric (monetary)
values.
I figured out how to get large numbers into DECIMAL types by passing them as
strings:
mysql insert into khtest set k1=1,t1=123456789012345678.10;
Stéphane,
Answers:
There are nine different states (and there are 12 months).
*
The main problem is the layout and the order of the results set. I will
have
9 state (provinces) and I would prefer the month to be the columns. The
ideal results would look like this, Please note I have only
Lee,
Tuesday, April 02, 2002, 8:54:44 PM, you wrote:
LPR I just installed MySQL 3.23.49 on NT and executed the following
LPR commands:
LPR UPDATE USER SET password=password(test1) WHERE host=localhost;
LPR UPDATE USER SET password=password(test1) WHERE host=%;
LPR Now, after doing
David,
Wednesday, April 03, 2002, 3:30:52 PM, you wrote:
Dy I have :
Dy mysql select version();
Dy +---+
Dy | version() |
Dy +---+
Dy | 4.0.2-alpha-debug |
Dy +---+
Dy 1 row in set (0.00 sec)
Dy But an error too :
Dy mysql delete
Dy
João,
Monday, April 01, 2002, 9:12:04 PM, you wrote:
JPV Hello everybody,
JPV I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I
JPV get the following error:
JPV [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
JPV myisamchk: error:
Murali,
Wednesday, April 03, 2002, 1:55:57 PM, you wrote:
MP When I try to install the Msql-Mysql module it throws up a list of
MP questions.One of them is :
MP Where is your MySQL installed? Please tell me the directory that
MP contains the subdir 'include'. [/usr/local]
It looks like in
Bernd,
Wednesday, April 03, 2002, 2:42:33 PM, you wrote:
BM I want to get the difference between 2 tables.
BM table_1:
BM column_1
BM A
BM B
BM C
BM D
BM table_2:
BM column_2
BM B
BM C
BM What is the sql select syntax to get as result A,D or B,C?
Look at JOIN clause:
Jane,
Wednesday, April 03, 2002, 12:27:33 AM, you wrote:
JT We have encountered the problem to install Mysql-3.23.49 version on Linux
JT Redhat 7.1.
JT 1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed.
JT 2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compressed
JOUANNET,
Wednesday, April 03, 2002, 3:32:25 PM, you wrote:
Jeoen I search mySQL-MAX on the mySQL web site and just found mySQL binaries (not
Jeoen mySQL-MAX binaries). Is InnoDB table handler compatible with HPUX (10.20 or
Jeoen higher) ?
You can compile it from the source according to the
I am running Windows XP with MySQL running as a service. When I want to
run MySQL with the option for logging (--log -bin), I have to start the
service MANUALLY and type the --log -bin in the parameters box each time I
restart the server. Is there an easier way to do this?
Thx,
Craig
Actually, I like this proposal of being able to plug in any language into
MySQL. I also want to make a note that Greg Cope has a very good point.
I believe it to be good to be able to plug in any language, but the mySQL
community may want to make a standard recomendation of a certain language.
On Wed, Apr 03, 2002 at 06:10:02PM +0300, Egor Egorov wrote:
: Murali,
: Wednesday, April 03, 2002, 1:55:57 PM, you wrote:
You know, I don't meant to be a bother, but can you folks at Ensita
reply to the list using standard reply conventions? All of your
replies
Jane,
Probably u downloaded the file on your windows box and ftp'ed it using
ascii mode instead of binary as Egor has suggested.
-Prakash.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:40 PM
To: [EMAIL PROTECTED]
Subject:
Hi, pwxgao
I will suggest to use JBuilder6 EnterpriseEdition and
Borland Enterprise Server. You will be able to build EJB(CMP2.0),
which can persistent blob column, very easily without coding. :-)
pwxgao wrote:
I also interestig in this topic...I wanna know how to save a blob object ,
I seem to be having issues with the way MySQL names
the table files under Unix and WinXP. I'm not sure if it's a
mysql issue or a windows issue.
Normally, when I create tables in MySQL, I like to capitalize the
first letter. Under unix, it all works fine and dandy. But under
WinXP, the table
I didn't have time to try out your hints/techniques described in your
earlier post, but after playing around a bit with the web frontend I decided
that it would be more user intuitive to used the month as column and the
state as row... The reason being my change of heart is I also have a similar
Russell E Glaue wrote:
Actually, I like this proposal of being able to plug in any language into
MySQL. I also want to make a note that Greg Cope has a very good point.
And going from what Greg mentioned in an earlier e-mail in this thread,
the embedded language of choice really needs to be a
Hi, how do I do the following:
I have a table I have added a new field to, I want to take field X and copy
it to the new field for each record. What should this query look like?
Thanks,
Chuck
-
Before posting, please check:
How can I connect to a distant MySQL Server -using tcp/ip- securely ?
Thanks
Stéphane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
MySQL version 3.23.32
(please don't ask me to upgrade to the newest version of mysql as an answer)
Everytime the replication server gets reset, the slave properties gets all
messed up
I am assuming the master.info gets trashed
Is this a known issue for this version?
Anyways, I can use the
Hi All,
I am trying to install DBD for mysql on linux machinein the process
when i did
make test i am getting the below error messages...
Could any one kindly help me in getting out of this??
Please refer the procedure to install Perl DBD module from source thru the
below link...
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:10 AM
To: [EMAIL PROTECTED]
Subject: copying field x to field y for each record in table
Hi, how do I do the following:
I have a table I have added a
Hi!
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, April 03, 2002 9:00 AM
Subject: Re: Replication and transaction questions
On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote:
...
2) why are creations of
At 10:10 -0600 4/3/02, Chuck Barnett wrote:
Hi, how do I do the following:
I have a table I have added a new field to, I want to take field X and copy
it to the new field for each record. What should this query look like?
Thanks,
Chuck
UPDATE tbl_name SET y = x;
Humph. Undocumented CHANGE MASTER TO MASTER_CONNECT_RETRY=60;
Still asking the other question if there is a fix for the problem or not...
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:37 AM
To: MYSQL-List (E-mail)
Subject: Replication
Am Mittwoch, 3. April 2002 18:10 schrieb Chuck Barnett:
Hi, how do I do the following:
I have a table I have added a new field to, I want to take field X and copy
it to the new field for each record. What should this query look like?
UPDATE yourtable set newfield=x
Regards
Georg
Chuck,
Wednesday, April 03, 2002, 7:10:16 PM, you wrote:
CB Hi, how do I do the following:
CB I have a table I have added a new field to, I want to take field X and copy
CB it to the new field for each record. What should this query look like?
UPDATE table_name SET y=x;
CB Thanks,
CB Chuck
update table
set newfield = oldfield
- Original Message -
From: Chuck Barnett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 6:10 PM
Subject: copying field x to field y for each record in table
Hi, how do I do the following:
I have a table I have added a
i am running a basic install of mysql version 3.23.49-log and i have a
pretty simple query that is not fast enough for my needs. any thoughts on
optimization would help.
the table description is below:
mysql desc RADPOOL;
++--+--+-+-++
|
One thing to consider with Perl is that perl 5 and perl 6 are totally
different beasts.
Perl 6 is built on top of parrot, a general purpose register based virtual
machine which is optimized to execute perl and similar languages. There are
already a small test language running on top of parrot
its a permission issue.. do
grant ALL on *.* to root@localhost ..
-Original Message-
From: Pramod Chowdavarapu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: Problem while installing DBD for mysql on linux.
Hi All,
I am
Note also that by doing this, your database will be denormalised. This may
not be a big deal, however.
On Wednesday 03 April 2002 9:55 am, you wrote:
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03,
That assumes you believe the myth that Java is really the language of choice
in the back rooms of large enterprise IT shops. It isn't. In the financial
industry perl is ubiquitous. Upper management will tell you Java is god, but
if you actually look at the deployed systems that are out there
-Original Message-
From: Russell E Glaue [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 7:15 AM
...
Does anyone on this list have a suggestion as what might be the best
language to embed into MySQL? Be sure to consider memory efficiency,
threadding, speed of the
MySQL Manual | 4.1.2 my.cnf Option Files MySQL Manual [2621454]
MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts
4.1.2 my.cnf Option Files MySQL can, since Version 3.22, read default
startup options for the server and for clients from option files. MySQL
reads default
Hi,
When I do a make test for msql-Mysql-modules-1.22.19,two of the tests are
failing.They are
akmisc.t and mysql.t
It also says :
make[1]:*** [test_dynamic] Error 29
make: *** [test] Error 2
Can anyone pls help me with this.I have been trying for hours to fix
this.
Thanks
Prakash.
Hello everybody,
I have a problem inserting a text from anywhere (application,console,
doesn't matter) into a [char][varchar][text] field type. If I try to
insert eg: 'hello_there.txt' in a field ot type I enlisted above ,when I
read that field i get 'hello\_there.txt' and that is a big problem
Hi,
I am trying to store a .gz file in a BLOB field in a mysql database. I have
tried two commands :
1. Insert into mytable values('1', 'file1.gz');
2 Insert into mytable values('1,','\'file1.gz\'');
These two commands just store the name of the file in the BLOB field instead of
the content of
I've been reading the docs but I just want to verify. It seems like the
latest version of MySQL support transactions and referential integrity. Is
this correct? Does MySQL now also support stored procedures?
Thanks,
Kevin
-
Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
How-To-Repeat:
this happens
Alright, I've got a little bit of a problem with this query.
This is what the current query looks like ( I know I'm doing it wrong, I
just don't know how to fix it.. I'm not that familiar with the LEFT
JOIN/subquery stuff.. )
select cluster.cid, cluster.isp, cluster.country_id-20 as
Hello everyone, I have the following line in my create table code:
SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
SCAN_PARAMETER(SCAN_PARAM_ID)
I need to make it so that scan_param_id references to two differences tables? Will
this work?
SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
sql,query
I have two tables which are exactly alike. What I want to do is copy an
entire column(DESCRIPTION)from one table(ebooks2) and put that information
into the other table's(ebooks) description column where the ID(BOOK) matches
up. Is there a way to go about doing this?
Thanks,
A.J.
On Wed, Apr 03, 2002 at 01:58:55PM -0500, Kevin D wrote:
I've been reading the docs but I just want to verify. It seems like
the latest version of MySQL support transactions and referential
integrity. Is this correct? Does MySQL now also support stored
procedures?
BDB and InnoDB tables both
if your app is PHP, then use stripslashes() on field
-Original Message-
From: Pal Lucian [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:58 AM
To: [EMAIL PROTECTED]
Subject: underline char in a [char][varchar][text] field ?
Hello everybody,
I have a problem inserting a
no stored procedures yet. maybe vers 4.1
-Original Message-
From: Kevin D [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: transactions, referntial integrity
I've been reading the docs but I just want to verify. It seems like the
Hello again,
is there any way to make mysqldump dump every insert as a single insert
instead of making INSERT INTO ... VALUES (...), (),(...) and so on ?
I read the manual and there is sth about -e wich as I understood means
multiple inserts in single line, but I did'n use this switch.
look at the manual, section :
6.4.9 LOAD DATA INFILE Syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
Hello all,
Does anyone know if MySQL can do subqueries?
I am trying to provide a SELECT subquery to an IN clause and I am getting
errors. Is this possible?
-Leo
-
Before posting, please check:
Thank you much - I somewhat understand the query that you posted now.
The problem that I'm dealing with NOW however is that it will only
display results if there is a second level referree. I need to get
results despite whether there are six levels or referrals, or only one.
I added a
On Wednesday 03 April 2002 12:35 pm, Leo Przybylski wrote:
Hello all,
Does anyone know if MySQL can do subqueries?
Not the current version, no.
I am trying to provide a SELECT subquery to an IN clause and I am getting
errors. Is this possible?
Read the manual and follow the example on
It can't, try using JOIN.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: Leo Przybylski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 03, 2002 1:35 PM
Subject: Subqueries
Hello all,
Does anyone know if
Sorry if this is an obvious question. I swear I RTFMed first.
Is there any compile-time option to redefine MySQL's data area (normally
mysql-path/var with compiled versions)? I've seen many possible ways of
doing it at run-time, but really I'd prefer this to be compiled in so I
don't have to
Hello all,
Please pardon my newbie-ness I've been looking at somehow migrating from a
flatfile user system (/etc/passwd, etc) to a MySQL backend for authentication for all
my processes... qpopper, postfix, and apache/frontage (ick)
I can't seem to find anything that would enable me
Yes, --localstatedir. See
http://www.mysql.com/doc/c/o/configure_options.html
Michael
On Wed, 3 Apr 2002, John Klein wrote:
Sorry if this is an obvious question. I swear I RTFMed first.
Is there any compile-time option to redefine MySQL's data area (normally
mysql-path/var with
Steve
Have you tried using compound index:
INDEX( POOL, STATE )
Just a thought.
David
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: select query optimization
i am running a basic install of
Does MySQL have the capability for the user to specify their own
delimiters for the command:
INSERT into (database) values (value1, value2,...,valuen);
The values that I am inserting contain both and '' and I am receiving
a syntax error.
On Wednesday 03 April 2002 2:02 pm, Lori Thompson wrote:
Does MySQL have the capability for the user to specify their own
delimiters for the command:
INSERT into (database) values (value1, value2,...,valuen);
The values that I am inserting contain both and '' and I am receiving
a syntax
I have read the MySQL manual on column types and I
can't find anywhere which is smaller, ENUM, SET, or
TINYINT?
Could somebody let me know which of those three is the
smaller data type?
Thanks,
Steve
Stephen R. Simons
Software Development
The Academy of the New Church
STAIRS Project -
At 16:53 -0500 4/3/02, Stephen Simons wrote:
I have read the MySQL manual on column types and I
can't find anywhere which is smaller, ENUM, SET, or
TINYINT?
Could somebody let me know which of those three is the
smaller data type?
Go to the manual link at the bottom of the message and type
Hey Guys,
I need to reorganize the list of reviews on my site so they are displayed by
category. However, I want it to display all the reviews from all categories
at once. How do I do this? Here is my syntax now for display all reviews at
once, but not sorted by category:
?php
$db =
hello,
i have plans to create a complex SQL database.
before that i'd like to draw a scheme of it.
could you please advice which
program(freeware/shareware)
would fit for that purpose?
any links to pages, tutorials about graphical
databases projecting would be great.
thank you in advance.
ktt.
mechanical pencil + graph paper? That's what I use.
ktt wrote:
hello,
i have plans to create a complex SQL database.
before that i'd like to draw a scheme of it.
could you please advice which
program(freeware/shareware)
would fit for that purpose?
any links to pages, tutorials about
$r = mysql_query(SELECT * FROM hwureviews ORDER BY category,num DESC);
what are you trying to do with this statement?:
while ($info = mysql_fetch_row($max)) {
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 4:08 PM
To: [EMAIL PROTECTED]
Description:
This isn't a very critical issue, but I discovered today that if a
table has only one record in it, then a query with MATCH in the WHERE
clause will succeed for that record regardless of whether or not it
should. NOTE: I have read the manual with regards to fulltext
searching, the
my thoughts
I would assume a plpgsql solution wouldn't be a bad one, All you would
really need is IF ELSEIF ELSE and FOR/WHILE, a way for procedures,
triggers, views, etc. to be able to access each other with in the
syntax of the language (providing routine/function support) along side
the
3.23.50 not yet published, but 3.23.51 is already being developed, according
to the manual at http://www.mysql.com/doc/N/e/News-3.23.51.html.
--
./ premax
./ [EMAIL PROTECTED]
-
Before posting, please check:
The manual is build (from what I can tell) about a week or so behind the
source tree on the work server. If you want to mess with the latest
snapshots check out
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Przemyslaw Popielarski wrote:
3.23.50 not yet published, but 3.23.51 is
Hello All,
I'm having a problem when using Load Data where the single and double quotes
in the text file are getting nuked. It appears that the escape character is
not being respected but I'm not sure why. It is also knocking out
characters near the quotes.
The command I'm running is:
load
Hi kim,
Try using
load data local infile '~/Documents/web export.txt' into table stories
fields terminated by ',' enclosed by '' escaped by '\\' lines
terminated by '\r'
(StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Also, if this is a windows text file you should be
G'day Colin
load data local infile '~/Documents/web export.txt' into table stories
fields terminated by ',' enclosed by '' escaped by '\\' lines
terminated by '\r'
(StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Thanks for your suggestion but sadly it didn't fix
1 - 100 of 122 matches
Mail list logo
