Sebastian Mendel schrieb:
Hiep Nguyen schrieb:
hi all, i have an existing database (internal) with a user named
'admin', everything works fine as far as privileges concern.
i just created a new database (test) and want to grant admin's
privileges on test as same as internal.
how do i do thi
The following query run flawlessly in localhost but produces error on ISP
server:
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 'distinct
sf_threads.views) as views, ((count(distinct sf_messages.' at line 6
Th
At 2:57 PM -0400 4/16/08, Jim Winstead wrote:
On Fri, Apr 11, 2008 at 08:54:26AM +0200, Martijn Tonies wrote:
Hello Jim,
> On Thu, Apr 10, 2008 at 09:32:43AM +0200, Martijn Tonies wrote:
> > It seems that SHOW ENGINES fails on MySQL 5.0.51a (community edition
> > checked).
> >
> > Instea
>-Original Message-
>From: Tim McDaniel [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, April 16, 2008 2:32 PM
>Cc: 'Mysql'
>Subject: RE: \x96 in column value?
>
>On Wed, 16 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
>> I'm running afoul of the UTF8 character set somehow:
>>
>> mysql>
On Fri, Apr 11, 2008 at 08:54:26AM +0200, Martijn Tonies wrote:
> Hello Jim,
>
>
> > On Thu, Apr 10, 2008 at 09:32:43AM +0200, Martijn Tonies wrote:
> > > It seems that SHOW ENGINES fails on MySQL 5.0.51a (community edition
> > > checked).
> > >
> > > Instead of returning the full data, the first
Christian Hammers <[EMAIL PROTECTED]> writes:
> On Wed, 16 Apr 2008 16:43:01 +0200
> Kent Boortz <[EMAIL PROTECTED]> wrote:
>
>>
>> * Disk Data: Important Change: It is no longer possible on
>>32-bit systems to issue statements appearing to create Disk
>>Data log files or data files great
On Wed, 16 Apr 2008, Jerry Schwartz <[EMAIL PROTECTED]> wrote:
I'm running afoul of the UTF8 character set somehow:
mysql> select convert(char(0x96) using utf8);
+--+
| convert(char(0x96) using utf8) |
+--+
| NULL
I'm running afoul of the UTF8 character set somehow:
mysql> select convert(char(0x96) using utf8);
+--+
| convert(char(0x96) using utf8) |
+--+
| NULL |
+--+
1 row in set,
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> is there any command that can set so that admin's privileges on internal =
> admin's privileges on test???
>
> what i'm trying to avoid is manually adjust admin's privileges on test if
> admin's privileges on internal cha
On Wed, 16 Apr 2008, Daniel Brown wrote:
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
hi all, i have an existing database (internal) with a user named 'admin',
everything works fine as far as privileges concern.
i just created a new database (test) and want to grant
At 8:49 AM -0700 4/16/08, Rob Wultsch wrote:
On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois <[EMAIL PROTECTED]> wrote:
> When you create a table, you can specify a character set for a column. How
> can you tell what character set was used when the column was created?
>
SHOW CREATE TABLE. I
Hi all,
im new on the performance tuning of this database (MySQL 5.0.45, rpm-based
installation), and i have one performance problem on our new installation:
- The radius servers (that are written on perl) we have are writing the auth
and acct log to one mysql database. The conn we have is a
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
> hi all, i have an existing database (internal) with a user named 'admin',
> everything works fine as far as privileges concern.
>
> i just created a new database (test) and want to grant admin's privileges
> on test as same
On Wed, 16 Apr 2008 16:43:01 +0200
Kent Boortz <[EMAIL PROTECTED]> wrote:
>
> * Disk Data: Important Change: It is no longer possible on
>32-bit systems to issue statements appearing to create Disk
>Data log files or data files greater than 4 GB in size.
>(Trying to create log files o
Why is the character \x96 not allowed as a value in an INSERT query? I've SET
NAMES utf8, the table collation is utf8_general_ci, the default character set
for the table is utf8. I get this error message from my application:
ERROR: INSERT INTO prod
(prod_title,prod_published,prod_pub_prod_id,pr
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Iam having the one table name called AccessDetails and data inside that
> tables is following,
>
[snip=schema]
>
> In that , I need to calculate the number of total sites , number of
> total Accessed Sites,num
Selon Rob Wultsch <[EMAIL PROTECTED]>:
> http://www.google.com/search?q=STRAIGHT_FORWARD+mysql yields buckus.
> Where is this documented?
oops, I meant 'straight_join' :/
Tristan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
The production system is running 4.1.22. Does it supports schemas?
In any event, I'm not familiar with using them.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpre
On Wed, Apr 16, 2008 at 12:41 AM, <[EMAIL PROTECTED]> wrote:
> The 'STRAIGHT_FORWARD' + 'FORCE INDEX' worked, thanks a lot to all :)
http://www.google.com/search?q=STRAIGHT_FORWARD+mysql yields buckus.
Where is this documented?
--
Rob Wultsch
[EMAIL PROTECTED]
wultsch (aim)
--
MySQL General
On Wed, Apr 16, 2008 at 7:24 AM, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
> > When you create a table, you can specify a character set for a column. How
> > can you tell what character set was used when the column was created?
> >
>
> SHOW CREATE TABLE. If no character set is shown for the column
Hello,
I would like to add comments to existing tables in my database without
having to re-create the tables themselves. I know I can add a comment
using the alter table change column
comment ''. My question is what performance
impact will this alter statement have on my database. Will it
given that my table is in myisam, there are some hacky way of doing this
(referred to this online) like creating table without keys, insert data from
.myd, copy of .frm, .myi files for same table created with keys, and then
doing a repair table on new table..
but i was wondering if there is an eas
Bingo! You get a cookie.
Thanks, I knew there had to be a way.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Original Message
Bugs fixed (continued from part 1):
* Creating a foreign key on an InnoDB table that was created
with an explicit AUTO_INCREMENT value caused that value to be
reset to 1. (Bug#34920: http://bugs.mysql.com/34920)
* mysqldump failed to return an error code when using the
--master-d
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.24-rc release,
a new "release candidate" version of the popular open source database.
Bear in mind that this is still a "candidate" release, and as with any
other pre-production release, caution should be taken when installing
When you create a table, you can specify a character set for a column. How
can you tell what character set was used when the column was created?
SHOW CREATE TABLE. If no character set is shown for the column,
it uses the table default character set.
Example:
mysql> create table t (c1 char(5)
When you create a table, you can specify a character set for a column. How
can you tell what character set was used when the column was created?
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.67
Hi
How can i monitor multiple MySQL Database using mytop or are there any other
tools to monitor it.
Thanks and Regards
Kaushal
hi, i have this table
*TABLE friends:
*id_usr INT
id_friend INT
and i have a query in which i return friends from a given user and data
related to each of them stored in some other tables.
So i do this:
SELECT F.id_friend, M.status, P.firstname, P.lastname, IF( UNIX_TIMESTAMP( )
- UNIX_T
> It's possibly a DNS problem (reverse DNS exactly).
You know, I'm feeling a bit stupid here... That was indeed the problem,
as the new server hadn't been moved on DNS yet.
I put the IP address into the windows hosts file on the DB server, and
the problem cleared up immediately.
Thanks!
-Doug
hi,
is there any other best way add a new column to an existing table having 60+
million records. alter is taking more than 1.5 hours.. what are the best
practices around this. quick help will be appreciated.
--
cheers,
- a
Hi Patrick, all !
Patrick J. McEvoy wrote:
I have two MyISAM tables; each uses 'phone' as a primary key. Finding
rows where the primary keys match is efficient:
mysql> explain select bar.phone from foo,bar where foo.phone=bar.phone;
[[...]}
Ok, let us take some simple example. Say tables "f
From what I understand, Flex Builder 3 has a code generation wizard that
you can point to a database. Haven't used it myself though.
Sanat.
On Wed, 16 Apr 2008, Carl wrote:
I have been doing a lot of development in Flex over the last six months.
While it is a terrific presentation layer, co
I have been doing a lot of development in Flex over the last six months.
While it is a terrific presentation layer, connecting to a data manager (we
use MySQL) is time consuming (we use Java based openAMF) and a little
tempermental. We use Flex 2 Builder to help with the presentation layer and
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
DateTime UserName SiteName
ScanType Status Virus_Category
| 2008-04-16 | 13:05:31 | 172.16.1.22 | - | www.veer.com
|C | A
The 'STRAIGHT_FORWARD' + 'FORCE INDEX' worked, thanks a lot to all :)
Tristan
--
Tristan Marly
06.16.84.57.43
http://www.linkedin.com/in/tristanmarly
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've been building my PHP/MySQL applications by hand for years. Now I am
wondering after seeing a Flex demo if some sort of instant or super easy mysql
application builder existings. I want something for rapid development with a
graphical user interface. Maybe drag and drop table query c
37 matches
Mail list logo
