You're missing the semi-colon after the ($query) on the previous line
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 10:26 AM
Cc: [EMAIL PROTECTED]
Subject: mysql_fetch_array
i'm checking a php that has the following thing
$result1=
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
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_inf
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 ans
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 a
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
server-id=1
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 succ
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 che
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
Ph
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:
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
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
--
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. január 22. 19:31
To: [EMAIL PROTECTED]
Subject: Problem with Grant command
Hello,
I have what I consider to be a very strange pro
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 passw
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:
http://www.mysql.co
Hi All,
I have an OpenBSD box running mysql-3.23.47, php4.1.1 & Apache 1.3.22.
I have been using php-nuke on it for some time now without incident
until today...
I have tried to create a new database in order to add another nuke based
site to this server and I can't seem to import the sql file.
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 |
> > |
>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. 'safe_m
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
-Wparenthe
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
---
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(s
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 o
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 t
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 2
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
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
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 19
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
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:
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 Alessandro,
Tuesday, January 22, 2002, 12:40:20 AM, you wrote:
AT> Hi,
AT> I am a newby on MySql and more less a week ago I tried to install it on my
AT> SuSE 7.1. I followed the instruction in the manual, but when I run the
AT> command 'safe_mysqld --user=mysql &' the daemon mysqld didn
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
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 newl
All,
Tuesday, January 22, 2002, 12:06:41 AM, you wrote:
KM>Yes, 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 datab
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 in
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 http://www.mysql.com/doc
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
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' GR
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 of
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, Januar
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.
Ther
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 fi
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 t
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 r
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 DELE
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
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>
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 14:18
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 Byel
You can put images in the DB, but the easiest way is to put the path to the
images in a text field, and rely on the disk to send the images.
hope that helps,
Brian
-Original Message-
From: Rochester, Dean [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 22, 2002 7:50 AM
To: MySQL (E-ma
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 beg
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:
http://www.m
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 : http://mysql.com/down
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 PROTEC
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
-
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 backgro
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
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,
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
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;
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 com
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 t
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
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 Al
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
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
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 dele
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 ano
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 :
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.
>
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 (th
Hi all!
I've got quite a strange problem. Got to work today, was about to
continue my work on a database, and tried to log in with user
"varlehti", which is a user that's got SELECT, INSERT, UPDATE,
and DELETE -privileges. I got an Access denied -error, and
I'm sure I typed the password righ
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 er
* 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.
http://www.mysql.com/doc/S/E/SELECT.html >
--
Roger
-
Be
> 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 w
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
* 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
> >
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']
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 ?
[s
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), the
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)
http:
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 winm
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
>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.
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 t
Title: ³×À̹ö ¸ÞÀÏ
¹ÚÂù¹Î (naracom2002) ´Ô²² º¸³»½Å ¸ÞÀÏ
ÀÌ ´ÙÀ½°ú °°Àº ÀÌÀ¯·Î Àü¼Û ½ÇÆÐÇß½À´Ï´Ù.
¼ö½ÅÀÚÀÇ ¸ÞÀÏ º¸°ü ¿ë·®ÀÌ °¡µæÂ÷ ÀÖ½À´Ï´Ù. ³ªÁß¿¡ ´Ù½Ã ½ÃµµÇϽʽÿÀ.
-
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)
88 matches
Mail list logo