On 6/22/2012 12:18 AM, Anupam Karmarkar wrote:
Thanks Rick for your reply,
Here i am asking about logic to perpare query or whole query itself.
A set-based approach to doing the basic task is to convert your set of
start/stop times into duration values. The timediff() function mentioned
June 2012 10:52 PM
Subject: RE: Need Query Help
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
and SEC_TO_TIME()/3600
-Original Message-
From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com]
Sent: Wednesday, June 20, 2012 2:39 AM
To: mysql
Hi All,
I need query help for following table struture, where we need to calculate
login duration of that employee for give period.
Example table
EmployeeID LoginTime LogoutTIme
101 2012-05-01 10:00:00 2012-05-01 12:30:00
102 2012
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
and SEC_TO_TIME()/3600
-Original Message-
From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com]
Sent: Wednesday, June 20, 2012 2:39 AM
To: mysql@lists.mysql.com
Subject: Need Query Help
Hi All
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2),
On 5/12/2011 2:30 PM, Grega Leskovšek wrote:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2), uniqueid(idlog) );
CREATE TABLE log (
idlog int auto_increment primary key,
imepriimek
i asked about this once upon a time, and might need a little more
help here. a friend's mysql hosting provider lost an entire DB, but
has managed to recover and hand over the ibdata1 file (or at least
some portion of it).
when my friend popped into mysql, what he's seeing is that some of
Thank you very much Jorn. Your suggestion helped me.
Hi Fello MySQL users,
I am Bala Raju, i have a problem to extract data by writing query, i need u
r help. Please help me.
I have two tables, i am giving the tables as attachement, firs table is
playersloginfo and second one is playerhanddetails.
playersloginfo : This table stores all
On Saturday 10 February 2007 12:45, balaraju mandala wrote:
Hi Fello MySQL users,
I am Bala Raju, i have a problem to extract data by writing query, i need u
r help. Please help me.
I have two tables, i am giving the tables as attachement, firs table is
playersloginfo and second one
Hi Jorn,
Thank you for reply, of course i can merge the columns and change the
datatype. But buddy that is not problem here, the problem is extract the
data.
Did u able to understand my language, if not i will explain you again.
Please read the mail again and tell some ways from u r experience.
On Saturday 10 February 2007 19:21, balaraju mandala wrote:
Hi Jorn,
Thank you for reply, of course i can merge the columns and change the
datatype. But buddy that is not problem here, the problem is extract the
data.
After reading your message once more, I realise that you should do even
Hey everybody,
i´m becoming desperate about the following problem.
We´ve an online-community / network.
There´s a network table ( sql create below ), in which we store the
relationships between the member.
I need a SQL-statement or a PHP-Function to calculate the 2nd, 3rd and
4th degrees
I use something like this in my e-commerce for degrees of my category of
products. I think it´s the same thing you want.
I get everything to an array and then use it to work.
By this follow function, i get all options for my select field, it´s all in
portuguese but i think it can help you.
Jesse wrote:
Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table
`alumni`... Is your table `alumni` MyISAM or Innodb?
It is MyISAM.
Here are few more pointers:
1. If it is possible *always* try latest version first when solving
problems. In your case 5.0.22 I think...
I don't know why they renamed it again ?!?
For better explanation and comparison take look here:
http://www.mysql.com/network/compare.html
http://www.mysql.com/products/database/
http://www.mysql.com/products
Thank you. Those links were very helpful. I don't know why I can't seem to
find
Jesse wrote:
Are you sure this is the right line - I mean the whole statement?
You are right, I did not include the whole statement. Here's the entire
section:
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION
:36 PM
Subject: Need Restore Help
I have a backup that was created by a MySQL 5 server using MySQLDump. When
I try to restore the database using the following command:
mysql -u root -p -D BPA c:\backup\mydata.sql
I get the error:
ERROR 1064 (42000) at line 29765: You have an error in your SQL
Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table
`alumni`... Is your table `alumni` MyISAM or Innodb?
It is MyISAM.
Here are few more pointers:
1. If it is possible *always* try latest version first when solving
problems. In your case 5.0.22 I think...
You were
Jesse wrote:
I have a backup that was created by a MySQL 5 server using MySQLDump.
When I try to restore the database using the following command:
mysql -u root -p -D BPA c:\backup\mydata.sql
I get the error:
ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax;
check the
Are you sure this is the right line - I mean the whole statement?
You are right, I did not include the whole statement. Here's the entire
section:
/*!50003 SET @OLD_SQL_MODE=@@SQL_MODE*/;
DELIMITER ;;
/*!50003 SET SESSION
I have a backup that was created by a MySQL 5 server using MySQLDump. When
I try to restore the database using the following command:
mysql -u root -p -D BPA c:\backup\mydata.sql
I get the error:
ERROR 1064 (42000) at line 29765: You have an error in your SQL syntax;
check the manual that
I have a table named table1 structure is
++---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
++---+--+-+-+---+
| name | varchar(50) | NO | PRI | | |
| gender |
UPDATE `table1` SET `gender` = IF('f'=`gender`, 'm', 'f');
If you have NULL columns you might want to make another sublevel in IF to
leave it NULL !
I believe this should do it... you might also take into consideraion
removing the possibility of a NULL in the `gender` column... because it
allows
Thread
* I Need you Help Urgently - Pratchaya Chatuphian, August 23 2005
8:54pm
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net
This is my sample error in my MySQL Log
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://www.mysql.com/doc/en/Using_stack_trace.html and
follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the
]
To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
Rhino wrote:
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some
In article [EMAIL PROTECTED],
iNFERNo [EMAIL PROTECTED] writes:
Hi,
First of all thank you all for the quick replys.
Now here's:
select * from events limit 10;
+--+--
--+++--+-+---+--+---+--
+
| id | user_id |
Hi,
Thank you very much that was what I looking for.
Best regards,
Cristi
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
iNFERNo [EMAIL PROTECTED] writes:
Hi,
First of all thank you all for the quick replys.
Now here's:
select * from events limit 10;
+--+--
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql describe events;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql describe events
Rhino wrote:
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 5:23 PM
Subject: I need some help
Hi,
I have a problem: I am using mysql 4.0.24 and I need to make
some reports from a database:
mysql describe
- Original Message -
From: Michael J. Pawlowsky [EMAIL PROTECTED]
To: Rhino [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Wednesday, April 06, 2005 7:51 PM
Subject: Re: I need some help
Rhino wrote:
- Original Message -
From: iNFERNo [EMAIL PROTECTED]
To: mysql mysql
I was wondering if anyone wants to help me with this project.
I already have a test database we can use, I just need help making the team
pages.
please take a look and reply if interested.
thanks in advance
I'm a noobie in regards of php but I am trying to learn.
http://www.theufl.com
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] writes:
Have you considered splitting this into two queries? One query can gather
information from your token and token_ins tables. The other would join the
first queries results to the other tables to complete your original query.
Depending
Hum,
Well, I'm back with another one... When adding a
join to the previous query, it sloows down once again
even though it retrieves less datat. Here's the info :
mysql explain SELECT ti.posi, ti.docid, d.filename,
ti.id, c.name
FROM corpus_documents cd, corpus c, documents d,
tokens_ins ti,
Have you considered splitting this into two queries? One query can gather
information from your token and token_ins tables. The other would join the
first queries results to the other tables to complete your original query.
Depending on your data, one of these subqueries should return a smaller
Create composite index on (cat, date). Use EXPLAIN to see if MySQL uses
index:
http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
This partially solved my problem. Thanks a lot. However I am facing a new
problem here.
The query where I am ordering by a column is much more slowly than the same
Hi again,
Second: specify what you mean with all relations. Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] | auto_increment
| reference| varchar(255) |
|
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify what you mean with all relations. Can you
share some sample data and sample output (that is: what
do you expect the query to return).
Ok my table noms is like
| id | int(11) | | PRI | [NULL] |
Steve Folly said:
However, I suspect this isn't the full story. Do you also want to
see what components make up C003 and D003 in the same query? I
think you're after a feature not yet implemented in MySQL - the
'CONNECT BY PRIOR' SELECT statement, just the ticket for
hierarchical queries.
I want to have all the items into a recorset with only one query like
Select id, reference, component from NOMS where reference = '4'
but i want not only the primary relations, i want all relations.
Could somebody help a newbie like me?
It can also help to change the way you look at the
more on nested set models.
Cheers,
Matt
-Original Message-
From: Steve Folly [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 13, 2004 1:59 PM
To: MySQL MySQL
Subject: Re: hierarchical records, I need some help!! ;(
On 13 Jan 2004, at 09:19, Victor Reus wrote:
Hi again,
Second: specify
On 13 Jan 2004, at 19:11, Jochem van Dieten wrote:
I most certainly hope this Oracle idiosyncracy will never make it into
MySQL.
The SQL standard defines a different syntax for doing recursive
queries, using WITH RECURSIVE. I see no reason for MySQL to implement
a non-standard way for doing
Hi
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical like
reference - component
reference
Hi
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical like
reference - component
reference
Victor,
First: don't ask the same thing twice.
I have one table called noms like this:
| id | int(11) | | PRI | [NULL] | auto_increment |
| reference| varchar(255) |
| component| varchar(255) |
the relation between reference and component is hierarchical
Hi,
I downloaded Linux semi static binary of
mySQL,mysqlgui-linux-semi-static-1.7.5.tar.gz. Could you please help me,how to install
in my system.My OS is Redhat Linux9.0.
Warm regards,
Renuka Prasad.N
-static-1.7.5 /usr/local/mysql
read the installation instructions in the INSTALL-BINARY file in
/usr/local/mysql
Hope this helps,
Andy
-Original Message-
From: Renuka Prasad [mailto:[EMAIL PROTECTED]
Sent: 07 November 2003 08:00
To: [EMAIL PROTECTED]
Subject: Need ur help
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if it is possible
to create a query to search for words in a given field. What I am trying to
do is allow a user to enter words to search for a given title in the
database. For example, a person is looking up the title
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
]
Sent: Thursday, June 26, 2003 7:23 AM
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if
it is possible
to create a query to search for words in a given field. What
I am trying to
do
]
Subject: Need your help in a search query
Hi MySQL Experts,
I am pretty new at this and need your help in figuring out if it is
possible
to create a query to search for words in a given field. What I am trying
to
do is allow a user to enter words to search for a given title in the
database
I'm trying to write a Delphi program that accesses a MySQL database via
MyODBC. It's going pretty well except for a sticky problem I'm having with
an unsigned integer column.
I have a column named 'IP', type unsigned integer, that will hold IP
addresses. However, Delphi seems to assume this
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on mysql) from
version 3.23 to version 4. since then, any attmepts we've made
On 11/9/02 3:14 PM, 3mip1s4la-Emilio Pisanty [EMAIL PROTECTED]
wrote:
hello everyone:
to begin with, I apologise for asking a question which is probably
obvious. My name is Emilio Pisanty and I and one of the two makers of my
school's website. recently we updated the database system (on
tables have met with a 1175 error (You are using safe update mode and you
tried to update a table without a WHERE that uses a KEY column).
Nothing is obvious and is hard to advise you if you don't give us some more
info on the table structure and the update query you have trouble with.
Niedner [EMAIL PROTECTED]
Cc: MySQL Mailinglist [EMAIL PROTECTED]
Sent: Sunday, November 10, 2002 12:34 AM
Subject: Re: little problem, I need some help...
tables have met with a 1175 error (You are using safe update mode and
you
tried to update a table without a WHERE that uses a KEY
On Sat, 2002-11-09 at 19:34, 3mip1s4la-Emilio Pisanty wrote:
tables have met with a 1175 error (You are using safe update mode and you
tried to update a table without a WHERE that uses a KEY column).
Nothing is obvious and is hard to advise you if you don't give us some more
info on
-Emilio Pisanty [mailto:emipisala;lancaster.edu.mx]
Sent: Sunday, 10 November 2002 11:34
To: R. Hannes Niedner
Cc: MySQL Mailinglist
Subject: Re: little problem, I need some help...
tables have met with a 1175 error (You are using safe update
mode and you
tried to update a table
hello everyone:
1) in my school groups are called forms, so I used it not to confuse you
2) I hadn't learnt how to define indexes on MySQL so I hadn't defined any
3) now I have, and...
4) the query worked.
thanks for your help,
Emilio Pisanty
: little problem, I need some help...
Every SQL database requires the ability to locate a record which is
unique
in some way. You can't have two records which look the same.
That's why you need to define a primary KEY on a column or coumns.
You need to read a primer on SQL databases
Alan
hello,
I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
installed a new system (I'm running on MacOSX, was 10.1.5.1, now after
upgrading it is 10.2.1) and I did not properly do it I'm afraid : I backed
up my /usr/local/var directory which contained all my mysql
Maybe you didn't specify the correct data-dir in my.cnf?
Thomas
sql,query
On Sun, 6 Oct 2002 09:23:51 +0200 jeroen [EMAIL PROTECTED] wrote:
hello,
I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
installed a new system (I'm running on MacOSX, was 10.1.5.1,
Okay, I'm very sorry for bothering you all with this. If I had not panicked,
I probably would have found it myself.
- Original Message -
From: jeroen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 06, 2002 9:23 AM
Subject: need urgent help recovering after renistall
means a permission issue. a straight sudo
chown -R mysql /usr/local/mysql/* solved everything.
- Original Message -
From: jeroen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, October 06, 2002 9:23 AM
Subject: need urgent help recovering after renistall (plase !)
hello
From: root
To: [EMAIL PROTECTED]
Subject: I need some help in MySql installation
Description:
I tried to install MySQL,version :- MySQL-3.23.52-1
using RPM which I downloaded from mysql website. I
copied it in my root directory i.e. [root@FireWall2
/root]
My machine name
sachin,
Friday, August 30, 2002, 10:30:47 AM, you wrote:
ss Description:
[skip]
ss I got this
ss MySQL-3.23.52-1
ss That means mysql is installed successfully.
ss What is the step by step procedure for post
ss Installation configuration of MySql server?
Check chapter 2.4 Post-installation
I'm sorry that my English is very week!I come from Chinese ! My computer OS is RedHat
Linux 7.2 and the machine is intel celeron 300A 64M memory!
the bad command message is :
[root@guanqun zsj]# cd /usr/local/src/zsj
[root@guanqun zsj]# cd mysql-4.0.1-alpha-pc-linux-gnu-i686
[root@guanqun
ÕÅÉƽð wrote:
I'm sorry that my English is very week!I come from Chinese ! My computer OS is
RedHat Linux 7.2 and the machine is intel celeron 300A 64M memory!
the bad command message is :
snipped
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!
please tell what mean the follow:
[root@guanqun zsj]# cd /usr/local/src
[root@guanqun src]# cd mysql-3.23.44.tar/
[root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr/local/mysql
bash: ./configure: No such file or directory
[root@guanqun mysql-3.23.44.tar]# ls
mysql-3.23.44
is optional)
Regards,
Jocelyn Fournier
- Original Message -
From: ÕÅÉƽð [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 12:24 PM
Subject: Thank you!I need your help!
please tell what mean the follow:
[root@guanqun zsj]# cd /usr/local/src
[root@guanqun src]# cd
: ÕÅÉƽð [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 24, 2002 12:24 PM
Subject: Thank you!I need your help!
please tell what mean the follow:
[root@guanqun zsj]# cd /usr/local/src
[root@guanqun src]# cd mysql-3.23.44.tar/
[root@guanqun mysql-3.23.44.tar]# ./configure --prefix=/usr
You need libtermcap. (libtermcap-2.0.8-28.i386.rpm)
You are running a Redhat 7.2 box, use binary distribution instead of source
package if you're not familiar with building programs.
Regards,
Sébastien
please tell what mean the follow:
[root@guanqun zsj]# cd /usr/local/src
[root@guanqun
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is there any
way I can recover the database using
Why don't you create a php script that generates SQL instead of HTML; i
will repopulate your database acting as a dump?
I know it will take some time to develop...
Balteo,
John Parsons wrote:
I have just been a complete muppet and trashed the tables in my database and
don't have a recent
From: Balteo [EMAIL PROTECTED]
Why don't you create a php script that generates SQL instead of HTML; i
will repopulate your database acting as a dump?
Not a bad idea. John, be carefull not to mess up whatever cache is currently in place
by changing something that will confuse the cache.
: DESPERATE NEED FOR HELP!
I have just been a complete muppet and trashed the tables in my database and
don't have a recent backup.
The database is used for the phpBB system and still functions when I visit
the site via a web browser since the database is still cached. Is there any
way I can recover
worked fine.
Cheers
John
-Original Message-
From: John Parsons [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 04, 2002 9:52 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: DESPERATE NEED FOR HELP!
I have just been a complete muppet and trashed the tables in
my database
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=mysql_fetch_array($r)) {
$retval.=nbsp;nbsp;nbsp;nbsp;a href=\%s\img src=\%s\
border=\0\/abrnbsp;nbsp;- a
href=\%s\%s/abrbr,$a[url],$a[picurl],$a[url],$a[title]);
}
It just gives me a parse error
printf, so mine is probably wrong, but
that's the problem.
- Jonathan
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 1:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying why I have an error
$retval = .= nbsp;nbsp;nbsp;nbsp;a href=\.$a[url].
\img src=\.$a[picurl].\border=\0\/abrnbsp;nbsp;.
- a href=\.$a[url].\.$a[title]./abrbr;
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some help
Hi, I need a little help as I am a beginner with db things. I'm
building a database for technicians and help-desk problems where
technical problem tickets are stored in one table, and technicians in
another. Really I have two main questions. First, each problem may
have more than one
On Sun, Mar 17, 2002 at 12:28:35AM -0500, Lionlike wrote:
Hi, I need a little help as I am a beginner with db things. I'm
building a database for technicians and help-desk problems where
technical problem tickets are stored in one table, and technicians in
another. Really I have two main
i have Mac OS X Server and i think MySQL is preinstalled, but it's not
running so i tried to start it and got the typical socket error 2002.
then i tried this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon
i have Mac OS X Server and i think MySQL is preinstalled, but it's not
running so i tried to start it and got the typical socket error 2002.
then i tried this:
[mbase:~] ted% safe_mysqld
touch: /usr/var/mbase.err: No such file or directory
chown: mysql: invalid user name
Starting mysqld daemon
Hi there,
I've been trying around for some time now and i just don't see a solution to
my problem:
I have a table called feiertage (Holidays):;
mysql select * from feiertage;explain feiertage;
++
| datum |
++
| 2001-12-24 |
| 2001-12-25 |
| 2001-12-26 |
| 2002-01-01
I was wondering if anyone could help me converting some PostgreSQL
queries with sub-queries into a similar form usable (hopefully) by both,
or at least into a form that I can use in place of the PostgreSQL ones.
I'm going to post them - I hope no one minds. If this is the wrong
mailing list for
I am currently running an online golf tournament on an NT server with an
Access database and asp pages. I have access to a Unix server that
supports asp script and mySQL database and I'd like to move my tour site
(for several reasons) but the SQL statements don't all work. The
following statement
I am currently running an online golf tournament on an NT server with an
Access database and asp pages. I have access to a Unix server that
supports asp script and mySQL database and I'd like to move my tour site
(for several reasons) but the SQL statements don't all work. The
following statement
-0800, [EMAIL PROTECTED] wrote:
hi,everyone.
i have wrong deleted the records from file; use the
sql : delete from test where treeid like '%';
who knows how i can restore the records from the MYD
file.
i need your help.
sincerely,
zhangyun
--
[EMAIL PROTECTED
My question is how in MySQL I can get information
is table exists or not ( I don't want some query
that return
error but kind of message from serwer !)
I'm beginner and I have no idea how to do it
smart and properly
Please help !!!
On Sat, 2001-11-10 at 04:33, Artur Kowal wrote:
My question is how in MySQL I can get information
is table exists or not ( I don't want some query
that return
error but kind of message from serwer !)
I'm beginner and I have no idea how to do it
smart and properly
Please help !!!
Hello all,
I have 3 tables I need to join to extract certain data base on the acct_days in
the active table '6' days.
QUERY:
SELECT CONCAT(m.fname,' ',m.lname) AS name,
m.email,m.zip,p.paytype,p.event,p.paydate
FROM members m
LEFT JOIN payhistory p ON p.memid = m.memid
LEFT JOIN active a ON
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 1 November 2001 4:22 p.m.
To: [EMAIL PROTECTED]
Subject: Need query help
Hello all,
I have 3 tables I need to join to extract certain data base on the acct_days
in
the active table '6' days.
QUERY:
SELECT CONCAT
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see it
clear as day, and I think that I have the configurations correctly. However
I really am a programmer, not a server admin. Could someone out
mysql must own the database directories.
chown -R mysql /var/lib/mysql
( or whatever the database directory is )
Mike Eggleston wrote:
Folks,
I know I am new here, and I really need your help. You see, the MySQL
server is saying that it cannot find the host.frm file. Now, I can see
Hi,
I am facing some problem using MYSQL..When I am listing the records I am
getting the following error..
Microsoft Cursor Engine error '80004005'
The data provider or other service returned an E_FAIL status.
/keyknowledgev1.2/content/admin/productlist.asp, line 87
Line 87 Highlighted below
Is it possible to open two recordsets for the same table without closing the
first one?
With Regards
Priti
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On 11 Apr 2001, at 11:16, [EMAIL PROTECTED] wrote:
Good morning,
Please,
I use MySql, I would use INTERSECT/UNION functions and they
don't work, I need help,
My query is :
select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
Entreprise E, Mot_Entreprise ME, Mot M, Categorie C where
1 - 100 of 109 matches
Mail list logo