I can't manage to have an acces to my database with mysql installed on E: on a windows
Nt server.
What can I do ?
Thanks
Hi all,
I would like to try and create a database that can be used for
report/letter generation on both IBM and Macs, and eventually emails. I
have success on the IBM simply using ODBC and Office, and was wondering how
one would go about the same process on the Mac. The advantage of using
Off
Hi,
> -> DAY) >'$tdate' and city.id=special.cityid order by RAND() limit 1;
> ERROR 1064: You have an error in your SQL syntax near 'RAND() limit 1' at
> line 3
>
> select version();
> +---+
> | version() |
> +---+
> | 3.22.32 |
> +---+
>
> What could be the proble
On Mon, May 21, 2001 at 11:32:46AM +0530, Adrian D'Costa wrote:
> Hi,
>
> I have been trying this on my localhost and this works
>
> select special.contid, special.cityid, special.curr1, special.catalogo,
> special.hf, special.curr2, special.vitofferta, special.fh, special.club,
> special.stars
Err also, RAND() is a 3.23 feature ;-)
Adrian D'Costa wrote:
>
> Hi,
>
> I have been trying this on my localhost and this works
>
> select special.contid, special.cityid, special.curr1, special.catalogo,
> special.hf, special.curr2, special.vitofferta, special.fh, special.club,
> special.sta
3.22.32 has known Join issues, the machine running that version should
be upgraded to the 3.23.32 STABLE release.
Adrian D'Costa wrote:
>
> Hi,
>
> I have been trying this on my localhost and this works
>
> select special.contid, special.cityid, special.curr1, special.catalogo,
> special.hf,
Hi,
I have been trying this on my localhost and this works
select special.contid, special.cityid, special.curr1, special.catalogo,
special.hf, special.curr2, special.vitofferta, special.fh, special.club,
special.stars, city.city from special,city where
DATE_SUB(special.periodo, INTERVAL 3 DAY)
Hi,
I have four table that have common fields like: date, destinazione and
price.
I what to create a temporary table with all four fields from four tables,
what would be the correct sql syntax.
TIA
Adrian
-
Be
well I've never really looked into how the PPM app that activestate
works, I'd assume you'd probably just want to go grab the .zip file and
unzip it into your library path your self, Then when you want to play
with it make sure to use the Oracle driver in your DBI connect
statement.
Siomara Pant
Hi,
> I can not access to an access file via ODBC
> It gives me
> Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
> The Microsoft Jet database engine cannot open the file '(unknown)'.
> It is already opened exclusively by another user, or you need
> permission to view its data., SQ
I reinstalled these two packages:
D:\Perl\bin>ppm install DBI.ppd
Installing package 'DBI.ppd'...
Writing D:\Perl\site\lib\auto\DBI\.packlist
D:\Perl\bin>ppm install DBD-Mysql.ppd
Installing package 'DBD-Mysql.ppd'...
Writing D:\Perl\site\lib\auto\DBD\Mysql\.packlist
and now it works again:
mys
Hello
I treid to access an access file using following code
PHP Test
I gives me
Warning: SQL error: , SQL state 0 in SQLConnect in
c:\inetpub\wwwroot\php\ietest.php on line 7
Warning: Supplied argument is not a valid ODBC-Link resource in
c:\inetpub\wwwroot\php\ietest.php on line
Well, this really isn't a mysql issue. This is an ActiveState perl
issue, But it sounds like you've clobbered your DBD files some how and
or you're just not initializing them correctly.
Siomara Pantarotto wrote:
>
> Hi All,
>
> I got a code from a PERL list that inserts a row into a mysql db ta
I installed recent version of mySQL,myODBC,PHP on my W2000 machine
yesterday
I can not access to an access file via ODBC
It gives me
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft
Jet database engine cannot open the file '(unknown)'. It is already opened
exclusively
Hi All,
I got a code from a PERL list that inserts a row into a mysql db table.
I changed to my needs, tried, and it worked. Then I decided to install
DBD-Oracle.ppd to see if it would work well with Oracle but it did not.
After that my machine rebooted for no reason and now when I run the same
Thank you!!!
-Original Message-
From: indrek siitan [mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 20, 2001 9:51 PM
To: Mike; [EMAIL PROTECTED]
Subject: RE: Inserting images into BLOB Fields
Hi,
> How can I insert an image file into a blob field? I search the MySQL
> Documents but nothin
Hi,
> I have just done this:
> select * from indexed_table where match(indexed_col)
> against ('"visual basic"')
> This returns rows with either visual or basic. I read
> phrase searching was allowed in mySQL v4.0? Can someone please advise.
you're right, phrase and AND searches will be in MySQ
Hi,
> How can I insert an image file into a blob field? I search the MySQL
> Documents but nothing came up specificaly on inserting images from files.
INSERT INTO sig
VALUES (
1,
'Paul',
'Davolio',
LOAD_FILE('d:/signatures/paul.txt')
);
Rgds,
Tfr
--==< [EMAIL PROTECTED]
Hmm. Can you be a bit more specific how you upgraded your Apache?
Typically I've had good luck with building the new Apache first, then
building PHP (using the new apxs that it installs). You are installing
these modules as .so, correct? And building everything from source
code? The only
MySQL 3.23.38 made no difference
>
> Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem...
>
> Am about to upgrade MySQL to 3.23.38 to see if this changes things, but
feel this is clutching at straws...
>
>
> Thanks,
>
> Dave
> On Thursday, May 17, 2001, at 0
How can I insert an image file into a blob field? I search the MySQL
Documents but nothing came up specificaly on inserting images from files.
Using the Windows version.
Here's the script
CREATE TABLE sig
(
ItemID INT NOT NULL AUTO_INCREMENT,
FirstNameCHAR
If that's an exact quote then you left off the opening quote marks.
Cal
http://www.calevans.com
-Original Message-
From: Li Bing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 19, 2001 4:14 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: The Syntax to Get JDBC Connection
Dear
Dear All,
I use mm.mysql.jdbc to access mysql in Java. To get the connection, the
following sentence is writen in my program. But an error occurred.
I guess that the syntax is wrong. Could you please give me the correct
one.
Connection conn =
DriverManager.getConnection(jdbc:mysql://localhost/Re
Que tal esmeralda.
Primeramente,
visual FoxPro y Access son manejadores de base de datos tipo DBMS y que
opcionalmente pueden accesar a Servidores de Bases de Datos SQL.
MySql, Oracle, Microsoft SQL, DB2 de IBM, Etc, pertenecen a la categoria de
Servidores de Base de datos SQL
Una de las pr
My server application may end up being spread over 200 servers supporting up
to 1 million persistent tcp connections. Each client will have many records
in a database, performing updates and selects. How well does mysql
replication work over 200 servers? Was replication meant for an application
of
Using temp table... thanks I don't understand why this isn't legitimate
SQL however. I would think that it should be supported
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Message-
From: Don Read [mailto:[EMAIL PROT
On 20-May-01 Dave Carter wrote:
> Is this ok?
> UPDATE table1
> SET table1.field1 = table2.field1
> SELECT table1.field1, table1.field2, table2.field1, table2.field2,
> table2.field3
> FROM table1, table2
> WHERE table1.field2 BETWEEN table2.field2 AND table2.field3
> HAVING table1.field1 IS NULL
Well we now have Apache 1.3.19 and PHP 4.0.5 but still the same problem...
Am about to upgrade MySQL to 3.23.38 to see if this changes things, but
feel this is clutching at straws...
Thanks,
Dave
> On Thursday, May 17, 2001, at 08:59 AM, Matthew P. Marino wrote:
> >
> > > Apache is up to 1.
Is this ok?
UPDATE table1
SET table1.field1 = table2.field1
SELECT table1.field1, table1.field2, table2.field1, table2.field2,
table2.field3
FROM table1, table2
WHERE table1.field2 BETWEEN table2.field2 AND table2.field3
HAVING table1.field1 IS NULL;
I know there's a lot of rules about the update
Hola.
No pertenezco su lista de correo, pero me parece muy
interesante su trabajo. Para efectos de un proyecto de
grado requiero averiguar cuales son las ventajas y
desventajas que ofrece Mysql con respecto de los demás
manejadores de bases de datos como oracle, PosgreSQL,
access, visual fox pro,
So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thanks!
Either use a TIMESTAMP column, which wi
So sprach Scot Robnett am Sun, May 20, 2001 at 03:03:55PM -0500:
> Anybody out there that can tell me how this is done? Thanks!
Yeah, the manual will tell you. In the section 'Date and Time functions',
look for 'DATE_FORMAT'. Since you don't know where the manual is, it's
online available at ht
On 20-May-01 Scot Robnett wrote:
> I have a column "LastUpdated" in a table which uses TIMESTAMP to record the
> date and time of entries. The format of the column is:
> When I display the result, I would like reformat it so that it reads:
>
>
> May 19, 2001 04:16:25
>
> Anybody o
I have just done this:
select * from indexed_table where match(indexed_col)
against ('"visual basic"')
This returns rows with either visual or basic. I read
phrase searching was allowed in mySQL v4.0? Can someone please advise.
***
As per select * from indexed_table where match(indexed_col)
against ('+oracle +sybase +london -oracle')
> > Nothing was returned.
>
> What did you expect ? This query should return only rows that
> contain the word "oracle" AND did not contain it at the same time.
I expected it to return just r
I have a column "LastUpdated" in a table which uses TIMESTAMP to record the
date and time of entries. The format of the column is:
mysql> select LastUpdated from DriveLeadTimes;
++
| LastUpdated|
++
| 20010519161625 |
Hello,
I did the following query against my indexed table:
select * from indexed_table where match(indexed_col)
against ('oracle +sybase +london')
It returned 16 rows of which only 4 rows included all words.
I then did:
select * from indexed_table where match(indexed_col)
against ('+oracle
David Webber writes:
> Hi,
>
> 've just looked to MySQL++ examples, class names are very poorly named (!)
> Thats fine for small exaple but makes a big mess in large projects. "class
> Query" for example is SO generic that there is big probability that will
> collide with other declaration and cl
Hi,
've just looked to MySQL++ examples, class names are very poorly named (!)
Thats fine for small exaple but makes a big mess in large projects. "class
Query" for example is SO generic that there is big probability that will
collide with other declaration and classes elsewhere and this small
"c
Hello
Does anybody know if MySQL can be build on the arm architecture?
(This bug was reported against the Debian MySQL packages)
bye,
-christian-
With 3.23.37-3 I'm now seeing a different failure:
gcc -DDEFAULT_CHARSET_HOME=\"/usr\" -DDATADIR=\"/var/lib/mysql\"
-DSHAREDIR=\"/usr/share/mysq
I have faced the same problem which took me a very long time to solve.
Here are the steps I did hoping it will help you:
1- Install Mysql on d drive and not under c drive. That was clearly stated.
2- In your command line, stop at mysql "cd d:\mysql"
3- mysql>bin\mysqld-shareware --basedire d:\mysq
Hi,
while trying to link the DBD::mysql driver on a Win32 machine
I receive the following error message claiming about missing
symbols __pctype and ___mb_cur_max in mysqlclient.lib. As you
can see from the output below, I am linking against all ".lib"
files in the MySQL distribution. The paths a
Well I was hoping to be able to do it in SQL, however I do know it can be
accomplished in the middleware. I am seriously considering it as my deadline
is approaching quickly
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti.cc
717.464.2970
-Original Mess
Hi,
I have HP-UX B.10.20 A 9000/811 2002798330 two-user license
and mysql ./mysqladmin Ver 7.11 Distrib 3.22.23b, for hp-hpux10.20 on
hppa1.1
instald from depot file.
I'd like to upgrade to mysql-3.23.37.
Here begin the problems. I try binary distri
At 20:05 19/5/2001 +0100, James Cox wrote:
Hi!
Remove the service first: mysqld-nt --remove
Create /winnt/my.ini file with the following section and keys:
[mysqld]
basedir=G:/mysql
datadir=G:/mysql/data
Install the service: g:\mysql\bin\>mysqld-nt --install
start the server: net start mysql
You can also download Junction from
http://www.sysinternals.com/ntw2k/source/misc.shtml#junction which does the
same thing.
sql
> Hello Tom,
>
> If you're using Windows 2000 it has junction points. It's almost the
> same as symbolic links in UNIX. Except it works only for directories.
>
> Try
On Sun, 20 May 2001, Carlos Godoy wrote:
> Hello, wich is the meaning of this message.
> I don't have a table named 'SQL521ed_0':
> Message: General error: The table 'SQL521ed_0' is full
> SQLState: S1000
> ErrorCode: 1114
>From the very fine manual about the SET syntax:
`SQL_BIG_TABLES = 0 |
Hello, wich is the meaning of this message.
I don't have a table named 'SQL521ed_0':
Message: General error: The table 'SQL521ed_0' is full
SQLState: S1000
ErrorCode: 1114
Thanks
Carlos Godoy
-
Before posting, pleas
Hello Tom,
If you're using Windows 2000 it has junction points. It's almost the
same as symbolic links in UNIX. Except it works only for directories.
Try to find access to Windows 2000 Resource Kit, there should be a
utility called linkd.exe. If you running NT 4.0, you can try to apply
Service P
MySQL's raid function says that it can use multiple drives/directories to
put its database in to get over the 2GB limit. How do I configure MySQL to
make sure that it knows about the drives when its instructed to create a
table as RAID_TYPE = STRIPPED ?
Would I put in my.cnf:
[mysqld]
datadir=/db
50 matches
Mail list logo
