Does MySQL support "serial" (auto-increment a number) and currency types ?
It seems that both are not supported but I would just like to confirm this.
Thank you
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
Hi all,
One feature that PostgreSQL has is non-blocking API calls. Admittedly, they
don't have prepared statements yet, but non-blocking calls might be well
worth having for an app I'm hoping to build. Does the MySQL API have this
sort of capability?
Regards,
Chris
--
MySQL General Mailing
Hi Paul,
FLUSH PRIVILEGES; <- missing hahaha
That's the command I didn't use after the commands you asked me to put in
before... it is working know... I can't see mysql. I can see testdb and
test... thank you very much for your help
Cheers,
Clive
-Original Messag
On Sun, Oct 26, 2003 at 10:05:07AM -0500, Will French wrote:
>
> Are there others like me who would like to preserve the empty string
> skipping version of CONCAT_WS. Perhaps the new version of the function
> could be added under a new name like CONCAT_WS_NOSKIP or perhaps the option
> to skip bl
At 1:06 PM +1100 10/27/03, Clive Luk wrote:
| localhost | testdb | testuser | Y | Y | Y |
Y | Y | Y | N | Y | Y
| Y | Y | Y|
the N is Grant_priv
I don't understand why? tha
| localhost | testdb | testuser | Y | Y | Y |
Y | Y | Y | N | Y | Y
| Y | Y | Y|
the N is Grant_priv
I don't understand why? thanks...
Cheers,
Clive
-Original Messag
At 12:48 PM +1100 10/27/03, Clive Luk wrote:
Hi paul,
Thanks for the quick reply.
I have revoke all the privileges and ran
grant all privileges on testdb.* to [EMAIL PROTECTED];
and i login as testuser and i have confirm with select Current_user(); that
i am a testuser;
and i can still select o
Hi paul,
Thanks for the quick reply.
I have revoke all the privileges and ran
grant all privileges on testdb.* to [EMAIL PROTECTED];
and i login as testuser and i have confirm with select Current_user(); that
i am a testuser;
and i can still select on mysql.user.
just an info.
select * from
At 12:26 PM +1100 10/27/03, Clive Luk wrote:
Thanks Paul,
but how do i reset all the previous setting before I try to run the command
again? Or do I need to reset the privileges?
Try:
REVOKE ALL PRIVILEGES ON testdb FROM [EMAIL PROTECTED];
Cheers,
Clive
-Original Message-
From: Paul DuBo
Thanks Paul,
but how do i reset all the previous setting before I try to run the command
again? Or do I need to reset the privileges?
Cheers,
Clive
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:21 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROT
Please reply to the list, not to me personally, so that others can
follow this discussion.
At 12:13 PM +1100 10/27/03, Clive Luk wrote:
it says the following..
mysql> select current_user();
+---+
| current_user()|
+---+
| [EMAIL PROTECTED] |
+---
I'll bet the real problem is that you're not being authenticated as
testuser.
After you try connecting to the server as testuser, issue this query:
SELECT CURRENT_USER();
What's the result?
At 11:57 AM +1100 10/27/03, Clive Luk wrote:
Hi all,
I have a question. I have created
=
Hi all,
I have a question. I have created
===mysql_command start==
mysql> GRANT ALL PRIVILEGES ON testdb to [EMAIL PROTECTED]
-> identified by 'some_passwd';
===mysql_command end==
the user can login no p
Desperately need some way to get around the fact that UNION is not
possible to use on mysql prior to version 4…
Was just about to launch a site when it showed up that the hosting
provider was running version 3.
Help!
Regards,
Victor
--
MySQL General Mailing List
For list archives: http:/
Eduardo
Use the format '-mm-dd' instead
By the way, there is an excellent manual on http://www.mysql.com including
all the field types and formats
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 16:15
To: [EMAIL PROTECTED]
I have some Java programs that connect to MYSQL to create a table and
populate it. I had it working fine about a week ago. The next day I
started getting an error message that I don't understand. There seems to be
a problem with my connection not the program so I have no idea what to do to
f
Hi All !
I have a datetime field in a table. When I use insert into table
(aniversary) values ('24/10/2003'). The date is save as 20/10/2024. I am
using dd/mm/ What can I do to save the date correctely ?
best regards,
Eduardo F. Melo
___
I've been working on a small app which produces flexible schema
visualizations. Tables are oraganized along a circular path with FK links
shown by lines or curves. Tables and links can be highlighted in a flexible
manner, using regular expressions.
http://mkweb.bcgsc.ca/schemaball/
Schemaball is
I noticed in the changelog for the upcoming 4.1.1 alpha release that
CONCAT_WS is being changed to NOT skip empty strings. I am sure that this
must have been done in response to feedback but I wonder if there are others
who like me have relied on the skipping of empty strings. Among other
things,
Like my last mail, I've updated gcc to the newest version.
And tried to recompile mysql, without any luck.
The strange thing is to, with version 4.0.14 I've got no problems.
Only with 4.0.15,4.0.15a & 4.0.16 I've got this error message.
I hope someone can help me with this caus I'm tierd to stay w
I'm writing an application and have the following SQL Query written in
C/GTK+ code:
select customer_id, phone, last_name, first_name,
company, account_code from customers;
OK, I then issue the following C commands:
results = mysql_store_result(conx);
numRows = mysql_num_rows(results);
g_
Okay, I've update gcc to : gcc (GCC) 3.3.2
And I'm still getting the same error. It's a RH9.0 box.
Hope someone can shed some light on this.
Thanks in advance.
-Original Message-
From: Patrik Fimml [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 26, 2003 8:21 AM
To: Richard Pijnenburg
I have a small dBase4 Database that contains 260 records. Exporting it
to a text file and then using LOAD DATA into table... I see that of the
260 records only 204 get loaded. I cannot make out what is specific
about the records skipped. I do get warnings but (since I am using only
4.1.0 alpha!
On 26-Oct-2003 Heinrich Stoellinger wrote:
> I have a small dBase4 Database that contains 260 records. Exporting it
> to a text file and then using LOAD DATA into table... I see that of the
> 260 records only 204 get loaded. I cannot make out what is specific
> about the records skipped. I do g
I am trying to create a mortgage loan calculator that would give me the
monthly payments, payoff amount, interest pmts, and all the possible
scenarios in an amortization schedule. (Down payment, Interest Rates...)
Is there a simple table + query that can do this without me having to
re-invent the
Victor
How about generating a temporary table with the results of both queries ?
Or open two recordsete and merge them in your code ?
Freddie
-Original Message-
From: Victor Spång Arthursson [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 16:56
To: [EMAIL PROTECTED]
Desper
Thanks. I am at the early stage of evolution. I have created about 20-30
tables using only text. But this is my first with pics. I am not quite at
the upload stage. But I will start with the basic table design that was
mentioned in the article.
Thanks again.
Braulio
---Original Me
Hi there,
I'm trying to restrict the access that a Tomcat server has to mysql
4.0.15-standard-log database server. Unfortunately some of the queries use
temporary tables, so I've had to GRANT CREATE TEMPORARY TABLES to the user.
However, since the server is using connection pooling, it also DROP
Eduardo
MySQL does not use the square brackets [] as field delimiters. Try to use
`Clientes of Supermarkets` instead
Note, these are not single quotes (') but ASCII 96
Freddie
-Original Message-
From: Eduardo Melo [mailto:[EMAIL PROTECTED]
Sent: Sonntag, 26. Oktober 2003 14:40
To: [EM
Hi all !
I am migrating my database from MS-ACCESS to MYSQL. When I try to use a
select statement below the application fails.
select * from [Clientes of Supermarkets]
anybody have an idea ?
best regards,
Eduardo F. Melo
_
MSN M
I am new to the world of GIS and have an application where I would like
to use MySQL's (found in 4.1 alpha currently) Spatial Extensions. I
have a set of latitude and longitude for various locations and am trying
to figure out how to convert to the SRID units. I have started going
thru the to
Hi Heikki,
> > As you know - I'm a transaction zealot :-)
> >
> > Is there a way to get a signal back to the client when a
> > transaction has started?
>
> what do you mean? If you have AUTOCOMMIT=0, then every SELECT, INSERT,
> UPDATE, DELETE starts a new active transaction.
Aha - that's good, I
On Sat, Oct 25, 2003 at 11:49:46PM -0500, Adam Clauss wrote:
> I have a select statement that selects two string (text) fields. In some
> cases, the first of them may be NULL. In this case, I would like the second
> field to be selected instead. It is also possible that in rare cases that
> the
I have downloaded perl 5.8.0 & DBI 1.38 & DBD Mysql 1.2219
I'm not too sure how to install from this point. I am running NT4 and
have tried:-perl makefile.pl, and nmake makefile, and then nmake install
but I keep getting error - can't locate DBI DBD.pm in @INC
Please help
thanks d.a.
--
MySQL
10/26/03 12:37:28 AM, Patrik Fimml <[EMAIL PROTECTED]> wrote:
>
>Well, I tried it many times... here is the last:
>
>gcc -L/usr/local/lib/mysql -lmysqlclient -lnsl -lm -o rpgservices conn.o io.o
>main.o
>main.o(.text+0x80): In function `main':
>: undefined reference to `mysql_connect'
>collect2:
35 matches
Mail list logo
