On Friday, January 21, 2011 09:23:47 am Jerry Schwartz wrote:
[JS] A UUID (what Microsoft calls a GUID) is based in part on the MAC
address of the generating device. Since MAC addresses are supposed to be
unique across the known universe, so should a UUID.
Not entirely true - and even
Received.
On Sunday, September 12, 2010 09:32:12 am monloi perez wrote:
Hi All,
Sorry if I posted on the wrong list.
I've had this issue with my previous server already, seems like
skip-locking configuration does not seem to work on myisam tables.
Also what is the difference between
On Wednesday, July 14, 2010 09:25:22 am Scott Mullen wrote:
I'm having trouble formulating a query to gather the following data. I can
do this via a script, but now it is more or less just bothering me if there
is an easy/efficient way to gather the following data from a single query.
On Tuesday, July 13, 2010 02:25:33 pm Prabhat Kumar wrote:
GRANT ALL PRIVILEGES ON **.** TO username@'tuna.iamghost.com' IDENTIFIED BY
PASSWORD 'password';
**.** ie for all databases , if want on particular DB
GRANT ALL PRIVILEGES ON *MyDATABASE.** TO username@'tuna.iamghost.com'
I believe you're describing a crosstab query. This should help you put it
together:
http://rpbouman.blogspot.com/2005/10/creating-crosstabs-in-mysql.html
---Michael
On Friday, July 09, 2010 07:37:41 pm Phillip Baker wrote:
Hello All,
For the life of me I cannot remember how to make a
of some use
mc
On 5 July 2010 03:35, Michael Satterwhite mich...@weblore.com wrote:
On Sunday, July 04, 2010 06:36:00 pm you wrote:
What user are you at the time you are running these tests. Would I be
correct in guessing 'root'?
The reason localhost works is because, in some
On Monday, July 05, 2010 10:46:48 am Bob Cole wrote:
The remote computer let me into mysql and I typed:
mysql use mysql
mysql select host, user, Password, Select_priv from user;
+--+--+---+
-+
| host
On Monday, July 05, 2010 01:17:57 pm burhan.kha...@gmail.com wrote:
Michael:
It could be that MySQL is only listening on localhost (127.0.0.1) and not
your net IP. Check your network settings in your server config.
Alternately, you can also do a
netstat -anp | grep mysql
As root and
I've recently reloaded my box (PCLinuxOS). The machine name on the network is
photon. I've set this in the hosts table, in hostname, and on the network. in
my.cnf I have the following 2 lines:
bind-address= photon
bind-address= localhost
The skip-networking directive
On Sunday, July 04, 2010 06:36:00 pm you wrote:
What user are you at the time you are running these tests. Would I be
correct in guessing 'root'?
The reason localhost works is because, in some distros, root is
enabled localhost with no password .. which is dangerous enough..
granting
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I don't really think this is the right place to ask this question, so
please forgive this post. I've tried asking the question over on the
OpenOffice list, but can't get an answer. I'll try to give all the
information to ease things. One of the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I use a local MySQL server (we're using 4.0) for development. It's been
running cleanly for months - and the configuration file has not changed.
This morning we had a major power problem causing the machine to come
down in an unorderly manner. I can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| That happens sometimes. Do a mysqladmin shutdown and then try to
restart it. It should start just fine.
|
I ran mysqladmin shutdown which reported that it couldn't connect to the
mysql server (not surprising - the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kishore Jalleda wrote:
We're at least thinking in the same terms.
| see if there is a /tmp/mysql.sock file,
Doesn't exist.
| is there a mysqld process running (#ps -ef),
This was the first thing I checked. No, no mysqld running
also you could
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kishore Jalleda wrote:
| do you have a bind-address = ip-addr option set in your my.cnf file,
You're a genius! Thanks much.
It was, indeed, a bind problem. I'm now back. You have no idea how much
I appreciate the help. Thanks again.
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
| MySql loses money from many vendors on this very point. Of which they do
| not budge.
|
| We have a Point of Sale software company who can distribute Oracle
cheaper.
| They only require a percentage of the final product
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I just found out that the hosting company we're using has disabled
INNODB support in their MySQL configuration. I'm a bit upset that they
don't document crippling the server anywhere, but that's neither here
nor there.
When I asked them about this, I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
J S wrote:
|
|
| J S wrote:
| | Hi,
| |
| | I need a bit of help with a mySQL query. I have a list of users in a
| | text file called 'users':
| |
| | u655354
| | u687994
| | u696974
| | u728141
| | ..
| | ..
| |
| | and I need to check the last date
mysqldump backs all of the tables up in alphabetic order, including the
table create statements. The problem is that if foreign keys exist on
the tables, the reload will not work unless the backup file is hand
edited to insure that tables depended upon are created first. Is there a
way around
On Saturday 13 November 2004 06:40 am, Jerry Swanson wrote:
This is my query
select id, status from sale where user_id = 1 GROUP BY id;
I need to know how many rows or how many entries this query returns. I
tried to use count and sum. But the result is wrong.
I want to be able to make
I'm running MySQL 4.0.21
In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I
issue a statement of the form
Alter Table TblName Type=INNODB;
This statement appears to execute correctly. I would expect this to affect the
Show Create Table output, but when I say
Show
On Saturday 30 October 2004 09:35 am, Martijn Tonies wrote:
Why not simply recreate it with the InnoDB table type?
If there's data in it, rename the old table, recreate the
table and pump the data.
All done!
Certainly that *COULD* be done, but it shouldn't be necessary (according to
the
On Saturday 30 October 2004 10:58 am, Paul DuBois wrote:
What output does the following statement produce?
SHOW VARIABLES LIKE 'have_innodb';
If YES, the ALTER TABLE statement should have worked.
If NO, your server doesn't have InnoDB support built in.
If DISABLED, your server supports
If I attempt to insert a record that has a duplicate key on a unique index, I
get an error message of the form:
ERROR 1062: Duplicate entry '1' for key 2
I'd like to get a little more information so as to provide the user with a
meaningful message. Specifically: what index is Key 2? Is there
On Thursday 28 October 2004 08:22 am, Rhino wrote:
- Original Message -
From: Barry Zimmerman [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, October 28, 2004 7:24 AM
Subject: Ho do I backup
Hi there,
I am a novice with mysql on the terminal side using shell.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 05 October 2004 15:18, Ed Lazor wrote:
Also, back to my original question, what are you seeing that denotes the
difference between whether I reply or create a new message when starting a
new topic? After all, I took care of changing
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 05 October 2004 14:23, David Brodbeck wrote:
Well, that's nice...
I just don't see what difference it makes. As far as I can see, the
outcome is identical either way...
If the recipients email program threads messages, it makes a big
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 05 October 2004 14:39, Scott Hamm wrote:
Jeff,
If you sort it by conversation topic, then it will seem to group by
threads.
I'm running Outlook 2000.
Not the same thing. Threading uses the In-reply-to header. Messages will
stay
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In order to make my field definitions more dynamic, I'd like to retrieve the
field length definition from the database. E.g. If a field is described as
varchar(5), I'd like to retrieve the 5 at runtime so as to limit the length
of data a user can
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 25 September 2004 14:31, Rhino wrote:
- Original Message -
From: Michael Satterwhite [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 25, 2004 12:29 PM
Subject: Retrieving field characteristics
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This one has to be easy, but it seems to be hidden in the documentation
(translation: I'm too dense to find it g).
When doing an insert, there is the feedback line 1 Row Inserted. When
reloading a database from a backup, this can drastically slow
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In mysql 4.0.18
I have a database with innodb tables and foreign keys. I need to drop /
recreate the database for testing purposes. When I enter the command
drop database xxx
I get an error message indicating a foreign key violation. As I
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 10 September 2004 18:00, Ren Fournier wrote:
I've got a SELECT statement that is returning the data I want, but not
in the right order (and I don't know why...). Let's say there are two
tables, People and History. Some records in People
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 15 February 2004 10:56, Mr. Justin G. Kozuch wrote:
Hi All,
I need with an SQL statement.
I have two tables in my database (mySQL): portfolio and categories.
In the portfolio table, I have a column called categories, and
there is a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 09 February 2004 08:44, Patricio Gigoux wrote:
Hi:
How Can I do for after a query I put at the its last record?
I'm not sure I followed the question, but I think you're asking how to look at
the last record in the set you just returned.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 09 February 2004 08:05, Carl Schéle, IT, Posten wrote:
I use php 4.1.1. mysql 3.23.49 and phpmyadmin 2.5.4
I have two tables
classes
- class_id (int)
- class_name (text)
HS
HD
DD
DS
MD
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I still have the problem with being unable to logon to a database with a
password. When the password is entered - either on the command line (-p???)
or on the following line (-p without a password), mysql returns a Bad
handshake error message.
I'm
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 06 February 2004 11:45, Harrison Fisk wrote:
The issue is that 4.1.0 used a different authentication handshake with a
different form of password encoding. Due to the fact that 4.1.0 was
alpha, it was decided not to support the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
OK, I've got my server running again on 4.1. I'm having a grant problem,
though (I have run the script to fix the privilege tables).
If I enable a user without a password, he can connect to the databases fine.
If I add a password to the user, he
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:14, [EMAIL PROTECTED] wrote:
Was the user created under MySQL 4.1 or a previous version? How are you
connecting? MySQL monitor, ODBC, JDBC, etc. ?
The user was created under 4.1.
The user is at the machine running
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote:
What about if the user enters
mysql -uusername -ppassword
MySQL fails to start with the error message Bad Handshake
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 05 February 2004 16:52, [EMAIL PROTECTED] wrote:
What version is the MySQL client? Is the user logging on remotely?
4.1.0-0 on the client.
The user is logging on on the machine running MySQL. I'll check out remote
login after I have it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've reinstalled MySQL 4.1. I'm trying to start the server (mysqld_safe), but
it fails to start. The log file shows the message:
/usr/sbin/mysqld-max: Fatal error: Can't find messagefile
'/share/mysql/english/errmsg.sys'
The files exists, but the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 04 February 2004 16:03, mos wrote:
At 09:35 AM 2/4/2004, John Croson wrote:
I have a simple query:
SELECT id,year,month,day,cat_id FROM events
LEFT JOIN calendar_cat ON
events.cat=calendar_cat.cat_id
WHERE year=YEAR(CURDATE())
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm running the SuSE 8.2 distro with MySQL 4.1.0-0 and python-mysql-0.9.1-430.
On Saturday, I had to do a reinstall of everything (long story). The software
listed above is the same as it was before the reinstall. The only difference
is that this
here.
On Monday 19 January 2004 07:25, Michael Satterwhite wrote:
I'm running the SuSE 8.2 distro with MySQL 4.1.0-0 and
python-mysql-0.9.1-430.
On Saturday, I had to do a reinstall of everything (long story). The
software listed above is the same as it was before the reinstall. The only
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 19 January 2004 08:56, you wrote:
The password column is 41 bytes in 4.1, except for 4.1.0 which uses 45
bytes. If I understand you, though, you reinstalled 4.1.0, so that
isn't the problem.
Perhaps you started mysqld with
On Monday 19 January 2004 13:17, sulewski wrote:
Okay, I think I'm missing something obvious. I have two tables
Table 1 Table 2
___ _
ID rdid vid
___
On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
So let's make it 2 fields:
SELECT
t1.*
FROM
table1 t1,
table2 t2 INNER JOIN table2 t3
ON (t2.rdid = t3.rdid AND t2.vid = 46 AND t3.vid = 554)
WHERE
t1.rdid = t2.rdid
Add GROUP BY/DISTINCT per your requirements.
On Monday 19 January 2004 16:30, Jochem van Dieten wrote:
Michael Satterwhite said:
On Monday 19 January 2004 15:38, Jochem van Dieten wrote:
So let's make it 2 fields:
SELECT
t1.*
FROM
table1 t1,
table2 t2 INNER JOIN table2 t3
ON (t2.rdid = t3.rdid AND t2.vid = 46
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
This has got to be a common question, but I'd really appreciate a little help.
I recently reinstalled my Linux (SuSE 8.2). I *KNOW* I don't have a cron run
that deletes this.
When I try to start mysql, I get the message
Can't connect to local
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 25 July 2003 17:38, Alec Smith wrote:
But what I really need is a result like
+--++
| name | domain |
+--++
| hostdom1 | abc123.com |
| hostdom2 | abc127.com |
| hostdom3 |
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 23 July 2003 03:59, W. Enserink wrote:
hi all,
i have this table filled with names.
Does anybody know how I can write a select statement which selects all
names starting with a certain letter in the alphabet or a strane sign like
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 22:28, [EMAIL PROTECTED] wrote:
Sorry I completely forget the query:
SELECT * FROM Kardex WHERE Fecha IN (SELECT maxfecha FROM fechas)
P.D. Im using 4.1 alpha version for win32
OK, something is still missing. I went to my
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 00:04, [EMAIL PROTECTED] wrote:
You are right above the max date query and I really appreciate your
help, but the subselect query its other question. I try the subselect
query with the 4.0.12-max win32 with the --new option
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 12:28, Ola Ogunneye wrote:
I am still getting my feet wet on mysql. I, however have seen the MYSQL
Refereence Manual at the mysql site while I have also seen Mysql
Cookbook referenced or mentioned in the list.
As a true
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 22 July 2003 21:56, Greg Macek wrote:
Hello,
I have a strange question. I'm in the design phase for a table and was
wondering if it's possible in MySQL to force a pair of fields in a
record to be unique within the table. I would like
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 22:59, Tanamon wrote:
++---+--+
| id | file_name | max(version) |
++---+--+
| 6 | ffour |2 |
| 1 | fone |3 |
| 5 | fthree|
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 04:14, Egor Egorov wrote:
Michael Satterwhite [EMAIL PROTECTED] wrote:
I'm trying to add a foreign key to a table. All tables are INNODB. Table
a has following partial Definition:
TableA
( Fld1 int Primary Key
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 18:48, [EMAIL PROTECTED] wrote:
Cod Product date
10Nissan Car 2003-06-20
20Guitar Yamaha 2003-07-01
10Nissan Car 2003-05-01
30Stereo Cables 2003-01-20
20Guitar
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 09:03, Andreas wrote:
Hi folks,
how would you design a 1:1 relation ?
I'd like to split an entities's attributes because they won't get
equally frequently requested. So I can save memory and disk access time.
The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote:
Hello,
I have to join two columns from different tables in a query. Assume that
I have two tables:
staff
idcompany_Id name
11FirstName
21
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm trying to add a foreign key to a table. All tables are INNODB. Table a has
following partial Definition:
TableA
( Fld1 int Primary Key,...
)
TableB
(Fld2 int Primary Key,
Fld1 int not null, ...
)
I use the following Statement:
Alter
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 17:17, Andrew Rothwell wrote:
So I can add the column, and I can set it to have an auto_increment, but
will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 18:17, Jim McAtee wrote:
Are you saying that it will propogate through the _existing_ rows, or only
on rows added later?
It will number all existing rows and continue with rows added later.
- ---Michael
-BEGIN PGP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 19:20, Jim McAtee wrote:
Interesting. In the case where you want to begin numbering existing rows
at 1,
is it necessary to set the autoincrement number to that of the next, i.e:
Alter Table X Auto_Increment = 201;
No.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 July 2003 21:28, [EMAIL PROTECTED] wrote:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
.
Any ideas? I need subselect working.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Is there a tool for displaying / printing the tables and table definitions for
a given database? I know about info / show, I'm looking for something that
can take a database name and produce the entire definition report.
-BEGIN PGP
68 matches
Mail list logo