 | | | MySQL General | | Mark Steudel wrote
> I was doing a full text search and had a question on why two different
> entries got the same score
>
> Here is my select statement
>
> SELECT
> id
> pubyear
> MATCH ( titable master has alast_dat a date that is not updated. pk is reg_id.
table detail has date_update inserting each transaction. fk is reg_id.
is there an update command that will take max date from dOn 6/8/06 Frances <fdr58@(protected) > wrote
> Daniel da Veiga wrote
> > On 6/8/06 Frances <fdr58@(protected) > wrote
> >
> > > what 's event viewer? (searched google for error 1067 so opened .err
> > >I am creating a new table from the fields of an existing table.
create table newtable select a+b+c col1 from oldtable
I don 't want to create newtable ahead of time because it will have around
200 fOn 6/8/06 murthy gandikota <murthy_gandikota@(protected) > wrote
>
> I 've checked the dump file I created with mysqldump on a database sfg and
> it has statements like the following
>
> DROP VIEW IF Hi
The following happened when I tried to create table. Can anyone please help?
mysql > create table sfgbackup.advEmail select * from sfg.advEmail
mysqld got signal 11
This could be because you hit At 10 20 AM 6/8/2006 you wrote
>Hi
>
>I am trying to import a 3.2Gb sql dump file back into my sql server (4.1.12)
>and im coming across the following error
>
>mysql Out of memory (Needed 1787232Nenad Bosanac schrieb
>
>
> Hi all
>
> I made mistake i n my last post so now
> i make it true.
>
> I have problem in MYSQL query tool.
> Well i put on foreign key on delete no action
> but nextHi all
unluckily I made a bad typing error
Joerg Bruehe wrote
>
> this is in reply to various questions that have reached us after the
> recent security fix contained in MySQL 4.1.20 4.0.22I wrote
> > My problem isn 't quite the same as the original poster 's but I
> > suspect the solution may be the same. However I 'm having trouble
> > running the myisamchk command.
> >
> > I 'm usingMySQL 5.0.19 running in Apache 2 on Mac OS X 10.4.6
I 've been dipping my newbie toe into the murky waters of full text
searching but not with a great deal of success. I have a complex
search set uHello
we need to query one of database tables that sore usernames and many of them
have spaces in them that need to be removed. what would be the correct function
to identify each username columnThis may be a really stupid question but I hate looking stupid if I can
avoid it. -)
I have been using Microsoft SQL Server for a while and I 'm now trying to
switch all our applications over to Hi everyone
Should be an easy question but I couldn 't find the answer anywhere.
Firstly I can 't figure out why the REF column shows NULL and secondly I
don 't know why the key length is 5.
I haveHi
this is in reply to various questions that have reached us after the
recent security fix contained in MySQL 4.1.20 4.0.22 and 5.1.11-beta
The problem was a possible "SQL injection " risk Hi
MySQL 5.1.11-beta a new version of the popular Open Source Database
Management System has been released. The Community Edition is now
available in source and binary form for a number of platfoHi List!
I 've recently upgraded to MySQL 4.1.20 and now I 'm facing a strange
problem. Periodically my queries hang up.
mysql > show processlist
...
| 155 | root | localhost | db | Query | 3338Recently I noticed a changed behavior in how linux utilities (ps ans
pstree) report mysql usage.
Previously a ps output would list all active mysql threads and a
pstree would list the number of mysqTaras I 'm guessing you 're using version 4.1 or earlier. This is a
known issue with MySQL prior to 5. 4.1 and earlier would only use one
index per instance of a table per query leading to poor peI have a site running MySQL 4.1.19.
When I was first given the problem the site only stayed up for a couple
of days - they then found they had to reboot (as opposed to just
restarting MySQL).
The ePerhaps the easiest way is with CREATE TABLE... SELECT. For example
if I have a database called "NYCNH " (by coincidence I do!) which
contains a table called "checks " and I want to copy that tabWilliam Scott wrote
> Dear Sir
>
> I have a database with over 80 tables. Is there an easy way to find
> table names that has PERSON_ID field using SELECT query?
>
> Thanks in advancOn 6/8/06 mos wrote
> At 08 15 PM 6/7/2006 you wrote
> > I believe that if you are only using MySQL for your company 's
> > internal needs whether from a web server or for deployment to other
> > comAt 17 30 -0600 6/7/06 Jake Peavy wrote
>Hey yall
>
>I 'm unable to open the .chm I just downloaded for 5.1. I get the following
>error
>
>Cannot open the file mk @(protected) C \Documents and SettiI am new to databases and mysql in particular. I need to provide the
specifications for database size for a new design...
Lets assume one of my tables has the following structure
column1 int
columI created a sql file for database sfg as follows
mysqldump -uuser -ppassword sfg > backup.sql
Then I tried to reload it in another database sfg2
mysql -uuser -ppassword sfg2 < backup.sql
I get thOn 6/7/06 Aron Levy <alevy@(protected) > wrote
> Hi James i follow your recomendation and verify that the hash produced
> matches the password field in user exactly.
>
> -- Aron L.
>
Well thatJay
>We all know that you cannot do something like this
>sum(if(substring(updated 1 10) curdate() 1 0)) AS curdate()
>nor can you use user variables even though they get set properly
>set @(protected)Hi good afternoon i am triying to connect with my company 's mysql
server using a client program from shell and I keep receiving the
following answer
[root@(protected) ~]# mysql -u user1 -p -h serveOn Wednesday 7 June 2006 at 11 35 56 -0700 James Barros wrote
> Hello
>
> I 've got 5.1.9 running on FreeBSD and I 'm trying to do some backups
> but mysqldump is locking up on me.
>
> when I run |
|
|
