 | | | MySQL General | | venkata ramana wrote
> Hi
> I don 't know whether I can ask this question on this mailing
> list or not but I want to know how the php communicates with mysql
> when it is on the localhoHi
Table "mpprim " has UNIQUE constraint on 3 fields Primka Tip Godina
(Document Type Year in English). I am trying to insert a new record
into it without having first to count how manny docOn Thu 3 Jun 2004 22 36 55 +0100
"Andrew Dixon " <andrew@(protected) > wrote
> Hi Everyone.
>
> I have the following SELECT statement the get information from two
> tables. The statemenHello all
I 'm getting the error message "2013 Lost connection to MySQL server
during query " during inserts on a lightly-loaded mysql server. I also
noticed the following error in the error I 'd suggest you add a static route to the W2k clients just to see if
that corrects the problem... try this command
route ADD ddd.ddd.ddd.ddd MASK mmm.mmm.mmm.mmm ggg.ggg.ggg.ggg
d destinatiHi
Is it wise to have a database with hybrid table types?
In other words if I have a table that wouldn?t have many
INSERT/DELETE/UPDATE queries may I create it
as MyISAM type and even interAt 12 44 -0700 6/3/04 David Blomstrom wrote
>My database "world " won 't work online because the
>online version is username_world with a different
>username and password. So I want to create a cYou will need to reuse your database connection do not open a new
connection with each call or the lock will not be there.
LOCK TABLE table1 READ
SELECT * FROM table1
UNLOCK TABLES
-----Or
On Thu 03 Jun 2004 13 57 Michael Stassen <Michael.Stassen@(protected) > sent
>
>
>McKeever Chris wrote
>
> > MYSQL 4.0.13
> >
> > I must be doing something wrong - I am trying to do a mmichael young <mhyoung@(protected) > wrote
> I want to move a DB to a new server.
> The old one has MySQl version 4.0.13.
> The new one has 4.0.18. Is there any kinda
> prep that needs to beBob Lockie <bjlockie@(protected) > wrote
> What I really want was
> mysql > update records set records.prio 2 where records.in (select
> records.id from records audit_log audit_log_records where
Donny Simonton wrote
> I definitely don 't see this in the documentation anywhere but can you drop
> multiple indexes at one time with an alter table?
>
> Donny
From the manual <http //dev
McKeever Chris wrote
>MYSQL 4.0.13
>
>I must be doing something wrong - I am trying to do a mysql dump and it keeps yelling that tables dont exist whenever I put a where clause in..
>it runI believe this means mysql found fewer columns in each row of your infile
than are defined in your table.
Michael
Mauricio Pellegrini wrote
> Hi again
> Thanks to all your kindIn the last episode (Jun 03) Dossy said
> The schema in question needs a redesign (dynamic row format contains
> two BLOB columns) but I was wondering if anyone has written up some
> guidelines In the last episode (Jun 03) Sp.Raja said
> Our software environment requires mysqld to be daemonized. (running
> in nohup cannot help) Does mysqld support it? Or do we need to change
> the sourcHello Mauricio
I tested in version 4.1.0 and not function.
Only in version 4.1.1 according to text below extracted from MySQL manual
Note that the framework for warnings was added in MySQL 4You need version 4.1.x and greater. Then issue SHOW WARNINGS after the
statement that generated the warnings.
-----Original Message-----
From Mauricio Pellegrini
To MySql List
Sent 6/3/04 1On Thursday June 3 2004 8 14 00 AM Victor wrote
VP > If you choose to copy the files I would ensure that you are getting the
VP > innodb binary logs as well if they do not exists in the mysql dYou may want to forget all those joins and filters to create two
columns which is probably making MySQL do multiple full table scans.
It sounds like what you are really looking for is to separateDavid Blomstrom <david_blomstrom@(protected) > wrote
> --- "Robert A. Rosenberg " <MySQL@(protected) > wrote
> > At 20 36 -0700 on 06/02/2004 David Blomstrom wrote
> > about
> > Exporting/Importing DatYou should try the USGS or the USPS sites. I would expect that either of
them might offer a set of standard codes for identifying counties from the
US.
Dave
-----Original Message-----
From At 1 22 +0000 6/3/04 Nick Mudge wrote
>Hi
>
>I am trying to get MsSQL working. I can 't get the server to start.
>
>I tried typing in mysql_install_db and got the following response
>
> linYou can change the download options so that it will ask you where you want
to put the file rather than default to the desktop.
Tools/Options/Downloads/Ask me where to put every file.
Dave
--I 'm a little out of my realm in asking this on behalf of someone else
but here goes...
I finally got 4.1.2 working for me on OS X 10.3.4 but have a curious
performance snag.
If I connect tAt 13 57 -0500 6/2/04 Oropeza Querejeta Alejandro wrote
>
>Hi two questions
> Is it possible to select data from different Databases on the same
>server?
Yes. You can qualify table and co
Chris Dietzler wrote
>I am trying to pull cst_SiteID from a query result to use in another query
>
>SELECT cst_Name cst_SiteID FROM customers WHERE cst_Name LIKE 'st% '
>
>+Hi! My name is Nicolas Pace and i?m quite new in mysql.
This is the situation
I have One table with 4 inverted-index fields.
I want to query the table which stores the inverted-index keywords.
IAt 9 15 -0700 6/2/04 Robert Frame wrote
>This is probably something simple that I am just not seeing but I
>would appreciate your help.
>
>As root I have created a schema named test along witHow about
SELECT @(protected) COUNT(*) FROM table
SELECT date COUNT(*)/@(protected) AS average
FROM table GROUP BY date
Michael
Chris W wrote
> I have a table where the date a record |
|
|
