Hey all,
I'm currently converting a SQLServer 2000 database over to MySQL. I have a
web application that currently uses SQLServer but will be using MySQL soon
as I can get this done.
I was able to match data types but so far I have not found a way to let the
database handle setting the default va
Deal all,
I am migrating an old Access database to MySQL. After
migration, we'll keep using Access forms as front end,
and MySQL as database.
I experienced a strange problem when creating table
with a column name "id #", which is used by many
queries in Access. My command is like this:
create tab
Adam wrote:
All,
I've got data listing people's identification details including first
and last name, social, and status in the application. Given this data, I
want to know how many duplicate socials I have. Normally I'd write a
query with a sub select to get that information - something like
All,
I've got data listing people's identification details including first
and last name, social, and status in the application. Given this data,
I want to know how many duplicate socials I have. Normally I'd write a
query with a sub select to get that information - something like this:
SELECT
Hi All,
I have a huge Database which contains about 500,000 records, (will be
adding about 20-25k records every week)
I need to run group queries and output the same to a web interface.
An example is:
SELECT DISTINCT(`Call Svc Tag ID`),Count(`Call Svc Tag ID`) as counter,
`Journal Create Date`
On Fri, 16 Apr 2004, mayuran wrote:
> I would like to optimize the configuration settings
> for this beast of a machine, here are the specs:
>
> Quad Xeon 3ghz (4x2 = 8 cpus), 512 cache
> 16 gigs ram
> running Redhat Enterprise 3.0 AS
> All tables are InnoDB.
>
> I read this warning in the MySQL d
If you do any math on your column, no index on the column can be used. If
possible, you should always try to write your condition so that the
calculations are done on the value(s) to compare to, not on the column. So,
assuming you have no rows with future timestamps, something like this should
> i have a simple query
>
> select u.*,p.* from users u, profiles p
> where u.uname = p.uname
> and u.level != 0
>
> Is there any tricks to make this use an index. If i do level=0 is uses an
> index , but != does not.
MySQL only uses an index if it will return less than approx. 30% of the
record
At 11:42 -0400 4/17/04, Mark Susol|Ultimate Creative Media wrote:
> The general answer to your question, if you're willing to cooperate
with the server, is to lock the tables from within the server so that
no other clients can modify them, and use FLUSH TABLES to flush any
changes to disk. Whi
Occasionally, when looking at the processlist using MySQLAdmin, I see
entries
'unauthenticated user' 'reading from net'
Would some kind person tell me what this means, and if I'm in danger of
having data compromised?
Thanks
Terry Riley
--
MySQL General Mailing List
For list archives: http:/
At 22:39 -0400 4/16/04, Robert A. Rosenberg wrote:
I am talking a PHP+MySQL course at my local community college and
since this is the first time the course is being offered there are
some teething problems with the curriculum. I am posting this query
at the request of the instructor.
We are us
> The general answer to your question, if you're willing to cooperate
> with the server, is to lock the tables from within the server so that
> no other clients can modify them, and use FLUSH TABLES to flush any
> changes to disk. While the lock remains in place, copy the table
> files. Then unlo
The you will need to use the second format.
DATE_FORMAT(queue_time, '%Y%m%d') = CURRENT_DATE()
-Original Message-
From: Dirk Bremer (NISC)
To: [EMAIL PROTECTED]
Sent: 4/16/04 4:09 PM
Subject: Re: SQL Query Question
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
Hello
i have a simple query
select u.*,p.* from users u, profiles p
where u.uname = p.uname
and u.level != 0
Is there any tricks to make this use an index. If i do level=0 is uses an
index , but != does not.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hello,
when do you plan to release 4.1.2 version ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, collugues
Have a problem with replication in MySQL-5.0.0-alpha
Configured server with server-id=2, slave with server-id=4
Copied DBs, configured the slave, restarted the servers.
Under MySQL v4.0.18 from debian distro replication works perfectly.
Kept all configs in place, overwrite all binar
saiph <[EMAIL PROTECTED]> wrote:
>
> alea> mysql -V
> mysql Ver 12.22 Distrib 4.0.17, for pc-linux-gnu (i386)
>
> but
>
> mysql < SHOW VARIABLES LIKE "have_innodb";
> +---+---+
> | Variable_name | Value |
> +---+---+
> | have_innodb | NO|
> +--
"Ronan Lucio" <[EMAIL PROTECTED]> wrote:
>
> Is it possible to make a search for a word in a longtext column
> from a InnoDB database?
>
Yes. Look at:
http://dev.mysql.com/doc/mysql/en/Pattern_matching.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
"Jan Broermann" <[EMAIL PROTECTED]> wrote:
> Hi, I've got a little Excel Macro that connects to
> MySQL via ADO below is the code. Funny thing is
> it connects to the database and executes the truncate
> orders without a problem.
>
> But when I come to Load data in file i receive an
> [MySQl][ODBC
Hi, I've got a little Excel Macro that connects to
MySQL via ADO below is the code. Funny thing is
it connects to the database and executes the truncate
orders without a problem.
But when I come to Load data in file i receive an
[MySQl][ODBC 3.5.1 Driver][mysql-4.0.18-nt]Access denied for user
:'[
20 matches
Mail list logo