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
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 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
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
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,
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
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
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, 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( )
-
Hi
How can i monitor multiple MySQL Database using mytop or are there any other
tools to monitor it.
Thanks and Regards
Kaushal
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:
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)
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 on
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
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
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
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 table change column col_name col_name
col_def comment 'column comment'. My question is what performance
impact will this
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,
it
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
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
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:
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,number of
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
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 as
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 or data
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
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. If no
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 changed.
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, 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
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 greater than 4 GB
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 two columns are
-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 select
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).
Instead of
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
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
37 matches
Mail list logo