> I use mysqldump to do a total backup of my database. This is done once a
> day just after midnight. The file is then taken up by our tape backup
> software. I do hourly backups of our more important databases, also using
> mysqlbackup. Works fine and I have used it for restorals on a number
X wrote:
Hmmm, this genereated the error message, "Parse error: parse error in
/directory/connect.php on line 12" - Line twelve is the first "printf..."
line.
Any suggestions?
Chris
Here is corrected version:
\n", $row["DBID"]);
printf("First Name: %s\n",$row["FIRST_NAME"]);
Has someone experienced a problem running MySQL v 3.23 as NT service on
Windows2000 ServicePack 3 ?
==
I'm having a problem running MySQL v 3.23 as NT service on Win2000 SP3. It
works allright in manual mode (by 'mysqld' command), bu
How do I correct this SQL code:
2 tables there,
lcopen: id, bank, unit_price_us, order_cbm
lcreceive: id, amount_us, due_date
#this condition :lcreceive.due_date < current_date
#only affect to : SUM(lcreceive.amount_us)
#and NOT :
#SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS
open
SELE
Hi,
I suppose this may be slightly off topic and not really relevant to a mysql
mailing list, sorry... but...
I've spent the last month getting up to speed with MySQL with much help
from you guys and Mr DuBois' book. I've done this because an existing
client of mine has a system which works wi
It is up to you, but for a guide have a look at what MySQL training cover
and if you know that then you are up to speed?
Simon
-Original Message-
From: Jeff Snoxell [mailto:[EMAIL PROTECTED]]
Sent: 08 January 2003 09:25
To: [EMAIL PROTECTED]
Subject: When is learning chargeable to a client
Sam Przyswa wrote:
Septenber 11 2001, more than 3000 women, men, child, killed, Tel Aviv January 5
2003, 23 death and 100 injured by islamic terrorists, that's the islamic history
(small part).
Sam Apache-PHP-MySQL user.
--
"Albert Einstein, Karl Marx, Jesus Christ,
and you Mohamed what have
I know this is a emotive subject but PLEASE drop it from the MySQL list.
Thanks
Simon
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hi Jeff,
Try the magic undef as it is with no '' or ""
$dbh->do('insert into yourtab values (' .
join (',', map($dbh->quote($_), $your_stuff, undef, $more_stuff)) .
')') ;
Regards
Salam
Jeff Snoxell wrote:
Hello,
I've got a mysql table with a lot of fields and I'm using a map
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff, et al --
...and then Jeff Snoxell said...
%
% Hi,
Hi!
%
% I suppose this may be slightly off topic and not really relevant to a mysql
% mailing list, sorry... but...
*grin* I agree that it is but at least it isn't a flame war. This
prob
Version: 4.0.8, installed from the RPMs downloaded from the mysql.com
webpages. The server runs RedHat 8.0, all updates installed. The hardware
is a Dell 2650.
Problem: Any connection, using the command line client for example, from
any other node fails even though the access should be allowed. T
hi all,
anyone knows if it is possible to create the query log
in a mysql table instead of in a text file?
Otherwise ... is there a way to import it into a
table?
Thanks to all.
Natale Babbo
sql, query
__
Yahoo! Cellular
Hello MySQL,
we have this problem:
when using phpmyadmin if we select database to view and we put SQL
command to ENTER SQL QUERY/QUERIES TO DATABASE field and submit it,
it will display NO SQL QUERYwhat is wrong?
please help me...thank you
--
Best regards,
Martin
A little complicated solution is to create the log in a file then setup a
php/perl program that reads that file continously and insert/process that
data .
- Original Message -
From: "Natale Babbo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 12:25 PM
Subjec
On Wed, 2003-01-08 at 04:55, CM Miller wrote:
> Have a new years resolution, to get MySQL to run
> Here are the errors that I keep getting...
>
> I don't understand what this is telling me?
>
> from /var/log
>
> 021214 19:13:21 mysqld started
> 021214 19:13:21 /usr/local/libexec/mysqld: Can'
InnoDB seems to delaying writes for too long.
After adding or deleting records in a table, viewing
the results of a query from another application on the
same workstation and other workstations does not
reflect the changes.
It is as though another connections are still being
presented with old sn
Hello,
I have two tables whose structures are below.
- Table1 -
table1id int not null auto_increment
data varchar(30)
- Table2 -
table2id int not null auto_increment
table1id int not null
data varchar(30)
These two tables are connected to each other with the "table1id" column. I need to
dele
@mysql_select_db("be"); // this doesn't fail, because only the second
(UPDATE) query fails. The first query (SELECT) is done!
- Original Message -
From: "Marek Kilimajer" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sen
Doesn't you have any simpler answer??
Maybe installing the new version of mysql server - I have version 3.23.49 -
should do the trick
- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, Janua
On Tue, 7 Jan 2003 [EMAIL PROTECTED] wrote:
>
> > I use mysqldump to do a total backup of my database. This is done once a
> > day just after midnight. The file is then taken up by our tape backup
> > software. I do hourly backups of our more important databases, also using
> > mysqlbackup. Wo
Can anybody help me
with select query
how to do this:
I have table "foo1" with two fields "image" "check"
| image | check |
| 6782 | 0 |
| 2732 | 1 |
| 6734 | 1 |
so I want to make query
select * from foo1 where [so is it possible to make some if check=1 then
image
Dear sir
Pls help
I run Mysql 3.23.54 , Os Windows 2000 service pack 3
I'm got error Lost connection to MySQL server during query and also to drop
service in service control manager.
Anyway, mysql.err log can not help me to resolve this problem.
What Happen ?
Thank you very much.
Kanda Taweechu
Hello Martin,
Your problem is related to PHP not MySQL. You should check the
max_post_size directive in yor php.ini file. AFAIK, this limit is set to 8M.
If you decreased the size, increasing it may solve your problem.
max_post_size controls the maximim POST size you can do, and if you
mysql
ÄúÏëÔÚÏã¸Û³ÉÁ¢¹«Ë¾Âð£¿
ÄúÏëÔÚÏã¸ÛÓµÓÐ×Ô¼ºµÄµç»°¼°´«ÕæרÏßÂð£¿
ÄúÏë¿Í»§²¦´òÏã¸Ûµç»°£¬¶øÄúÉíÔÚ¹úÄÚ¶¼¿ÉÒÔËæʱ½ÓÊÕÂð£¿
ÄúÏëͨ¹ýÏã¸ÛµÄ¹«Ë¾¿ªÍØÏã¸ÛÊг¡¼°¹ú¼ÊÊг¡Âð£¿
ÄúÏëÏã¸Û¹«Ë¾ÓÐרҵÓÐÀñµÄÃØÊéÒÔ¸óϹ«Ë¾Ãû³ÆÓÃÖÐÓ¢ÎÄ
½ÓÌýµç»°Â𣿲¢¼´Ê±×ªÒÆ»ò»Ø´«(·Òë)¸øÄãÂð£¿
ÄúÏëÔÚ¼ÒÀïÉÏÍø¾Í¿ÉÒÔ°ÑÏã¸Û¹«Ë¾»§¿ÚµÄ×ʽ
Why can't you use an Env variable to point to the server you want to query
from and switch the value back and forth as needed in the case that you want
to periodically switch back and forth between servers? Or write a function
that runs on server1 to query against the tables on server2 making the
Hi,
I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional)
linux server. I have tried many full text queries and I had only a problem
with a query like this:
SELECT count(a.rsori) pippo
FROM ecoras a, ecotxt b
WHERE MATCH ( b.rstxt ) AGAINST ( '-linux' IN BOOLEAN MODE )
AND a.rs
> Why can't you use an Env variable to point to the server you want to query
> from and switch the value back and forth as needed in the case that you want
> to periodically switch back and forth between servers? Or write a function
> that runs on server1 to query against the tables on server2 mak
I've got what would be best described as a medium sized table, which
normally queries quickly, except for this one...
Table "data_static" has around 35,000 records.
This trivial query:
SELECT tracking_id,
complainant_email,
DATE_FORMAT(import_date,'%Y-%c-%e') AS date,
subject
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: delay on executing mysql_free_result with underfetched query
Description:
If to execute mysql_use_result on the query that returns large amount of
records and then
execute mysql_free_result - execution the last function take time equal to
fet
Are many people using MySQL version 4 yet? I'm interested in it because I
want to use it's SSL capabilities but would like to hear that people are not
having trouble with it first.
Thanks,
David Rock
-
Before posting, please
You don't even need the "check" field you can just directly check the
contents of the image field. Although I'm not sure if you are trying to
set a filter or display something different. If you want to display a
conditional on a field then you need to specify that field directly.
select *,if(im
Hi Beogradjanin
As Paul mentioned yesterday, the final column defination does not require a
comma because it is the final defination.
Bhavin.
- Original Message -
From: "Beogradjanin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 7:38 PM
Subject: I'm new in Mys
Hello,
I would like to ask three questions related to MySQL and MERGE tables.
I have a program that reads from mysql server (4.0.5 for Solaris 2.8 on a
V880 with 8 processors and 32 GB of memory), using Perl DBI MySQl driver,
two tables FULLM (merge of 3 tables) and RECKM (merge of 15 table
That would be my guess, the extra time is the data transfer. You can
easily verify this by changing your query to:
SELECT COUNT(*)
FROM data_static
WHERE case_id = 0;
That will give you the raw query time without the data transfer or
formatting overhead.
On Wednesday, January 8, 2003, at 10:32
The problem you are having is a result of the permissions that are set on
the data and log directories that are identified in my.cnf, and is
documented in the MySQL Reference Manual. If you change the ownership of
the data and log directories to mysql (both user and group), the error
should go awa
On Mon, 6 Jan 2003, Beogradjanin wrote:
> Hello mysql,
>
> I want to learn MySQL and PHP I've installed Apache , PHP and MySql
> Whan I try to make tables
>
> create table guestbook
> (
> name varchar( 40 ) null,
> location varchar( 40 ) null.
> email varchar( 40 ) null,
> url varchar( 40 ) nu
Hey folks-
'nother question.
I'm not an SQL expert, and I think I need a subselect, which means I need a
workaround on MySQL 3.23 or whatever version it is.
Here's the tables I have, with the relevant columns:
Students
- Name
- StudentID (PK)
- ClassID
Classes
- ClassID (PK)
- Name
Each
I just imported a .csv file and one of the columns of data was websites
addresses. Those addresses aren't being recognized as links when I output
an html table from my queries. I'm scratching me head on how to make the
conversion. I figured there would by a hypertext datatype of some sort, but
I
At 18:06 +0200 1/8/03, Vladimir Zheleznyak wrote:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: delay on executing mysql_free_result with underfetched query
Description:
If to execute mysql_use_result on the query that returns large amount of
records and then
execute mysql_free_result -
- Original Message -
From: "Lefevre, Steven" <[EMAIL PROTECTED]>
> The problem (as I see it) is that I'm storing the last name and the first
> name in two seperate fields. I can make an SQL statement like "Select *
from
> Students Where LastName Like "Smith%";", but can I make something li
>Are many people using MySQL version 4 yet? I'm interested in it
because I
>want to use it's SSL capabilities but would like to hear that people
are not
>having trouble with it first.
We have been using 4.0.x for about five months now on a production
system and have had no problems.
Scott Pipp
At 7:27 -0500 1/8/03, Veysel Harun Sahin wrote:
Hello,
I have two tables whose structures are below.
- Table1 -
table1id int not null auto_increment
data varchar(30)
- Table2 -
table2id int not null auto_increment
table1id int not null
data varchar(30)
These two tables are connected to each o
At 14:03 +0100 1/8/03, Walter Procopio wrote:
Hi,
I have installed mysql max 4.0.7 gamma on a Suse (ver. 8.0 professional)
linux server. I have tried many full text queries and I had only a problem
with a query like this:
SELECT count(a.rsori) pippo
FROM ecoras a, ecotxt b
WHERE MATCH ( b.rstxt
Hi all,
I've read the following in a MySQL book:
A special case of record deletion occurs when you clear out a table
entirely using a DELETE with no WHERE clause:
DELETE FROM tbl_name;
In this case, the sequence counter may be reset to 1, even for table types
for which values normally are no
Jonas,
We use mysqlhotcopy as a command line script set to run daily as a cron
job. Seems to work fine. You can add flags that allow you to maintain
previous copies of the db in case you need to go back a version or two. It
took about 10 minutes to set up. We then run TSM backups to storage of
* Svens Klave
> Can anybody help me
> with select query
I can try.
> how to do this:
>
> I have table "foo1" with two fields "image" "check"
>
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to make query
> select * from foo1 where [so is
On Wednesday 08 January 2003 03:17, Adam Dershewitz wrote:
> After digging through the mysql web site and hunting on google I couldn't
> find the answer to a problem that I am having.
>
> It looks like MySQL is having problems differentiating between the
> "Т"(ascii 244) and the "o" characters.
On Monday 06 January 2003 14:51, Daniel Kiss wrote:
> Does anyone know why 'on update cascade' option does not work in InnoDB
> foreign keys?
> Is it supported anyway?
It's supported since 4.0.8:
http://www.mysql.com/doc/en/News-4.0.8.html
--
For technical support contracts, goto http
On Wednesday 08 January 2003 06:55, CM Miller wrote:
> Have a new years resolution, to get MySQL to run
>
>
> Here are the errors that I keep getting...
>
> I don't understand what this is telling me?
>
> from /var/log
>
> 021214 19:13:21 mysqld started
> 021214 19:13:21 /usr/local/libexec/mys
On Tuesday 07 January 2003 11:49, Leonid Prokopets wrote:
> I'm having a problem running MySQL as NT service on Win2000 plattform. It
> works allright in manual mode (by 'mysqld' command), but refuses to run as
> service. I installed the service by 'mysqld-max-nt --install' command.
> The syste
Hi Stefan,
-Original Message-
From: Stefan Hinz, iConnect (Berlin)
>
> Alexander,
>
> > - After having set up both machines completely, I installed
> > the Win32 binary distribution of MySQL 4.0.7-gamma. Although
> > I did not upgrade from an earlier version, the privileges
> > tables stil
On Sunday 05 January 2003 16:10, Francesco wrote:
> I tried to drop a table with Mysql 4.0.1 alpha nt and I have encountered
> the following problem:
> ERROR &: Error on delete of .'\camcomm.tmpge.MYI'
> The problem persists. I don't know the reason of this error.
> I ask if a new version of Mysql
>I'm having trouble getting the two to work, when I try to connect to
the
>database in Crystal I get an error message saying "ODBC Error:
[TCX][MyODBC}
>Could not read table names"
It is worth a try. Here are the instructions for the registry fix.
Download odbcregs.zip from Crystal Decisions.
h
On Wed, Jan 08, 2003 at 03:27:51PM +0200, Svens Klave wrote:
>
> Can anybody help me
> with select query
>
> how to do this:
>
> I have table "foo1" with two fields "image" "check"
>
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to ma
FROM must precede WHERE.
Terence Ng wrote:
How do I correct this SQL code:
2 tables there,
lcopen: id, bank, unit_price_us, order_cbm
lcreceive: id, amount_us, due_date
#this condition :lcreceive.due_date < current_date
#only affect to : SUM(lcreceive.amount_us)
#and NOT :
#SUM(lcopen.unit_pr
I need to copy a MySql Production database to QA. What is the best method of
doing this? Do I need to write SQL queries or is there another quicker method?
From the command line?
From, within phpMyAdmin?
-
Before posting, pl
On Wed, Jan 08, 2003 at 09:00:51AM -0700, David Rock wrote:
>
> Are many people using MySQL version 4 yet? I'm interested in it
> because I want to use it's SSL capabilities but would like to hear
> that people are not having trouble with it first.
I've had very good luck with MySQL 4 in several
Hello Paul,
I have tried the code you have written, before posting to list and it did not work.
When I have seen the sentence "This requires that you have MySQL 4.x" at your mail I
realized the problem. I am using mySQL 3.23.49. :(
Thanks for your help.
Paul DuBois <[EMAIL PROTECTED]> wrote:
-Original Message-
From: Lefevre, Steven [mailto:[EMAIL PROTECTED]]
>
> Hey folks-
>
> 'nother question.
> I'm not an SQL expert, and I think I need a subselect, which
> means I need a workaround on MySQL 3.23 or whatever version it is.
>
> Here's the tables I have, with the relevant column
Resending this, since the first one didn't seem to get posted on the MySQL
list.
> -Original Message-
> From: Erlend HopsÛ StrÛmsvik
> Sent: 7. januar 2003 10:18
> To: [EMAIL PROTECTED]
> Subject: RE: MySQL fulltext. Question about the stopword list
>
>
> > What I can easily do without
> What I can easily do without breaking 4.0.x "gamma" status, is to add
> command line switch --disable-fulltext-stopwords. It can help as a
> temporary solution, untill a proper fix - per-index options, that is -
> will be implemented.
That would be helpful for me, but what about Thomas Spahni's
is there an snmp mib or something available for snmp to monitor mysql
server? or, does anyone have a script that they would like to share that
they use to monitor and gather statistics about mysql?
thanks,
shon
-
Before posting,
I think the problem is in your table structure. If you did this:
Students:
- Name
- StudentID
Classes:
- ClassID
- Name
StudentsClasses:
- StudentID (PK)
- ClassID (PK)
(You make them a combined key by doing PRIMARY KEY (StudentID,ClassID) in
your table def.)
When you add a student to a class
Charles,
>> I posted the same problem a couple of days ago. LOCAL will not work
>> because of a security "improvement" the MySQL folks applied.
> LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table;
> Hope this helps, but only a workaround...
Without LOCAL, quite alot of things will not
At 8:34 -0800 1/8/03, Rick Tucker wrote:
I just imported a .csv file and one of the columns of data was websites
addresses. Those addresses aren't being recognized as links when I output
an html table from my queries. I'm scratching me head on how to make the
conversion. I figured there would b
Hello mysql,
I try use 4.0.8 (max & standard)in our production box,
and it was crash every TCP connection, For 4.0.7 (standard) i has over 20 days
uptime.
Best regards,
Andrew Sitnikov
e-mail : [EMAIL PROTECTED]
GSM: (+372) 56491109
-
Rick Tucker wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversion. I figured there would by a hypertext
From: Rick Tucker <[EMAIL PROTECTED]>
> Those addresses aren't being recognized as links when I output
> an html table from my queries.
[ snip ]
> I figured there would by a hypertext datatype of some sort...
Do you mean like this:
CREATE TABLE stuff (
link hypertext
);
INSERT I
From: Lefevre, Steven <[EMAIL PROTECTED]>
> ...I think I need a subselect...
It's rare that a sub-select is actually ~needed~, but it does happen. You can almost
always get around it with a JOIN of some sort.
> Final result should look like
> Student | Class
> --
> St
can you send the description of your table. There are lots of reasion for
slowing down your query but I dont thint Date_formate () is a cause for
slowing down the query.You have very less data only 35,000..
You can try to optimize by using
1. Create INDEX on case_id
2. optimize and check table [t
can you send the description of your table. There are lots of reasion for
slowing down your query but I dont thint Date_formate () is a cause for
slowing down the query.You have very less data only 35,000..
You can try to optimize by using
1. Create INDEX on case_id
2. optimize and check table [t
Hi Prathmesh,
What is the behaviour that you see when you try to LOAD DATA. Any messages?
Regards,
Bhavin.
- Original Message -
From: "Prathmesh J. Mahidharia" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 11:22 PM
Subject: Load local data infile problem
> he
> I have two tables whose structures are below.
>
> - Table1 -
> table1id int not null auto_increment
> data varchar(30)
>
> - Table2 -
> table2id int not null auto_increment
> table1id int not null
> data varchar(30)
>
>
> These two tables are connected to each other with the
> "table1id" co
On Wed, Jan 08, 2003 at 08:34:25AM -0800, Rick Tucker wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversio
Larry,
This is the code I'm using. I'm pretty new to PHP, so there may be a simple
solution within PHP of which I'm unaware. I just thought it could be done
from the MySQL side of things.
$resultID = mysql_query("SELECT * FROM ports", $linkID);
print "Port #";
print "TransportApplicationRFC/V
I seem to have found a bug with 4.0.7. I just want to make sure the
issue hasn't been covered before I submit a report.
I have 4.0.7 installed on windows 2000 server with all the service packs
and stuff. When I connect to the database through a Linux client
(haven't tried it on the box itself) and
On 8 Jan 2003, at 15:27, Svens Klave wrote:
> | image | check |
> | 6782 | 0 |
> | 2732 | 1 |
> | 6734 | 1 |
>
> so I want to make query
> select * from foo1 where [so is it possible to make some if check=1 then
> image is image but if check=0 then into image goes othe
Try...
while ($row = mysql_fetch_row($resultID))
>{
>print "";
>foreach ($row as $field)
>{
print "$field";
>}
>print "";
>}
>print "";
>mysql_close ($linkID);
I don't use print so I'm not sure about that, I use echo.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message
Got another problem with 4.0.7 when trying to alter the table.
Trying to run:
ALTER TABLE `call_information` CHANGE `close_date` `close_date`
TIMESTAMP DEFAULT '' NOT NULL
and it returns a:
ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
>Student | Class
>--
>Steve Lefevre | Math101
>Stacy Adams | Intro to SQL
>Something like
>SELECT Student.Name, Classes.Name FROM Students, Classes WHERE
>Students.StudentID = " . $ID . " AND Classes.Name IN ( SELECT
Classes.Name
>FROM Classes WHERE ClassID = Students.Clas
At 9:33 +0200 1/8/03, Octavian Rasnita wrote:
Hi all,
I've read the following in a MySQL book:
A special case of record deletion occurs when you clear out a table
entirely using a DELETE with no WHERE clause:
DELETE FROM tbl_name;
In this case, the sequence counter may be reset to 1, even f
On 1/8/03 8:34 AM, "Rick Tucker" <[EMAIL PROTECTED]> wrote:
> I just imported a .csv file and one of the columns of data was websites
> addresses. Those addresses aren't being recognized as links when I output
> an html table from my queries. I'm scratching me head on how to make the
> conversio
Octavian,
> I've read the following in a MySQL book:
It's a rather old book, which deals with MySQL 3.23, and not with MySQL
4.x.
> DELETE FROM tbl_name WHERE 1 > 0;
In MySQL 3.23, this was a workaround to force the server to delete a
table row by row. By default, 3.23 would on DELETE FROM tbl
FYI:
Setting up a lab environment for this database answered my question.
I moved the big field to a dedicated table, and queries on data_static got
much faster. Instead of 60 seconds, the query is done in less than 1.
Thanks for all the ideas people sent me privately.
Cheers,
Jim
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rick,
How are you pulling the data? PHP? Perl? ASP? HTML doesn't
automatically insert hyperlinks where it finds
http://www.somedomain.com. It has to be told that it is a link by the
http://www.somedomain.com";>SomeDomain
tag.
If you are pu
I got a gift certificate for book store. I am looking for good MySql
books with reference, examples, etc? Anyone have some ideas on good
books to look at
Chuck
=
"Incoming rounds always have the right of way"
- Rules of War
-
Alexander,
> Have you tried to reproduce them?
Bug #1: GRANT USAGE doesn't seem to create a user:
mysql> GRANT USAGE ON *.* TO 'foo'@'foohost';
Query OK, 0 rows affected (0.26 sec)
mysql> SHOW GRANTS FOR 'foo'@'foohost';
Empty set (0.03 sec)
mysql> SELECT Host, User, Password FROM mysql.user W
I'd like to be able to create a new database using Perl/DBI instead of using
the MySQL command line (and other) utilities. It looks like you can create a
new database with the driver handle but I can't seem to make it work.
-
Bef
Frank,
> >I need to copy a MySql Production database to QA. What is the best
method of
> >doing this? Do I need to write SQL queries or is there another
quicker method?
There are alot of possibilities to accomplish this fast.
> > From the command line?
shell> mysqldump -uusername -ppassword yo
I created a new forum for all of you who do not like to dig throught tons of
a-mail to find one that really matters.You can talk about Linux, mysql and
pretty much whatever else is computer realted. Check it out here
http://www.linuxforum.hopto.org
thanks
_
I had this same problem. Based on a similar thread, I went into the
properties for the service, changed it run under a user account with admin
privileges, applied the changes, then changed it back to run under the local
account and applied the changes. No more problem. Go figure.
-Original
Bonjour,
Consultant / Chef de Projet Indépendant à la recherche d'une mission,
je vous propose ma collaboration.
Mes principales compétences techniques sont les suivantes :
Systèmes : Windows NT / 2000 / XP, Linux, Unix (Solaris)
Réseaux : Windows NT / 2000 / XP, TCP/IP, DNS, IIS, Netscape
/
>Imagine an ISP giving every customer write privileges for the mysql/bin
directory ... ;-/
Why would they have to do that? The file does not need to be in that
directory. In order to use LOAD DATA INFILE without LOCAL the file just
needs to be somewhere on the server that mysqld is running on and
On 8 Jan 2003, at 12:08, Paul DuBois wrote:
> You must perform the conversion yourself, displaying the URL both
> as the href atttribute and body text of an tag. Don't forget
> to URL-encode it for use in the attribute, and HTML-encode it for
> use in the body text.
I think Paul meant to say yo
At 10:27 -0800 1/8/03, Steven Nakhla wrote:
Aside from designating a row as a primary key, is
their any SQL syntax to force that entries within a
row are unique (such as a string value)? Thanks!
Steve Nakhla
Well, other than using a PRIMARY KEY, you can use a
UNIQUE index, but aside from a cou
On Wed, Jan 08, 2003 at 10:27:30AM -0800, Steven Nakhla wrote:
> Aside from designating a row as a primary key, is
> their any SQL syntax to force that entries within a
> row are unique (such as a string value)? Thanks!
Hello Steve,
You can create a UNIQUE key for a column that will ensure t
What I did was setup my file in mysql directory (i.e. fred.txt)
LOAD DATA INFILE "C:\\mysql\\fred.txt" INTO TABLE data_table;
Hope this helps, but only a workaround...
Chuck
http://68.43.100.7:81/aa8vs
==
"Patriotism is the willingness to kill and
be kil
Hi,
Is there a difference in speed between these two querys:
SELECT whatever, somethin_else FROM table1 WHERE 1 AND (
table1.whatever='value' OR )
SELECT whatever, somethin_else FROM table1 WHERE table1.whatever='value'
OR ...
-
Hi Rick!
You could also do something like the following (I'm assuming that the
http://www part isn't in $field already. . .).
=
print "";
foreach ($row as $field)
{
print "http://www.$field/";>http://www.$field";
}
print "";
=
Cheers!
-warre
Aside from designating a row as a primary key, is
their any SQL syntax to force that entries within a
row are unique (such as a string value)? Thanks!
Steve Nakhla
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mai
1 - 100 of 124 matches
Mail list logo
