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 b
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.
>
> E
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'
> ID
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
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 r
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
ms
64 bytes from photon (192.168.1.20): icmp_seq=2 ttl=64 time=0.045 ms
> ton listed in /etc/hosts ?
>
> Hope thats of some use
> mc
>
> On 5 July 2010 03:35, Michael Satterwhite wrote:
> > On Sunday, July 04, 2010 06:36:00 pm you wrote:
> > > What user are
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
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
-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 guru's
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kishore Jalleda wrote:
| do you have a bind-address = 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 PGP SIGN
-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 us
-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 problem
-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 n
-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 price
-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 go
-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 th
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 t
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
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 suppo
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
t
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 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
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
-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 wi
-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 b
-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 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
> Subj
-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 pre
-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 ).
When doing an insert, there is the feedback line "1 Row Inserted". When
reloading a database from a backup, this can drastically slow d
-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 Peopl
-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 a
-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
-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
>
-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 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 authenti
-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'
-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
On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote:
> What about if the user enters
> mysql -u -p
MySQL fails to start with the error message "Bad Handshake"
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux)
iD8DBQFAI
-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
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 re
-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(C
-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 p
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
> >>
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 requireme
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
> ___ _
-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 --old-pa
sn't apply 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
-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 t
-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 MySQ
-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 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
-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 li
-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 li
-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 tru
-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 optio
-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
> 20Gui
-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:
>
-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 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
> 2
-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 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
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;
-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 SI
-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
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 Ta
-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 SIGNATURE-
68 matches
Mail list logo