Dear all,
Is there any equivalents to ROLES in SQL-Server in MySQL.
regards,
Sreedhar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: regarding the MySQL's server Caching feature
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
I was try with explain or describe command. The result in column 'type'
show 'ALL' , column ' possible keys' show index name I was created. I
wonder that why did not use index it take a long time (look like computer
hang).
SF
At 14:23 22/1/2002 +0700, Kittiphum Worachat wrote:
Hi
Try to
Description:
When starting the mysql client, I could not input any Scandinavian
characters, like æøå. Even if these characters are inputable in the
bash shell. Readline in a bash shell first reads the /etc/inputrc and
then the ~/.inputrc. Thus, most configurations are placed in
/etc/inputrc.
Hi,
i installed mysql-3.23.47-win version on win2k, but i cant start MySql
service.
When i try to start mysql service, i get an error msg like this;
Can't start MySql service on Local Computer
Error 1067 : Unexpected process termination.
i installed mysql once again and started service with
OK, I know how to insert the data into a database, now
how can i retrieve it and display it in client's browser?
Thanks
ST Ooi
Malaysia
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Monday 21 January 2002 17:13, you wrote:
I have to agree with the below. Clearly they want to get you into mssql
and keep you there. There's really no point in switching databases, so
(I know, this is too neutral) if you like these guys for some reason
(good haircuts or whatnot), then
Hi!
On Mon, Jan 21, 2002 at 05:06:41PM -0500, Ken Menzel wrote:
Hi Heikki and All,
Yes, it seems to be a cache problem, it happens to both MyISAM
I can't reproduce this bug.
Can you create test-suit to reproduce this bug and download it to
ftp://support.mysql.com/pub/mysql/secret ?
Hi
If you use PHP it very simple to do by retrive data from BLOB field and then
echo or print such as
$sql=select fld_blob from tble_xxx;
$result=mysql_db_query($db,$sql);
$row=mysql_fetch_array($result);
//suppose your data is JPEG
Header(Content-type: Image/JPEG);
echo $row['fld_blob'];
* Jeremy Zawodny
On Mon, Jan 21, 2002 at 05:18:35PM +0100, Roger Baklund wrote:
Hi,
Also, I wonder what is the best order for my primary keys:
a intThis is the 'main' id, very many distinct values
b tinyintThis is a source code, possible values are 1 or 2
c smallint
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: Inserts during a long select?
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ Re: Release of 4.1
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
Hi,
Hi, thank you for your reply.
Since b can have only two values, making it the first column in the
index columns will not be efficient,
Why?
but since b is many distinct values
...I suppose you mean 'a'...
ordering on this key first makes sense. Also you are always
querying with a
* Investor
Do you only query Table C or do you structure the
query to get info from all three tables?
You structure the query to get info from all three tables.
URL: http://www.mysql.com/doc/S/E/SELECT.html
--
Roger
-
Hi
I am new in mysql. I 've compiled and installed mysql-3.23.47 from
the source on HPUX version 11.00 platform.
I have two questions.
first: Is it possible to start mysql from NFS tree
Two : when I run ./bin/safe_mysqld or ./bin/safe_mysqld --user=mysql as
root, I get the error
Hi All
I am new to Mysql / Linux and would like to import my access 2000 database
into a MYSQL database - is there an easy way to do this ??
Thanks
Gary
-
Before posting, please check:
http://www.mysql.com/manual.php
I think the best way is to export Access 2000 tables to tab
delimited text files and then use mysql LOAD DATA INFILE in mysql
to get data from text files into MySQL tables.
See manual for LOAD DATA INFILE syntax.
I'm not sure but maybe some utilities exist to convert Access to MySQL.
Peter.
Hello,
How can I delete from teble news all that are
existing in table news2
the following don't work
delete a.* from news where a in news2
Thanx
___
Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
Yahoo! Courrier :
Hi!
For some strange reason MySQL doesn't listen for incoming
connections on port 3306. I have four servers, two of which are
4.0.1 and two are 3.23.47. I can connect between three of them freely,
but one, shodan (yes. *g*) doesn't allow it. localhost logins are
apparently ok, but not from
Hi,
I think is better to make a join between the tables:
delete from news inner join news2
on news.* = news2.*
Hope it helps,
Caterina
-Original Message-
From: Sofiane Sakhri [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 1:00 PM
To: [EMAIL PROTECTED]
Subject: How can I
On Tuesday 22 January 2002 14:32, Markus Lervik wrote:
Hi!
For some strange reason MySQL doesn't listen for incoming
connections on port 3306. I have four servers, two of which are
4.0.1 and two are 3.23.47. I can connect between three of them freely,
but one, shodan (yes. *g*) doesn't
The tar from Solaris would not work! Try download and install gnu tar from
www.gnu.org and use gnu tar.
From: Chris Stefanick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: instillation problems
Date: Thu, 17 Jan 2002 11:43:33 -0500
I've been trying to install mysql-3.23.43 on a SunOS 5.7
To convert Access DB to MySQL check this URL
http://www.urbanresearch.com/software/utils/urbsql/
theOtherOne
- Original Message -
From: Gary Portellas [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, January 22, 2002 2:45 AM
Subject: Converting Access 2000 to Mysql
Hi All
I
Dudes Dudettes,
I got a SQL script with all the SQL to setup a database. But I can't seem to
access the script. I did this before so I know it can be done, but I've to
do it for a new project, and I can't remeber how.
So I've 2 questions :
- Does my script file need to be a .sql file or just a
Hi,
M. Lavasani wrote :
Hi
I am new in mysql. I 've compiled and installed mysql-3.23.47 from
the source on HPUX version 11.00 platform.
I have two questions.
first: Is it possible to start mysql from NFS tree
I have never done it myself but according to posts on this mailing
lawrence writes:
Support
I am new to mySQL and would like to use the MySQLGUI .
I can see the download page but are there any instructions for installing
and setting the GUI up under windows 2000
Many thanks
Lawrence Wharton
Hi!
Just follow instructions from the README that comes with
Emmanuel van der Meulen writes:
Hello Monty,
I downloaded and installed 4.0.1 for the SQL_CALC_FOUND_ROW option.
However, the query runs 600% longer, so the saving I get with FOUND_ROWS()
running in 0.0 secs does not serve me. Am I maybe doing something wrong?
Here is what I did;
I
Hi,
This should do the trick
mysql source /path/to/file.sql
or
shell mysql databasename /path/to/file.sql
And it doesn't matter about the file extension.
Kevin
- Original Message -
From: Jarlath . Hennelly [EMAIL PROTECTED]
To: MySQL (E-mail) [EMAIL PROTECTED]
Sent: Tuesday,
The file extension can be anything you like
the command is mysql file_name
-Original Message-
From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 1:19 PM
To: MySQL (E-mail)
Subject: Running SQL Scripts
Dudes Dudettes,
I got a SQL script with all the
Hi J,
I think you shoud type of command prompt:
mysql database file.sql
and this will create the database
Cheers,
Caterina
-Original Message-
From: Jarlath . Hennelly [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:19 PM
To: MySQL (E-mail)
Subject: Running SQL Scripts
Gary Penn writes:
I am having trouble with this error:
Found option without preceding group in config file: c:\WINNT\my.ini
line: 1 Program aborted
Before this I got the infamous 1067 error where the service would go to
start on Win2000 and then stop unexpectedly.
Some background that
Greeting all
Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql
database? I have done this with OLE objects using MS Access... can this be
done using the blob data type some how?
Thanks in advance
Dean-O
Excellente..I went with Kevin's solution for within the MySQL
shell. Thanks to everyone who gave a little time to reply.
cheers,
J.
-Original Message-
From: Kevin Smith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 2:29 PM
To: Jarlath . Hennelly
Cc: [EMAIL
Hello lawrence,
Monday, January 21, 2002, 11:15:34 PM, you wrote:
l Support
l I am new to mySQL and would like to use the MySQLGUI .
l I can see the download page but are there any instructions for installing
l and setting the GUI up under windows 2000
Take a look at :
Hello Rahadul,
Tuesday, January 22, 2002, 1:08:23 AM, you wrote:
RK Hi,
RK Do anyone know whether 4.0.1 is better than the 3.23.47, eventhough
RK 4.0.1 is not a stable version. Is 4.0.1 would do the same thing as the
RK 3.23.47?
You can read information about version 4.0.X at:
Hi Alexander,
I am not sure I can create a test-suite to reproduce this. The
problem seems to comes up over time on our in-house test server, where
we are testing 4.0.1. The application being tested is rather complex
and I am not sure what is causing the issue, so I would not know
where to
Sanja,
maybe adding some debug code to the client or the server would help? After
all, the symptom is easy to notice: the client claims the connection to the
server is broken. Why does it claim that?
Regards,
Heikki
-Original Message-
From: Ken Menzel [EMAIL PROTECTED]
To: Sanja
Hi,
I've just installed MySQL 3.23 binary on Solaris.
When I try:
bin/safe_mysqld
it crashes out like this:
bash-2.03# bin/safe_mysqld
[2] 9106
bash-2.03# Starting mysqld daemon with databases from
/export/mysql-3.23.39-pc-solaris2.8-i386/data
Segmentation Fault - core dumped
020122
Rahadul,
Tuesday, January 22, 2002, 1:04:27 AM, you wrote:
RK Thanks so much for your help. but it only worked for client and devel
RK package. When I tried to uninstall the MySql Server package i get an error
RK message as
RK [root java]# rpm -qa | grep -i mysql
RK MySQL-3.23.47-1
RK [root
Emmanuel,
Tuesday, January 22, 2002, 12:05:54 AM, you wrote:
EvdM However, please advise whether I can run 3.23 and 4.0.1 interchanging on
EvdM same data without putting the data at risk? BTW, I use InnoDb.
If you exchange data with mysqldump - I believe there will be no problem. But if you
Hello Markus,
Tuesday, January 22, 2002, 12:27:44 PM, you wrote:
ML Hi all!
ML I've got quite a strange problem. Got to work today, was about to
ML continue my work on a database, and tried to log in with user
ML varlehti, which is a user that's got SELECT, INSERT, UPDATE,
ML and DELETE
Tuesday, January 22, 2002, 8:43:55 AM, it is written:
I have a large amount of date that I need to select from in order to
generate reports (might take 20 minutes). I also have data
continuously being inserted.. I don't mind if the select results
doesn't contain the recently added rows (or
Sommai,
Tuesday, January 22, 2002, 7:17:36 AM, you wrote:
SF I have problem with these query:
SF select * from holder, management where holder.id=management.id or
SF (holder.name=management.name and holder.surname=management.surname) order
SF by holder.no
SF It take
As far as I can tell from the documentation, the --log option is
supposed to turn on logging to the general query file (section
4.9.2), which shows all connections and queries.
I've added that option to the [mysqld] section in my.cnf, and MySQL
is seeing the option, because it creates a log
Hi ALl,
I have a speed problem with MySQL.
I have a big table with over 2 million records in it. It has a non-unique
index on one of the fields called City_Code, which has a type char(3)
I need MySQL to quickly count the records with specific values and I found
out a strange behaviour.
If its a web based DB, then put the URL path in the text field of the
DB. Otherwise if you put the images into the database, the database
will become overwhelmed, plus a bunch of wasted disk space
-Original Message-
From: Brian P. Austin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
This is an OK solution for a small number of images. Most filesystems
(unix/linux et al included) have a severe time penalty in opening a known
file in a folder when the folder contains many files.
So while easier to hold a reference to a file (filename) it will become
slower when your number
Try '=' instead of 'LIKE'.
LIKE is used for wild card pattern matching, which you don't have here.
Johan Hallenberg - LUB NetLab wrote:
Hello,
I'm experience the same problem. I use a query like this:
SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND
month LIKE 'Oct' GROUP
You dif not join the tables ON anything, so you result set is every record
from table a matched with every record from table b.
It's going to be big.
[EMAIL PROTECTED] wrote:
Description:
I think I just found a bug in mysql 3.23.41 (as shipped with
RedHat Linux 7.2 x86). I have a
ST,
Tuesday, January 22, 2002, 8:14:36 AM, you wrote:
SO How can I insert a picture into blob field of a database?
You can, but use longblob (probably your picture will be bigger than a usual blob data
type) and don't forget to escape special chars in your query.
See
Trond,
Tuesday, January 22, 2002, 12:21:24 AM, you wrote:
NR By the way I run my application which should run on MySQL, I get the error
NR message which includes that libmysqlclient.so.6
NR could not find!!!
NR What I have down wrong?
How did you install MySQL? Have you installed the rpm
All,
Tuesday, January 22, 2002, 12:06:41 AM, you wrote:
KMYes, it seems to be a cache problem,
[]
KM Also it only seems to affect mysqldump!
BTW, once it helped me to solve such a very-very similar problem
by only adding -q to the mysqldump commandline. God knows why was all the
Jarlath,
Tuesday, January 22, 2002, 3:18:33 PM, you wrote:
Script means a file with SQL statements in it I suppose.
JH - Does my script file need to be a .sql file or just a plain .txt file???
The suffix doesn't matter. But inside it there should be a plain text file in UNIX
format of
Chetan,
Tuesday, January 22, 2002, 9:00:56 AM, you wrote:
CL I am using (open source) MySQL-3.23.47, I wanted to know, is the feature
CL of caching of the data in RAM is available in this version ?If yes ,
CL then what is the limit of that in terms of size. What I have Understood
CL is that
Rochester,
Tuesday, January 22, 2002, 3:49:40 PM, you wrote:
Reoen Is there a way to put images like jpgs, tifs, gifs, bmp files into a mysql
Reoen database? I have done this with OLE objects using MS Access... can this be
Reoen done using the blob data type some how?
Yes, but don't forget
Hello everyone,
I have some problems loading files into blobs when the file resides on a network
filesystem e.g. SAMBA. I use mysqld 3.23.43-nt.
e.g.
UPDATE Reading SET Data=LOAD_FILE(//linbox/log/travel/001.jpg) WHERE id=1;
Query OK, 0 rows affected (0.05 sec)
Rows matched: 1 Changed: 0
Hi,
I wonder if its possbile to make a toplist from the folowing table:
+--+--+
| name | status |
+--+--+
| Bob | working |
| Jane | sleeping |
| Joe | sleeping |
| Bob | sleeping |
| Bob | working |
| Bob | sleeping |
| Bob
Thansk for the suggestion, however two things come to mind, I
used --opt, which includs --quick (-q)
--opt Same as --add-drop-table --add-locks --all
--extended-insert --quick --lock-tables
and I attempted to dump only the table in question which had
I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
RAM).
The problem is that the main query (listed below) takes approximately 3
hours to run.
my.cnf looks like:
[mysqld]
port= 3306
socket = /tmp/mysql.sock
skip-locking
set-variable= key_buffer=128M
You can do with both of perl and php
but, you should not to do that, you'll get slow data retrieval
and you database's size will extremely large!
Save pathname should be enough.
From: ST Ooi [EMAIL PROTECTED]
Reply-To: ST Ooi [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How to read blob
i'm checking a php that has the following thing
$result1= mysql_query($query)
$line = mysql_fetch_array($result1);
and it give me the following error
Warning: Supplied argument is not a valid MySQL result resource in
/apache/htdocs/html/intranet.domus.cl/mail.php on line 242
where the line
I have a smaller database but am still unable to fulltext index one of
the tables that is only about 600mb and has rougly 3.5 million rows.
I tried both 3.23.47 and 4.0.1 and in both cases it was about the same.
I watched the temporary table that it was building and in both cases
it got up
At 16:31 +0800 1/22/02, ST Ooi wrote:
OK, I know how to insert the data into a database, now
how can i retrieve it and display it in client's browser?
If you're using Perl, you can get some sample code at
http://www.kitebird.com/mysql-perl. This page also
contains links to the online version of
In the last episode (Jan 21), Jeremy Zawodny said:
On Tue, Jan 22, 2002 at 12:57:12PM +0530, Chetan Lavti wrote:
Is there any other way (except query cache) using which the database
can be made memory resident. Actually I want a database which is to
be used by a lookup server(something
I am running MySQL and using phpmyadmin 2.2 as the GUI.
I noticed that if there is a lot of db activity - the overhead increases
on various tables.
What causes overhead ? I have looked into the MySQL docs and haven't
really found much of an answer.
Any help is appreciated.
Mark
When using the BUILD/compile-pentium and BUILD/compile-pentium-pgcc I get
the following errors..
/bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -Wimplicit
-Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W
-Wchar-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int
Description:
We are running about 100 MySQL-database servers on a single
Machine.
The databases are usually accessed via a web-interface. For some
batch processing
we tried to do basically 'SELECT *' on some tables. This caused
the mysqld-Processed
to fail.
At 22:35 -0800 01/21/2002, I whispered:
On Mon, Jan 21, 2002 at 11:02:47PM -0500, James Riordon wrote:
I have our new client up and running and have come upon another
question. When I get extended-status I get the following:
| Bytes_received | 53553199 |
| Bytes_sent
On Tue, 2002-01-22 at 00:08, Rahadul Kabir wrote:
Hi,
Do anyone know whether 4.0.1 is better than the 3.23.47, eventhough
4.0.1 is not a stable version. Is 4.0.1 would do the same thing as the
3.23.47?
AFAIK it's not the same, you can se the changes since 2.23.47 here:
Hello,
I have what I consider to be a very strange problem, I log in into mysql
on my localhost I can select from and manually modify tables using
insert select and delete, but I cannot do Grant. I typed the following
command:
GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'my
It's correct, just insert at the end of line:
WITH GRANT OPTION;
rtfm
Vaso
-Original Message-
From: Andrew Dumaresq [mailto:[EMAIL PROTECTED]]
Sent: 2002. janur 22. 19:31
To: [EMAIL PROTECTED]
Subject: Problem with Grant command
Hello,
I have what I consider to be a very strange
In a query like:
SELECT * from log_data where log_data.id = other_table.id;
Will the database lock both the log_data and assets tables, or just the
log_data table? More generally, are locks applied to any table related
to the query, or just data being selected?
Thanks,
Eric Mayers
hi!
jon-david == jon-david schlough [EMAIL PROTECTED] writes:
jon-david Christopher Thompson wrote:
jon-david Have you installed perl? You need it (and the Perl MySQL drivers)
jon-david installed before you can benchmark.
yep. perl is all good - got activestate perl fer windoze and the
In the last episode (Jan 22), James Riordon said:
At 22:35 -0800 01/21/2002, I whispered:
On Mon, Jan 21, 2002 at 11:02:47PM -0500, James Riordon wrote:
I have our new client up and running and have come upon another
question. When I get extended-status I get the following:
|
I don't understand what you mean by this. Where do I add that command?
Also I am logged into database as root (ie I used mysql mysql -u root -p
to connect).
Btw I did rtfm :)
Thanks
Andrew
Andrew Dumaresq
Technician / Administrator
Mathematics Computing Science
Saint Mary's University
while ($line = mysql_fetch_array($result1)
{
execute your code
}
Curtis
Original Message
From: [EMAIL PROTECTED]
Date: Tue 1/22/02 11:40
To: Undisclosed Recipients
Cc: [EMAIL PROTECTED]
Subject:mysql_fetch_array
i'm
It looks like you may need to run the mysql_install_db if you haven't done
so.
-Original Message-
From: Shinta H Leagazpi [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 7:03 AM
To: [EMAIL PROTECTED]
Subject: help in running mysql on slak8...
Goodday, I have been able to
You might have just hit the nail on the head.. Server1 is replicating
everything to server2 but it is only saving changes to one particular
database. Those changes are being manually gathered via mysqlbinlog and sent
to server3. Here are the relative entries in my.cnf
Server1:
log-bin
How about with Java and straight sql call to put the blob in a datastream or
what object type?
-Original Message-
From: Kittiphum Worachat [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 1:08 AM
To: ST Ooi; [EMAIL PROTECTED]
Subject: Re: How to read blob field data as picture
thanks christopher and monty ! got perl into my path and it's working...
another ? tho: i also want to benchmark postgreSQL living on another 2K
machine, does the mysql benchmark have to run locally or can i specify an ip
with a username and password in the batch file?
i'm searching for some
On Tuesday 22 January 2002 10:21 am, Bernhard Schmalhofer wrote:
x807b75f handle_segfault__Fi + 383
? ? ? ? ?0x812bcaa pthread_sighandler + 154
? ? ? ? ?0x8150974 chunk_realloc + 56
? ? ? ? ?0x8150907 realloc + 787
? ? ? ? ?0x811594e my_realloc + 46
? ? ? ? ?0x80fae62 _mi_read_pack_info +
I have a database with a first and last name fields that I would like to
combine for a search. Basically on my web page interface I would like the
end user to fill out one field instead of individual first and last fields.
I tried writing a query like so;
SELECT id, CONCAT(first, ,last) AS name
82 matches
Mail list logo
