Hi.
Are temporary tabels or views supported in MySQL?
Some info required please
Thanks
Anis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 12 Mar 2003 [EMAIL PROTECTED] wrote:
Hi! I'm trying to install mysql on a RISC-6000 box running AIX 4.3. When
I type './mysql' I get the following error:
# ./mysql
Could not load program ./mysql:
Dependent module libz.a(shr.o) could
It's IMHO the only difference...
Have you looked up the documentation?
Bernhard
- Original Message -
From: Dan Cumpian [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 3:45 AM
Subject: mysqld-nt vs mysqld-max-nt
MyISAM tables) and I'm a bit confused by what's in
I've discovered what causes this issue.
The file nt_serv.cpp has a method called IsService. This requests SERVICE_ALL_ACCESS
permission from the service control manager. Changing this to SERVICE_QUERY_STATUS
fixes the issue whilist achieving the same effect/
Simon
Message from Simont
- Original Message -
From: [EMAIL PROTECTED]
To: Bernhard Döbler [EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 9:09 AM
Subject: Re: Fw: phpMyAdmin
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
Hi,
If a parent table has multicolumn primary key
AND child table have a constraint to one column of this parent
primary key (let's say column id_a)
AND there are more records in parent table having the same value
of id_a (let's say id_a==1)
AND child table has record with id_a==1
Hi !
I have tried to find a solution to my problem on groups, FAQs, with no
effect.
GRANT Select,Insert,Update,Delete ON `sprzet`.* TO
- 'azsxdcfv_azsxdcfvgb''azs.azsxdcfvg.az';
ERROR 1145: The host or user argument to GRANT is too long
hmm ...
mysql show columns from user;
Hello,
when linking to libsqlplus from an own project, I found that it was looking for
libmysqlclient.la in /usr/lib (instead of /usr/local/lib, where it is really
installed). As it seems, this path to libmysqlclient is taken from the
libsqlplus.la, where it is put down hard-coded.
Is there a
Hello,
when building mysql++-1.7.9 from the source distribution, I get an error
message:
const_string1.hh:50: `out_of_range' undeclared (first use this function)
I checked the source at that line, and indeed the exception `out_of_range'
seems to be incorrectly used: The `std' namespace isn't
Respondendo,
quinta-feira, 13 de março de 2003, 05:05:24, Mensagem Original:
ASKA Hi.
ASKA Are temporary tabels or views supported in MySQL?
ASKA Some info required please
ASKA Thanks
ASKA Anis
ASKA -
ASKA Before posting,
Hi,
I try to use raw devices with innoDB and i have some problems.
First, after modifying my.cnf file, and restarted mysql, i received an error
13. The solution was to start mysql with the root user (baaah !). I think it
is a temporary solution.
BUT, now, i have an error 5 with innodb.
my.cnf
Respondendo,
quinta-feira, 13 de março de 2003, 08:23:38, Mensagem Original:
JR Hi,
JR I try to use raw devices with innoDB and i have some problems.
JR First, after modifying my.cnf file, and restarted mysql, i received an error
JR 13. The solution was to start mysql with the root user (baaah
Hi,
is there any built in high availability issue on mysql today? Or even plans to
do it?
I mean, I made my own HA perl script running on both master and slave
replication servers to set up a HA but it could be a plugin of mysql,
couldn't?
In fact i want to rewrite it in C or Java but i
* YC Nyon
I need to get the time/date (ie. 1 day 12 hours 11 min 4sec)
between 2 time dates.
Can't seem to find any of these functions in the Mysql manual. The nearest
was Period_diff() which is calculating months elapsed.
I don't think you can do it directly, you have to split the day and
At 22:25 -0700 3/12/03, Jason Brothers wrote:
Hello,
I apologize if this topic has been discussed in the past. I am just looking
for feedback whether to use Datetime or Unixtime (32 bit Int) for my
timestamps. From what I can tell here are the advantages and disavantages
of each method:
you can use any programmin language to manipulate...
i did the following in PHP...
//###
// Function to calculate remaining days, hours,
Hi,
I am able to create temporary tables in MYSQL,using CREATE TEMPORARY
TABLE
I am using JDBC for this.
Just like show tables will give all the table names in that
databases, is there any query to view all current Temporary table names?
Rgds
Anis
Greetings MySQL folk,
New to MySL, please bear with me..
I have created two tables
Clients and Jobs
One Client has many jobs.how do I create a relation between the two
tables ?
I have searched the manual using terms like relations - create
relations etc etc to no avail.
If someone could
You moved the prototype startup script, not the output script created by
'make'.
You need to check the error log to see what the problem is.
Defryn, Guy wrote:
I have installed 4.0.9 from source.
After compiling it I want to start it with
/usr/local/mysql/bin/mysqld_safe --user=mysql
and
* Chris Blake
I have created two tables
Clients and Jobs
One Client has many jobs.how do I create a relation between the two
tables ?
Simply by including a column in the jobs table 'pointing' to the client
table. Say, for instance, that the Client table have a unique primary key
called
I have 1 table with 3 fields: date, userid, and a number. I would like an sql query
result with the userid for the first column followed by 1 column for each date and all
corresponding numbers displayed for that userid for that date. Is there a way to do
this using just sql and not php or some
To anyone that cares
I am looking for a bona fide distributed database system, like Oracle or
SQLServer, but open source running on Linux. I have found one, Backplane,
but as I understand it it is used for BSD Unix. If anyone can help it would
be much appreciated.
tx Jimmy the hat
I am currently looking at building a Perl object to handle data from a
a database.
I'm not really sure if it is best to have one connection to MySQL and
let the object just deal with its own properties.
Or to allow the object to initiate a DBI connection each time an instance
of the object is
Chris Blake wrote:
New to MySL, please bear with me..
I have created two tables
Clients and Jobs
One Client has many jobs.how do I create a relation between the two
tables ?
I have searched the manual using terms like relations - create
relations etc etc to no avail.
Look up join. The
On 3/13/03 6:47 AM, Tom Norwood [EMAIL PROTECTED] wrote:
I am currently looking at building a Perl object to handle data from a
a database.
I'm not really sure if it is best to have one connection to MySQL and
let the object just deal with its own properties.
Or to allow the object to
Hi,
I am planning to run an instance of MySQL 3.23.55 and 4.0.11-max on the
same machine. The question is: what do I do with DBD::mysql ? Can I
leave it intact? The install note says I have to recompile modules that
link against libmysqlclient... but do I really have to do that? Or can I
At 14:47 + 3/13/03, Tom Norwood wrote:
I am currently looking at building a Perl object to handle data from a
a database.
I'm not really sure if it is best to have one connection to MySQL and
let the object just deal with its own properties.
Or to allow the object to initiate a DBI connection
At 11:25 +0100 3/13/03, boka wrote:
Hi !
I have tried to find a solution to my problem on groups, FAQs, with no
effect.
GRANT Select,Insert,Update,Delete ON `sprzet`.* TO
- 'azsxdcfv_azsxdcfvgb'@'azs.azsxdcfvg.az';
ERROR 1145: The host or user argument to GRANT is too long
Use a shorter user
Please.seven days to try it!! Help me!! :-(
--
Hello,
I've tried to setup a replication but ...i've several problem! I've
follow the manual istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html
But the slave don't start the replica.
SHOW SLAVE STATUS on SLAVE return
On 12 Mar 2003, at 22:25, Jason Brothers wrote:
I am just looking for feedback whether to use Datetime or
Unixtime (32 bit Int) for my timestamps.
You left out a major advantage of Unix time: you don't have to worry
about changing time zones or daylight saving time. MySQL DATETIME
doesn't
Paul,
I guess I would see the fact that the script would hold the connection
to MySQL for a shorter period of time, as the most obvious advantage.
As far as OO programming goes the integration of DBI into my object
would assure that a connection to the database would be established
automatically
This is going to sound silly, but I accidently removed the privelages of my
user that could add users..etc.. I use the Control Center, since I am not
all that great with advanced SQL syntax... now I can't even use the CC to
add users, or anything.. what can I do? What is the username/password that
Perhaps I'm missing something, but couldn't you essentially have it both
ways. What about allowing your method that initiates the object optionally
accept a reference to a DBI object? If a DBI object reference is passed,
your object will use that. If one isn't passed, have it open a new
JSP
JSP
JSPTOMCAT4.1.8WEBMANAGER
CGI PERL5.6 PHP4(2.X) JSP1.2 Servlet2.3
(CGI-BIN,WEB-INF,CONTEXT+Javamail1.2)
J2SDK1.4.1 EJB
SQL SERVER2000MYSQL(),
WEB-CONTEXT
WEBManagerweb application
1800-4500/
2G
JSP:http://www.01isp.com/support/jspconf.net
:http://www.01isp.com
Email:[EMAIL
At 10:34 -0500 3/13/03, Keith C. Ivey wrote:
I am curious why a DATE takes 3 bytes and a TIME takes 3 bytes, but a
DATETIME takes 8 bytes, even though TIME covers a much greater range
than the time part of a DATETIME, but that's just one of the
mysteries of MySQL that's probably not worth losing
At 15:47 + 3/13/03, Tom Norwood wrote:
Paul,
I guess I would see the fact that the script would hold the connection
to MySQL for a shorter period of time, as the most obvious advantage.
As far as OO programming goes the integration of DBI into my object
would assure that a connection to the
On 13 Mar 2003, at 10:20, Paul DuBois wrote:
At 10:34 -0500 3/13/03, Keith C. Ivey wrote:
I am curious why a DATE takes 3 bytes and a TIME takes 3 bytes, but a
DATETIME takes 8 bytes, even though TIME covers a much greater range
than the time part of a DATETIME, but that's just one of the
Although my initial implementation would only deal with one instance
of my object.
There WOULD be simultaneous connections if two or more instances of my
object existed at the same time.
Tom Norwood.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 13 March 2003 16:23
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
Paul DuBois wrote:
At 10:34 -0500 3/13/03, Keith C. Ivey wrote:
I am curious why a DATE takes 3 bytes and a TIME takes 3 bytes, but a
DATETIME takes 8 bytes, even though TIME covers a much greater range
than the time part of a DATETIME, but that's just one of the
mysteries of MySQL that's
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
On Thursday 13 March 2003 10:05, Ahmed S K Anis wrote:
Are temporary tabels
Yes. Take a look at:
http://www.mysql.com/doc/en/CREATE_TABLE.html
or views supported in MySQL?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
At 11:56 -0500 3/13/03, walt wrote:
Paul DuBois wrote:
At 10:34 -0500 3/13/03, Keith C. Ivey wrote:
I am curious why a DATE takes 3 bytes and a TIME takes 3 bytes, but a
DATETIME takes 8 bytes, even though TIME covers a much greater range
than the time part of a DATETIME, but that's just one
Philip,
- Forwarded message from Philip Molter [EMAIL PROTECTED] -
Date: Mon, 10 Mar 2003 08:30:22 -0600
From: Philip Molter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: InnoDB Assertion Error
THE SITUATION:
We're running MySQL 3.23.51. We have a table which has a
Description:
I attempted to use the binary distribution available for
the Tru64 5.1 OS that is available from the download site, but the
mysql_install_db script crashes:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Thanks to everyone that took the time to reply.
As far as the timezones and unixtime, yes, thank-you for reminding me on
that advantage.
Jason
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Jason Brothers [EMAIL PROTECTED]
Sent: Thursday, March
At 12:54 +0100 3/13/03, Roger Baklund wrote:
* YC Nyon
I need to get the time/date (ie. 1 day 12 hours 11 min 4sec)
between 2 time dates.
Can't seem to find any of these functions in the Mysql manual. The nearest
was Period_diff() which is calculating months elapsed.
I don't think you can do
Hello-
I upgraded three servers to 3.23.55 over the weekend configured them to
be peers in a daisy-chain setup. It's worked well with one exception:
Our FreeBSD 4.6 server (built from the ports collection) crashed (this
morning; on day five of uptime) with the following in the log:
Fatal error
To anyone that *didn't see the forest because of the trees*.
You already find it.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original
trashMan wrote:
Please.seven days to try it!! Help me!! :-(
--
Hello,
I've tried to setup a replication but ...i've several problem! I've
follow the manual istruction
http://www.mysql.com/doc/en/Replication_HOWTO.html
But the slave don't start the replica.
SHOW SLAVE STATUS
On Thu, Mar 13, 2003 at 10:47:05AM -0700, Jason Brothers wrote:
- portability -- code using unixtime is less likely to rely on MySQL's
date functions, and more easily ported to PostgreSQL, Foxbase, etc.
I thought the Datetime function in MySQL was based on the ANSI SQL99
standard?
Paul Larue wrote:
Hi all,
I got MySQL 3.23.55-nt running on XP and MySQL Client 3.23.36 running on
Linux Red Hat 7. I'm trying to have the client connect to the server but I
get the same error all the time:
[EMAIL PROTECTED] /root]# mysql -h 10.0.0.41 -u guest
ERROR 1130: Host '10.0.0.220'
I am linking an MS Access front end to MYSQL on the back with ODBC
If I open the table I can enter a value in the course name field only which
is the primary key
and it will save the record even though I have not entered values in the
fields set up as NOT NULL
I have an ODBC trace file but it
Hello All,
I am trying to develop a SQL statement to ultimately strip a field of
everything buy numeric digits. Does anyone know how to do this or can
anyone look at the below code and give direction if I am on the right
track?
For example, let's say the contact_phone field has 2 records:
I am attempting to use mysql_num_rows() after mysql_store_result(), but the
return value is always 0. The documentation says that it will not work if I
use it after mysql_use_result() without doing a fetch first, but I am doing
a mysql_store_result() instead, which should work right away. This
Hi Dan and everyone,
First off, I apologize for the stupid question due to my lack of technical
knowledge on this area.
What I am trying to do is to connect to a MySQL on a Win2k machine from
another Win2k machine with SSH.
After doing some research, I manage to grasp some idea on how to
What does it say when you run SHOW MASTER STATUS on the master? Are you
sure the slave is the problem and not the master?
-Original Message-
From: trashMan [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 7:29 AM
To: [EMAIL PROTECTED]
Subject: Replication error
Please.seven
Is there a setting that I must change on a MYSQL server to allow remote
connections from a GUI client? I can only connect when I am local
Thanks!
.::d::.
--- THEbeatingsWILLcontinueUNTILmoraleIMPROVES ---
-
Is there a setting that I must change on a MYSQL server to allow remote
connections from a GUI client? I can only connect when I am local
-
To add to this, the error I am getting is:
Unable to connect to any hosts due to exception: java.net.ConnectException:
Connection refused
Michael-
That seems to be correct. I've been able to do this using PuTTY as the
client. Just forward the local 3306 to the server's 3306 and connect to
localhost:3306. Be sure to log to the server via ssh before attempting
a connection.
-jeff
On Thu, 2003-03-13 at 13:09, Tam, Michael wrote:
At 11:03 -0800 3/13/03, Hebron Mak wrote:
I am attempting to use mysql_num_rows() after mysql_store_result(), but the
return value is always 0. The documentation says that it will not work if I
use it after mysql_use_result() without doing a fetch first, but I am doing
a mysql_store_result()
SHOW MASTER STATUS on the master say
file: webserver-bin.003
Position:11345
Binlog_do_db: zopista
Where zopista is the database i want replicate.
:-/
Massi samuela
-Messaggio originale-
Da: Jennifer Goodie [mailto:[EMAIL PROTECTED]
Inviato: giovedì 13 marzo 2003 20.05
A: trashMan;
# [EMAIL PROTECTED] / 2003-03-13 11:51:52 -0700:
This is not proper syntax, but I would think it is close...
select replace(contact_phone, REGEXP ^[1234567890],'') from
individual;
I don't use REs in MySQL, but inverse classes are written [^spec],
not ^[spec].
--
If you cc me or
hi
i posted this to the newsgroups and got told it was probably a sql
parser bug so here goes...
if u try to execute a query such as:
insert into foo (id,textfield) values (54,'\\fred\\')
the query fails
if i add a space after the last \\ it works
this is a real pain personally cos we use a
I could be lame, but I couldn't reproduce the error.
The query worked ok for me -- using 4.0.4-beta-max-nt
i posted this to the newsgroups and got told it was probably a sql
parser bug so here goes...
if u try to execute a query such as:
insert into foo (id,textfield) values (54,'\\fred\\')
[EMAIL PROTECTED] wrote:
I could be lame, but I couldn't reproduce the error.
The query worked ok for me -- using 4.0.4-beta-max-nt
Isn't Lauren using a language that uses \ as an escaping character? And
then tries to do something with \f? If it works form the mysql comman
line, then this can
On 13 Mar 2003, at 14:59, lauren wrote:
if u try to execute a query such as:
insert into foo (id,textfield) values (54,'\\fred\\')
the query fails
if i add a space after the last \\ it works
this is a real pain personally cos we use a lot of that stuff :(
You'll have to show us
the actual horror story query is:
update link set path=insert(path,1,13,'\\test\\test21\\') where
person_id = 8 and path like '\\test\\test2\\%'
am going slightly dilly
:/
---
even if my world is weird its my world
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Everything was working fine. No changes were made and suddenly this
error shows up:
java.sql.SQLException: Server configuration denies access to data source
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:386)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1486)
at
Jeff,
Thank you for your confirmation. I will give it a try later on my machines.
Michael
-Original Message-
From: Jeff Kilpatrick [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 11:29 AM
To: Tam, Michael
Cc: [EMAIL PROTECTED]
Subject: RE: Telneting failed
Michael-
That
On 13 Mar 2003, at 15:30, lauren wrote:
the actual horror story query is:
update link set path=insert(path,1,13,'\\test\\test21\\') where
person_id = 8 and path like '\\test\\test2\\%'
You still haven't told us how you're sending this query to MySQL, and
my advice remains the same. If at
its cool i got the 4 backslashes thing worked out
thanks very much for the pointer
:)
---
even if my world is weird its my world
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 13, 2003 16:11
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Hello,
First install.
Acquired the mysql-max-3.23.55-pc-linux-i686.tar.gz file.
Uncompressed and installed into /usr/local
Would like to have Innodb tables activated and set the datadir to
'/usr/local/mysql_db_files'
In viewing the /usr/local/mysql/scripts/mysql_install_db file the option
Jan,
this is a design deficiency which was known to me, but was not documented. I
will remove it in some version 4.0.xx.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, hot backup, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-4.0 from
Jungsu,
please add the line
log
to your my.cnf.
If you want to know what happens within mysqld, you should start it
with --log[=file]. This will log all connections and queries to the log file
(by default named `'hostname'.log').
Then the next time mysqld crashes, you can look from the
Hello,
I'm interested in building a translation dictionary:
russian - french. My database would have only one
table which contains in each entry a the word and its
translation. I intend to put such a dictionary on a
web page.
I would like to ask for some ideas on how to build
such a dictionary
Hi,
I am trying to build an application that is using mysql and sometimes
sensitive data will need to be removed from the database.
When I delete something how do I make sure there isn't a trace of it left?
I am looking for a linux shred type solution. There should be absolutely no
At 1:12 +0100 3/14/03, Nico van Leeuwen wrote:
Hi,
I am trying to build an application that is using mysql and
sometimes sensitive data will need to be removed from the database.
When I delete something how do I make sure there isn't a trace of it
left? I am looking for a linux shred type
Hi there, I am still having issues creating a user that can access a
database. The only time the user can access is if I SSH into my linux box
(redhat 8) and connect with:
# mysql -u id -p
It works fine when doing that, and I can create and do everything I need to
do.
Now - I am trying to
Paul DuBois wrote:
At 1:12 +0100 3/14/03, Nico van Leeuwen wrote:
When I delete something how do I make sure there isn't a trace of it
left? I am looking for a linux shred type solution. There should be
absolutely no possibility of data recovery.
As far as I'm aware, there isn't anything like
Short version: I need to refresh MySQL tables on a Linux box with MS
Access data at irregular intervals. The MySQL version of the data will
never be updated; it serves purely as a replica of the Access data. My
plan is as follows:
1) Install MyODBC on Windows machine.
2) Create linked
Paul DuBois wrote:
At 1:12 +0100 3/14/03, Nico van Leeuwen wrote:
When I delete something how do I make sure there isn't a trace of it
left? I am looking for a linux shred type solution. There should be
absolutely no possibility of data recovery.
As far as I'm aware, there isn't
I have set apache 2.0 and PHP 4.3.1 as well as mysql.
I was wondering how I can disable PHP per user directory?.
At the moment everyone can put php scripts on their personal website.
I want to limit it to a few users.
Cheers
Sql,query
At 20:00 -0500 3/13/03, Bruce Feist wrote:
Paul DuBois wrote:
At 1:12 +0100 3/14/03, Nico van Leeuwen wrote:
When I delete something how do I make sure there isn't a trace of
it left? I am looking for a linux shred type solution. There should
be absolutely no possibility of data recovery.
As
The manual does not give any warnings about using load data local when
applying changes via the binary log.
I am having trouble getting my head around how this would work.
IE if you update a table via load data local then how can you replicate
these changes using the binary log, because when
Hi,
I am running MySQL version 3.23.55 on FreeBSD 4.7, linuxthreads 2.2.3_8
and with gcc 2.95.4 .
I use the following configuration line :
CFLAGS=-g -I/usr/local/include/pthread/linuxthreads CPPFLAGS=-g
-I/usr/local/include/pthread/linuxthreads LDFLAGS=-L/usr/local/lib
-llgcc_r ./configure
Hi, All
Can two mysql servers work on the same database directory ? It it possible in
read only mode or in read and write mode ?
With best regards
Vlad A. Shalnev
E-mail: [EMAIL PROTECTED]
Gravity can't be blamed
Hi Guy,
Try sticking this in the relevant VirtualHost directive:
Directory /path/to/client/doc/root
php_flag engine off
/Directory
HTH
Ben
In response to your mail sent on Friday, March 14, 2003 at 12:38:19 PM.
I have set apache 2.0 and PHP 4.3.1 as well as mysql.
I was wondering
In the last episode (Mar 13), Jeff Kilpatrick said:
I upgraded three servers to 3.23.55 over the weekend configured them
to be peers in a daisy-chain setup. It's worked well with one
exception:
Our FreeBSD 4.6 server (built from the ports collection) crashed
(this morning; on day five of
89 matches
Mail list logo
