sir,
i am using
"mysql-5.0.2-alpha-win-noinstall".. for my academic
project purpose.
i am final year engg. student from India.
currently i am using "mysqld" server type.
the following query causes the mysqld server to close
***
1.describe syntax eg: DESC
Douglas,
- Original Message -
From: ""Douglas B. Jones"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, March 14, 2005 11:19 PM
Subject: compilation problems with 4.1.10a on Tru64 5.1
Here is the script to compile 4.1.10a, it worked compiled fine
with the directory
Hi, I have a problem with how Mysql sorts norwegian letters. I first
found (after a lot of digging) that adding default-character-set=danish
to my my.conf file will solve the problems I had with à being sorted
before à and Ã. Unfortunately that did not solve the issue with 'AA'
being placed togethe
on one level, the test database is there just have something to log into
after intall to prove it's working.. some init.d startup scripts (I'm
thinking RedHat here) try to log into the database as an authenticated
user after each start up and when doing a 'status' call just to make
sure it's ali
Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
>> $query = "SELECT v.vbusiness, v.vcategory, v.vurl, v.v
Nick Zukin wrote:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the vendors
and the products. There is nothing more than the vendor and product ids in
the
Okay, so MySQL is now installed and running. It looks like a database
named "test" was created with no tables. Is this just used for
installation purposes? Can it now be deleted or is there a reason to
keep it? Or does it have some magical purpose like the "mysql"
database?
Jeff
--
MySQL G
Also:
ALTER TABLE TableName MODIFY COLUMN ColumnNameToMove longtext BEFORE
ColumnNameToPutBefore
ALTER TABLE TableName MODIFY COLUMN ColumnNameToMove longtext FIRST
ALTER TABLE TableName MODIFY COLUMN ColumnNameToMove longtext LAST
will work, depending on what you're looking to do.
sk
--
MySQL
ALTER TABLE TableName MODIFY COLUMN ColumnNameToMove longtext AFTER
ColumnNameToPutAfter
Note that long text is required (put in the correct column type you
intend to move)
Alternate:
INSERT INTO new_table SELECT columns-in-new-order FROM old_table;
DROP table old_table;
ALTER TABLE new_table RE
Why don't you use Fulltext indexes, they are very fast and you use
several columns.
http://dev.mysql.com/doc/mysql/en/fulltext-search.html
Best regards
Alejandro
-Mensaje original-
De: nick [mailto:[EMAIL PROTECTED]
Enviado el: Lunes, 14 de Marzo de 2005 05:59 p.m.
Para: Mysql List
As
On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote
> Because, with the '%keyword%' operator, you're going to match any of
> those columns that contain the keyword inside of it. This can be a
> little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
> you might try 'keyword%'
Hi,
Is it possible to change the order of columns in a table after the table has
been created?
Thanks for your help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
El Lun 14 Mar 2005 14:59, Stephen Andert escribió:
> Hi there,
>
> I searched the archives, but didn't find anything helpful.
>
> I am trying to build a fairly simple application for contact
> management. I already have what I want built in MS Access, but I need
> this application to run on Linux.
Michael:
I solved it just before you sent this message, and it was #2!
Thanks just the same,
Michael S.
Michael Stassen <[EMAIL PROTECTED]> wrote:
You're getting "Permission denied" when mysql tries to create
/tmp/mysql.sock. Usually, this happens for one of two reasons:
1) mysqld is alrea
Because, with the '%keyword%' operator, you're going to match any of
those columns that contain the keyword inside of it. This can be a
little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
you might try 'keyword%' so that 'apple' returns true for 'apples',
'apple juice', 'apple ci
What are the results?
sk
On Mon, 14 Mar 2005 14:22:38 -0800, Nick Zukin <[EMAIL PROTECTED]> wrote:
> I'm trying to do a multitable query and am having problems.
>
> I have three tables: vendors, products, and vendorproducts. The
> vendorproducts table creates a many to many relationship between
Stephen Andert wrote:
Hi there,
I searched the archives, but didn't find anything helpful.
I am trying to build a fairly simple application for contact
management. I already have what I want built in MS Access, but I need
this application to run on Linux.
I did some searching and Rekall looked
Hi there,
I searched the archives, but didn't find anything helpful.
I am trying to build a fairly simple application for contact
management. I already have what I want built in MS Access, but I need
this application to run on Linux.
I did some searching and Rekall looked like a good tool. H
Hi,
I'm intending to upgrade from mysql 4.1.4 gamma with InnnoDB to
production release 4.1.10a with InnoDB on a suse Linux machine.
I've read the documentation inside the binary distribution and found the
steps to install this release from scratch.
my question is :
Is it recomendable to leave in
You're getting "Permission denied" when mysql tries to create
/tmp/mysql.sock. Usually, this happens for one of two reasons:
1) mysqld is already running, so there's already a socket.
2) mysql doesn't have permission to write to /tmp.
As you've eliminated #1, #2 is the likely problem. If so, yo
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the vendors
and the products. There is nothing more than the vendor and product ids in
the vendorproducts tab
I do not know what else to do at this point. I even messed with
permissions but I realized it is not the problem.
Jeff Steinkamp wrote:
Yes, and it look pretty much like yours. Form what I can tell, the
daemon is never started during the init cycle, or actually aborts for
some reason. Since m
Hi Bob,
Yes the ownership is correct. In fact I did a chmod -R mysql:mysql
/var/lib/mysql and I still have the same problem.
I wonder if it is because I am running a dual processor machine.
Robert A. Rawlinson wrote:
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysql
I am using MySQL 5.0.2 on a Redhat 9 box. I am having problems altering
some columns default value and having it show up in the 'show create
table x' and backup files. Here is my repeatable example:
I issue this create statement:
create table mytable (
a int not null,
b int not null,
c in
Here is the script to compile 4.1.10a, it worked compiled fine
with the directory changed on 4.0.23a and before:
#!/usr/bin/ksh
PATH=/usr/local/bin:"$PATH"
export PATH
echo $PATH
D=mysql-4.1.10a
CC="cc"
export CC
CXX="cxx -O"
export CXX
cd $D
./configure \
--prefix=/usr/local/mysql-test\
Your rudeness is not warranted in any manner. If the lists answer was to
Hire a consultant with every question what would be the point of peer to
peer help. The list gets busy and at times and I got excellent responses
from qualified and courteous people, from a simple bump after waiting a
respec
Hi and thanks for your reply.
I'm still trying to determine what caused the deadlock
and for that porpouse I'm examining the output of
InnoDB monitor and found this
LATEST DETECTED DEADLOCK
050311 15:43:08
*** (1) TRANSACTION:
TRANSACTION 0 735264031, ACTIVE 1 sec, proce
cabuov02:/tmp# ps -eaf | grep mysql
root 14530 13637 0 12:36:16 pts/tb0:00 grep mysql
cabuov02:/tmp# ll /tmp/mysql*
/tmp/mysql* not found
But there was a pid file:
/var/opt/mysql/hvu03931.pid
So, I renamed it, and tried starting mysqld again - it still fails.
Michael
[EMAIL PROTEC
Thanks that gives me options, yes table was already created what I wanted
was for the table itself to know that when MySql reloads to go an get all
from another table.
I was understanding this was just something I did when I created the table
the first time as a Character of the table to know on
Here is the contents of the err log:
050311 12:12:08 mysqld started
050311 12:12:08 [ERROR] Can't start server : Bind on unix socket: Permission
denied
050311 12:12:08 [ERROR] Do you already have another mysqld server running on
socket: /tmp/mysql.sock
?
050311 12:12:08 [ERROR] Aborting
05031
Here is the contents of the err log:
050311 12:12:08 mysqld started
050311 12:12:08 [ERROR] Can't start server : Bind on unix socket: Permission
denied
050311 12:12:08 [ERROR] Do you already have another mysqld server running on
socket: /tmp/mysql.sock
?
050311 12:12:08 [ERROR] Aborting
05031
Mark Sargent wrote:
Robert Restad wrote:
snip snip
Hope I've given enuff info this time. Cheers, again. (Oh, btw, I'm not a
php programmer etc, I'm just doing this so I can say to a future
employer, yes, I can install/setup/config php/mysql etc if you need it).
Mark Sargent.
Hi All,
ok, am I b
Stembridge, Michael wrote:
I noticed another listmember used COUNT(fieldname) instead of COUNT(*).
Is there a noticeable performance increase with COUNTing a column name
instead of all columns? (ie, like SELECTing specific columns instead of
using SELECT *)
If anything, I'd expect the reverse,
I've tried just about every syntax combination to try and add columns to a
table using Alter Table and I keep running into syntax errors.
Alter table MyTable add (newcol1 float after col3, newcol2 float after col3);
or
Alter table MyTable add (newcol1 float, newcol2 float) after col3;
Of course i
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
I noticed another listmember used COUNT(fieldname) instead of COUNT(*).
Is there a noticeable performance increase with COUNTing a column name
instead of all columns? (ie, like SELECTing specific columns instead of
using SELECT *)
Thanks!
--
MySQL General Mailing List
For list archives: htt
C.F. Scheidecker Antunes wrote:
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
Hello Mr Paharenko,
I have started it with mysqld_safe & and I also tried
/etc/rc.d/init.d/mysql start
Funny thing is that after install the the mysql and test databases are
empty so I've tried mysql_install_db which runs but the databases
remains empty as well.
It is weird. I've done so many
Hi,
I upgraded MySQL 4.0 to 4.1 and imported all data using phpmyadmin.
All accented letters (italian, french, spanish) have been replaced by asian
characters...
and now the default collation for tables and varchar fields is:
"latin1_swedish_ci"
I'm only using european languages in the DB, so w
[EMAIL PROTECTED] wrote:
> [Donny Lairson] Quick bump I never got an answer
>
> I have a table fsearch_temp I use it as a memory table to keep things
> light and fast but after a restart I want to repopulate some data
> automatically. So I thought I just said load from TEST2 which would by a
> m
This error message seems a bit different than others I have gotten. it is from
a ColdFusion server that uses an ODBC driver...
ODBC Error Code = S1000 (General error)
[MySQL][ODBC 3.51 Driver][mysqld-4.0.20-log]Lost connection to MySQL server
during query
that "during" part threw me, but it
Robert Restad wrote:
I dont remember exactly what you have to do,
But there is password incompability between versions of MySQL, latest
versions doesnt accept the old password type. (I copied some MySQL raw
datafiles from one computer to another, and I got the same problem as
you)
Research MySQL we
On Monday, March 14, 2005 03:27, [EMAIL PROTECTED] wrote:
> Hi,
> Thank you for your reply. I tried even with --tee option with
> mysql as follows
>
> Mysql -uroot db_name --tee = test < 'input_file' > 'output_file'
>
mysql -uroot db_name < input_file 1> output_file 2> err_file
> But in
Hi,
I can see how this would help with bandwidth (I don't have a bandwidth
problem as explained below) but how will this help with the latency I
have?
Cheers,
Andrew
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Fri 11 March 2005 14:51
To: mysql@lists.mysql.c
Hi,
Thank you for your reply. I tried even with --tee option with
mysql as follows
Mysql -uroot db_name --tee = test < 'input_file' > 'output_file'
But in the out put file I am getting as below
Logging to file 'test'
Actual error is not logging into the ouput file. I am able to see the
Hello.
Have you been at:
http://dev.mysql.com/doc/mysql/en/too-many-connections.html
[snip]
Hi,
I have a live site using mysql. It is heavily used with over thousand users per
minute,
with 3 select / update queries per user per minute accounting to over 3000
queries
per minute.
Hello.
>) ENGINE = MEMORY LOAD FROM TEST2 DEFAULT CHARSET = utf8 AUTO_INCREMENT =0
You should use select statement, not LOAD. For example:
CREATE TABLE . SELECT * FROM TEST2;
And table options like DEFAULT CHARSET you should put before select statement.
See:
http://dev.mysql.com/
Hello.
You set the character_set_xxx variables only for your session.
MySQL CC is not under development now, and I don't know what it reads
from MySQL configuration files. Usually putting the following string
in the [client] section of the configuration file affects the
clients to use specif
Hello.
You shouldn't start MySQL server with configure. Use mysqld_safe instead.
If mysqld stops look at the error file. See:
http://dev.mysql.com/doc/mysql/en/starting-server.html
http://dev.mysql.com/doc/mysql/en/error-log.html
OpenView Mike <[EMAIL PROTECTED]> wrote:
> [-- te
Hello.
> [EMAIL PROTECTED] scripts]# mysql_install_db --user=mysql
> -bash: mysql_install_db: command not found
> [EMAIL PROTECTED] scripts]# ./mysql_install_db --user=mysql
> ./mysql_install_db: line 86: my_print_defaults: command not found
> Could not find help file 'fill_help_tables.sql'
Hello.
> Is there any advantages to having one single ibdata file, or is it better to
> have several, and if so, how many?
As said at:
http://dev.mysql.com/doc/mysql/en/innodb-configuration.html
You may get some performance improving if you put the files on the different
disks. I thi
Hello.
> under /var/lib/mysql saying mysqld started and mysqld ended.
It is unusual behavior of MySQL to leave the error files without
clues. Please, send us the contents of this file.
> The tables are not created not even if I run mysql_install_db.
According to the manual they should
52 matches
Mail list logo
