Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in MySQL. I was told
clint lenard wrote:
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another
Thanks Jasper for the info! This may sound stupid - but I just want to be
sure... do I need to strip the slashes and special characters out and add
them when they're called... or..? I'm just trying to get a clear picture
of exactly what needs to be done with this particular job...
thanks!
Hi Clint,
Another possibility is to actually run the mysql client with a --html
option and let mysql do the work for you
eg : prompt $ echo SELECT some_stuff FROM table | mysql -u xyz -pxxx
--html
This generates a block of html for a table with the data encapsulated
within, then it is just a
David and Jasper - thank you both! I will play around with this more now
that you have explained my biggest questions!
Thanks guys,
Clint
:-)
On 9/9/05, Jasper Bryant-Greene [EMAIL PROTECTED] wrote:
clint lenard wrote:
Thanks Jasper for the info! This may sound stupid - but I just want
clint lenard wrote:
Thanks Jasper for the info! This may sound stupid - but I just want to
be sure... do I need to strip the slashes and special characters out and
add them when they're called... or..? I'm just trying to get a clear
picture of exactly what needs to be done with this
The original message was received at Fri, 9 Sep 2005 15:00:22 +0800 from
chosun.com [77.253.195.244]
- The following addresses had permanent fatal errors -
mysql@lists.mysql.com
- Transcript of session follows -
... while talking to host 147.168.60.215:
550 5.1.2
Scott Haneda wrote:
Unless I am totally off base here, the mysql docs tell very little in
regards to how to performance tune mysql.
So far I have found this article to help:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
But it still leaves me with a ton of
...and when MySQL-shared-compat-4.0.26-0.i386.rpm will be released?
rpm (and some older tools) complains :(
There is only:
Dynamic client libraries
(including 3.23.x libraries)4.0.25-0482.1K
Joerg Bruehe wrote:
Hi,
MySQL 4.0.26, a new version of the popular Open
Hello.
So now my question... is it possible that MySQL didn't execute that first
UPDATE query on
that first page until after the rest of the process completed?
...
- Every page has UPDATEs, INSERTs, or DELETE commands so I'm wondering
whether the
There
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Qus 2. Is there any other way
Hello, Clint!
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible?, is
I've see no reply to this and I checked the archives, so please
excuse my resubmitting it. Maybe I shouldn't be using 4.1.14 but
4.0.x?
Thank you,
Hugh
On Wed, 7 Sep 2005, Hugh Sasse wrote:
Attempts to do make test prior to installation, to check that I'm
installing something
Okay, I asked the web host guys and this is what they said:
Hi Jenifer, we only use single instances of MySQL so the master/slave
replication issue would not be possible. As far as I know, the only way a
delayed update could occur would be if you had multiple updates queued
behind a slow
Devananda [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Dan Baker wrote:
Eric Bergen [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
When you add that index are more than 30% of the rows in the table
DateTimeNext1126215680?
There are currently 28.53% of the rows
Greetings all,
I am knew to the the world of SQL and am interested in putting data into a
database that I have created. The data will be in the form of a tab
delimited text file that will generated several times a day with different
data. What I would like to do is use the LOAD LOCAL DATA
If you use textarea field of a form, it produces null characters (\n) in
the
end of every string. I recommed to replace them with br tags before
writing into the database. It'll help to avoid output problems. Use
preg_replace(); for it.
Be careful here Vladimir, the (\n) are not 'null'
Amen. Translating user input into HTML is great until you need to read
the data *out*, and someone decides the output should be formatted as
RTF or PDF or text. Best to store it as you got it, IMO.
-Original Message-
From: Alan Williamson [mailto:[EMAIL PROTECTED]
Sent: Friday,
Hey all,
Just brought up a new RH EL3 server and updated MySQL to ver
4.1.13-standard
I'm trying to get replication from an older server running version
Server version 4.0.16-standard-log
Replication on the slave system seems to start ok but then just sites
there with connecting to master
Hugh,
I get the same thing on Mac OS X 10.3.9. My thinking was that rather than
replying with an unhelpful Me too, I would do some digging and then reply
with what I found. I realize now that left you hanging (sorry), so I'll
report what I've found so far.
The test suite is broken.
The
On Fri, 9 Sep 2005, Michael Stassen wrote:
Hugh,
I get the same thing on Mac OS X 10.3.9. My thinking was that rather than
replying with an unhelpful Me too, I would do some digging and then reply
with what I found. I realize now that left you hanging (sorry), so I'll
report what I've
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
The tool to run the test suite does not run as it should.
I understand that the effect
I would like to save graphs in a mysql data base. The table definition I have
set up is:
CREATE TABLE `GRAPHS` (
`graphid` int(11) NOT NULL auto_increment,
`graphic` blob, `f_time_stamp` timestamp NOT NULL default CURRENT_TIMESTAMP on
update CURRENT_TIMESTAMP,
PRIMARY KEY (`graphid`)
)
Kenji HIROHAMA [EMAIL PROTECTED] wrote on 09/08/2005 08:54:58 PM:
Hi,
Does somebody point me out where I should refer to understand what is
row level replication implemented in 5.1?
I should have read the source comments in the source tree, but the bk
port is closed at my environment.
One of our engineers first installed MySQL on one of our Sun boxes
which was doing nothing more than MySQL... It seems we also put it on
the server and turned it on... it behaved very badly. Essentially
when we started to investigate MySQL and find out if we could use it
we discovered that
On Fri, 9 Sep 2005, Joerg Bruehe wrote:
Michael,
you beat me in replying, and saved me from typing the analysis - thanks!
Michael Stassen wrote:
[[...]]
The test suite is broken.
Well, I would not put it that way - a diplomatic wording is:
The tool to run the test suite does not run as
Hello.
..e, but I am manually entering it in.
Use mysql command line client. You may pass SQL statements as the
command line options or execute them from the file (i.e mysql -e
sql_statement or mysql sql_file). See:
http://dev.mysql.com/doc/mysql/en/mysql.html
Eric Mynes
infact .. the default debian config (some of these are just explicit
defaults but this is what debian provides):
[mysqld]
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port= 3306
basedir = /usr
datadir
Hi!
Remo Tex wrote:
...and when MySQL-shared-compat-4.0.26-0.i386.rpm will be released?
rpm (and some older tools) complains :(
There is only:
Dynamic client libraries
(including 3.23.x libraries)4.0.25-0482.1K
It has been built by now, and it is on its way propagating to
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but newline
characters.
Agree, I was wrong.
And i would highly recommend *not* replacing them with br
tags as you write them into the database. This is asking for trouble on
so many levels.
The database will cope
Vladimir B. Tsarkov wrote:
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but newline
characters.
Agree, I was wrong.
And i would highly recommend *not* replacing them with br
tags as you write them into the database. This is asking for trouble on
so
Use addslashes($htmlCode) and execute query normally.
?php
$slashedHtmlCode = addslashes($htmlCode);
?
[]´s
Tomita
On 9/9/05, Vladimir B. Tsarkov [EMAIL PROTECTED] wrote:
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but
newline
characters.
Agree, I
Hi people,
I having problems to import a dump generated via mysql dump in mysql
4.0.20slackware version to a mysql
4.1.14.
The dump generated with other table name (Insert into temp, temp2 , temp3)
in 20 sql large (420mb.) sql files.
I tried LOAD DATA INFILE but data not inserted correctly,
Filipe Tomita [EMAIL PROTECTED] wrote on 09/09/2005 04:37:01 PM:
Hi people,
I having problems to import a dump generated via mysql dump in mysql
4.0.20slackware version to a mysql
4.1.14.
The dump generated with other table name (Insert into temp, temp2 ,
temp3)
in 20 sql large (420mb.)
tks for reply but i dont have acces to original database... the dump file
not generated from me..
Someone tell me about SAD command to replace table name to correct name
but i dont find anything about it.
On 9/9/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Filipe Tomita [EMAIL
Perhaps you mean 'sed'.
Filipe Tomita wrote:
tks for reply but i dont have acces to original database... the dump file
not generated from me..
Someone tell me about SAD command to replace table name to correct name
but i dont find anything about it.
On 9/9/05, [EMAIL PROTECTED] [EMAIL
when using the loading command
load data local infile '/home/kzhou/xxxy.data' into table mytable;
it will run to completion, after a long time, then telling me that 90%
of the rows are skipped.
load data local infile
'/home/kzhou/RUN_BLAST/pep2genome_ost9901.tbn.tab' into table
I know this has to be a simple query but its really kickin' my butt. I have the
table below where fld1 is the year, fld2 is a number, fld 3 is a subnumber, and
fld4 is the user. I need to know the count of all the records for user am
without the sub number getting in the way. For example, the
I think you want this or something similar:
select count(distinct fld2)
from yourtable
where fld4 = 'am';
N.B. I have not tested this solution.
Rhino
- Original Message -
From: Ed Reed [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, September 09, 2005 6:08 PM
Subject:
Oops, that should be:
select count(distinct fld1, fld2)
from yourtable
where fld4 = 'am';
That version of the query is tested and works with your data; it returns the
fact that there are 5 combinations of fld1 and fld2 for all the rows where
fld4 is 'am'.
Rhino
- Original Message -
Hi List,
Does MySQL have something similiar to
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific';
I need to handle the timestamp in the database. Previous posts and some
googling suggests it should be in the PHP layer which is not an option
for me.
My users come from
In the last episode (Sep 10), Terence said:
Does MySQL have something similiar to
SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'Canada/Pacific';
I need to handle the timestamp in the database. Previous posts and some
googling suggests it should be in the PHP layer which is not an
42 matches
Mail list logo