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 of
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:
?php
$db = mysql_connect(host, user, pwd);
mysql_select_db(dbname,$db);
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),
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
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
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
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
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.
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!
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
Subject:
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't find
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
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
@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]
Sent: Tuesday,
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, January 07, 2003
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. Works fine
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 is
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
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
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
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
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
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 Mysql
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
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
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
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 ) null,
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
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 like
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 Pippin
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
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
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 it possible to
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. If you
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
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/mysqld: Can't
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 system
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 still have the
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 (the
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.
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 make query
select *
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 :
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,
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:
At
-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 columns:
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 breaking
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
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 work.
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
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 INTO
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
--
Steve
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
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
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
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
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
conversion.
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 tabletrthPort #/th;
print thTransport/thth
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 other
Try...
while ($row = mysql_fetch_row($resultID))
{
print tr;
foreach ($row as $field)
{
print td align=centera href=$field$field/a/td;
}
print /tr;
}
print /table;
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)
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:
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.ClassID )
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
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
conversion. I
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
A HREF=http://www.somedomain.com;SomeDomain/A
tag.
If
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
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.
-
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
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 a 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 you
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
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
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
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 tr;
foreach ($row as $field)
{
print td align=centera
href=http://www.$field/;http://www.$field/td;
}
print /tr;
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.
HTML doesn't just see a URL and automatically make it a hyperlink it is not
helpful like MS products. So what you are seeing is expected behavior. I
would alter the while loop to look like this...
while ($row = mysql_fetch_array($resultID)){ #fetch_array adds little
overhead and gives you an
ERROR 7: Error on rename of '.\helpdesk\call_information.MYI' to
'.\helpdesk\#sql2-b90-81.MYI' (Errcode: 13)
Any ideas on why I would get this??
Errorcode 13 is permission denied or file not found. Either
.\helpdesk\#sql2-b90-81.MYI exists and your mysqld user does not have
permission to
1 - 100 of 122 matches
Mail list logo