Join many table with 1 query is the ideal. Because you must sure that
there are the valid data integrity. If there is only 1 broken join key
(any part of table1.key=table2.key), you'll got the null row. When you
need to display all of the first table value and retrieve another
information
Note: I am not subscribed to this list, so please Cc me at
[EMAIL PROTECTED] if you reply to this message.
Moodss (a modular monitoring application, graphical and daemon) fully
supports the MySQL database and great efforts are made in collaboration
with the MySQL AB developer Sinisa Milivojevic,
hi stephen,
the ncurses library is not part of the mysql distribution. it's
available as a solaris binary package at
www.sunfreeware.com. look for ncurses-5.2.
HTH
michael
Stephen D. Myles wrote:
Hi,
I am new to MYSQl so any help is much apreciated! I have recently instaled
mysql
Hello,
Can anybody help me out in solving the build error
problem for mysql
I am trying to build MySQL-3.23.49-1.src.rpm with the
linux command rpm --rebuild MySQL-3.23.49-1.src.rpm.
Using redhat linux 6.2 with glibc2.1.3.
Following is the error while compiling-
make[2]: Entering
On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant Agarwal wrote:
Hello,
Can anybody help me out in solving the build error
problem for mysql
I am trying to build MySQL-3.23.49-1.src.rpm with the
linux command rpm --rebuild MySQL-3.23.49-1.src.rpm.
Using redhat linux 6.2 with
Placed At :
Hi ...
I 'm getting this very odd error with my update query..I run mysql-4.0.0-alpha
on a redhat linux machine..
My table type is innodb.
the error is as follows..
ERROR 1030: Got error 101 from table handler
I do not have a
i am using egcs 2.91.66
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
On Mon, Apr 01, 2002 at 01:33:12AM -0800, Laxmikant
Agarwal wrote:
Hello,
Can anybody help me out in solving the build error
problem for mysql
I am trying to build MySQL-3.23.49-1.src.rpm with
the
linux command
Hello All,
I've got an SQL question. I have a database that contains Reviews of some
of a clients publications. The client is interested in generating some
summary reports and I simply can't wrap my head around a single SQL query
(if that's possible) that will generate the information I'm
kaps,
Sunday, March 31, 2002, 10:51:14 AM, you wrote:
k how can i get a backup of the database using the mySQL Server terminal
k access with my mySQL Sever?
k any help?
Look at the section 4.4.1 Database Backups in the manual:
http://www.mysql.com/doc/B/a/Backup.html
Take a look at
Kenneth,
Sunday, March 31, 2002, 2:13:47 AM, you wrote:
KLSubmitter-Id: submitter ID
KLOriginator:Kenneth Lerman
KLOrganization:
KL Systems Essentials Limited
KLMySQL support: none
KLSynopsis: Can't find file: 'host.frm' even though it exists
KLSeverity: critical
KLPriority:
MySQL plans to implement stored procedures in 4.1
though :-)
--- Jeremy Zawodny [EMAIL PROTECTED] wrote:
MySQL doesn't have stored procedures yet. It has
user defined
functions (UDFs), but that's not what you're looking
for here.
Jeremy
Troy writes:
Hi all,
Just wondering if there are any examples on the web that will compile
using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get
the example to compile.
Thanks in advance
Troy
HI!
MySQL++ requires VC++ 6.0.
--
Regards,
__ ___ ___
Hi!
Id would like to have 4 tables
files (
id int(8),
type set(directory, file, link),
)
files_directory (
id int(8),
is_files int(8),
name varchar(20)
...
)
files_file (
id int(8),
is_files int(8),
name varchar(20)
...
)
files_link (
id int(8),
is_files int(8),
name varchar(20)
...
)
And
* Gordon Stewart
I've been following the website of :-
http://www.wdvl.com/Authoring/DB/SQL/Build/
And its the best ive seen - so far...
Im up to this page :-
http://www.wdvl.com/Authoring/DB/SQL/Build/build4-5.html
now i'm stuck - I need to know 2-3 more things that i can do WITHIN /
You might also want to consider looking at Lasso Professional 5
www.blueworld.com. This product has MySQL built-in, while also connecting
directly with external MySQL and FMP database sets. For me, its the perfect
solution when bringing parts of MySQL and FMP together using a browser
interface.
Hi all,
I accidently move some database dir temporary (for space pb) but when moving
I surely forget something I cant no longer start my server.
I put the sock file where it had to be but nothing more.
See that
www:/var/lib/mysql# ls -ls
total 100
4 drwxr-xr-x2 mysqlmysql
Does anyone know of a program or algorithm that will take a table
structure and update another table to the new one? Like, to just change
or add a column? What I'm trying to do is continually update the table
with different fields, or change the field types whenever I feel the
need to add a new
Did you dump the 24 records on both boxes and compare them?
Maybe someone updated the records on the slave, and now the dates don't
match.
Vico Timmermans wrote:
I think i stumbled upon a bug that's got something to do with join
size. Detailed information below.
Using 2 intel-linux platforms
* James Gosnell
Does anyone know of a program or algorithm that will take a table
structure and update another table to the new one? Like, to just change
or add a column? What I'm trying to do is continually update the table
with different fields, or change the field types whenever I feel the
I need some help formatting a MySQL longtext column for presentation via PHP
When I pull the data with PHP the line feeds are not respected unless I use the
pre/pre HTML tags around my data field.
This does not have the desired effect.
how can I pull the data into the php web page and
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 for the online manual
On 31 Mar 2002, at 17:34, Alex Behrens wrote:
My statement is this and it still gives me an error and wont add the data,
the addslashes doesn't seem to be working:
$sql = addslashes(INSERT INTO hwureviews
(name,title,picurl,url,author,email,category,num,info) VALUES
I thought the 4.0 series was still Beta?
On Mon, 1 Apr 2002, Heikki Tuuri wrote:
Date: Mon, 1 Apr 2002 18:09:53 +0300
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: mysql innodb error
Kannan,
please upgrade to 3.23.49a or 4.0.1.
101 used to mean lock
William,
- Original Message -
From: William R. Mussatto [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 6:29 PM
Subject: Re: mysql innodb error
I thought the 4.0 series was still Beta?
yes, 4.0.1 is beta or alpha, depending on
if I dont have the mysql.sock running in the temp folder how do I start
it???
I tried service mysql start and it did work it give me the same error in the
subject line
- Original Message -
From: andy thomas [EMAIL PROTECTED]
To: colin o [EMAIL PROTECTED]
Cc: Mike Yrabedra [EMAIL
Well, first off, I can't seem to get max_allowed_packet higher than 64
MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are
reflected in the system settings, but only up to 64 MB, then regardless
of what I put in there, it stays at 64 MB. But like I said, the file is
only
Can you tell me what the mysqlmanager application will end up doing?
Currently you say it is for testing purposes.
But what is the future intended use of this program? What is in store for
this application down the road?
I see one of the parameters is a command length. Will this app allow a
i run a mysql :
mysql select version();
+---+
| version() |
+---+
| 4.0.2-alpha-debug |
+---+
1 row in set (0.00 sec)
on a mandrake 8.1 box.
on /var/lib/mysql (DATADIR), I have several ib* file note that I have mysql
max install.
what
ERROR MESSAGE: 1 WE R DEVELOPING A PRODUCT USING KDE2.0/QT3.0.2
ENVIRONMENT, USING MYSQL AS DATABASE.
WHILE CONGIGURING THE QT3.0.2--- $./configure -qt-sql-mysql
-I/usr/local/qt/include -system-libjpeg -qt-gif -qt-libpng -debug
...ENTER
AFTER CONFIGURATION FOR gmake WE R
Description:
Existing mit-pthreads code does not compile on current NetBSD/powerpc
How-To-Repeat:
Attempt to compile
Fix:
Apply patch
$NetBSD$
*** mit-pthreads/machdep/syscall-powerpc-netbsd.S Thu Feb 14 12:30:14 2002
---
I have a query:
SELECT feature_type.title, feature.title
FROM feature_build
LEFT JOIN feature ON feature_build.feature_id = feature.id
LEFT JOIN feature_type ON feature_build.feature_type_id = feature_type.id
WHERE feature_build.product_id = '112479'
AND feature_type.full_ordinal != 0
Sihem,
Sunday, March 31, 2002, 1:26:00 AM, you wrote:
SAY problem in connecting to server through C API function
SAY mysql_real_connect()
SAY the mysql handle returned by mysql_init() is not null
SAY error message says:
SAY Program received signal SIGSEGV, Segmentation fault.
SAY
Anton,
Sunday, March 31, 2002, 10:53:45 PM, you wrote:
AC REALFROM: Anton Chalbaud [EMAIL PROTECTED]
AC HOUR: 2002033122
AC Hi, if I need to do multiple INSERTS (I mean into different tables) which is
AC the best way to manage this? Do I have to run a different Query for each
AC INSERT ? Or
David,
Monday, April 1, 2002, 4:07:53 AM, you wrote:
Dy I accidently move some database dir temporary (for space pb) but when moving
Dy I surely forget something I cant no longer start my server.
Dy I put the sock file where it had to be but nothing more.
Looks like the server is not running
Alex,
Saturday, March 30, 2002, 6:50:17 PM, you wrote:
AB quick question, I'm setting up a script that does headlines for my site and
AB I need to pull some information from a table with my review info from it but
AB I only want to view the 7 latest reviews, how do I make it so I can only
AB
Art,
Sunday, March 31, 2002, 11:28:17 PM, you wrote:
AF Does anyone know how or where there is a howto to import tables from an
AF Oracle Database into Mysql and then to keep the Mysql syncronized with the
AF Oracle database?
There is no such thing as syncronizing between Oracle and MySQL
Shelly,
Sunday, March 31, 2002, 4:12:49 PM, you wrote:
Looks like MySQL server is not running. Please check that.
SY After running setup on Window professional , I tried
SY to install using the follow command. I got error.
SY C:\mysql\binmysqladmin -u root shutdown
SY mysqladmin: connect to
kaps,
Sunday, March 31, 2002, 9:54:00 AM, you wrote:
k i m fairly new to mySQL. I have to work on already set up live database
k which can be managedwith phpAdmin system.
k Now i was wondering how can i take a backup (dump) of the database with that
k system?
Use mysqldump utility:
Try this function
nl2br()
Mat
- Original Message -
From: Rance Hall [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 7:51 AM
Subject: Using MySQL text column with PHP4
I need some help formatting a MySQL longtext column for presentation via
PHP
When I pull the
nl2br() works, thanks for the info
manual stinks on this subject
example code should be something like:
$newtext = nl2br($oldtext);
Rance Hall
308.238.2455
Internal Office Extensions: 2455 or 6655
PC Programmer, The Buckle, Inc.
[EMAIL PROTECTED]
-Original Message-
From: Mat
* Egor Egorov
AC REALFROM: Anton Chalbaud [EMAIL PROTECTED]
AC HOUR: 2002033122
AC Hi, if I need to do multiple INSERTS (I mean into different
tables) which is
I think he asked about inserting into multiple tables... ;)
--
Roger
query
Hi.
I am running MySQL 3.23.44-Max
I have 2 tables.
Table A
+---++
IDName
+---++
1 string 1
2 string 2
+---++
Table B
+---++
IDName
+---++
2 string 2
3 string 3
+---++
And I need result
+---++
ID
hi guys,
how can i use arabic language in the mysql tables data, my data in the
table looks like Extended Ascii, and it is re-interpreted in windows
programs - as MySQLMaker - into arabic, how can i let MySQL itself
understand arabic?
thx
--
Hytham Shehab
Is it true that mysql is planing to implement google's famous
PigeonRank
system in it's FTS word weighting schema???
*drool*
:-)
--
Colin Faber
(303) 859-1491
fpsn.net, Inc.
-
Before posting, please check:
Hi there,
can anyone reccommend a free schema manager for MySQL? I've heard of Kermit, but it's
very expensive.
Thanks,
Steve
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
If you are looking for a web version, the best is phpMyAdmin which
allows you to do just about everything you need to manage any number of
mysql dbs.
Andrew Hazen
-Original Message-
From: Vu, Steve [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 2:54 PM
To: [EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At Montag, 1. April 2002 21:38 Colin Faber wrote:
Is it true that mysql is planing to implement google's famous
PigeonRank system in it's FTS word weighting schema???
I allready have a simple quick-n-dirty implementation running
on our local mysql
I have the 3.23.49 Version of MySQL and it is saying the load data command
does not work with this version. I also read in my book that any version
past 3.22.15 should be able to complete this function. Please advise.
Rosina M. Everitte, B.A., Research Assistant
University of Arkansas for
Just to clarify, my problem is that I do not want MySQL to use disk-based
temp file. Everytime I try to ORDER a result set that contains a TEXT type
field, MySQL will use disk based temp file.
What can I do to:
1. SELECT a TEXT type field
2. ORDER by an INT column
3. not use a disk based
How about using the state transitions, i.e.
0 - 1 state changed, no error
0/1 - 0/1 state unchanged, no error
1 - 0 state changed, overflow
C:~
-Original Message-
From: Michael Zimmermann [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 12:07 PM
i've read the bit on google about thier pigeon rank thing, sounds like a
cross between reality and alittle aprils' fools to me, either way id
apreciate a better explanation of this technology and how it may be
implemented into mysql -dan
David,
- Original Message -
From: David yahoo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Monday, April 01, 2002 7:10 PM
Subject: ib* files and their rules
i run a mysql :
mysql select version();
+---+
| version() |
+---+
|
Who knows with google... ;-)
Though I do like Michael's 'peck' 'not-yet-pecked' system.
I question though how much more performance we could get out of Rats
rather than Winged Rats.
Dan Zarrella wrote:
i've read the bit on google about thier pigeon rank thing, sounds like a
cross between
./safe_mysqld --user=mysqld --datadir=/db/
./safe_mysqld --user=mysqld --datadir=/db/
020401 16:55:04 mysqld started
020401 16:55:04 /d2/usr2/local/mysql/libexec/mysqld: Can't find file:
'./mysql/host.frm' (errno: 13)
020401 16:55:04 mysqld ended
My unix user is called mysqld and I want
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Dat
e_and_time_functions
Mike
- Original Message -
From: Edilson Vasconcelos de
Hello there,
I am trying to find which database to use. I will have text and image data.
Lots of image data. Most of the time I am doing data retrieving, but when
updating, it will be text almost always. No enterprise use, but very busy
database hits. Could any one please educate me if mysql
I had the exact same problem.
when you install mysql there is a database that stores all the user permissions and
that table is created for you.
the mysql server can start without that permissions file but you have to send a -Sg
option to the server if you are on unix, linux or the like
This
Hi,
As I'd got not answer, I repost my question ;)
I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :
For exemple :
dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI
(to
Hi all,
How can i do a delete from multiple table in mysql?
Eg :
I want ot delete record something like that I dont when to select but delete
delete
from
externallink as link,
topic as topic,
topiclink as joiner
where
link.resid = joiner.resid and
topic.catid = joiner.catid and
topic.rid like
I want to do a query that will find all the titles I have in my db that
start with numbers and ambigious characters (i.e. 0-9, , #, $ etc...). My
query is below, however I don't know what to change the a too in order for
it to return what I just described.
select id, shortdescription, title
MySQL will be good for this type of stuff.
Tyler
- Original Message -
From: Zhao, Charles [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 3:53 PM
Subject: Beginners Question
Hello there,
I am trying to find which database to use. I will have text and image
I am working with a low-load, mission-critical database. Although I have
yet to have a corrupted table, I seem to read about it a lot on the
list. This is a scary thought for me, considering the importance of the
data I manage. Can anyone tell me if this is a rare occurrence? Is it
even
Graig,
I've been using mysql for about a year now on a linux machine and it has not
crashed or had any corrupted tables in that time. I believe mysql is just as
good in stability and safety of data has it is in speed.
Mike
- Original Message -
From: Scalper [EMAIL PROTECTED]
To: [EMAIL
Use a combination of the DATE_ADD function and the NOW function:
SELECT DATE_ADD(NOW(), INTERVAL 20 MINUTE)
--jeff
- Original Message -
From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED]
To: MYSQL [EMAIL PROTECTED]
Sent: Monday, April 01, 2002 12:04 PM
Subject: DATE_ADD ?
Yes, mySQL is up to the task. Just make sure you design the DB with
fast retrivals in mind
-Original Message-
From: Zhao, Charles [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 01, 2002 3:53 PM
To: '[EMAIL PROTECTED]'
Subject: Beginners Question
Hello there,
I am trying to find
At this 14:31 1/04/02 +0200 Roger Baklund told us all something interesting :-
From the build4-5 web-page above, I'll assume that
$result = @mysql_query(show databases); would be the correct code to
SHOW the databases available..
That is correct.
However its not going the website
I downloaded mysqlgui linux semi static binary and installed it. I copy
my.cnf to ~/.my.cnf. I set the user name to my user. When I start it up
it prompts for password then indicates that it can't connect. I am using
the same USER/PASS that I use successfully with mysql --user=USER
Ive uploaded it to one of my sites (doesnt have PHP - (I dont think..))
as a text file...
http://homepages.slingshot.co.nz/~gordon52/3.txt
I just 'viewed source' I saw all the correct source-code..
Ive changed some text of my PHP script :- New lines are :-
(see above URL - view
G'day,
I keep on getting the following error message when trying to connect to
MySQL - ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
This can be fixed by creating a link from the /tmp/mysql.sock file. Which I
have done and still get the same error
I'd like to authenticate mySQL users against an LDAP directory. Can I
do that? If so, how? Couldn't find anything anywhere ...
Thanks,
Johannes.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
-Original Message-
From: Chetan Lavti
Sent: Thursday, March 28, 2002 11:39 AM
Subject: RE: To run MySQL Server from the remote machine
hi,
Is it possible to Start the MySQL Server from the remote machine..??
Mysql provides a Api's for shut down the server from the remote
place
* Gordon Stewart
[...]
http://homepages.slingshot.co.nz/~gordon52/3.txt
[...]
while ( $row = mysql_fetch_array($result) ) {
echo(p . $row[JokeText] . /p);
[...]
But how do i list the actual database names ?
The result column of the show databases command is named Database, not
On Sat, 30 Mar 2002, Paul DuBois wrote:
At 17:15 -0500 3/30/02, Michael Stassen wrote:
On Sat, 30 Mar 2002, Paul DuBois wrote:
At 21:25 +0100 3/30/02, Roger Baklund wrote:
* Son Nguyen
== I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from
Hi,
How I can use ',' instead of '.' in a number values in mysql. I changed
charactermap but nothing.
MySQL 3.23.41 RH7.2
Liivar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I have created a database called friends with four columns:
Name / Address / City / State
I also made an XML file to coincide with those variables:
test
contacts
friends
nameFriend 1/name
address999 Foo Avenue/address
75 matches
Mail list logo