Sohail Hasan wrote:
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
Randy,
>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
>c
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
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 the
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,
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 produc
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 (
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.
Thanks
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, I
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
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
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 coo
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
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
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),
->
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 n
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
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, MaxDB,
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 possib
Hi P Arunachalam ,
Add this to your program . Make sure header files exist ( its there anyway).
#ifdef WIN32
#include
#include
#pragma warning (disable: 4514 4786)
#pragma warning( push, 3 )
#define VERSION "4.1"
#endif
Enjoy...
P Arunachalam wrote:
Hi,
I have made all the changes
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
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 Mai
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
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
sp
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 charact
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, p.LA
On Tuesday, December 16, 2003 10:29 AM CET, Adam Hardy wrote:
> On 12/16/2003 01:35 AM 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 charact
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 char[strl
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.
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]
> IDENTI
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
'-dev
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
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 l
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> GR
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
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]" IDENT
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%';
+-
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 S
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 Solar
> >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 di
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 '',
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 are
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 reso
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 slo
> > 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
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
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 an
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 lo
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 ent
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
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 (
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 ne
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: [
> 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
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.
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 PROT
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 th
[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
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'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 ("til
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
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/mysq
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 -
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-
mysql
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"
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 yo
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 o
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'
c:\mysql\include\mysql_com.h(
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 Fisc
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
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 s
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]>
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
"libmysql.
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
"libmysql.
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 |
"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\sql>mysql -u root -e "create database t; show create
>> database t; drop database t"
>>
> +--+---
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 config
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 to
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 it
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 expla
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 reso
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 it
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 a
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
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 t
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 connectio
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]
On 12/16/2003 01:35 AM 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 depends
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
> v
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=INNOD
- 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
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
F
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> gra
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 PROTEC
> 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
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/?
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 mys
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]
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 in
1 - 100 of 102 matches
Mail list logo
