Hi
Could i in some way find out the seconds between to datetimes
I.E.
I have a DATETIME in a table and i want to find out how many
second it is from that DATETIME to NOW()
Does anyone have an idea?
/Jonas
-
Before posting,
On Wed, 2001-11-28 at 22:40, Jeremy Zawodny wrote:
> Has anyone considered optionally putting PCRE (Phil Hazel's Perl
> Compatible Regular Expressions -- http://www.pcre.org/) in MySQL so
> that someone could write:
>
> SELECT * FROM mytable WHERE myfield PCRE "some_complex_perl_regex";
select
>Description:
My correct socket filename is:
/home/bb/depot/mysql-3.23.43-9a7c0100047f2d1b5c72210d23df8448/tmp/mysql.sock
However, the socket filename is truncated in the error message when
the database isn't started:
% mysqlshow
./mysqlshow: Can't connect to local MySQL server through socket
Hi all,
I try to connect me to mySQL server from a java application. I create a
new user called "was" with
a password and with an host restricted to one host identified by his IP.
I have made another user for localhost (with the same name).
Local connection with "mysql -u was -p" wor
Hi,
Can you tell how can i do my database backup timely i mean in regular
intervals with out explicitly doing by us.
thanks in advance,
regards,
sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (t
Auri Net SAC wrote:
> Hi
>
> please who knows a package that install apache + php + mysql in linux,
> i know phptriad but its for windows
> Thanks for your answer
> rvj
Hello,
If your system is Linux...
You need install Apache , php and MySQL !
Edward.
-
Foxserv at sourceforge.net
- Original Message -
From: "Auri Net SAC" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 29, 2001 2:01 AM
Subject: Mysql apache php
> Hi
>
> please who knows a package that install apache + php + mysql in linux,
> i know phptriad but its
You can use server parameters see capter 10.1 Tuning server parameters.
and any other for maximum performance.
we use mail server, http server, app. server, on pentium 1 GHz, 800 MB of ram, nothing
problem.
Ady Wicaksono([EMAIL PROTECTED])@Thu, Nov 29, 2001 at 06:54:32PM +0700:
>
> Hi guys, i
I'm getting an error when i query a table i created. I have about 7 or 8
records, which showed up just fine, but all of a sudden I get this
SQL-query : [Edit]
SELECT * FROM `clients` LIMIT 0, 30
MySQL said:
Can't open file: 'clients.MYD'. (errno: 144)
whenever I try to browse or query the clie
Hi
please who knows a package that install apache + php + mysql in linux,
i know phptriad but its for windows
Thanks for your answer
rvj
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
On Thursday 29 November 2001 04:34, Jonathan Hilgeman wrote:
> I know this is a really simple thing that I'm just missing. Basically I
> want to store Apache logs in a mySQL database, in a table with 9 fields. I
> want each entry to be completely unique via all 9 fields. So, if fields 1-8
> in a n
After having experience with InnoDB and MyISAM..
There's lack in MySQL engine with InnoDB comparing to MySQL with MyISAM
the problem exists when you do wrong with my.cnf configuration file
for example do wrong in max_connections, table_cache
Using MyISAM although with configuration
Hi all,
I wanna try the following query,
=
select concat(
"update product set price=",
p2.price,
" where id=",
p1.id,
";"
)
from product p1 left join product p2
on p1.name=p2.name
where p1.
Hi guys, i have 256 RAM and dual Pentium III
This machine will run mail server, web server, and database MySQL server
there's CGI Application that use MySQL server WITHOUT persistent connection -
uh... the lack of my CGI Application
What is the best configuration of my.cnf if :
there will b
From:-
Gani Pola
PCI Data
Marketing Division
434 Ridgedale Avenue, PMB # 11-108
East Hanover NJ 07936
Tel: 1-888-248-3443 OR 1-888-713-7201
Fax:1-603-297-5644
mailto:[EMAIL PROTECTED]
Attention: Recruiting Department/Human Resources DepartmentX
==+=+
After I replace with this DDL mysql back normaly,
the load average 13 if i change max_connection=150 and table_cache=96
using the second DDL.
mysqler expert please analyze this, i would know why.
the query just result total of record:
1st query:
+--+
| COUNT(*) |
+--+
|350
I am currently running an online golf tournament on an NT server with an
Access database and asp pages. I have access to a Unix server that
supports asp script and mySQL database and I'd like to move my tour site
(for several reasons) but the SQL statements don't all work. The
following statement
I am currently running an online golf tournament on an NT server with an
Access database and asp pages. I have access to a Unix server that
supports asp script and mySQL database and I'd like to move my tour site
(for several reasons) but the SQL statements don't all work. The
following statement
Well, Paul, i think he means using source in an .sql script.
Yes you can, Shankar. I used it several times for several reasons :)
And u can envoke your sql script the same as you use your other
scripts.
[EXAMPLE]
-- in query.sql file:
CREATE TABLE ( id INT, value CHAR(30) )
-- in source.sql
> > database,sql,query,table
>
>
>I notice that "source" is only accepted at the *command line*. This
>means that I can't source a script that sources another file.
>
>I guess "source" is implemented in some special way that prevents it
>from being recursively used?
>
>Is there a way to do what
At 3:29 PM -0600 11/28/01, john wrote:
>Erik,
>
>Thanks for your input. I had no idea of what a troll was. I have seen the
>term flung about before, but I had no idea I was being a troll. So, a person
>who just sends an email to a list that has a valid complaint is not a troll,
>but if they se
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Gordan Bobic writes:
>> On Tuesday 27 Nov 2001 23:33, you wrote:
>>
>> > gcc version 3.0.2
>>
>> It would appear that you tried compiling using the GCC 3.0.2 compiler. Try
>> downgrading to 2.95.3 (the last stable r
> database,sql,query,table
I notice that "source" is only accepted at the *command line*. This means
that I can't source a script that sources another file.
I guess "source" is implemented in some special way that prevents it from
being recursively used?
Is there a way to do what I want (ha
Thanks a lot for the perror. However it doesn't seem to have descriptions
for some code (ex. 1046, 1064).
But still, it was really usefull (y MySQL book doesn't mention that, weird)
Cindy wrote:
C:
C: Bill Adams writes:
C: >Cindy wrote:
C: >
C: >> I tried checking for error codes in the
Bill Adams writes:
>Cindy wrote:
>
>> I tried checking for error codes in the documentation, but didn't find
>> anything particularly useful.
>>
>> I'm getting this:
>> mysql> load data infile '/export/home/Scratch/WordIndex.txt' into table wor
>dindex (aid, wid, wordform, start, length);
rick herbel wrote:
> Question - Why is key len,ref null ?? Is it not using my key? Why does it
> say type range
> here and below it says type ref the table has 134000 records in it so it
> should be using key.
Have you run myisamchk -a on the table? (Or ANALYZE TABLE from the sql prompt?)
b.
on a RedHat7.1 box I have built 4.0a with --vio and --with-openssl,
"SHOW VARIABLES like "have_openssl" shows YES.
on the server i have created a user with
"grant all on *.* to foo@"192.168.10.%" identified by "password";
and this works fine when connecting from this and other linux hosts using
Cindy wrote:
> I tried checking for error codes in the documentation, but didn't find
> anything particularly useful.
>
> I'm getting this:
> mysql> load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex
>(aid, wid, wordform, start, length);
> ERROR 1030: Got error 28 from ta
Chang-Ping Hsiao writes:
> Hi!
>
> Thanks for the help. Tried both and both failed. Still get the
> following.
>
> __cxa_pure_virtual mysqlbinlog.o
Hi!
Please install libstdc++-v3 and try again.
Regards,
- Jani
For technical support contracts, visit https://o
Who has set up the RPM packaging for the current MySQL-generated RPMs? It's
very different from the RedHat-generated packaging, and makes it impossible
to just upgrade the package in place.
Of course, one could just delete the RedHat package and then install the
MySQL-generated package, but th
Etienne Marcotte wrote:
> What is the exact difference between
> this
> index(col1,col2).
Create a single index on col1 and col2.
>
> that
> index(col1),index(col2).
Creat two indexes, one on col1, one on col2.
>
> and this
> index(col1),index(col2),index(col1,col2).
Do all three. Note that
"Jeff Hinds" writes:
>I have an application that is developed in perl using dbi and mysql that has
>been working well for some time now. However, I have received emails and
>phone calls asking if the server is down. I look at the service and the
>system is up however, the mysql error log repo
Hi guys,
Locally I've already redone that for mysqldeveloper.com, Give it a
look-see
http://www.mysqldeveloper.com/lists/
Alexander Skwar wrote:
>
> So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 :
> > Does that work for you? The "MySQL" button on the side links to a
>
> Yep, i
Hello,
I am testing a web page on my server (code and result of phpinfo attached).
In the browser window I get several errors like this:
Warning: SQL error: [unixODBC][Driver Manager]Data source name not found, and no
default driver specified, SQL state IM002 in SQLConnect in
/home/marco/publ
Hi.
Please post the result of EXPLAIN for the two queries.
Bye,
Benjamin.
On Wed, Nov 28, 2001 at 12:50:21PM +0700, [EMAIL PROTECTED] wrote:
> I dont understand mysql eat system 13 load average after that mysql hang while
> runing query via web using DBD-Mysql and DBI.
> Everyone help
Hi.
On Wed, Nov 28, 2001 at 02:26:45PM +0900, [EMAIL PROTECTED] wrote:
> i want to do this:
>
> SELECT matrix.matrixId FROM matrix, language WHERE (matrix.fromLanguageId =
> language.languageId AND language.isoLanguageId = 25) AND
> (matrix.toLanguageId = language.languageId AND language.isoLang
So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 :
> Does that work for you? The "MySQL" button on the side links to a
Yep, it does. Mozilla 0.9.6, Opera 5.05tp1 and Konqueror 2.2.1 checked;
all on Linux.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote
I think that's the error code that's spit out when permissions are wrong on
the DB file. You might want to check permissions.
Good luck,
Tyler Longren
- Original Message -
From: "Venu Allavatam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 4:10 PM
Subje
Error code 13: Permission denied
Venu Allavatam wrote:
>
> Hello All:
> I am working on a particular database, which I created
> some days ago in mysql ver. 3.23.36. I am quite sure
> that I have not made any changes to the system (Dell
> WS with Red Hat Linux 7.1) either. What I see is
> this
If you wouldn't mind, though I think the folks at MySQL.Com should consider
throwing a copy back up. Maybe I'm just a nervous nelly, but I won't be
moving update Mysql 4 until it's beyond the alpha stage. I'm running an
accounts receivable system, and I just upgraded to 3.23.45 yesterday.
Dear mysql developers,
Personally, I think your web pages are very nice
and also user friendly. I have no idea about
what this fuss is all about.
Regards,
Neil
-
Before posting, please check:
http://www.mysql.com/manual.p
I have an application that is developed in perl using dbi and mysql that has
been working well for some time now. However, I have received emails and
phone calls asking if the server is down. I look at the service and the
system is up however, the mysql error log reports the following message:
Hello All:
I am working on a particular database, which I created
some days ago in mysql ver. 3.23.36. I am quite sure
that I have not made any changes to the system (Dell
WS with Red Hat Linux 7.1) either. What I see is
this...
###
[Venu@localh
Thanks for the help regarding my php question (in_array function) Sorry
I posted it here; obviously I was a bit confused.
Thanks again,
Steve Osborne
Database Programmer
Chinook Multimedia Inc.
-
Before posting, please chec
That has happened to me occasionally, I wrote it off as me being tired.
It seems to work now, although a date/thread list would be nice.
But those (along with my email address!) are all over the net.
-ravi.
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]]
Sent: November
John,
I know what you mean, to some extent. I bought a recently-published
book that served as an introduction to MySQL and PHP. I thought it
would be perfect -- it seemed to be engagingly written, and specifically
dealt with what I wanted to learn about. The only problem was that the
editi
"Steve Osborne" <[EMAIL PROTECTED]> wrote:
> Simple question for one of you I am sure. I'm new to mysql (and php) and
I
> am hoping someone can explain exactly what the 'in_array' function does.
> (Although I am new to mysql and php, I have programmed in extensively in
> Visual Basic, and have a
Calvin...
The connection is being made from the machine on which php is running.
Most likely the web server. It is not connecting from your browser.
So, these tables are checking the privileges of the connection.
-- Jason
On Wed, 2001-11-28 at 16:14, Wee Chua wrote:
> Hi all,
> I have a que
"raezor" <[EMAIL PROTECTED]> wrote:
> Please alphabetize or at least use some sort of date organization for the
> http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b instead of making us search
> through every entry, including those that have never been responded to.
Personally, I prefer the format of t
>
> What is the exact difference between
> this
> index(col1,col2).
> that
> index(col1),index(col2).
> and this
> index(col1),index(col2),index(col1,col2).
>
> I read in the manual about it, but it's not really clear about the way
> to should be used / created.
>
> Any sql pseudo-teacher in h
In your situation, MySQL sees the client to be the web server, as it is the
box that connects to the database and executes queries. If you need finer
granualarity on the access controls at the MySQL level, you can pass
different usernames/passwords to MySQL through the php mysql_connect()
functio
Erik,
Thanks for your input. I had no idea of what a troll was. I have seen the
term flung about before, but I had no idea I was being a troll. So, a person
who just sends an email to a list that has a valid complaint is not a troll,
but if they send it with an attitude, because they are frust
Ideally, you will want at least 2 tables. One for user info, and another
for purchase information. One easy way to think of database normalization
is to make sure that each table only has one purpose, ie user information.
(Obviously, for security reasons, you would want to remove credit card inf
On 28 Nov 2001, at 15:28, Ravi Raman wrote:
> Not really interested in getting involved in the flamewar that seems to be
> brewing, but this might help:
>
> http://www.nexial.com/mailinglists/
Does that work for you? The "MySQL" button on the side links to a
URL that just redirects back to ht
Hi all,
I have a question regarding the client IP address between PHP and MySql. The
built-in mysql database have different privilege tables. When I log on to
mysql through the internet browser, does mysql know where I am connecting
from if I use mysq_connect(.) function? From what I see, this
We'll be using PHP, but right now, i'm just learning MySQL through the
terminal client.
I don't think strings would do the trick here... There will be alot of
data, so it might get messy in a short time. It also seems like a slow
way of doing it. We might need to change the item ids in the fut
Simple question for one of you I am sure. I'm new to mysql (and php) and I
am hoping someone can explain exactly what the 'in_array' function does.
(Although I am new to mysql and php, I have programmed in extensively in
Visual Basic, and have a little bit of experience in C, C++, and Java, so
f
See:
DATE_ADD(date,INTERVAL expr type)
DATE_SUB(date,INTERVAL expr type)
ADDDATE(date,INTERVAL expr type)
SUBDATE(date,INTERVAL expr type)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> m] On Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, November 28, 2
In addition to the purchased list, we want to have a "with list" kind of
feature where you could add and remove things you might want to buy...
So we would need to have some kind of array for each user that lists the
ids of the puchasable items, that can grow and shrink...
Any ideas?
Thanks.
Thanks for the input
-Original Message-
From: Ravi Raman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 2:28 PM
To: john; Johnny Withers; 'Etienne Marcotte'
Cc: 'MySQL Lists'; [EMAIL PROTECTED]
Subject: RE: Please redo this horrible web page
Hi.
Not really interested in
I think while you've got the hood up, a better method of doing the
difference between two dates should be derived.
Unless I'm going about this all wrong, the only way to get the time
difference between two values currently is:
UNIX_TIMESTAMP(end_datetime) - UNIX_TIMESTAMP(start_datetime)
Solution is simple
Either
1. Filter your e-mail to specific folders
2. Remove yourself
>
> On Wednesday, November 28, 2001, at 02:44 PM, john wrote:
>
>> pages every day. Things on the list are no way near how easy they can
>> be. I
>> cannot fathom why this is not a newsgroup, and why ever
I know this is a really simple thing that I'm just missing. Basically I want
to store Apache logs in a mySQL database, in a table with 9 fields. I want
each entry to be completely unique via all 9 fields. So, if fields 1-8 in a
new record are all identical to fields 1-8 in an existing record, but
Hi.
Not really interested in getting involved in the flamewar that seems to be
brewing, but this might help:
http://www.nexial.com/mailinglists/
-ravi.
-Original Message-
From: john [mailto:[EMAIL PROTECTED]]
Sent: November 28, 2001 2:52 PM
To: Johnny Withers; 'Etienne Marcotte'
Cc: 'M
On Wednesday, November 28, 2001, at 02:44 PM, john wrote:
> pages every day. Things on the list are no way near how easy they can
> be. I
> cannot fathom why this is not a newsgroup, and why every person/eu has
> to be
> flooded with so much email that has nothing to do with them or their
> q
I tried checking for error codes in the documentation, but didn't find
anything particularly useful.
I'm getting this:
mysql> load data infile '/export/home/Scratch/WordIndex.txt' into table wordindex
(aid, wid, wordform, start, length);
ERROR 1030: Got error 28 from table handler
In case it h
I'm new to MySQL and i'm having some trouble with creating a table with
the format i need.
I need to create a table for user information (name, email, phone) and a
list of purchased items (IDs) that will grow or shrink with time, in
some kind of dynamic array.
Is it possible to have this in o
Mr. Winters,
They do have a very slow search engine built in to the site. Look at the
header.
-Original Message-
From: Johnny Withers [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 1:09 PM
To: 'Etienne Marcotte'; 'raezor'
Cc: 'MySQL Lists'; [EMAIL PROTECTED]
Subject: RE
Questions about index
mysql> show index from listing;
+-++-+--+-+-
--+-+--+
| Table | Non_unique | Key_name| Seq_in_index | Column_name |
Collation | Cardinality | Sub_part |
+-++
Ms./Mrs. Marcotte,
First, since you asked, I am not a smooth talker, I am an asshole through
and through. When things aren't right I'll be the first to let you know.
Have you ever seen the movie "The American President"? Well, in order to
make things work for non-pro's the pro's have to be rem
- Original Message -
From: "Tony" <[EMAIL PROTECTED]>
To: "A. Clausen" <[EMAIL PROTECTED]>; "MySQL Mailing List"
<[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 11:20
Subject: Re: MySQL 3.23 Manual - PDF
>
> Image you had a product and wanted to make a PDF manual available for you
i have to disagree
you should read it before asking us to go read it!
Title is on top of each page: "MySQL Technical Reference for Version
4.0.1-alpha"
I am also looking for the latest 3.xx version manual.
Etienne
Tony wrote:
>
> Image you had a product and wanted to make a PDF manual availa
> You could just exec() the page again, with a parameter telling it to
use
> the test server, like so:
I like this general idea, though the above method would take a little
more work since I would have to pass the environment variables and
apache variables (GET and POST, etc) to exec and I don't
What is the exact difference between
this
index(col1,col2).
that
index(col1),index(col2).
and this
index(col1),index(col2),index(col1,col2).
I read in the manual about it, but it's not really clear about the way
to should be used / created.
Any sql pseudo-teacher in here? :)
Thanks a lot,
Eti
Image you had a product and wanted to make a PDF manual available for your
users. Where would you put it?
Website, under documentation. BINGO!
http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual.pdf
Not sure why this MySQL list has so many questions and folks have t
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Otavio
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Really... you could also search it with some sort
of search function in your browser..
-
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.209.4985
-Original Message-
From: Etienne Marcotte [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 28, 2001 12:16 P
I am OO newbie, but in an effort to consolidate a lot of reusable code,
I am trying to design an object in perl ( I think that's the right word)
that will match an array to the fields in an input/output screen
(template, form). It's rough going for me since the joins themselves
are complicate
In article <[EMAIL PROTECTED]>, Michael Widenius
<[EMAIL PROTECTED]> writes
>I just tested this with the upcoming MySQL 4.0.1:
>
>mysql> create table t1 (a text);
>Query OK, 0 rows affected (0.01 sec)
>
>mysql> CREATE INDEX t1 ON t1(a);
>ERROR 1170: BLOB column 'a' used in key specification witho
right
Etienne
Jose Gerardo Amaya Giron wrote:
>
> Thanks I now understand the difference. I can use a timestamp If I used a
> database to log access for example I only make an insert to
> the other fields and the timestamp insert the current time and date right?
>
> Gerardo Amaya
>
> "Alok K.
Thanks I now understand the difference. I can use a timestamp If I used a
database to log access for example I only make an insert to
the other fields and the timestamp insert the current time and date right?
Gerardo Amaya
"Alok K. Dhir" wrote:
> You probably want to start with datetime rather
Hi,
I'm forwarding you the file named mysql_3.23.45_pt-brazil.zip (I have uploaded it to
address ftp://support.mysql.com:/pub/mysql/Incoming) which contains the updated
Brazilian Portuguese idiom version of files ERRMSG.TXT and ERRMSG.SYS, to be parked in
directory mySQL\share\portuguese. The
Is there still a PDF-formatted version of the MySQL 3.23 manual available?
A. Clausen [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
I know you won't read my answer since I'm not from mysql
but I wanna give my 2 cents.
First don't you think you could go the "smooth" way for making a
request? Either I'm not in a good mood or I can't read english, but your
post seemed harsh.
It's probably a really huge task to have this archiv
You probably want to start with datetime rather than timestamp, as
timestamp comes with some additional magic to auto-set it for you and
you may not want this. A good source for this type of information is,
incidentally, the MySQL reference, at www.mysql.com.
> -Original Message-
> From:
Let's make everything as hard as is possible for the "newbies".
Please alphabetize or at least use some sort of date organization for the
http://lists.mysql.com/cgi-ez/ezmlm-cgi/1#b instead of making us search
through every entry, including those that have never been responded to. The
Messages b
Hello,
I don't know if this is the right mailing list for a simple feature
request, but please read on anyway.
SKIP TO THE END IF YOU JUST WANT TO READ THE FEATURE REQUEST.
As a Java programmer, I often access a MySQL database trough a driver, and
notice a little problem:
The MySQL format for D
timestamp is a good start
- Original Message -
From: "Jose Gerardo Amaya Giron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 28, 2001 2:42 PM
Subject: date type
> Hello all I got a a simple question, I changing from access to MySQL. I
> have in access some field
Simon Green writes:
> Hi all
> This is probably a silly question but
> Can MySQL GUI connect from my windoz desktop to my Unix box?
> Just can not seem to get it working!
>
> Simon
Yes, of course it can. Start "Options", fill it up correctly and click
to "Save" if you wish to connect always
Hi,
I uploaded the file innerjoin.tar to
ftp://support.mysql.com/pub/mysql/secret.
please reject my first attemp with name "innerjoinbug.tar" (problems
with kde :-( )
Please let me know if I can be of further help.
Thank you guys,
I think you are doing a wonderful job!
Best re
timestamp
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jose
Gerardo Amaya Giron
Sent: Wednesday, November 28, 2001 8:43 AM
To: [EMAIL PROTECTED]
Subject: date type
Hello all I got a a simple question, I changing from access to MySQL. I
have in access
Hi all
This is probably a silly question but
Can MySQL GUI connect from my windoz desktop to my Unix box?
Just can not seem to get it working!
Simon
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
Hello all I got a a simple question, I changing from access to MySQL. I
have in access some fields that have date and time. What type of field
in MySQL can handle this.
thanks
Gerardo Amaya
-
Before posting, please check:
h
mysql> load data local infile '/tmp/Parts.txt'
-> replace
-> into table Parts
-> fields
-> optionally enclosed by '"'
-> terminated by ','
-> ('PN','APN','C','Q','D')
Query OK, 100946 rows affected (39.66 sec)
Records: 100946 Deleted: 0 Skipped: 0 Warnings: 2
This has o
Hi,
> > AND and orders_common.id=1060340
> > Result - 1 row
>
> You have two AND's one after another.
>
> Try with one AND and tell us what you get ...
Two AND is a typo
Real query has only one AND
I'll send full test case via ftp in a one hour
Best Regards,
Zeus Gómez Marmolejo writes:
> SEND-PR: -*- send-pr -*-
> SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
> SEND-PR: will all comments (text enclosed in `<' and `>').
> SEND-PR:
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: MySQL strange error: lost connecti
I'm basically looking for two things:
1) An article/tutorial/document discussing operating system threads. I keep
hearing about LinuxThreads on FreeBSD, and how MySQL won't run correctly
with pthreads or something like that. I need to learn about threads and when
and where they're used or not use
Sergey S. Kostyliov writes:
> >Description:
> Query with INNER JOIN return 0 rows, but the same query + yet another
> WHERE condition return 1 row
> >How-To-Repeat:
> Query:
> SELECT orders_common.vendor_id
>FROM orders_common
> INNER JOIN orders_common_count
> ON (
Urtzi Larrazabal writes:
>
>
> Dear friend,
>
> I am planning to install mysqlgui in my Solaris 2.8 O.S. but I haven't any idea what
>steps should I follow to install it. I would be gratefull if you could help me.
>
> Best regards,
>
> Urtzi Larrazabal.
>
If you have SPARC, try the e
Mike Gleason Jr Couturier writes:
> Hello all !
>
> I'm creating an MFC program with the mySQL API.
> Everything is working fine but when exceptions
> occurs (ie when connecting, changing databases...),
> I can't display the er.error message to the user...
>
> How can I convert the error message
1 - 100 of 133 matches
Mail list logo