YL,
(2) the rows in the table are
mysql> select * from tt;
++--+-+
| id | name | options |
++--+-+
| 1 | abc | (1,2,3) |
| 2 | bbc | (2,3,7) |
| 3 | cbc | (3,1,7) |
++--+-+
>(4) My intention is a query like
>mysql> select id,name from tt wh
My 1st question, can be understood after 3 steps below:
(1) Suppose we have a table defined as:
mysql> desc tt;
+-+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+-+-+--+-+-+---+
| id | int(
> But what about INNODB? And are there
> table engine-independent implementation details which might cause
> performance problems for a database with many tables?
This thread got me wondering how many file-handles are open for INNODB tables
since it is only one large file on the file system. A q
Hi guys:
This is probably an off-topic, and more related to PHP, but it is related to
mysql as well
I need to execute two insert queries into a single statement from a PHP
application, but it keeps giving me an error.
I have found this page
(http://dev.mysql.com/doc/mysql/en/c-api-multiple-queri
inferno wrote:
> Hi,
>
> I have a problem: I need to make a select for data that was entered
> more than 24 hours ago, but in that 24 hours I have to count only Monday
> - Friday since that is the working program, and does not have the status
> = '2' ( Solved ) and the problem is that I sincerly
This message was undeliverable due to the following reason:
Your message was not delivered because the destination server was
not reachable within the allowed queue period. The amount of time
a message is queued before it is returned depends on local configura-
tion parameters.
Most likely there
on 9/2/05 4:10 PM, Michael Stassen at [EMAIL PROTECTED] wrote:
> So [EMAIL PROTECTED] is missing something (you can't GRANT a privilege you
> don't have). In that case, I think you need to do as Gleb suggested. Shut
> down mysqld, then start it with --skip-grant-tables and reissue
>
>GRANT
Scott Haneda wrote:
on 9/2/05 9:08 AM, Michael Stassen at [EMAIL PROTECTED] wrote:
Modify them how?
show grants for 'root'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, LOCK TABLES,
EXECUTE, RE
on 9/2/05 9:08 AM, Michael Stassen at [EMAIL PROTECTED] wrote:
>> Modify them how?
>> show grants for 'root'@'localhost';
>> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN,
>> PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, LOCK TABLES,
>> EXECUTE, REPLICATION
on 9/2/05 6:54 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote:
>
> I was confused by your "all I have is select privs." phrase in the
>
> previous post. Please, send the output of the 'status' command.
>
> What is in the 'Current user' field?
Sorry about the confusion:
mysql Ver 12.22 Distrib
I have 100K job posting records and 40K job title records. There is a M:M
relationship here. I expect these tables to grow rapidly.
What is the best way to design a junction or link table? Do I need to create
a primary key?
My thought was no primary key, just two indices on each foreign key (FK).
Hello
GP> Send to the list the output of 'SHOW VARIABLES' and 'SHOW STATUS'
GP> statements, amount of RAM, most problematic queries (use mysqldumpslow
GP> utility to find them) include tables' definitions (use SHOW CREATE
GP> TABLE).
SHOW VARIABLES;
back_log50
basedir /***
Thanks to all for your help. I solved my problem the
quick and dirty way. Here's what I did:
1. Created my Excel spreadsheet to look the way I
wanted it, saved it as an XML spreadsheet.
2. Used PHP to pull the desired data from the MySQL
server on our iSeries machine.
3. PHP writes the XML data
I am trying to connect to MySQL from within ColdFusion on a linux box.
ColdFusion (version 5) came with a Merant driver, but it is too old to
support transactions.
I've downloaded libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so
(MyODBC 3.5) and could not get either of these to work. But I'
Hi,
It is perfect, I was thinking of doing it in php but the solution that I've
had was no way optimal.
Thank you very much for the help.
Best regards and have a nice week-end,
Cristi Stoica
[EMAIL PROTECTED] wrote:
Hi Cristi,
Look at this :
mysql> select now();
+
>
> Hello.
>
>
> > is that when it gets probed, it COMPLETELY offlines (DOS) the server.
>
> One upon a time I solved such an issue with MySQL on FreeBSD by switching
> to the official binaries from:
> http://dev.mysql.com/downloads
>
> Still, the recommended way to run MySQL on FreeBSD is c
Hi Cristi,
Look at this :
mysql> select now();
+-+
| now() |
+-+
| 2005-09-02 23:15:21 |
+-+
1 row in set (0.00 sec)
mysql> select DATE_ADD(now(), INTERVAL -1 DAY);
+--+
| DATE_ADD(now(), INT
Hi,
I have a problem: I need to make a select for data that was entered
more than 24 hours ago, but in that 24 hours I have to count only Monday
- Friday since that is the working program, and does not have the status
= '2' ( Solved ) and the problem is that I sincerly do not know how.
An
Answers blended in
"YL" <[EMAIL PROTECTED]> wrote on 09/02/2005 04:18:27 PM:
> I've 2 basic questions. thanks for responses:
>
> (1) Suppose i have a table with a varchar colum named options which
stores
> option id's in the form
> "(id1, id2, , idk)", where id1,... are string repr
please write 2 emails for 2 unrelated questions, that said I will tackle
#2
you have all those line drawing chars since the field is very wide.
The MySQL client does not 'know' about new lines, it just prints them out,
so each one is counted as one char.
in your client you can ask for help,
I've 2 basic questions. thanks for responses:
(1) Suppose i have a table with a varchar colum named options which stores
option id's in the form
"(id1, id2, , idk)", where id1,... are string representations of
positive integers. Given an integer i,
I want to fetch all ID's for the re
Hello.
Have you run mysql_fix_privilege_tables script after the upgrade?
"T. Horsnell" <[EMAIL PROTECTED]> wrote:
> After replacing a 3.23.28 server with 4.1.14 server binaries on an Alpha
> running Tru64 5.1B, I get things like:
>
> ERROR 1045 (28000): Access denied for user 'tsh'@'10
Hello.
> GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
Are you sure that you are connected as [EMAIL PROTECTED] user? What
does 'status' command report (execute it in the mysql command line
client)? What version of MySQL do you use?
"Morten Kalles$e" <[EMAIL PROTECTED
Hello.
> This looks pretty much full access to me?
I was confused by your "all I have is select privs." phrase in the
previous post. Please, send the output of the 'status' command.
What is in the 'Current user' field?
Scott Haneda <[EMAIL PROTECTED]> wrote:
> on 9/2/05 1:27 AM, Gle
Klemens Ullmann <[EMAIL PROTECTED]> wrote on 09/02/2005 07:37:43 AM:
> hello!
>
> I've got two tables for an IT hardware inventory:
>
> ### table inventory:
> invid model
> ---
> 1001 HP Notebook// no attributes
> 1002 Dell Desktop // only one attribut 'pc-name'
> 1003
Klemens Ullmann wrote:
hello!
I've got two tables for an IT hardware inventory:
### table inventory:
invid model
---
1001 HP Notebook// no attributes
1002 Dell Desktop // only one attribut 'pc-name'
1003 Acer Laptop// attributes 'pc-name' & 'harddisk'
1004 App
Joe, you are not used to using a command line interface, are you
When you do a "START -> RUN -> cmd ", you are entering the world of
computing that exists outside of Windows (have you ever heard of DOS?).
What you are in is called a "shell" and on windows it's called the
"command shell" bec
Thanks for your reply.
I've done what you said. Unfortunately I get the message in the CMD
Window:
'MYSQLADMIN' is not a recognized as an internal or external command.
Can you tell me what this means? I did run the installer earlier. Thank
you.
Joe.
-Original Message-
From: Eric Mynes
Hi,
You can't delete selected rows from the same table in mysql.
Just create a temp table containing the select result. And delete from table A
where existe select ... from temp_table;
Mathias
-Original Message-
From: Jason Pyeron [mailto:[EMAIL PROTECTED]
Sent: vendredi 2 septembre 20
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 09/02/2005 01:07:00 PM:
> I apologize for not providing more information. I am currently
> using 4.1.8 client and server on windows xp.
>
>
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Friday, Sept
to quote the manual:
Currently, you cannot delete from a table and select from the same table
in a subquery.
mysql> select * from paths where id>=(select max(ppathref) from paths);
++-++--+
| id | typeref | name | ppathref |
++-+--
The way I could tell that mysl is running is to (assuming that you are
running windows):
Click Start
Click Run
Type CMD
Press Enter
Type MYSQLADMIN PING
Press Enter
if you get the message "mysqld is alive", then it is running
Thanks,
Eric
Network Administrator
West Virginia Federal Credit Union
I apologize for not providing more information. I am currently using 4.1.8
client and server on windows xp.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02, 2005 11:48 AM
To: Barbara Deaton
Cc: mysql@lists.mysql.com
Subject: Re: Whe
Hi,
MySQL 5.0.12-beta, a new version of the popular Open Source Database
Management System, has been released. The Community Edition is now
available in source and binary form for a number of platforms from our
download pages at http://dev.mysql.com/downloads/ and mirror sites.
Note that not all
Wiebe de Jong <[EMAIL PROTECTED]> wrote on 02/09/2005 17:32:07:
> I used mixed case in naming my schemas, tables and fields in Postgres
7.1.
> (i.e. onDemand.callDetailRecord) Now I have to move my app over to
MySQL.
>
>
>
> What are the best practices for naming in MySQL?
Definitely use low
I used mixed case in naming my schemas, tables and fields in Postgres 7.1.
(i.e. onDemand.callDetailRecord) Now I have to move my app over to MySQL.
What are the best practices for naming in MySQL?
Wiebe
Hello,
I am just getting started with MySql and PHP (previously was just
designing web pages). I am very new to database-based web development.
I installed IIS and PHP. I thought I installed MySQL as well but I can't
tell if it is working or not. I was told if I make a phpinfo.php file
and open i
Scott Haneda wrote:
on 9/2/05 1:27 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote:
Recreate grants for the 'root'@'localhost' user manually. For this
purpose restart server with --skip-grant-tables command line options
and modify the grant tables. See:
http://dev.mysql.com/doc/mysql/en/rese
>Hi,
>It is skip-name-resolve - I just wrote it by memory and was wrong. There is
>also a nice piece on "Access denied" errors at
>
>http://dev.mysql.com/doc/mysql/en/access-denied.html
Thanks - I'd already read that.
I've also discovered that its generating log entries (I've got a
3 Gbyte log fi
"Barbara Deaton" <[EMAIL PROTECTED]> wrote on 09/02/2005 11:33:19 AM:
> I need help re-writing a query.
>
> When accessing DB2 I can execute the below:
> delete from DM_KOHLS.clr_plan_price_change_metrics A
> where A.start_dt>= Date( '05/15/2005' ) and
> exists (
I need help re-writing a query.
When accessing DB2 I can execute the below:
delete from DM_KOHLS.clr_plan_price_change_metrics A
where A.start_dt>= Date( '05/15/2005' ) and
Morten Kallesøe wrote:
> Hi
>
> I have been trying to get my mysql server to do as i want, but its not
> quite playing along.
>
> I need to monitor the replication status from a remote server, first by
> hand, 2nd by a perl script.
>
> But i keep getting this darn message.
>
> mysql> show master s
Alan Williamson wrote:
I have made a user with the following command:
GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
Silly question Morten, and I am sure you have probably done it, but
you are definitely running:
% mysql> FLUSH PRIVILEGES;
You only need to FLUSH PRIVILEGES
Usually the performance hit is coming from the OS/file system.
Tracking 100,000 file handles along with all the other stuff the OS
is doing will slow any system down. If you have 1,000 tables, you may
want to rethink you data model. If you truly need that many tables,
you're better off spli
[EMAIL PROTECTED] wrote on 09/02/2005 08:46:59 AM:
> Hi,
>
> i have a file which i need to import in about 7 tables. For this reason
> i need toimport only parts of this file into each of the tables.
>
> Is there a way to do this with LOAD DATA INFILE or what would be the
> preferred way with ju
2005/9/1, Chris Cutler <[EMAIL PROTECTED]>:
> Hello,
>
> My apologies for repeating a question asked earlier[1] but the
> question and the answer were a little vague:
>
> Does the number of tables in a database affect MySQL's performance?
> Specifically, if I have a database with 1,000 tables in
Arno Coetzee <[EMAIL PROTECTED]> wrote on 09/02/2005 04:37:48 AM:
> shuming wang wrote:
>
> > Hi,
> > Could we do a database dump/backup in a query like below ?
> > mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1
> > -u root -p -C mydb>mydbfile
> > or restore a database in
Hello,
My apologies for repeating a question asked earlier[1] but the
question and the answer were a little vague:
Does the number of tables in a database affect MySQL's performance?
Specifically, if I have a database with 1,000 tables in it, will it
be slower than usual due to the number of t
Hello kind sirs,
I have a DL380 G4 box, Dual Xeon 3.0Ghz with 6GB of DDR2 Ram,
I'm Linux CentOS 4 with a 2.6.12.5 vanilla kernel, and a remote storage
which I access via iSCSI (linux-iscsi-4.0.2 complied as a module)
connected with two Gigabit interfaces. the 'balancing' between the two
links
Hello!
Bastian Balthazar Bux, Pooly, Shawn Green, Peter Brawley, I thank you all!
In fact, I don't understand why this command is not standardized (ANSI
SQL, etc.).
--
Удачи!
Владимир
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments
> I have made a user with the following command:
> GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r'
Silly question Morten, and I am sure you have probably done it, but
you are definitely running:
% mysql> FLUSH PRIVILEGES;
--
Alan Williamson, Technology Evangelist
SpikeSource
Hi
I have been trying to get my mysql server to do as i want, but its not quite
playing along.
I need to monitor the replication status from a remote server, first by hand,
2nd by a perl script.
But i keep getting this darn message.
mysql> show master status;
ERROR 1227: Access denied. You n
Hi,
i have a file which i need to import in about 7 tables. For this reason
i need toimport only parts of this file into each of the tables.
Is there a way to do this with LOAD DATA INFILE or what would be the
preferred way with just having mysql standard tool at hand??
Cheers
Thorsten
--
htt
Hello everyone!
I just wanted to give everyone an update. I'm still getting this error
when I try to back up this database table. I don't get it at the same
row each time - today was at row 1,618, yesterday it was at row 24,566.
Just a reminder of my symptoms:
1. mysqldump is the only thing rep
Hi,
I am having problems managing mysql users. I use Active directory/LDAP
for user management and the user names could be
[EMAIL PROTECTED] , [EMAIL PROTECTED] etc etc...
I want to use same users or atleast users with the same name to be able
to create Database.
The problem is that MySQL use
Hi,
Does the 10.4.0.101 reverse resolve to a specific hostname? If it does you are
probably running MySQL with the skip_hostname_resolve option and if it
doesn't there is no way the MySQL server could tell from which host the
request is comming.
My opinion is that it is always better to use the
Hi,
I would rather put the attributes.attribute='pcname' in the join clause
It should look something like this
SELECT inventory.invid,inventory.model,attributes.value as pcname
FROM inventory
LEFT JOIN attributes ON (inventory.invid=attributes.invid and
attributes.attribute='pcname' );
> Could we do a database dump/backup in a query like below ?
> mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u
> root -p -C mydb>mydbfile
> or restore a database in a query like below ?
> mysql.exe -h 192.168.0.1 -u root -p -C mydb
> Then we can do backup and restore in
hello!
I've got two tables for an IT hardware inventory:
### table inventory:
invid model
---
1001 HP Notebook// no attributes
1002 Dell Desktop // only one attribut 'pc-name'
1003 Acer Laptop// attributes 'pc-name' & 'harddisk'
1004 Apple iBook// only one
After replacing a 3.23.28 server with 4.1.14 server binaries on an Alpha
running Tru64 5.1B, I get things like:
ERROR 1045 (28000): Access denied for user 'tsh'@'10.4.0.101' (using password:
YES)
when trying to connect from a remote host.
The problem goes away if I replace hostnames by IP addre
Hi,
I had to do the same thing on a project and the problem was that if
you use CSV you will not be able to make a formated excel document.
I am using now *Spreadsheet_Excel_Writer
(
*http://pear.php.net/package/Spreadsheet_Excel_Writer ) and it does
everything I need, including format
on 9/2/05 1:27 AM, Gleb Paharenko at [EMAIL PROTECTED] wrote:
> Recreate grants for the 'root'@'localhost' user manually. For this
>
> purpose restart server with --skip-grant-tables command line options
>
> and modify the grant tables. See:
>
> http://dev.mysql.com/doc/mysql/en/resetting-per
Hello.
Yes, that link was for 4.1.x, but probably it means
that you should read all change-logs between
4.0.12 and 4.0.25, to be aware about possible
incompatibilities.
Osvaldo Sommer <[EMAIL PROTECTED]> wrote:
> Thanks, but that link is for 4.1.x and not for 4.0.x
>
> Osvaldo So
Hello.
Please, do not attache files to your messages. Lots of users
on the list don't read them.
> Release:mysql-3.23.38
Please, do not report bugs with such an old MySQL version. Check if
it still exists on the latest release. See:
http://dev.mysql.com/doc/mysql/en/bug-report
Hello.
> I am ssh'd int the box, so I am localhost, I am root, and it just does not
> want to let me remove access privs, in this case, all I have is select
Recreate grants for the 'root'@'localhost' user manually. For this
purpose restart server with --skip-grant-tables command line option
Privet!
Send to the list the output of 'SHOW VARIABLES' and 'SHOW STATUS'
statements, amount of RAM, most problematic queries (use mysqldumpslow
utility to find them) include tables' definitions (use SHOW CREATE
TABLE).
Michael Monashev <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I hav
Hello.
> is that when it gets probed, it COMPLETELY offlines (DOS) the server.
One upon a time I solved such an issue with MySQL on FreeBSD by switching
to the official binaries from:
http://dev.mysql.com/downloads
Still, the recommended way to run MySQL on FreeBSD is compiling it fr
Hello.
> Trying to upgrade MySQL from 3.23 to 4.0.16 on a new fedora core3
If you have a fresh installation, it is much better to use a latest
release (4.1.14 now).
> 050901 17:33:34 [ERROR] Can't create interrupt-thread (error 13, errno:
[EMAIL PROTECTED] gleb]$ perror 13
OS error c
Hello.
I'm not a Solaris expert but the general way for solving similar
problems is described at:
http://dev.mysql.com/doc/mysql/en/perl-support-problems.html
http://dev.mysql.com/doc/mysql/en/myodbc-unix-shared-libraries.html
Uthra Rao <[EMAIL PROTECTED]> wrote:
>We are running m
Hello.
I've wanted to say that you should check if, for example, the command
line options of mysqld program had been changed.
> I am sure that there is no change in the 'my.cnf'.
Check if it uses exactly this my.cnf, not another my.cnf which is
situated in a different place.
"Tedy
On Thursday 01 September 2005 22:14, [EMAIL PROTECTED] wrote:
> JM <[EMAIL PROTECTED]> wrote on 09/01/2005 06:01:57 AM:
> > Hi all,
> >
> >Ive read this link "http://dev.mysql.com/doc/mysql/en/gone-away.
> > html" hoping
> > this has something to do with the error...
> >
> >Ive already chec
On Thursday 01 September 2005 20:41, Pooly wrote:
> Hi,
>
> what is the error in your error log ?
im using MySQL-client-4.1.12-1 binary from mysql website
i got this..
050901 14:50:44 [Warning] Asked for 196608 thread stack, but got 126976
-- im trying to fix this by adding set-variable thread
shuming wang wrote:
Hi,
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1
-u root -p -C mydb>mydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbThen we can do backup a
Hi,
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1 -u
root -p -C mydb>mydbfile
or restore a database in a query like below ?
mysql.exe -h 192.168.0.1 -u root -p -C mydbThen we can do backup and restore in GUI mode
Hello Nick,
This you can do with the MySQL ODBC Driver installed
(http://dev.mysql.com/downloads/connector/odbc/3.51.html). Further more
you need to activate Microsoft ActiveX Data Objects in the references.
You can use the following code:
<--Begin Code-->
Dim cn As ADODB.Connection
Dim rs As ADO
75 matches
Mail list logo
