dear buddy,
when u specify permissions on a particular database, you need to give that
database name to connect to db.
user created fine, while connecting, try this:
mysql -u abc -p abc
where last abc is ur database name.
Nitin
- Original Message -
From: ads mysql [EMAIL PROTECTED]
mos wrote:
At 04:22 AM 12/15/2003, you wrote:
To elaborate on Dr Frank's thing if you're interested, here's a
classic deadlock example:
1. Transaction A obtains an exclusive lock on a set of rows which we
will call R1.
2. Transaction B obtains an exclusive lock on another set of rows
which
O K. I have tried following as advised.
#
[EMAIL PROTECTED] mysql]# mysql -u abc -p abc
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
##
Then once again I accessed mysql as root user and Granted permission as follows :
[EMAIL PROTECTED]
Hello,
I'm running MySQL 4.0.16 (source compiled) on FreeBSD 5.1,
and I have a big problem with SSL...
It runs perfectly for a few hours, but then suddenly I can't connect any
longer via an SSL-connection...
ERROR 2026: SSL connection error
That's the error that suddenly appears when using
Hi Richard,
Okay, that sounds good and all, but how does that help me, since the date
is
chosen
from the javascript calander in this format: mm/dd/
So then, when I'm selecting a date of at least todays value, or less in
the
database
how would I do it, since it's in mm/dd/?
I
Looking at the facts, the number of files used to store your data is of
very little consequence at the end of the day. Looking
at the following:
* MS SQL Server stores database data in a single file and logs in another.
* Oracle and FoxPro both have a pretty large number of files, for very
did u do a
flush privilege
- Original Message -
From: ads mysql [EMAIL PROTECTED]
To: Nitin [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 1:00 PM
Subject: Re: How to create mysql user?
O K. I have tried following as advised.
#
[EMAIL PROTECTED] mysql]#
As advised I tried following :
###
[EMAIL PROTECTED] root]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 71 to server version: 4.0.16-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql
I'm using v3.23.51 on Linux.
Can anyone explain why a simple 'sum' select won't work?? Here is the
example:
mysql select sum (id), pet from visits group by pet;
ERROR 1064: You have an error in your SQL syntax near '(id), pet from visits
group by pet' at line 1
--
MySQL General Mailing List
- Original Message -
From: Nitin [EMAIL PROTECTED]
To: ads mysql [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:01 PM
Subject: Re: How to create mysql user?
did u do a
flush privilege
- Original Message -
From: ads mysql [EMAIL PROTECTED]
To:
Mofeed Shahin [EMAIL PROTECTED] wrote:
Still doesn't work But thanks for trying.
Worked fine for me:
mysql CREATE TABLE Blah (
- ID INT PRIMARY KEY,
- Fname VARCHAR (50),
- Lname VARCHAR (50),
- UNIQUE (Fname, Lname)
- ) TYPE=INNODB;
Query
On Tuesday 16 December 2003 09:22, Noamn wrote:
I'm using v3.23.51 on Linux.
Can anyone explain why a simple 'sum' select won't work?? Here is the
example:
mysql select sum (id), pet from visits group by pet;
ERROR 1064: You have an error in your SQL syntax near '(id), pet from
visits
On 12/16/2003 01:35 AMnbsp;Ligaya Turmelle wrote:
Can anyone tell me what the current support for the UTF8 character set is?
How strong is it? Do I have to do anything special to save the characters?
I will be getting the characters from a webpage form and inserting the
characters with PHP.
It
Hi David,
for Zeos questions check:
http://www.zeoslib.net/modules.php?name=Forums
regards
Michael Daheim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Yes, It worked with folllowing :
I have created new user 'abc1' with password 'abc1' for database 'abc'.
###
##
[EMAIL PROTECTED] mysql]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL
try restarting mysql service ..
Cheers
Binay
- Original Message -
From: ads mysql [EMAIL PROTECTED]
To: Duke, Brian [EMAIL PROTECTED]; Nitin
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 2:07 PM
Subject: RE: How to create mysql user?
As advised I tried following
Noamn [EMAIL PROTECTED] wrote:
I'm using v3.23.51 on Linux.
Can anyone explain why a simple 'sum' select won't work?? Here is the
example:
mysql select sum (id), pet from visits group by pet;
ERROR 1064: You have an error in your SQL syntax near '(id), pet from visits
group by pet' at
Hi!
I am trying to get access to the MySQL embedded server using the library
libmysql.dll through c++builder. The loading of the library goes well,
but when calls are made to start the server, the application crashes.when i
run the program ,the program crashed in mysql_server_end
my program as
Creating library ../lib_debug/libmysqld.lib and object
../lib_debug/libmysqld.exp
set_var.obj : error LNK2001: unresolved external symbol _resize_thr_alarm
../lib_debug/libmysqld.dll : fatal error LNK1120: 1 unresolved externals
Error executing link.exe.
but i have link mysys.lib ,how to solve
Hi!
--cut
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve
Is there any reason that you need to sum the id? I'm assuming that
you're trying to count. Ya?
-Original Message-
From: Noamn [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:22 PM
To: [EMAIL PROTECTED]
Subject: 'Sum' syntax
I'm using v3.23.51 on Linux.
Can anyone explain
Creating library ../lib_debug/libmysqld.lib and object
../lib_debug/libmysqld.exp
set_var.obj : error LNK2001: unresolved external symbol _resize_thr_alarm
../lib_debug/libmysqld.dll : fatal error LNK1120: 1 unresolved externals
Error executing link.exe.
but i have link mysys.lib ,how to solve
I have a MySQL replication slave running 3.23.52 on a
2.4.18 linux box with 1.2GHz P3 and 512MB of memory.
The box serves three web servers and runs at about 70
queries per second most of the time, with system load
at about 0.5
MySQL is the precompiled RPM from mysql.com
Recently I tried
Hello,
I'm investigating a performance problem with mysql server set up.
The server is running linux with 1GB ram. I'ld like to tune the
configuration of the server to use as much RAM as possible without
swapping to the disc because of the big slow down.
The current
Juri Shimon [EMAIL PROTECTED] wrote:
Hi!
What does 'SHOW CREATE DATABASE database_name;' show for this database?
I've found it...
1. F:\Projects\has\sqlmysql -u root -e create database t; show create
database t; drop database t
I think over other problem.
In the table (shown below) there is another column defined as timestamp(6).
Do you think is it possible to get result grupped by month period: form
january to december ??
Best regards,
Paul
id | product | dat
---
0 | switch | 030702
1 | switch
Hello Patrick!
I am trying to connect COBOL to the MySQL Database. I
have used the C API to establish the conection to
MySQL. You have quoted that library file
mysqlclient.lib is enough.
But when I try to test the Connecton using VC++ editor
by writing a simpe C Program, the linking of
Hello Patrick!
I am trying to connect COBOL to the MySQL Database. I
have used the C API to establish the conection to
MySQL. You have quoted that library file
mysqlclient.lib is enough.
But when I try to test the Connecton using VC++ editor
by writing a simpe C Program, the linking of
I tried to insert this query:
SELECT COUNT(DATE_FORMAT(dat,'%M')), DATE_FORMAT(dat,'%M') FROM table GROUP
BY DATE_FORMAT(dat,'%M') order by dat
but I`m not sure of proper result.
Regards,
Pawel
- Original Message -
From: Pawel Filutowski [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
There are a few things that could be happening:
1. Solaris 8 uses many-to-many threads in Solaris threading mode and
1:1 in
POSIX threading mode. I'm not sure which functionality the MySQL
binaries exercise,
but 1:1 seems to be less intensive. Regardless, Solaris thread creation
tends to be
Dr. Frank Ullrich wrote:
Hi!
--cut
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely
Hi!
How heavy is your usage of TEMPORARY TABLES? I don't use them much
myself, but
I'm sure that the others on the list will have something to say in that
regard.
To get a better look at MySQL's usage of memory, you could try looking
at the output of
SHOW STATUS .
Regards,
Chris
Markus
I was trying to establish connection to MySQL through
a simple C program using it's C API mysqL_init(),
mysql_reak_connect(), ... in VC++ Editor. It shows
Errors ;
Compiling...
MYSQL.C
c:\mysql\include\mysql_com.h(116) : error C2061:
syntax error : identifier 'SOCKET'
On Tue, 2003-12-16 at 02:09, Jeremy Zawodny wrote:
On Sun, Dec 14, 2003 at 10:50:43PM +0100, Rodrigo Moya wrote:
Hi
We have been supporting MySQL in the GNOME-DB project
(http://www.gnome-db.org) since the beginning almost (1998). GNOME-DB
provides several liraries, and one of those is
I'm in the process of converting an application from Paradox to mySQL which
is why I have these syntax questions.
mySQL doesn't like a query with this syntax:
select p.name,
from projects p, ...
where p.closeddate = :fd
and p.closeddate = :td
...
where fd (from date) and td (till date) are
Hi,
I am trying to install and configure php with mysql support.
I have installed mysql and it works perfectly on the server. On the same server I
tried to install php with following configuration :
[EMAIL PROTECTED] php-4.3.4]# ./configure --with-apxs2=/usr/local/apache2/bin/apxs
--with-
On Tuesday 16 December 2003 13:43, ads mysql wrote:
php-4.3.4]# ./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-
mysql=/var/lib/mysql
It gives error configure: error: Cannot find MySQL header files under
/var/lib/mysql
what should I put in --with-mysql=/var/lib/mysql
On
[snip]
I'm in the process of converting an application from Paradox to mySQL
which
is why I have these syntax questions.
mySQL doesn't like a query with this syntax:
select p.name,
from projects p, ...
where p.closeddate = :fd
and p.closeddate = :td
...
where fd (from date) and td (till
I started with between, but when this didn't work, I switched to the
comparison operators.
mysql select projects.name from projects
- where projects.closeddate between :fd and :td;
ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at line
2
mysql
-Original Message-
[snip]
I started with between, but when this didn't work, I switched to the
comparison operators.
mysql select projects.name from projects
- where projects.closeddate between :fd and :td;
ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at
line
2
[/snip]
What are those
This is not a bug, you need to set your project/programming environment in
VC++ to include support for sockets. I haven't written any non socket
programs in several years, so it's part of my standard set-up.
MySQL is client/server and uses sockets. You do need to link with a socket
library. In
How do you get the string value of an argument to a function?
For integer, there's val_int(), for real, there's val().
I tried using val_str(), but that didn't work.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
mysql select projects.name from projects
JB - where projects.closeddate between :fd and :td;
JB ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at
JB line
JB 2
JB What are those colons?
He probably uses Delphi or C++Builder to connect to mysql via TQuery
component. TQuery
mysql select projects.name from projects
JB - where projects.closeddate between :fd and :td;
JB ERROR 1064: You have an error in your SQL syntax near ':fd and :td' at
JB line
JB 2
JB What are those colons?
He probably uses Delphi or C++Builder to connect to mysql via TQuery
I assume that I will have to write 01/01/02
Thanks for the help. Let's hope that there aren't any more questions of this
ilk and I can continue to port my application.
No'am
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 4:47 PM
To:
Hi,
I have made all the changes suggested by you in VC++
6.0 i.e., I have inluded the Library file wsock32.lib
into the existing library list in 'Project
Settings'(Alt-F7') and checked the path setting of
mysql header file and library file in Tools -- Options
menu's Directory tab.
but still it
OK I tried this, '+music +mix +2001' instead of this 'music mix 2001'
IN BOOLEAN MODE and the SQL time is the same ~21 sec.
select artists.name , cds.title, tracks.title from artists, tracks, cds
where
MATCH (artists.name) AGAINST ('madonna' IN BOOLEAN MODE)
and
MATCH (cds.title) AGAINST
I tried with option ./configure --with-apxs2=/usr/local/apache2/bin/apxs
--with-mysql as suggested that php might find mysql libraries on it's own.
It has not given any error.
Let me check whether I can connect to mysql using php.
Thanks for support.
Duncan Hill [EMAIL PROTECTED] wrote:
I have a simple MySQL replication system setup with a single master and
a single slave. The slave is running 4.0.16-standard and the master is
running 4.0.16-standard-log.
On an (almost) daily basis, I get this error on my slave:
031216 9:55:44 Error reading packet from server: log event
At 01:14 AM 12/16/2003, you wrote:
mos wrote:
At 04:22 AM 12/15/2003, you wrote:
To elaborate on Dr Frank's thing if you're interested, here's a classic
deadlock example:
1. Transaction A obtains an exclusive lock on a set of rows which we
will call R1.
2. Transaction B obtains an exclusive
Jeremy Zawodny wrote:
On Tue, Dec 16, 2003 at 12:01:55PM +0700, David Garamond wrote:
Sven K?hler wrote:
I was very disappointed by Interbase/Firebird. It seemed to me like a
MS-Access: a database-engine that works on regular files
Firebird seems simple, but it doesn't mean it's
Chris Nolan wrote:
Regarding mysqldump, it handles binary data through escaping the
required characters. pg_dump is similar if memory serves me correctly.
Thanks Chris.
So dumping binary data / large objects using myslqdump is fine. I looked up
if this is ok with pg_dump as well and it is but
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a single-bit
field.
Regards,
Chris
Sure --
Matthew Stanfield wrote:
Usually, i'll use enum('0','1') in place of a boolean type.
Curtis
For JDBC stuff, I've found that if you really want to call this a
shortcoming, then that's about as far as you can take it
- the MySQL JDBC driver makes the BIT field act just like a
single-bit field.
mos wrote:
At 01:14 AM 12/16/2003, you wrote:
mos wrote:
At 04:22 AM 12/15/2003, you wrote:
To elaborate on Dr Frank's thing if you're interested, here's a
classic deadlock example:
1. Transaction A obtains an exclusive lock on a set of rows which
we will call R1.
2. Transaction B obtains
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote:
There are a few things that could be happening:
Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl
2. Which FS are you using? The native Solaris FS needs a bit of tuning
to get
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to resolve these
In the last episode (Dec 16), Markus Fischer said:
I'm investigating a performance problem with mysql server set up. The
server is running linux with 1GB ram. I'ld like to tune the
configuration of the server to use as much RAM as possible without
swapping to the disc because of the big slow
David Griffiths wrote:
To be honest, the vast majority of database installations experience
problems in performance caused by poor query and schema design,
bad application logic or grossly underspecified hardware. A change in
the number of files used to store the data is extremely unlikely
to
Chris Allen wrote:
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote:
There are a few things that could be happening:
Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl
Well, that's one option out of the way,,,
2. Which FS
I'm trying to change the size of an InnoDB table field from CHAR(20)
to CHAR(30) using MySQLCC, but i'm getting this error message
ERROR 1091: Can't DROP '0_87'. Check that column/key exists
This is the create query:
CREATE TABLE `presentacion` (
`cl_Presentacion` char(4) NOT NULL default
High-end database systems perfer more files, as they can be spread across
multiple (usually fast SCSI) disks. Most databases recommend logs be kept
on
seperate disks than database files.
Changes in the number of files can resolve problems if the problems are
the
result of low disk IO and
On Wed, Dec 17, 2003 at 03:53:04AM +1100, Chris Nolan wrote:
The DB is on a vanilla UFS partition. Do you have any references about
this? I couldn't find anything on the MySQL site...
There's nothing on the MySQL site but I do remember reading a comparison
between Solaris x86 and
Hi,
We have just installed MySQL 3.23.53 on Solaris 9. We were going through the
testing stages and it had produced an error.
Pasted below is the error that we received and also attached are the logs.
Installing Test Databases
Removing Stale Files
Installing Master Databases
Installing
Hi,
I'm facing a problem with the new 4.1 branch.
I've built MySQL from sources with default-language=hebrew and
extra-languages=utf.
I've also used default-collation=hebrew_general_ci.
After installing, this is what I get for few of the variables:
mysql show variables like '%char%';
I seem to have run into a problem with a host name that incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY foo;
ERROR 1064: You have an error in your SQL syntax near
'-dev.foo.com IDENTIFIED BY foo' at line 1
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED
I am trying to setup Jabberd2 as a test for our IT users and have run into a few
issues. Here is a link to the instructions I'm following:
http://www.jabberdoc.org/app_mysql.html
I know there are things missing because after I complete the make install in step
A.4.6, it goes right on to have
At 13:12 -0500 12/16/03, Ari Davidow wrote:
I seem to have run into a problem with a host name that incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY foo;
ERROR 1064: You have an error in your SQL syntax near '-dev.foo.com
IDENTIFIED BY foo' at line 1
mysql GRANT
From: Ari Davidow [mailto:[EMAIL PROTECTED]
I seem to have run into a problem with a host name that
incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY foo;
ERROR 1064: You have an error in your SQL syntax near
'-dev.foo.com IDENTIFIED BY foo' at line 1
For RedHat, just download the rpms and install it, it's far much simpler...
Nicolas
- Original Message -
From: Ryan Sinnwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 1:21 PM
Subject: Installation Question - RedHat 9.0
I am trying to setup Jabberd2 as a
At 13:29 -0500 12/16/03, Mike Johnson wrote:
From: Ari Davidow [mailto:[EMAIL PROTECTED]
I seem to have run into a problem with a host name that
incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY foo;
ERROR 1064: You have an error in your SQL syntax near
From: Paul DuBois [mailto:[EMAIL PROTECTED]
At 13:29 -0500 12/16/03, Mike Johnson wrote:
From: Ari Davidow [mailto:[EMAIL PROTECTED]
I seem to have run into a problem with a host name that
incorporates a hyphen:
mysql GRANT ALL ON *.* TO [EMAIL PROTECTED]
IDENTIFIED BY foo;
I can't find in MySQL 4.1.1 documentation anything about 'character_set_system'
variable.
It is setted up to 'utf8'. How can I change it to be able to use russian KOI8-R in
mysql client?
Linux Mandrake 9.2 MySQL 4.1.1 RPM
With best regards,
Igor Zinkovsky
Saint-Petersburg, Russia.
Hi,
I USE THIS FUNCTION TO INSERT VALUES TO DIFFERENT
VALUES OF MY DATABASE..
void InsertValues(const string tableName, const
string values)
{
char ValuesToStore[255];
long datasize;
char *EncodedData;
char *query;
strcpy(ValuesToStore, values.c_str());
EncodedData = new
On Tuesday, December 16, 2003 10:29 AM CET, Adam Hardy wrote:
On 12/16/2003 01:35 AMnbsp;Ligaya Turmelle wrote:
Can anyone tell me what the current support for the UTF8 character
set is? How strong is it? Do I have to do anything special to save
the characters? I will be getting the
Hello,
I recently ugraded to 4-14-Max from 4.13-Max to take advantage
of the optimizer fulltext bug fix. However a certain query using the
fulltext indexies is MUCH SLOWER then using no idex. Here is the query
select distinct p.USER_CREATED, p.ID, p.DATE_CREATED,
Hi!
On Dec 16, Igor Zinkovsky wrote:
I can't find in MySQL 4.1.1 documentation anything about
'character_set_system' variable. It is setted up to 'utf8'. How can I
change it to be able to use russian KOI8-R in mysql client?
You cannot change it.
But you don't need to either.
It is character
Hi
I am using LOAD DATA INFILE to populate a mysql
db. I prepare the file in Excell and save it as
csv format. Every works fine... except that the
file contains special characters with accent or
symbols. Is there a way to import such text
field directly or do I need to escape all these
Hello everybody !
Pierre DELGOVE from Rennes, FRANCE.
I am studying a model of database adapted to the management of a veterinary
clinic (in order to design perhaps a software that I could use on my own on a
GPL license).
I meet this practical problem : how could I get a reminder (i.e. after
Hallo,
is it possible to use as a default INNODB instead of ISAM in a mysql
server, so that every table, database (at least the complete server) is
based on a INNODB tablespace? Is this a practical and good way to use
mysql in that setup, if possible?
regards
Harald
--
MySQL General
Harald Falkenberg [EMAIL PROTECTED] wrote:
is it possible to use as a default INNODB instead of ISAM in a mysql
server, so that every table, database (at least the complete server) is
based on a INNODB tablespace? Is this a practical and good way to use
mysql in that setup, if possible?
Hi P Arunachalam ,
Add this to your program . Make sure header files exist ( its there anyway).
#ifdef WIN32
#include windows.h
#include winsock2.h
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#define VERSION 4.1
#endif
Enjoy...
P Arunachalam wrote:
Hi,
I have
At 22:06 +0100 12/16/03, Harald Falkenberg wrote:
Hallo,
is it possible to use as a default INNODB instead of ISAM in a mysql
server, so that every table, database (at least the complete server) is
based on a INNODB tablespace? Is this a practical and good way to use
mysql in that setup, if
At 01:59 PM 12/14/2003, you wrote:
Hello.
I have been tasked with evaluating open source databases for a large
upcoming project: e-commerce, B2B, high availability.
The O/S is most likely to be Linux, although FreeBSD could possibly be used
(lower probability).
So far, it seems that MySQL,
Hi,
Many Thanks.
Jerry Apfelbaum
Toronto
Jerry,
Interbase/Firebird looks good on paper. But there are a couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if it is
still an issue. I know from reading their newsgroups a few years
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
The manual, and my testing, shows that NULL = NULL evaluates to 1, so
my now-fevered mind sees no reason the two above statements are not
mysql CREATE TABLE foo (
- ID INT PRIMARY KEY,
- note VARCHAR(50),
- First_Name VARCHAR(50),
- Last_Name VARCHAR(50),
- FOO_ID INT,
- INDEX(FOO_ID),
- INDEX(First_Name, Last_Name),
-
On Tue, Dec 16, 2003 at 01:22:15PM +0100, Rodrigo Moya wrote:
I *thought* that MySQL AB was coming up with some sort of exception
for GPL'd free software but I don't remember if that got resolved.
oh, that's nice for them
I checked into it. They're still working on it. I guess the
Hi,
I am trying out the new GIS capabilities in MySQL 4.1.1-alpha (windows)
and I am trying to follow some of the examples from chapter 10 in the
manual.
Here is a snap shot of my run
mysql create table geom(g geometry);
Query
You did an insert this way:
mysql insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in set (0.00 sec)
The formatting of the POINT
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value = NULL
The manual, and my testing, shows that NULL = NULL evaluates to 1, so
Are you saying that this is
At 16:03 -0800 12/16/03, Steven Roussey wrote:
You did an insert this way:
mysql insert into geom values(GeomFromText('POINT(1,1)'));
and expected results this way:
mysql select AsText(g) from geom;
+---+
| AsText(g) |
+---+
| Point(1 1)|
+---+
1 row in
My mySQL server unexpectedly restarts itself from time to time. I am able to
verify this as the server uptime resets. I caught it 'in the act' today, but
can't tell what the problem is. Does anyone know what causes this behavior?
Thanks,
Joshua Thomas
Network Operations Engineer
PowerOne Media,
Hello all this is my first post to the mysql mailing list. I installed
mysql on rh9 as an rpm. I setup the root password using this mysql - u
password foo
When I check the status it says
[EMAIL PROTECTED]
How do I change that to [EMAIL PROTECTED]
The box I am using does have a host name.
32-bit filesystem limits?
Looking at any modern Linux FS, your file size limits are not hindered
by 32-bit anything or even
the FS itself. On kernel 2.4, internal kernel structures limit the
maximum size of block devices to around 1 TB.
As a result, you can only have files of about that size
Hi
I have three linked tables : store, catalogue, and sales
store : ID_store, store, date
catalogue : ID_product, product
sales : ID_sales, ID_store, ID_product, product, quantity
I would like a view giving me ALL the products in catalogue with the
quantity per store if the store has this
Egor Egorov wrote:
Sohail Hasan [EMAIL PROTECTED] wrote:
I have created a database and created a user with select rights to that
database, there is a table name xyz in that database that I don't want
that user to view, that's why i want to revoke that select rights from
only that table,
This isn't going to be a very good question because I don't really
understand what I'm being asked... I have an invoicing database with two
tables: An invoice header table; and a line items table. The line items
table includes a column for the foreign key to the invoice header, a
column for
At 04:07 PM 12/16/2003, you wrote:
Hi,
Many Thanks.
Jerry Apfelbaum
Toronto
Jerry,
Interbase/Firebird looks good on paper. But there are a couple of
things to watch out for.
1) Check the Borland Interbase newsgroups for corruption to see if it is
still an issue. I know from
1 - 100 of 102 matches
Mail list logo
