Hi all--
I googled around a bunch but couldn't find a good answer to this question.
How do I open the ERD diagram I made in MySQL WorkBench 5.2CE, which is a
.mwb file-- on another computer that does not have MySQL on it? I want to
be able to print out the file and so I need to be able to open
to solve the problem.
On Sun, Aug 5, 2012 at 9:53 AM, Hassan Schroeder hassan.schroe...@gmail.com
wrote:
On Sat, Aug 4, 2012 at 8:14 PM, Fred G bayespoker...@gmail.com wrote:
But I'm sure that I must be missing something here. Is there a way to
use a
DECIMAL-like operator that treats blanks
to import to
as varchar, convert the column, the just select from temp table into prod
table.
-Original Message-
From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
Sent: Monday, August 06, 2012 2:05 PM
To: 'Fred G'
Cc: mysql@lists.mysql.com
Subject: RE: DECIMAL
What are the best ways to conduct financial data mining in MySQL? From
browsing the World Wide Web, it looks like using R to access MySQL and
using some pre-built R financial data analysis packages is the way to go.
Is there anything built-in to MySQL 5.2 Workbench, or, any other
possibilities
Hi--
I'm using MySQL 5.2 Workbench, and when I import a csv into MySQL, blank
values become 0 when I define the datatype to be a DECIMAL (in our case
(DECIMAL(12,2)). Since there is the potential for values to be 0, this
poses a problem for us. I initially wanted to make all the DECIMAL values
, Jul 31, 2012 at 5:36 AM, Michael Widenius mo...@askmonty.orgwrote:
Hi!
Fred == Fred G Fred writes:
Fred Thanks Dhaval. Putting the join condition before INTO outfile
doesn't seem
Fred to work, either.
Fred When I try to use the same outfile name 'test123.csv' I get Error
Code:
Fred
on?
On Wed, Jul 25, 2012 at 9:22 PM, Dhaval Jaiswal dhaval.jais...@via.comwrote:
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
ENCLOSED BY '' LINES TERMINATED BY '\n'
as above give your join condition before INTO OUTFILE.
On Thu, Jul 26, 2012 at 1:32 AM, Fred G
Thanks!
On Thu, Jul 26, 2012 at 12:05 AM, h...@tbbs.net wrote:
2012/07/26 06:52 +0530, Dhaval Jaiswal
SELECT * FROM test INTO OUTFILE '/home/test.csv' FIELDS TERMINATED BY ','
ENCLOSED BY '' LINES TERMINATED BY '\n'
as above give your join condition before INTO OUTFILE.
Right: MySQL
Hi--
I'm trying to do the following:
SELECT db.emp.emp_fname, db.emp.emp_fname, db.sale.sale_date,
db.sale.sale_no, db.sale.sale_total_amt
into outfile 'test123.csv'
FIELDS terminated by ','
FROM db.emp
LEFT OUTER JOIN db.sale
ON db.sale.emp_id = db.emp.emp_id;
The query without exporting the
Hi guys--
I am having some trouble importing a csv file correctly as a table in my
new database. In particular, there are 4 NA's in a column with 10,000+
other rows that have decimal values for that column.
How can I get MySQL to read in these NA's as some sort of null that is
accepted by the
Everything seems to go fine for me if I change the two 2007-3-23
to 2007-03-23.
Fred
-Original Message-
From: Rob Desbois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 29, 2007 5:02 AM
To: mysql@lists.mysql.com
Subject: datetime type conversion problem
I am having issues with type
the whole point of databases is to
avoid redundant data -- redundant schema-related
information. If they are not in sync the mapping between the .frm and ibdata1
information will probably thoroughly mess up your
access to the underlying stored database data.
Fred
-Original Message
I had the same problem. Disabling it isn't enough. I had
to use the sc command from the Windows command prompt to
delete the service. Just enter sc on the command line and
a description of the command will be displayed.
Fred
-Original Message-
From: Scott Hamm [mailto:[EMAIL
:
mysqld : ALL : ALLOW
mysqld-max : ALL : ALLOW
I did not change the default port of 3306. I assume mysqld automatically
opens up the port and begins listening for connections right?
Thanks for any help!!
Fred Aswad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
will
love you for this :)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General
you know that the database is in a good
state, even if the filesystem itself is consistent? I don't think MyISAM
gives you any guarantees in that regard. The secondary would need to run
myisamcheck on the tables before taking over.
Regards,
Fred.
--
Fred van Engen XB
.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General Mailing List
even more ;)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General Mailing List
m combinations, with n and m the number of records in table1 and
table2. You really want to do this for small tables only.
Consider an additional table to hold each of your 1, 3, 4, 6, ...
values together with the unique id of a record in table1.
Regards,
Fred.
--
Fred van Engen
`
A bit before that.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL
.
Your records don't have a fixed size because of a text column. I believe
this triggers MySQL to use a variable size for each column, converting
char to varchar. Functionally, it shouldn't make a difference I guess?
Regards,
Fred.
--
Fred van Engen XB Networks B.V
selects on the slave when an update is waiting for
the long query to end.
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
,
Fred.
Hi Fred,
InnoDB does not support AUTO_INCREMENT on secondary columns of a
multi-column index.
`id_registro` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id_formula`,`id_registro`)
There: id_registro is the second column of the index.
Matt
Hi Matt. Thanks a lot again !
It worked pretty good.
There is no problem about the app, because
the use of the indexes is in charge of the DBMS (MySQL). The
app doesn't know about the tables and indexes details.
Best Regards,
Fred.
Hi Fred,
Also, you may be able to swap the order
Can you send me the configure file + makefile configured for cygwin ? Version 3.23.58
please thanks alot!
#mysql_real_escape_string
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General Mailing List
));
}
Well, whatever the reason, I guess this is what API guys are expected to
use. I'll try that and see how it goes.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
, but there is a single line-break in
the example, just after abc.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
their account different GRANTs on the master than on the slave(s)
and make sure that GRANTs (the `mysql` database) are not replicated from
the master to the slaves.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
want to be
different between slaves and master.
Is there another way?
Not that I know of. I just looked at the startup options but couldn't
find anything for this purpose.
Regards,
Fred.
- Original Message -
From: Fred van Engen [EMAIL PROTECTED]
To: Eduardo D Piovesam [EMAIL
is
updated automatically.
Use DATETIME instead of TIMESTAMP if you don't want this to happen.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31
backticks around it:
alter table tbl_name change `IN` NEW mediumtext;
Pl. suggest how to rename particular field name for all the tables in
a database
Repeat the alter table for each table. :/
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL
On Wed, Oct 08, 2003 at 11:16:03AM +0200, Bob Brands wrote:
What is the correct syntax for using a Exponentiation operator in MySQL?
It's not an operator but a function. Look at EXP and POW in the docs:
http://www.mysql.com/doc/en/Mathematical_functions.html
Regards,
Fred.
--
Fred van
) column
has the data: `qwer'y\19o` then it knows that it
should read and return 10 chars/bytes.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax
an easier way, but this is (from memory) what I've used
before with 3.23.xx.
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
for user: [EMAIL PROTECTED]' (using password:yes).
This suggest you tried to log on with a username 'user%' instead of
'user'.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
ints.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General Mailing List
connection to MySQL for the outer query to
prevent the inner query from messing up the outer query's result set.
See the PHP manual for obtaining the connection id's from mysql_connect
and using them with other mysql functions.
Regards,
Fred.
--
Fred van Engen XB
Antony,
On Thu, Aug 28, 2003 at 06:29:54PM +0400, Antony Dovgal wrote:
On Thu, 28 Aug 2003 16:23:35 +0200
Fred van Engen [EMAIL PROTECTED] wrote:
You need to make a separate connection to MySQL for the outer query to
prevent the inner query from messing up the outer query's result set
Antony,
On Thu, Aug 28, 2003 at 06:45:27PM +0400, Antony Dovgal wrote:
On Thu, 28 Aug 2003 16:37:41 +0200
Fred van Engen [EMAIL PROTECTED] wrote:
Please elaborate.
I've already answered:
On the list I just saw your 'bad advice' message without explanation.
On Thu, 28 Aug 2003 17:07
;
Not in 3.23.xx.
You would need to do this from a programming language or possibly by
creative use of temporary tables (SELECT INTO temp ...; REPLACE INTO
`Table 2`(...) SELECT * FROM temp; with appropriate locking).
Regards,
Fred.
--
Fred van Engen XB Networks
? By domain
name? By ip? Nothing seems to work.
The server should be the same as the one running your website. You are
probably being blocked by their firewall as a security measure.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED
exactly
what went wrong for each field. It also prevents garbage or badly
formatted data from entering your database.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322
/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication_Features
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31
On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
Fred van Engen wrote:
On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote:
that comes with neither warnings nor errors reported ...
Error reports would have been nice, but why does your application
supply
On Sat, Aug 23, 2003 at 02:07:36PM +0200, Hans van Harten wrote:
Fred van Engen wrote:
On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
My checks might not match those of (the next version of) MySQL and
at that time the difference in thoughts will pass unnoticed !
I agree
and) installing _from_ /usr/local/mysql
and also _to_ /usr/local/mysql. You should compile and install from any
directory you choose, but it shouldn't be the same as the directory you
specify as destination with configure --prefix.
Regards,
Fred.
--
Fred van Engen XB
the ' in the first case because it is a string terminator.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
containing a calculated value will
allow you to create a good index (at the cost of making sure that the
added field will remain consistent). There are lots of possibilities.
Hope this helps.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL
[TO] new_tbl_name
| ORDER BY col
| table_options
So what it clearly tells you, is to use this (note the 'ADD'):
mysql ALTER TABLE EMPLOYEE
- ADD FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(SSN)
- ON DELETE SET NULL
- ON UPDATE CASCADE;
Regards,
Fred.
--
Fred van Engen
name as argument.
Connection id: 171359 (Can be used with mysqladmin kill)
mysql
So it looks like you could try the 'source' command. Copying the query
through your clipboard is another option.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL
MySQL 4.x. It won't work in
3.23.x or before. Look in the manual for details.
any suggestion? I read about using JOIN but I have no idea how to\
make it work for my need.
Joins are used for combining records from multiple tables, which is not
what you seem to want to do.
Regards,
Fred
to guard the integrity of your data.
TYPE = InnoDB only works if MySQL is compiled with InnoDB support,
which is the default in binaries from MySQL. If you compile it yourself
you need to configure --with-innodb .
Regards,
Fred.
--
Fred van Engen XB Networks B.V
listed in section 2 at
http://www.innodb.com/ibman.html
/opt/mysql-3.23.56/libexec/mysqld: ready for connections
So, look for something similar in your log. If it is there, then make
sure that you have innodb configured in my.cnf.
Regards,
Fred.
--
Fred van Engen XB
(.) is doing here.
Check for error messages in the webserver logs.
}
if (mysql_num_rows($result) ==0){
echo Sorry, no matching results.;
}
?
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED
to use an index, you add ORDER BY ... DESC
combined with a LIMIT to go to the last page of your form. You won't
know the actual count to display then.
Regards,
Fred.
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Mojtaba Faridzad [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
Hi,
On Tue, Jul 22, 2003 at 11:30:47AM -0400, Mojtaba Faridzad wrote:
thanks Fred! that's better. actully I took a field with one character but
it's better to run SELECT '1' FROM
as I know, if there is not ORDER BY in the query, mySQL doesn't need to
check all records and retreives
sample data (SELECT uid, level, name FROM members) and the
results you get for the query that doesn't work.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC
it, but just to make sure you're aware of this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
until disk space becomes available again. You wouldn't see much
disk activity while it is waiting.
Keep in mind that MySQL makes a copy of your table while it is adding
the index. You'll need twice the space of your initial table, plus
space for the additional index.
Regards,
Fred.
--
Fred
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote:
On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
create indexs for it, I couldn't finish after 4 hours.
You mean it was still running
was the first alpha release in august 1999 (few people would
use that)
I see no dates for 3.21.x, but it should have been the production
release in the beginning of 1999 and was probably supported for a while
after 3.22.x was the production release in march.
--
Fred van Engen
out if it crashed.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL General
version than 4.0.13, you could try to upgrade.
InnoDB: We intentionally generate a memory trap.
InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
Well, you did that now :)
I don't use InnoDB currently, so maybe someone else will respond.
Regards,
Fred.
--
Fred van Engen
:
GROUP BY Jobs.Job, Jobs.Sub, Jobs.Task;
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
be appreciated.
mysql pager /usr/bin/less
mysql tee somefile.log
I guess this is documented somewhere, or try:
mysql help
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
] IDENTIFIED BY 'update'' at line 1
mysql
Try [EMAIL PROTECTED] instead. UPDATE is a reserved word in SQL.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC
your DB as the root database user if
possible, and 2. you should stick your password (which shouldn't match
your UNIX password) in a textfile readable only by you so that you don't
pass the password on the command line.
-Fred
--
MySQL General Mailing List
For list archives: http
Hi
I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that
has lots and lots of subselects. I hear that 4.1 now supports this (I hope).
I used apt-get to install 3.23 so how can I install 4.1 over the top and not
get into any trouble is what Im after?
Ive tried apt-get
Thanks for your help! I might wait or look elsewhere
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, 23 June 2003 12:16 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subject: Re: APT-GET Help with upgrade to 4.1
On Mon, Jun 23, 2003 at 12:00:56PM +1000
. It would be highly appreciated if you could send me the
details at the earliest.
Sorry, but I have no experience with this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
);
++
| (5 | 7) ~(5 7) |
++
| 2 |
++
1 row in set (0.00 sec)
mysql
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
. It gives you
information on what you just inserted, not what someone else did with
another connection.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1362
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED
just did??
Sorry, you'll need a backup. If your backup is not recent enough and you
have a binary log (e.g. for replication), you can use that log to restore
the database state.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED
,
SELECT ID FROM theTable WHERE colorID = 5 AND colorID = 10
-Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you'd do this with a SQL query, short of using 'n' joins.
Of course if it's possible, it'd be best to modify the table such that
you separate colorID into two columns, and then use an AND.
-Fred
danchik wrote:
thats effectively an OR statement, isnt it?
how would i select the itemsIDs
the manual, check return values, etc. If you're running PHP in
apache, then check the error_log and use the error_log() function
instead of print as I use in the code above.
My code above is untested BTW.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL
Hi
Im new to mysql and am trying to connect externally.
I have hashed out the skip-networking in the my.cnf, created a new user and
gave permissions but it seems it just doent want to accept the connection. I
am trying to connect using free-Mascon.
Any idea's on what I can do?
Frederic
Tried that and it didn't work
Is it possible that the port 3306 is blocked? And if it is, how can I open
this?
Thanks
Fred
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 April 2003 12:09 PM
To: Lecul, Fred
Cc: '[EMAIL PROTECTED]'
Subject: Re: external
Hmm...
Yeah, its not connecting!
Im getting:
ERROR 1130: Host '10.x.x.x' is not allowed to connect to this MySQL server
Any idea's??
Fred
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Friday, 4 April 2003 1:42 PM
To: Lecul, Fred; [EMAIL PROTECTED]
Subject: Re
{
echo Can't perform the update. ;
mysql_error();
Try this:
echo mysql_error()
}
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
in MyPHPAdmin)
delete * from 'item' where 'quantity_of_item_in_stock' = 10;
Yes, this is incorrect syntax.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC
: $tanggal\n
Nama file: $namafile\n
;
}
echo Akhir baris.\n;
} else echo Gagal konek.\n;
mysql_close($konek);
?
Thank you very much in advance.
You're welcome.
Regards,
Fred.
--
Fred van Engen
']}');
Make that:
$sql = INSERT INTO testTable values ('', ' . addslashes($_REQUEST['testField']) .
');
Or you would just have coded your first exploitable line of code.
Regards,
Fred.
On Wed, 26 Mar 2003 14:28:21 -0500
BRYANT, LANCE [EMAIL PROTECTED] wrote:
Here is a copy of the php
tcpdump line and what do you see when you connect
manually from shelbyville to herzegbol? (i.e. telnet herzegbol 3306)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
just reply to
unsent packets.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL
it is for the latest
version of MySQL.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
?
Yes. The last inserted id is kept per connection. So unless YOU insert
another record using the same connection, the last_insert_id isn't
changed. Also, last_insert_id in a new connection will give you NULL,
regardless of what you did in a previous connection.
Regards,
Fred.
--
Fred van Engen
. network problems, the replication should
start again automatically. Again, you would see this in the error log.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC
: './mysql/host.frm' (errno: 13)
030326 14:35:47 mysqld ended
how do I correct this
You don't seem to have setup the privilege tables.
See http://www.mysql.com/doc/en/mysql_install_db.html for details.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email
/en/mysql_install_db.html for details.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
database option that will make a UNION behave properly in mySQL?
Please define 'properly'. What are you trying to do?
See msg 135092 for sample script if you want to see a physical example.
Which message is 135092? I'm reading a mailing list, not a newsgroup.
Regards,
Fred.
--
Fred van Engen
= Users.UserID
WHERE Users.UserId='2')
ORDER BY 'Cars!2!CarID!hide',
'User!1!UserID!hide',
Tag
;
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322
On Thu, Mar 20, 2003 at 10:32:07AM -0600, Dan Nelson wrote:
In the last episode (Mar 20), Fred van Engen said:
See msg 135092 for sample script if you want to see a physical example.
Which message is 135092? I'm reading a mailing list, not a newsgroup.
The mailing list software
://dbserver.myorg.com/MyDb?user=rootpassword=silksmitha
);
yields the exception:
java.sql.SQLException: Invalid authorization specification: Access denied for user:
'[EMAIL PROTECTED]' (Using password: YES)
Use FLUSH PRIVILEGES after updating the mysql tables directly.
Regards,
Fred
but by no means impossible.
You give them the application that contains the password or encryption
key. They just need to find it in your application then, which is more
difficult but not impossible.
Sue them! (that's what copyright laws are for)
Regards,
Fred.
--
Fred van Engen
,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
))) as apples,
sum(sign(find_in_set('pear', favourite_fruits))) as pears
from Kids;
This would give you all results on a single result row.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
/database/
http://www.python.org/topics/database/modules.html
http://sourceforge.net/projects/mysql-python
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC
this limitation the hard way, just like you seem to
have done. Since we don't control the scripts that use the database,
we couldn't use replicate-do-db. It just takes too much time to fix the
problems when someone forgets about this limitation.
Regards,
Fred.
- Original Message -
From: Ross Davis
1 - 100 of 224 matches
Mail list logo