Hi Everybody ,
I am using MySql 3.22.32 on LINUX.
My problem is , that 'SELECT COUNT(DISTINCT ) FROM
doesn't work
like described in the HTML-manual (7.4.13) .
It even doesn't work at all.
Is tthat a bug , am I stupid , or is there any workaround.
Greetings
Klaus
Besuchen Sie
COUNT(DISTINCT...) wasn't added until v. 3.23.02
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
> Hi Everybody ,
>
> I am using MySql 3.22.32 on LINUX.
> My problem is , that 'SELECT COUNT(DISTINCT ) FROM
>
> doesn't work
>
Benjamin Pflugmann wrote :
>
> Hi.
> []
>
> If MySQL uses the index, it has one of two possibilities.
>
> First:
> 1. Read the whole isbn index, and for each row
> 2. seek the record in the data file and get author from it.
> This is quite slow because of the random file seeks needed.
>
>
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:Tarmo Kähr
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release
Hi all,
Basically I have a requirement where I have to store xml files in the database.
The table that I visualised for the purpose will contain two columns, one being
the key (varchar) and the other for the xml file. What data type should I use
for the second column.
Are there any inherent pro
NOTE: Since iam not a member of this group, please reply by cc`ing
to my mail id.
--
Sivaramakrishnan I
AdventNet (India) Development center. Madras, India.
Phone: 91 44 243 2414
Hi all,
Basically I have a requirement where I have to store xml files in the
database. The table that I visu
Hi,
I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full
I can execute other queries without problems but when I want to execute the query :
SELECT DISTINCT person.*
FROM person, training, cursus
where training.BRANCH_ID=101
and training.CURSUS_SID=cursus.CURSUS_
Are U going to search thru the XML data in the future?
If so U have to be carefull ..
If not, depending on size u have these options
1. text(64K) or blob(64K)
2. mediumtext(16MB) or mediumblob(16MB)
Cheers!
Thiru
If U may search thru the XML data at some point,
On Fri, 16 Feb 2001 14:35:5
im new to this list and to the SQL language, id like to know if anyone
knows how to drop a column from a SQL database,i currently have the
following string: "ALTER TABLE WorkGroups DROP COLUMN Personnel"
i read somewhere something about having to store the information in a
temporary column before
Hi.
I have a server running mysql.From it reads data two web server
wich has about 30.000 daily visits and 250.000 pages so the
trafic to the mysql server is big.
Can anybody tell me a optimal mysql configuration for this
server?.
Actually in the /etc/my.cnf i have:
set-variable = max_conne
Okay, here's the deal.
First I unpack the .tar.gz into /a-path-name/mysql-dir-name
After that I should (atleast according to the readme) type ./configure
--prefix=/usr/local/mysql
That script tells me that this is a binary version and that I dont need to configure
it, it's ready to rock as it
On Fri, Feb 16, 2001 at 09:55:32AM +0100, Chappuis J.-Vincent wrote:
> Hi,
> I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full
> I can execute other queries without problems but when I want to execute the query :
>
> SELECT DISTINCT person.*
> FROM person, trai
I wish to set up mySQL running on a Windows Server and a client on a lan that can
access it but am completely in the dark as to what to download and install.
Thanks
Kerry Matthews
>Description:
I built mysql-3.23.33 against glibc-2.2.1, under Linux, kernel
2.4.1
Although the server appeared to be functional, all "show"
commands yielded blank lines, and mysqldump would not create a
dump file for databases - it would still work for spec
Hi,
we had a rather ... interesting ... problem with mysqld, compiled on a
system with glibc-2.1.3. We tried to run the server on a RedHat 7.0
machine and had inexplicable pthread errors.
The solutions turned out to be either to downgrade /lib/libpthreads.so.0 and
/lib/librt.so.1 to the versions
hello list;)
i have a SQL command to DROP a COLUMN from a mySQL database, the problem
is that the syntax i am using doesnt seem to be the right syntax for
mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN
Personnel" and i get the error message:
Error Type:
Microsoft OLE DB Pr
On 16.02.2001 10:05:54 I.SivaramaKrishnan wrote:
> Hi all,
>
> Basically I have a requirement where I have to store xml files in the
database.
> The table that I visualised for the purpose will contain two columns, one
being
> the key (varchar) and the other for the xml file. What data type sh
On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote:
> NOTE: Since iam not a member of this group, please reply by cc`ing to my mail
> id.
That's a behavior I never quite understood - you come to list seeking for
advice. Fine. Next you say that you do not care at all about the list. Geez,
if yo
kentj <[EMAIL PROTECTED]> writes:
> I believe so. I was trying that and was missing something because I could
> not get it to work.
If you've for it in init.d and "mysql stop" and "mysql start" work
there, then make sure they're also symlinked into rc3.d directory.
--
Dave Hodgkinson,
The test script is a command that must place test value into a column
in the table. Syntaxis - ./test . Text of script:
#! /bin/bash
/usr/bin/mysql --user= --password= --host=localhost
--port=3306 --execute='INSERT INTO TableName SET TextField='$1''
DatabaseName
echo $1
(of course, wit
On Fri, Feb 16, 2001 at 02:35:20PM +0300, áÆÁÎÁÓØÅ× ç.ì. wrote:
>
> The test script is a command that must place test value into a column
> in the table. Syntaxis - ./test . Text of script:
>
> #! /bin/bash
> /usr/bin/mysql --user= --password= --host=localhost
> --port=3306 --execute='IN
Please, tell me,
how could I determine,
which one of two datetime values is greater?
In other words,
how could I determine,
is stored on db datetime value in future or past?
Best regards, mailto:[EMAIL PROTECTED]
Vyacheslav Chukin
---
I cannot use the jdbc connection which the driver is download
from mysql web site. The error message prompted that
"invalid JDBC Driver", what can cause this error?
I predict my classpath is wrong, but I would like to know
how to set the classpath?
(at this status, I am not sure if my classpath is
I'm getting the following error on my gmake (most snipped for brevity).
gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite
-DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci`
-L/usr/local/lib -R/usr/local/lib \
-o httpd buildmark.o modules.o modules/
Can anybody help with this
If I put the following statement in PHP my browser tells me that there is an
error on the line.
//create sql statement
$sql = "select Business_Name,Trading_Details where Business_Type =
"Consultancy" and Bassingbourn != "0" from Main";
If I remove
where B
>Description:
"DELETE FROM mergetable" clears merge definition
>How-To-Repeat:
mysql> use test;
Database changed
mysql> CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20));
Query OK, 0 rows affected (0.04 sec)
mysql> CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, mes
select if(columnname > now(), "future", "past") from tblname
On Fri, 16 Feb
2001, Vyacheslav Chukin wrote:
> Please, tell me,
> how could I determine,
> which one of two datetime values is greater?
>
> In other words,
> how could I determine,
> is stored on db datetime value in future or pas
Hi,
I have a table
DAY : DATETIME
CAT_ID : INT
DATA : TEXT
ID : INT
and I have to extract all records not older than 2 weeks with given
CAT_ID (sorted by DAY).
query for that is very simple, but what if this table has 1 000 000
records? Do you think that deleting records older than eg
If U R using some IDE, then there shd be a place to add on Ur classpaths.
If not, from the prompt
For Windows > java -classpath "c:\JDBCdriver;c:\JDBCdriver\driver.jar;." file.java
For Unix> java -classpath "/tmp/JDBCdriver:/tmp/JDBCdriver/driver.jar:." file.java
note: when including jar or
Hi, readers of the mailing list!
Monty will roll a new distribution of MySQL 3.23.3x this weekend.
Innobase will be included there and it will provide transactions,
rollback, recovery, row level locking, and Oracle-like consistent read.
Monty will leave for a vacation in Rio on Wednesday, so the
Hi,
Didn´t find this anywhere in the documentation...
does -1 work if I want to set a Mysql timeout variable to indefinite??
e.g. wait_timeout=-1
Thanks
Mario Oschwald
-
Before posting, please check:
http://www.mysql.com/m
Take a look at your query once again: "select/../"Consultancy"/.../"
You can have "" inside "". The ways to do it, so that it would work:
-> use '$somethinghere' instead of "$something" or
-> use \"$somethinghere\" instead of second "$something" or
-> use '".$somthingh
PHP sees the first " of "Consultancy" as being the end of the variable $sql.
To get round this, change the " to ' inside the statement (e.g. ...where
Business_Type = 'Consultancy' and...)
HTH
Jon
-Original Message-
From: Matt Davis [mailto:[EMAIL PROTECTED]]
Sent: 16 February 2001 12:
On Fri, Feb 16, 2001 at 12:43:15PM -, Matt Davis wrote:
> Can anybody help with this
>
> If I put the following statement in PHP my browser tells me that there is an
> error on the line.
>
> //create sql statement
> $sql = "select Business_Name,Trading_Details where Business_Type
Why don't you :
select timestampfield from mytable order timestampfield decs limit 1
Jay Lawrence wrote:
>
> Atle, your suggestion is for the last time a record was updated. I am
> interested in the entire table.
>
> The closest that I have seen thus far is:
> SHOW TABLE STATUS
> The Update
> set SQL_BIG_TABLES = 1;
You also will have to keep in mind that now that a filesystem is being
used for the MySQL work you'll need the room to do it. In some cases the
default MySQL install uses '/var/tmp' for it's chalkboard which in some OS
installations, referring to UNIX of course
Description:
After having installed binaries, or compiled source code, mysql_install_db
ends in a coredump
How-To-Repeat:
Fix:
Submitter-Id: [EMAIL PROTECTED]
Originator:
Organization:
MySQL support: [none ]
Synopsis: install ends in coredump
Severity:
Mario Oschwald writes:
> Hi,
> Didn´t find this anywhere in the documentation...
>
> does -1 work if I want to set a Mysql timeout variable to indefinite??
>
> e.g. wait_timeout=-1
>
> Thanks
>
> Mario Oschwald
No, you will have to set a very large value.
Regards,
Sinisa
Unless you have a physical location in that state! If you are in a
state where Dell has a location you must pay that state's sales tax.
Hey Vivek do you ever sleep!
:)
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Origina
I'm start MySQL with 'mysqld-opt --default-character-set=gbk'.
I can use mysql connect to MySQL,and query.
But I use PHP,it display:
Warning: MySQL Connection Failed: Can't initialize character set 28 (path: default) in
Why???
WinMe+Apache 1.3.17(Win32)+PHP 4.04pl1+MySQL 3.23.33
[E
Dear All
I've just installed mysql on a new host (3.23.33) and show databases
does not work ;-(.
The data directory is thus:
drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql
Inside it has:
[root@server1 lib]# ls -l mysql/
total 28
drwx--S---2 mysqlmysql4096 Feb 16
hello list;)
i have a SQL command to DROP a COLUMN from a mySQL database, the problem
is that the syntax i am using doesnt seem to be the right syntax for
mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN
Personnel" and i get the error message:
Error Type:
Microsoft OLE DB Pr
Matt Davis wrote:
Check the manual.
The manual shows where following from.
>
> Can anybody help with this
>
> If I put the following statement in PHP my browser tells me that there is an
> error on the line.
>
> //create sql statement
> $sql = "select Business_Name,Trading_Details
If I start a transaction (set autocommit=0 in the command line utility),
then do an "insert" in one session, then open a second session and try
to do a select on that table, before the first session has committed, the
select just hangs. Once I commit in the first session, my select proceeds
Hello monty,
I'm trying to use merge table for logging - to have a possibility to
Rotate log files and to quickly delete old data - for this I'm goint
to setup a number of merge tables where each contains data for one
day, and the inserts are done to the last table using real table
name
Sorry, thought you were just having trouble teleneting to W2K server to run
mysql or other exe's at command prompt. We ran into this because
appartently W2K supports a different telnet that has to be started as a
service before you can connect. Once it was running we had no problem
coming into M
On 16.02.2001 13:27:58 Vyacheslav Chukin wrote:
> Please, tell me,
> how could I determine,
> which one of two datetime values is greater?
Date1 < Date2
> In other words,
> how could I determine,
> is stored on db datetime value in future or past?
Past:
DbDateTime < NOW()
Present:
DbDateT
On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote:
> Dear All
>
> I've just installed mysql on a new host (3.23.33) and show databases
> does not work ;-(.
>
Maybe it would help to read (or search) the list before posting.
There are several mails regarding this problem, among them a ma
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
Rick Roberts wrote:
>
> SHOW DATABASES;
Sorry my subject line had the last S missing:
mysql> 010216 15:29:14 1 Query SHOW DATABASES
SHOW DATABASES;
+--+
| Database |
+--+
| |
| |
| |
| |
| test |
+--+
5 rows in set (0.0
Scott,
did you try to do the insert and select on the same database page?
In BDB there is page level locking used, and the behavior you
describe sounds like that the insert has placed a page level lock
on the page where you try to do the select. Then it is correct behavior
of the database that y
Werner,
Your syntax is correct and valid for MySQL.
The problem could lie with your ODBC driver. What version are you on?
Try downloading a utility for administering MySQL. UrbSQL is good from
www.urbanresearch.com and see if that can drop the column.
Good luck.
Andy Woolley
www.databasewatch
>Description:
SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
a nice list of blanks - no of blank lines
equals number of databases / tables)
>How-To-Repeat:
Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
>Fix:
>Submitter-Id:
>Originator:Greg Cope
>
Hello all,
I have a database with a little over 2000 records. I want to be able to
construct a query that says something like this...
select id,lot_id,lot_type from scrap_table
(part I need help with)
order by id limit 10;
which should give me records 1932 - 1942 like this...
+-
Fred van Engen wrote:
>
> On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote:
> > Dear All
> >
> > I've just installed mysql on a new host (3.23.33) and show databases
> > does not work ;-(.
> >
>
> Maybe it would help to read (or search) the list before posting.
I have already searched
Hello,
can anyone tell me whether or not I have to convert the database files when
switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on
SuSe Linux 6.4. Is it sufficient just to copy the database files?
Thanks,
Tobias.
--
You can use:
SELECT , count() FROM GROUP BY
> -Original Message-
> From: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 16, 2001 3:02 AM
> To: [EMAIL PROTECTED]
> Subject: COUNT(DISTINCT )
>
>
>
> Hi Everybody ,
>
> I am using MySql 3.22.32 on LINUX.
> My
>Description:
"SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32
In v3.22.32, both the following SQL commands work:
mysql> SELECT MAX (record_id) FROM record;
+-+
| MAX (record_id) |
+-+
I know this has come up before, but I couldn't find a satisfactory solution.
I'm running MySQL 3.23.23 on mandrake linux. It's used by a web site that has
very high activity. During times of high activity, I find my perl
scripts generating two kinds of errors:
DBD::mysql::db selectrow_array fa
Greg Cope writes:
> >Description:
> SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
> a nice list of blanks - no of blank lines
> equals number of databases / tables)
>
> >How-To-Repeat:
> Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33
>
> >Fix:
select id,lot_id,lot_type from scrap_table where id >= 1932 order by id
limit 10;
select id,lot_id,lot_type from scrap_table order by id limit 1932,10;
either should work, i think the first would be faster but I'm not positive
how MySQL would handle the second in terms of optimization.
-jm
Does anybody know of any commercial or opensource CRM systems that
run with MySQL on Linux (and/or FreeBSD)?
Mainly I need canned responses and ticket management and some other
standard features.
-
Before posting, please check
> select id,lot_id,lot_type from scrap_table
> (part I need help with)
>order by id limit 10;
>
> which should give me records 1932 - 1942 like this...
>
> +--+--+--+
> | id | lot_id | lot_type |
> +--+--+--+
> | 1942 | 0034906 | F|
>
isn't it as simple as...
select id,lot_id,lot_type from scrap_table
where id >= 1932 and id <= 1942
order by id limit 10;
?
cheers,
P
>
> which should give me records 1932 - 1942 like this...
>
> +--+--+--+
> | id | lot_id | lot_type |
> +--+
Have a look in the manual, it says LIMIT [offset], rows, so you should say:
order by id limit 1932, 10;
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL]select_expression,...
[INTO OUTFILE 'file_name' export_options][FRO
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
> There are no DB defined space limits on MySQL Databases ?It's dangerours .How to
>control
> the database space on my database user?
Filesystem quotas.
--
Brian 'you Bastard' Reichert<[EMAIL PROTECTED]>
37 Crystal Ave. #303
mysql> select version();
+---+
| version() |
+---+
| 3.23.33 |
+---+
1 row in set (0.01 sec)
mysql> SHOW DATABASES;
+--+
| Database |
+--+
| mysql|
| test |
+--+
2 rows in set (0.02 sec)
I'm using Mandrake 7.2.
I installed using the RPM
M
Rick Roberts wrote:
>
> mysql> select version();
> +---+
> | version() |
> +---+
> | 3.23.33 |
> +---+
> 1 row in set (0.01 sec)
>
> mysql> SHOW DATABASES;
> +--+
> | Database |
> +--+
> | mysql|
> | test |
> +--+
> 2 rows in set (0.02 se
Sinisa Milivojevic wrote:
>
> Greg Cope writes:
> > >Description:
> > SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e
> > a nice list of blanks - no of blank lines
> > equals number of databases / tables)
> >
> > >How-To-Repeat:
> > Do a mysqlshow or SHOW DATABASES
Tobias -
You can continue to use the ISAM format or convert to the new MYISAM
format (and other formats such as HEAP, I believe). See the
'mysql_convert_table_format' script in the bin directory.
-karl
Tobias Wolff wrote:
>
> Hello,
> can anyone tell me whether or not I have to convert the d
I have a form on a webpage for a simple trouble ticket system. When
requesting a computer be fixed, software be installed, etc...a faculty
member can go to this website and type in the info via an HTML form.
My problem is, the form needs to be submitted to two different tables. All
of the faculty
Hello all again.
I think I need to be a little more specific in describing my problem.
So, let me try again. I have a database of scrap records. There are
currently over 2000 records in this database. I have a web page that
queries this database and displays the records in reverse order, newest
My guess is that this is what was happening. I'm not sure of any way to
confirm it though, how do I ensure that my select() is happening from a
different database page then the insert?
-Scott
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 16,
On Fri, 16 Feb 2001, Steve Ruby wrote:
> Does anybody know of any commercial or opensource CRM systems that
> run with MySQL on Linux (and/or FreeBSD)?
>
> Mainly I need canned responses and ticket management and some other
> standard features.
Have a look at http://freshmeat.net/, where most of
Ran into an interesting twist on "presence" in a state. One client went
to a trade show in Nevada. She was informed that for the next quarter
she would have to consider herself "in" Nevada, even though she did not
sell anyting at the show. I don't think she is going back.
On Thu, 15 Feb 200
The following statement:
SELECT Date, @MyYear := year(Date) AS MyYear, @StartMonth :=
floor((month(date)-1)/3)*3+1 AS StartMonth,
@EndMonth := floor((month(date)-1)/3)*3+3 AS EndMonth,
@Period :=
concat(left(monthname(concat('1-',@StartMonth,'-2000')),3),'-',left(monthname(concat('1-',@EndMonth
By the way, if I rewrite the SQL without calculated fields, e.g.
instead of defining @MyYear, @StartMonth, and @EndMonth as variables
but rather duplicating the SQL to create a MyYear (and the others) column
and then inside the larger formula for Period, it works.
-- Jamie
The following statemen
We have a ton of data in MS Excel that I need to put into a Solaris
based MySQL dB. The data needs input such that it correlates across
several different tables (i.e. I can't just do table dumps). What is
the most efficient way to do this?
Thanks,
Valerie
I'm running mysql 3.23.32, I did the test:
With a running server I forced a kind of problem, I delete the MYI file.
#mv contaComum.MYI contaComum.MYI.bck
Then I run CHECK TABLE contaComum;
It returns OK.
If I restard server or execute a flush tables it'll show the problem.
Should CHECK TABLE
Degerli dostumuz,Liberal Demokrat Parti olarak her pazartesi saat 19.00'de , genel
baskanýmýz sayýn Besim TIBUK'un da katilimlariyla düzenledigimiz "Halk
Toplantilarýnda" sizi de aramizda gormekten onur duyariz...
Yer : Balmumcu Liberal Demokrat Parti Genel Merkezi
Saat :
Can anyone see why maybe this set of select/insert statements always inserts a value
of 0 instead of the selected site id in the first select statement? The variable
$getid should hold the site id to be entered into the table ssx but its always entered
at 0 and I get no php or mysql errors. Any
I have a concern regarding how an index is being used for a query. I've
included the query (minus the fields) and the EXPLAIN output below. I'm
curious why MySQL would indicate that it's using filesort for table 'd'
since it's type is 'const.' The documentation indicates this means that
only on
Hi,
I know we can connect to 2 separate Mysql database's using Perl and the DBI
module but can we connect to 2 different machines? One will be what we are
using on our server and one our clients wants to be able to have on their
servers.
The reason I ask is that we are starting to license our we
--- Brian Reichert <[EMAIL PROTECTED]> wrote:
> On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
> > There are no DB defined space limits on MySQL Databases ?It's
> dangerours .How to control
> > the database space on my database user?
>
> Filesystem quotas.
But, to define filesystem quot
Had similar problem, get the current version of the driver.
On Fri, 16 Feb 2001, Chen Ka Pong wrote:
> Date: Fri, 16 Feb 2001 20:29:27 +0800
> From: Chen Ka Pong <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: JDBC question?
>
> I cannot use the jdbc connection which the driver is downl
I can't to compile this
I'm getting the following error on my gmake (most snipped for brevity).
gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite
-DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci`
-L/usr/local/lib -R/usr/local/lib \
-o httpd buildmark.
Is it possible to connect to mysql without connecting directly to a
database, check to see if a particular database exists, and if it doesn't
exist create it?
I have not been able to find a way of connecting to mysql without having a
database already (I want perl to be able to make the db.. not h
Hello,
How could I obtain the difference of two datetime fields giving the result
in seconds, like the function datediff in MSsql ?
I tried date_sub but I had no success.
Ex: 2001-02-16 15:00:00 - 2001-02-16 14:00:00=3600 seconds
Thanks,
Laercio Brehmer
CIASC
[EMAIL PROTECTED]
---
Yeah, just have your backend script parse the info it needs and just call
two queries to make that happen.
On Fri, 16 Feb 2001, Chris Toth wrote:
> I have a form on a webpage for a simple trouble ticket system. When
> requesting a computer be fixed, software be installed, etc...a faculty
> memb
> Hi,
> My name is sanjeev gupta. I have installed the mysql on nt owrkstation and
> also insatlle the myodbc drivers and i am trying to connect with mysql
> using the odbc and it gave me error while i am trying too create file dsn.
> the Error is followed
>
> <<...>>
> and if i try to create a
Hi,
There is a mistake and my last question.
I am asking about libmysqlclient.a, not libmysql.a.
And this is the case:
I am using Perl's MySQL module which upon installation
always asks me where libmysqlclient.a or
libmysqlclient.so is. So, I guess even Windows users
need those too.
In order to
> >Description:
> "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but
> fails in 3.23.32
>
Well, that shouldn't really come as a surprise. The manual
specifically says (Section "Functions for use in SELECT and
WHERE clauses):
Note: There must be no whitespace between a funct
I am , well I will have to wioork with oracle and jdeveloper, can some of
you please please please telll me where canI find examples of conections
to a database an oracle databse and if I use php again eh the
same question where can I see examples of conections to an oralce data
base u
Don't work with oracle. Sorry. However did have a problem with the
version of the jdbc driver on the mysql web site but not with the one on
developer's site. It was for mysql not oracle.
On Fri, 16 Feb 2001, webmaster wrote:
> Date: Fri, 16 Feb 2001 15:44:11 -0500 (EST)
> From: webmaster
Connect to the mysql database if you have access. It always exists.
- Original Message -
From: "John Tsangaris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 1:58 PM
Subject: Perl DBI
> Is it possible to connect to mysql without connecting directly to a
>
Hi,
I just started looking at the MySQLGUI tool in depth yesterday. I have one
question for now. I'm able to save queries via the "Save Query" button but
I don't see any facility to load the query back in from a file. Is this
functionality missing or hidden? I've examined all the readme's and
Hi,
How can I configure MySQL to utilize the SSH package
for encrypted TCP/IP connection between MySQL clients and server?
Thanks in advance.
Kuokai
-
Before posting, please check:
http://www.mysql.com/manual.php (the m
When I mysql status I get message "mysql dead but subsys locked"
I recieve socket error when I attempt any access - mysql.sock DOES exist @ /var/lib/
System: Linux localhost.localdomain 2.2.16-22 #1 Tue Aug 22 16:49:06 EDT 2000 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/
Hi, Eric.
What I'm trying to do is have my install program check to see if a database
of a certain name exists, if it does then the install needs to create
another one (using a name given by the user), if not then it needs to create
it with the original name.
But I cannot figure out how to conne
Hi.
On Fri, Feb 16, 2001 at 03:05:35AM -0500, [EMAIL PROTECTED] wrote:
> Hello, I have a large database with a lot of queries and was trying to
> tune MySQL to get the best performance. I was reading the manuals and it
> said to set the key_buffer_size to the best value, you take the first
> two
1 - 100 of 125 matches
Mail list logo
