Hi,
I have data in CSV format file which has a date value
in the format 'dd/mm/yy'?
When i used 'Load data...' to import to a MySQL table,
all the fields gets the value from the file except the
date field that contains the date of birth??
is there any way to format and import???
Thanks
Regards
S
mysqlÄúºÃ!
Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ
ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄ"ÎâÊÏ"ÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£
¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ
Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É
ʹ»¼Õß½â³ý²¡Í´¡£
¾Ö
- Original Message -
From: "Bryce C" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 10, 2002 7:14 AM
Subject: resetting mysql server "gently"
Bryce wrote:
BC> I have a script that runs every minute to deterimine
BC> if the load is above a certain value (or if swap is
At 17:19 -0400 10/10/02, [EMAIL PROTECTED] wrote:
> >Description:
> It is possible to create a table which mysqldump can dump,
>but mysql cannot undump.
>>How-To-Repeat:
Yes. You'll probably have better luck if you run mysqldump with
the --quote-names option.
> Create a table
There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
this users environment (RH 7.3).
"my.cnf" has been modified to include individual "user", "port" ,
"bind-address" and "host" specifics (and etc) unique to that user and is
passed as "--defaults-file" through "mysqld_safe
i appologize for sending unnecessary mail, but after
hurrying off that last response, i realized that you
are running oracle.
please be aware that you have not encountered a
shortcoming in mysql. i refer you to the section in
corereader's documentation concerning oracle's non-
standard ch
try corereader. it will run queries against your
mysql, oracle, and ms sql server (and anything else
laying around). you can switch between your servers
with a click.
peter brawley gives your answer in another message,
but you can quickly work out those simple queries
with point and click
Hi,
I finally could get MySql UDF functions to work under win32 (VC++). The
only thing that concerns me is that it nevers returns any error message.
It works fine, but none error message is displayed.
The function expects 2 strings, if one, more or none is passed, I should get
the error mess
At 16:04 -0400 10/10/02, Kevin wrote:
>Another question...I know. Second one in 24 hours...I hate it too.
>
>I have a column of data that may begin with an open parenthesis "(". When I
>do this:
>
> mysql> SELECT * FROM table WHERE column REGEXP "^(text";
>
>I get this:
>
> ERROR 1139: Got
On Thu, 10 Oct 2002, Anil Garg wrote:
> Date: Thu, 10 Oct 2002 13:38:52 -0400
> From: Anil Garg <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: users who can access a database
>
> hi,
Please checkout the GRANT command. In earlier versions of mysql you had
to put information into the mys
Hi all.
I'm having a problem with a pass-through query in Access (2002).
I'm using MySQL-4.0.3 and MyODBC 3.51.04.
I have already posted to the MyODBC list, but there doesn't appear to be
any traffic, and I'm not sure if it's an ODBC problem or not, so I'm
reposting here...
Table definition a
At 12:18 +0800 10/9/02, lb wrote:
>Dear all,
>
>I am not sure why mysql thinks char(192) = char(194) = char(193) =
>char(195)?
Presumably they are the same according to the character set's
collating sequence.
>
>mysql> select char(192)=char(193);
>+-+
>| char(192)=char(193) |
Hello Victor,
At 04:30 PM 10/10/2002 +0100, Victor Kirk wrote:
>>> Can anyone help me? Ideally I would like something that would
>>> be portable to oracle/sql server. Efficiency is not an issue.
>
>> How about ...
>
>>SELECT * FROM teams
>>LEFT JOIN users USING (team_id)
>>WHERE u
At 12:58 +0200 10/10/02, Alex Polite wrote:
>Is there any way I could display a MySQL database as a filesystem
>under Linux?
What does that mean?
>
>alex
>
>--
>Alex Polite
>http://plusseven.com/gpg
-
Before posting, please ch
I have one database(test) i would like to copy over to (test1). Ehat is
the syntax to do this? Is there any to just change the name of the
database?
Thanks in advance
(query, mysql)
-
Before posting, please check:
http://ww
Working with new clean install of Redhat 8.0 and
Apache 2.0.40 / php 4.2.2 / mySQL 3.23.52
I have a phpinfo page and mySQL is setup
I can access tables thru mysql
When ever I try to attach remotely to mySQL
thru php (DreamweaverMX, phpmysqladmin, Access ODBC export)
I get the following error:
It looks like a bug. I was able to repeat it and I had different results for the same
join depending on when index was added and values of actual data in tables.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 6:33 PM
To: [EMAIL PRO
At 15:10 -0300 10/10/02, Dyego Souza do Carmo wrote:
>In mySQL 4.0 the "Transaction multi points" are supported ?
>
>
>ex:
>
>BEGIN;
>INSERT INTO A VALUES (1);
>BEGIN WORK2;
>INSERT INTO A VALUES (2);
>ROLLBACK TO WORK2;
>COMMIT;
>
>In this case only value 1 are inserted in the table !
>
>
>mysql
I am not convinced that index on nullable field is a design flaw. This is not the
behavior in the major databases. To match and join two nulls, IS NULL should be
expected to be used instead of a.col1 = b.col2.
-Original Message-
From: Jan Steinman [mailto:[EMAIL PROTECTED]]
Sent: Thursd
Hello!
I'm sorry to disturb,
I'm an enthusiast user of mysql series, it's fantastic!
I like to know if it's possible to embed the engine (also with limited
functionalities) into a win32 target exe.
I like to build a .OBJ of the server with the borland c++, then load the
OBJ's into a DELPHI appli
>Description:
It is possible to create a table which mysqldump can dump, but mysql cannot
undump.
>How-To-Repeat:
Create a table with a field named 'key':
CREATE TABLE `testthing` (
`key` TINYINT NOT NULL,
PRIMARY KEY (`key`)
);
When you run mysqldump, it gives this back:
CREATE
I am getting:
./bin/myisamchk: error: 'data/mckesson/tempbak.frm' doesn't have a
correct index definition. You need to recreate it before you can do a
repair
on a number of my tables. I have recently imported this data, from a
box that is totally ruined. I have no other copy of the data.
A
> not a sum of all of the firsts. What I do want is a sum of
> all of the numbers in column 5 where the date is after a
> certain date, column 3 has "done" in it, and the url matches
> a regular expression mysql.
>
> How do I do that?
SELECT SUM(column5) FROM readdata WHERE processdate > '2
Is there any documentation/hints/tips avaible on how
to install 2 (or more) MySQL servers (and clients) on
the same Windows 2000 box?
I want to install multiple servers (3 machines x 3
servers) and clients to test replication, locking and
load.
Thanks a lot
=
-
Benoi
I'm running MySQL 3.23.52 (NT), and have discovered that some of the tables
in some old databases are still ISAM (left over from the 3.22.32 days).
I want to convert these tables to MyISAM, but rather than shot-gun all
tables in all databases, I'd like to run a query to determine which tables
are
I agree completely with Egor! You should not be killing your processes to
solve load problems. If there is a load problem 1) You need to write your
applications better, 2) you need to have a better database structure, 3) you
need to analyze where indexes would help you, or 4) you need a more
any info in the logs?
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 11:20 AM
To: [EMAIL PROTECTED]
Subject: cant connect to mysql
hi
i am facing a very strange problem..
when i say "apachectl restart" my web site works fine..
but, whe
Another question...I know. Second one in 24 hours...I hate it too.
I have a column of data that may begin with an open parenthesis "(". When I
do this:
mysql> SELECT * FROM table WHERE column REGEXP "^(text";
I get this:
ERROR 1139: Got error 'parentheses not balanced' from regexp
So,
Hi,
In a previous job I had the (mis)fortune to develop software exclusively on
DB2. While doing so I would often use FETCH to examine a certain number of
records. Example:
SELECT * from table FETCH FIRST 10 ROWS ONLY.
When I use this particular syntax in any mysql interface (I've used 2) I g
On 10 Oct 2002 at 16:30, Victor Kirk wrote:
> >> I have two tables, one for user details and another to indicate
> >> membership of some team. The later has user_id and team_id. I
> >> want to select all users that are NOT in a particular team.
> >>
> >> After a lot of effort (my sql skills ar
hi list,
this is one of these faq-questions (for sql queries) nowhere found. normally
two tables are
joined by two singular keys, for instance "id" which is (1) in both tables.
But how do I join them over a id-field like this:(1,2,4)? I know, there is
the WHERE id IN(...) function, but if I do a:
you need the ncurses libraries.
Philippe Benchemoul wrote:
>Hi,
>
>I try to install mysql 3.23.52 on a debian 2.2.8 with the sources.
>./configure --prefix=/usr/local/progs/mysql
>
>For the configure level, I have the message :
>checking for termcap functions library... configure: er
I haven't seen any traffic on this thread, so I figured I'd repost it
with a slightly more catchy subject. :)
Has anyone looked into this?
On Tue, Oct 08, 2002 at 09:12:13PM -0500, Shane Allen wrote:
> >Description:
>
> See "How-To-Repeat"
>
> >How-To-Repeat:
>
> I uploaded a copy of the tabl
Is there any way I could display a MySQL database as a filesystem
under Linux?
alex
--
Alex Polite
http://plusseven.com/gpg
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
Thanks, Keith! That does what I want.
I followed in the manual what I thought would work (page 163, 164). And,
since the response from my entering in a query was always "hey stupid, you
have to use the 'GROUP BY' when you do this," I never tried it without it.
Anyway, that is just justification f
Hi,
I setup a mysql db on an i386 box. After a while, I
needed to transfer that db to an s390 box. So I went
ahead with the mysqldump, etc.. and when I transferred
the db, I noticed that on the s390, the fields that
recorded the system time/date where not working...as
if they did not transfer c
In mySQL 4.0 the "Transaction multi points" are supported ?
ex:
BEGIN;
INSERT INTO A VALUES (1);
BEGIN WORK2;
INSERT INTO A VALUES (2);
ROLLBACK TO WORK2;
COMMIT;
In this case only value 1 are inserted in the table !
mysql 4 suports it ?
sql,query
--
On 10 Oct 2002, at 11:45, Kevin wrote:
> SELECT column5, SUM(column5) FROM realdata WHERE processdate > "2002-8-31"
> AND column3 = "done" AND url REGEXP "mysql";
>
> Thus, I get the 1140 error.
That's right. You can't get the individual values and the sum at the
same time. The sum is a sing
hi,
Is there some place where i can define the users who can access the
database.
If yes..plz help
thanx and regards
anil
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
Dear Mysql user,
I am not able to connect mysql server after executing this command
./safe_mysqld -O key_buffer=64M -O table_cache=256 -O
sort_buffer=4M -O read_buffer_size=1M
[repository@shoggoth bin]$ ./mysql -u root
ERROR 2002: Can't connect to local MySQL server through socket
'/t
select sum(first) from example;
should work.
Artem
-Original Message-
From: Kevin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 10:36 PM
To: [EMAIL PROTECTED]
Subject: Help with Sum(), newbie
OK. Maybe I'm expecting too much of myself, but I can't figure out what I am
From: Victor Kirk <[EMAIL PROTECTED]>
> SELECT u.uname FROM users u
> WHERE NOT EXISTS (SELECT * FROM team_members=20
> WHERE team_id =3D 7 AND user_id=3Du.user_id);
It sounds to me like you are trying to ask the database:
"Tell me all the users that aren't in team 7."
Hi,
I have arrived to pass the first level and now I'm at the second one.
I have done a "apt-get install libcdk-dev" to resolve the first level.
For the level 2 "make", I have this message :
-
ibmysql.c: In function `mysql_real_connect':
li
>From: [EMAIL PROTECTED]
>
>After adding a key to a nullable column, null values will
>successfully join through to null values in other tables.
And this is a problem because? :-)
Seriously, it may be a bug, but IMHO it is a design flaw to index a NULL field.
Indexed fields should always be NOT
At 12:21 +0100 10/10/02, Victor Kirk wrote:
>Hi,
>
>I have two tables, one for user details and another to indicate
>membership of some team. The later has user_id and team_id. I
>want to select all users that are NOT in a particular team.
>
>After a lot of effort (my sql skills are almost no exi
I did the following to resolve the problem.
1. Your create command didnt work for me and I changed the add(128) on line
6 to addrs varchar(128). I suppose this was a typo since you already had a
working table.
2. Your main problem comes from the format of your input. Use /N for
ommited column
hi
i am facing a very strange problem..
when i say "apachectl restart" my web site works fine..
but, when i say
#apachectl stop
#apachectl start
the web user is not able to connect to the mysql database.
Now, when i reboot the machine, the things become fine agian.
I would reaaly appreciat
Stephanie,
Without knowing the architecture of your program I cannot give a precise
answer. But I'll make a few stabs at it...
First, MySQL, being an application in its own right, can be installed
separately from your application. Alternately, your application's
installation program could incl
On Thursday, Oct 10, 2002, at 02:26 America/Phoenix, Nasir Aziz Gill
wrote:
> Hi fellows,
>
> I got one text file of 9816 records (9816 lines) seprated by commas and
> enclosed by the inverted quotes and seprated by the end of lines. But
> when I
> import the file, it only gets half of recor
Matthew J. Francis writes:
> On Thu, 2002-10-10 at 13:23, Sinisa Milivojevic wrote:
>
> I've pulled the latest 3.23 code with BK and compiled it on the machine
> in question. Unfortunately the problem still seems to be there as I can
> still knock the server over with the test case I wrote. The b
On Thu, 2002-10-10 at 13:23, Sinisa Milivojevic wrote:
>
> Hi!
>
> Our replication developers have recently fixed a bug that looks
> conspiciously like the one you reported.
>
> It will come up in 3.23.53 which should come up in 7 - 10 days.
>
> Would you please be so kind to check it out if
On Thursday, Oct 10, 2002, at 01:48 America/Phoenix, James Kavanagh
wrote:
> Hi all,
>
> Does anyone know if there's a way, using JDBC, to connect to a mySQL
> server without specifying a database?
>
> Basically I need to connect to n servers but don't always know which
> databases exist on the
Hi,
I try to install mysql 3.23.52 on a debian 2.2.8 with the sources.
./configure --prefix=/usr/local/progs/mysql
For the configure level, I have the message :
checking for termcap functions library... configure: error: No
curses/termcap library found
I have tried to install ter
kayamboo,
Thursday, October 10, 2002, 3:25:38 AM, you wrote:
k> If suppose my table has thousands of records, is it possible to create a
k> new table without a foreign key constraint, and then copy the existing data
k> with the foreign key constraint to the new one ?
Sure.
--
For technical
Erlend,
Wednesday, October 09, 2002, 2:21:40 PM, you wrote:
EHS> First time I downloaded the source code and compiled it, I just deleted the
EHS> old indexes and created new ones. But now I have a lot of tables with
EHS> fulltext indexes. So I'm looking for an easy way to do it.
EHS> Searched thr
Hello Bryce,
Thursday, October 10, 2002, 8:14:22 AM, you wrote:
BC> I have a mysql + php + apache server that is under
BC> heavy load.
BC> I have a script that runs every minute to deterimine
BC> if the load is above a certain value (or if swap is
BC> high) and if so, it kills all the httpd pr
Hello unplug,
Wednesday, October 9, 2002, 11:58:57 AM, you wrote:
u> I failed to connect mysql from external network (it works by connected
u> . In the error log, I found the following message.
u> Number of processes running now: 1
u> mysqld process hanging, pid 13523 - killed
u> 021009 12:35
Moestl,
Tuesday, October 08, 2002, 3:47:41 PM, you wrote:
MW> That's maybe true, I'll check it. As it's the default setting on Windows and I've
never changed it I guess it's on.
MW> If the flag lower_case_table_names is turned on, I would expect that SHOW
DATABASES os SHOW TABLES is returning
WebMaster,
Thursday, October 10, 2002, 11:22:25 AM, you wrote:
>MySQL don't detect the equal float numbers if aren't ineger, left float
>alwais greater then right float es. 1.1 > 1.1 = true.
> mysql> SELECT * FROM float_bug WHERE f=1.1;
> Empty set (0.00 sec)
It's an inexactness of floating poi
Bill,
Wednesday, October 09, 2002, 6:55:26 PM, you wrote:
BH> Nope - nothing close to 4GB or even 1GB... My greatest data file size
BH> is 80MB. The largest table is 1.7 million rows. I have databases with
BH> more and bigger files. I think my problem is that the table having the
BH> proble
Perumal,
Thursday, October 10, 2002, 3:01:21 PM, you wrote:
P> Since I need to install mysql-max , please give me an idea on
P> my.cnf in linux environment and tell me also other configurations in the
P> files to install mysql-max.
If you want to use InnoDB, please read the following chapt
Victor,
Thursday, October 10, 2002, 2:21:44 PM, you wrote:
VK> I have two tables, one for user details and another to indicate
VK> membership of some team. The later has user_id and team_id. I
VK> want to select all users that are NOT in a particular team.
VK> After a lot of effort (my sql ski
Thanks for the replies, Lucas, Terence, and John!
John: I don't run Windows, so that will not help.
Terence: No. I wanted the sums of all of the firsts...Lucas nailed it,
but...
Lucas: If I enter "SELECT SUM(first) FROM example;" it gives me the correct
answer, 3. I created that simple database
>> I have two tables, one for user details and another to indicate
>> membership of some team. The later has user_id and team_id. I
>> want to select all users that are NOT in a particular team.
>>
>> After a lot of effort (my sql skills are almost no existent) I
>> have the following that work
bonjour,
i would like to know if row level grants are in development
or are planned to be soon.
i am writing a software and i need row level grants,
so i would like to know if i'd better wait for mysql to include
this feature or write a sort of grant feature myself
in the software (not in mysql
Victor,
> I have two tables, one for user details and another to indicate
> membership of some team. The later has user_id and team_id. I
> want to select all users that are NOT in a particular team.
>
> After a lot of effort (my sql skills are almost no existent) I
> have the following that w
Stephanie,
Connector/J takes advantage of client/server architecture over TCP. This
means that the MySQL server could exist on one machine (a server), and
the client application(s) can connect to it via TCP and Connector/J from
anywhere that has a TCP route to the MySQL server.
If Connector/J is
if you have a windows machine for a front end,
download corereader from http://corereader.com/
it's free. it will connect to your mysql server
(and anything else).
it lets you do point and click queries, so you can
very quickly experiment to get the results that you
want. it also builds a
Please do not hesitate to contact us if you have any problems.
Jeff Zanzinger
Trowbridge and Associates
321-725-2981 (Phone)
[EMAIL PROTECTED]
100% Committed to Customer Satisfaction
-Original Message-
From: Jeff Zanzinger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002
Stephanie,
> Does anyone know if there's a way in MySQL have the same functionality
> without installing the whole program on a users machine? I'm using a Java
> program along with Connector/J and a MySQL DB. We are trying to make it so
> the user doesn't have to install MySQL everytime they wan
I do this with
select db;
show tables;
then parse through the result.
Niclas Hedhman wrote:
>On Wednesday 09 October 2002 21:43, Inbal Ovadia wrote:
>
>
>>Hi all,
>>There is a way to know if I have table x in my db?
>>Let's say some catalog tables that hold information about the db like
>
Is there a solution to compile mySQL on Solaris 8 SPARC using Forte v7 (Sun
native C Compiler v7).
Sinceraly.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Does anyone know if there's a way in MySQL have the same functionality
without installing the whole program on a users machine? I'm using a Java
program along with Connector/J and a MySQL DB. We are trying to make it so
the user doesn't have to install MySQL everytime they want to install the
prog
If it on the same system just stop the old mysqld and stat the new one
pointing at the same mysql/var/.
OR copy the table across useing cp or mv...it should just work (did for
me)...
This is all unless you are useing a new table format but you could use ALTER
TABEL TYPE..
Simon
-Original
Hi!
Our replication developers have recently fixed a bug that looks
conspiciously like the one you reported.
It will come up in 3.23.53 which should come up in 7 - 10 days.
Would you please be so kind to check it out if it still persists.
If you would like to test code sooner, you can fetch
Hi,
Since I need to install mysql-max , please give me an idea on
my.cnf in linux environment and tell me also other configurations in the
files to install mysql-max.
Thanx,
Perumal.
-
Before posting, please check:
h
How can I retain databases I created using MySql 3.23 in Mysql 4.0?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thre
Hi,
I have two tables, one for user details and another to indicate
membership of some team. The later has user_id and team_id. I
want to select all users that are NOT in a particular team.
After a lot of effort (my sql skills are almost no existent) I
have the following that works with Oracle
>Description:
Mysql fails a test if compiled with 64 bit gcc on HP-UX 11.00
>How-To-Repeat:
By compiling mysql 3.32.52 with the options mentioned below a simple "make test" will
show the problem on test "func_time"
>Fix: none
>Submitter-Id: none
>Originator: none
>Organization: none
>MySQL s
Hi all,
I am sure this has been asked before as it appears to be a simple
error, but I have searched everywhere for an answer, hence apologies
if I am repeating someone else.
I have a MySQL database hosted which contains large blobs (Powerpoint
Presentations), hence the database is 100MB+.
I
Hi
Two thoughts
try \r\n instead of \n
or
if you are getting warnings it may be that there is a problem with the
data - illegal characters or something?
if neither works email me offlist and I will take a look, if that helps.
HTH
Peter
---
Excel
What seemed to work for me was to reduce the wait_timeout and
interactive_timeout to a reasonable number, not less than 60 seconds. 90-500
should be okay.
Any processes running longer than this value will be killed.
At least you dont have connections running for thousands of seconds.
Rgds
Terence
hi
ALTER TABLE `database1`.`tablename` ADD `newfield` TINYINT NOT NULL;
ALTER TABLE `database2`.`tablename` ADD `newfield` TINYINT NOT NULL;
ALTER TABLE `database3`.`tablename` ADD `newfield` TINYINT NOT NULL;
ALTER TABLE `database4`.`tablename` ADD `newfield` TINYINT NOT NULL;
etc
or script i
* David Jourard
> I need to improve the performance of a 1-word search engine
> which I've created.
[...]
> The search consists of 2 SQL queries
>
> Query 1: select rec_id from word where word='book';
>
> All the rec_ids are captured into an array.
>
> Query2: select description from content where
Hi fellows,
I got one text file of 9816 records (9816 lines) seprated by commas and
enclosed by the inverted quotes and seprated by the end of lines. But when I
import the file, it only gets half of records in the table using below
mentioned command;
LOAD DATA INFILE 'user.txt' INTO TABLE userda
Hi,
i am looking for a easy way to update MySQL-databases and -tables which have
the same structure.
For example "Database1" has the same structure and tables as "Database 2".
Now i add new datafields in "Database1" and i i also want them to be in
"Database 2".
And when you dont have only two
David Jourard wrote:
> It consists of 2 tables: word and content.
>
> content consists of 2 fields:
>
>rec_id int unsigned not null,
>description varchar(200) not null
>
>
> word consists of 2 fields:
> word varchar(50) not null,
>
thnx jan
vat im planning to do NOW is
ill store path to the pdf file in the db
as i ve been told the files r gonna take a hell lotta space (n i ve planty
of them)
secondly i ll keep the TEXT of these pdf files in the db for indexing n them
compare search keywordz with these n throw out the mat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thursday 10 October 2002 07:31, BWoTHa wrote:
> All when fine until I tried to do ./configure for the mysql-3.23.52
> from the source tar.gz.
>
> Problem is, it keeps looping saying "can't cd to mit-pthreads". I did
> my homework and seeked
fuck you!
this is the four time!
can you say me before!
--
INFOTEL TELEMATICA Srl Tel 0541 775927 - Fax 0541 775933 Sede operativa :
Via Nuova Circonvallazione 57/c - 47900 Rimini (RN) Sede legale : Via
Mazzoni 38 - 47900 Rim
Hi Arjen
If that is the case, suppose if I have forgotten the string password of
a particular user But I want to grant certain privileges to him,
is
GRANT DELETE ,. ON TO IDENTIFIED BY
''
valid ?
regards
- Original Message -
From: "Arjen Lentz" <[EMAIL PRO
> I am curious if there is a better way to restart mysql
> that would kill off any hung/long-running queries but
> not totally bring the server down. Any other ideas for
> managing a big load.
What you can do, assuming the mysql user has proper privs, is list and
kill all mysql threads running wh
mysql_connect("localhost:3306", "mysql_user", "mysql_password");
- Original Message -
From: "Webmaster" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 09, 2002 5:57 PM
Subject: using php to connect to a 2nd mySQL server
> Hello all,
>
> I am new to this list ... an
93 matches
Mail list logo
