Hello guys,
Im kinda new at creating databases thru the command line
When I try to login using.
Mysql -h hostname -username -p
I get this message on command line.
C:\Documents and Settings\Karl Jamesmysql -h hostname -u username -p
-p;
'mysql' is not a recognized as a internal or exteranl
Message-
From: James Walters [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 9:42 AM
To: [EMAIL PROTECTED]
Subject: Basic Database Design Question
Hello,
DB novice checking in here with a basic design
question. I have a table called 'nms_apps' which
stores information about
Hello,
DB novice checking in here with a basic design
question. I have a table called 'nms_apps' which
stores information about all of our applications which
we have developed/maintained for our client. One
column which I would like to use is called 'used_by',
which would store information
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote:
I need to replicate data (approx. 10,000 records) from a mySQL database into
a different (non mySQl) database automatically on a regular basis. I have no
control over the mySQL server (apart from
--i-am-a-dummy
ref: http://www.mysql.com/doc/en/mysql.html
oO..\/ peace
James
-Original Message-
From: Mohammad Khan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:29 PM
To: [EMAIL PROTECTED]
Subject: Restrict UPDATE without WHERE
Is there any way to restrict UPDATE
still exists.
I could implement a perl script to just check the replication status, and
take necessary action to restart the slave if the SQL thread is down, but I
was wondering if a more elegant solution existed.
Thanks
James
([EMAIL PROTECTED]) [(none)] show slave status\G
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 18 Jul 2003 15:42:47 -0400, Chris Edwards wrote:
I have multiple OR logic in the where clause.
where id = 1 or id = 2 or id = 3
The list is finite, at about 20 ids.
You can also do this:
where id in (1,2,3)
- --
jimoe at sohnen-moe
went very fast!
James Hicks
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Slow batch load after 500MB
James E Hicks III [EMAIL PROTECTED] wrote:
I have encountered an interesting problem using
I'm trying to get both MySQL 3 and 4 running on the same machine, ideally
from RPM packages. The MySQL 4 RPM complains of a conflict with the
installed MySQL 3. Can anyone tell me if this installation is possible
from
RPM's, or will I have to compile MySQL 4?
--
MySQL General Mailing List
I'm trying to upgrade the glibc on some machines that do not yet have glibc2
in order to support 1000 threads. It seems that some of the instructions
concerning setting a pthread maximum for older glibc's are no longer
pertinent.
I wonder if the glibc 2.3.2 is known to be compatible with MySQL
am using PIII 550, RedHat 8.0, with 1G Memory and IDE Hard Disk.The
database is stored at ext3 file system. When I use show processlist for
the 2.2G indexs, it tell me Copying to tmp table.
James
[EMAIL PROTECTED]
_
The new MSN 8
index for 2.2G
table, the tmp index file is increased at the first phase. Any reason?
James
[EMAIL PROTECTED]
I have a MYISAM table, which is about 2.2G and 19,000,000 records.
When I
create indexs for it, I couldn't finish after 4 hours.
You mean it was still running? Was there still
the mysql_statements.SQL into smaller files and
consecutively loaded these files, the load only took 5 minutes top. Any ideas
what I can do to get these large files to load without breaking them down? Is
there a server config value I missed?
James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
umm... how do I specify which one? (this sounds really slow-poke
to me, sorry.)
Use either people.peopleID = some_specific_ID or models.modelID =
some_specific_ID.
- --
jimoe at
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 02:49:21 -0400, [EMAIL PROTECTED] wrote:
I don't understand how to morph the following with your specification:
SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
make, propID, addressIP, OS FROM people, make,
test (This time it worked)
make install
Can someone tell me what effect these two options (--config, --static) have
on the installation?
Thanks.
James Nallen,
NUI Maynooth,
Ireland.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
[EMAIL PROTECTED] \
/ Pantek Incorporated (877) LINUX-FIX /
\ http://www.pantek.com/security(440) 519-1802 \
/ Are your networks secure? Are you certain? /
\___9C80D881D4D379058537BE21F52F14FA6354C11AC57734FB___\
On Sun, 2003-06-01 at 21:21, James
root 16 May 26 07:04 libssl.so.2 -
libssl.so.0.9.6b
Is the answer as easy as creating a link to the b files?
Thanks for any help,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
out here?
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 30 May 2003 11:40:11 +1000, phieu huynh wrote:
The problem is my netscape browser, somehow the file had been corrupted.
I just re-download the file by using another computer and I can unpack
the file.
Yes, navigator can be twitchy about
|
+-+--++
| 1 | car1 | engine, seat, wheel|
| 2 | car2 | seat, doors|
| 3 | car3 | steering wheel |
+-+--++
TIA, JAMES
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 14:17:55 -0500, Peter Fleck wrote:
The results you wanted and the results you get were not very clear. Some examples
would have gone a long way.
SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants, dates
WHERE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID
2)
I know I this select is very simple, ...
So what's the problem?
- --
jimoe at sohnen-moe dot com
pgp/gpg
, James.
Example of existing system:
Table item
item_id - 1
item_desc - car1
Table item_TO_options
-
item_id
option_id
Data for Table item_TO_options
item_id | option_id
11
1... 2
1... 3
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote:
I can ask for the data in any data format, but I would like to get some
advice on what is best to ask for.
I have found text format to be the most flexible method for transferring
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 16:33:45 +0200, Anthony Ward wrote:
SELECT userid,subject,date,code FROM testing WHERE userid=testid
Use only single quotes.
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.net/en/
-BEGIN PGP
I second that
:-) My offering would be to suggest developing in Delphi or Kylix,
depending on the platform.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It seems that the union has problems when some values returned in the
selects are nulls like in left joines. Instead of seeing Nulls the rows
inherit the value of the previous row. Which make a real mess. I did how
ever found a work around. I use
coalesce(myfield,space(30)) as myfield
anywhere a
indexing. I suppose this is getting off topic, though. [grin]
Joe
UDMSEARCH is now mnoGoSearch. I pity the fool that is forced to run this
on Windows! It seems the linux version is GPL'd and the Windows version
is going to cost you. Ha ha...
James
sql, query
--
MySQL General Mailing List
=pword DB_2update /fullpathto/thefile.SQL
mysqlimport: Error: Can't get stat of '/fullpathto/thefile.SQL' (Errcode: 13), w
hen using table: thefile
For the filter.
sql, query
James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757-928-9000 ext 435
[EMAIL PROTECTED]
--
MySQL
Please ignore this this problem as I found the answer. For those inquring minds,
I added a -L to the mysqlimport command and we are all happy now.
James
-Original Message-
From: James E Hicks III [mailto:[EMAIL PROTECTED]
Sent: Monday, March 24, 2003 2:48 PM
To: Mysql
Subject
sql,query
You have written the following:
My code:
http://nopaste.php-q.net/8594
My site:
http://66.12.3.67/webdb/webdb13/assignment_1a.php
My goal:
http://66.12.3.67/webdb/webdb19/assign01/index.php
==
Can anyone help me get this resolved
linked in each table respectively. Is
there a simple way of doing this?
For what it's worth, I'm using MySQL 3.23.49 and accessing it from PHP
4.
Thanks,
James
-
Before posting, please check:
http://www.mysql.com/manual.php
To anyone that cares
I am looking for a bona fide distributed database system, like Oracle or
SQLServer, but open source running on Linux. I have found one, Backplane,
but as I understand it it is used for BSD Unix. If anyone can help it would
be much appreciated.
tx Jimmy the hat
why am i not able to select the browse link on mysql phpmyadmin to view
my table
ultimatefootballleague.com/index.php
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Hello all
I'm trying to work out how to import Checkpoint FW1 firewall logs into
mysql.
Each line of the logs consists of 27 space deliminated fields.
Of the 27 fields, I want to ignore about 11 of these fields when I do
the LOAD command on the log file.
I've already figured out I want to use:
to
help!
James E Hicks III
Noland Company
2700 Warwick Blvd
Newport News, VA 23607
757-928-9000 ext 435
[EMAIL PROTECTED]
For the filter (mysql MySQL SQL table row insert select delete)
-
Before posting, please check:
http
the tables this
way.
I'm using myql 3.23.49.
Anyone have any ideas?
James
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
a problem in Linux. However I don't know
how to fix this on Mac OS X Server 10.1.4. We are unable to upgrade to the
Jaguar release, and your site does not post binaries for OS X 10.1.4 Server.
Perhaps if there were some notes posted on how to properly build the
binaries, it may help.
Thank You
James
Quoting Jeff Kilbride ([EMAIL PROTECTED]):
What about just issuing a PURGE MASTER LOGS TO master-bin.007 on the master
and then starting the slave without a master.info file? I think that will
recreate it for you -- but you should research this before trying...
Works perfectly.
James
(sql
, it may be enough that the logs
(including the delete statements) end up on the slave. If your queries
against the no-deletes version are trivial, you may be able to just pipe the
log output through grep.
- James Moore
-
Before
rely on the current
behaviour.
Since you probably need to make a copy anyway, I wouldn't bother to worry
about what DBI may or may not do after a connection is closed. Seems much
safer to just assume that DBI owns the hash, and whatever you want needs to
be copied out.
- James Moore
of the binary log?
James
sql query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e
variables output the variable
have_raid? I do have the data directory stored on an external raid device,
however the variable is set to NO. Will this cause me any problems...
Thank you all so much for your help, MySQL is a great app, and I
apreciate all the hard work you have done...
-James
of this database, and when the load jumps users fail to authenticate.
Any help/sugestions with this matter would be great.
Thanks for your time...
-James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
sql sql sql
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
I am writing an Apache module that has to perform some queries against a
MySQL database. For the most part, it is working properly. However, when I
get an empty result set for my query (that is, the select returns no rows) I
get a segmentation fault when trying to call mysql_num_rows.
Here is
,
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED
What I want to do is display to the user a list of files that
require a
security level that is less than or equal to the user's
security level, with
formatted last name and first name and date if the file is
checked out.
Checked out by is a foreign key refering to username in the
systems
sys_nameID
Abrams 202
Patriot 544
Stinger 229
... and ...
new_req
proj_name ID
Test Bed Alpha 344
Tracked
Whenever I insert data that is
around 1 Megabyte in size, I get an error saying
MySQL server has gone away. It doesn't happen with
smaller data, and even if I change the column type to
LONGBLOB I still have this problem.
You've hit the default maximum packet size of 1 MB.
This is a protocol
mysql SELECT cell, sector,
If you only want one row, then selecting cell doesn't make any sense.
Cell is different in each row you've selected. If you only want one
row, don't select cell.
- sum(att) as att,
- sum(lc) as lc,
- sum(csh) as csh,
- ROUND((SUM( lc + csh ) * 100
Here's what I did. Based on the same query (the one you
provided) as below
I executed the following:
select mgrname, pjname from managers, projects, pocs
WHERE pjid = 'x'
AND pocs.pjid = projects.pjid
AND pocs.pmyid = 'x'
AND pocs.altid = 'x'
AND (pocs.pmyid = managers.pmyid OR
# Query_time: 17 Lock_time: 6 Rows_sent: 207550
Rows_examined: 207550
SELECT ID FROM sys_users;
If this is really the query that you want to do, there really isn't
much you can optimize. You're asking for every ID in the table,
so MySQL has to examine every row, and send every row.
You
Hello,
I have a table with the following structure and values:
CustomerIDScore
4 8
2 6
3 2
3 8
4 7
2 7
I would like to query for the top
I've been using mysql for a while now, but haven't yet been able to figure
out what the
domainname-bin.001, .002, .003, etc. files are listed in the /var
directory. They seem to get completely out of control sometimes (I usually
go through and delete them daily - after deleting and re-creating
So, apparently, you don't need to be a member of this list to send mail to
it? What a great idea!
-Original Message-
From: The Certain Way [mailto:freedom4u3233118;aol.com]
Sent: Wednesday, October 23, 2002 4:21 PM
To: [EMAIL PROTECTED]
Subject: Great news mysql , your $8000 per month
Here's a little thing I wrote a while ago on how to do this so I wouldn't
forget. There are probably better ways to go about this - If anyone knows
of any so I could update this thing, please let me know.
http://www.hatesville.com/~jtx/apache.txt
This is how I usually set up my installations
this large before, and am not a
professional DBA in the least. Just looking for some suggestions here on
how to handle this. Thanks for all your help.
James Taylor
-
Before posting, please check:
http://www.mysql.com
On Sunday, October 6, 2002, at 01:53 AM, James Riordon wrote:
Have you tried monitoring server B via 'top' or something and see what
processes are taking up CPU time and/or swapping.
Hello,
I have monitored top for a bit. It is definitely MySQL-Max that is
taking up the CPU
kind of boring. More tomorrow.
Thanks by the way to everyone who has given some good suggestions.
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
-34)
I have also tried a machine with of similar build to Server B with a
freshly built kernel 2.4.18-10. Same results as Server B with the
2.4.9-34 kernel.
James
James Riordon wrote:
Hi,
I have two servers.
Server A:
Dual 1GHz processors
1GB of RAM
MySQL
At 15:53 +0100 10/06/2002, Andrew Braithwaite was thought to have said :
Hi James,
What kind of disks are in the old system and the new system (scsi or ide,
any raid, what rpm do they have etc..?) I ask this because high cpu levels
can be a symptom of a diskbound server...
Try running
At 11:17 -0500 10/06/2002, I whispered:
-Original Message-
From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 9:04 AM
To: James Riordon; [EMAIL PROTECTED]
Subject: RES: Re: Server comparison running Mysql
Another thing... I noticed once when
mysql at this point. Someone
suggested the Kernel, but I fear it is the lack of an extra processor.
J
James Riordon wrote:
Have you tried monitoring server B via 'top' or something and see what
processes are taking up CPU time and/or swapping.
Hello,
I have monitored top for a bit
be greatfully accepted.
Thanks
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe
=2M
set-variable= write_buffer=2M
[myisamchk]
set-variable= key_buffer=128M
set-variable= sort_buffer=128M
set-variable= read_buffer=2M
set-variable= write_buffer=2M
[mysqlhotcopy]
interactive-timeout
Thanks
James
Bhavin.
- Original Message -
From: James Riordon
, and NOT stopping itself?
Thanks!
-James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED
believe that my permissions are ok. Can anyone point me in another
direction to turn?
MySQL Version 2.32.51
Thanks!
-James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Thanks to those on the list that looked into it. Apparently the
developer was trying to do an insert on a read only connection.
Damn.
Thanks again!
-James
On Wed, 2002-10-02 at 11:26, James Kelty wrote:
sql,query
Ok, this is a little weird.
From system A I can access the Database
that is hogging resources, I'd like
to be able to kill that query so everyone else can get on with life. How is
this, if it can be done, accomplished?
Thanks!
-James
-
Before posting, please check:
http://www.mysql.com/manual.php
mysql ,
My dear,
Good day, I wish to introduce myself to you. I am Lt. Col. James Kadeh, (rtd.).
I am the personal assistant to President Laurent Kabila of Democratic Rep. of Congo.
I got your contact information from your country's information directory over the
internet during my
if correct. Any other reason that this is failing?
-James
sql query
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488.0801
-
Before posting, please check:
http
Apparently I had list File permissions with my user. Thanks anyway.
-James
-Original Message-
From: James Kelty [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Replication Problem
Hello,
I have this replication problem. I am getting
Hello,
Does anyone know, off the top of their head, what server_errno=1159 on a
SLAVE means? Replication is working, but I just want to know what that is.
Thanks.
-James
sql query
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED
Thanks alot!
-James
-Original Message-
From: Oscar Rylin [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 16, 2002 3:05 PM
To: 'James Kelty'; [EMAIL PROTECTED]
Subject: RE: Server Error
http://www.geocrawler.com/archives/3/8/2002/6/0/9054036/
/ Oscar Rylin
-Original Message
Hello,
Is there a compile option or startup option to make mysql ignore table name
case? So that the tables security and Security would be seen as the same
table?
-James
James Kelty
Director of Operations
Everbase Systems, LLC
624 A Street
Ashland, OR 97520
[EMAIL PROTECTED]
541.488.0801
Well, I guess that ISN'T really the case.
http://www.mysql.com/doc/en/Name_case_sensitivity.html
Sorry that I asked the question at all, but thanks for the replies.
-James
-Original Message-
From: Nilesh Shah [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 10:20 AM
To: James
On Thu, 1 Aug 2002, Ralf Narozny wrote:
Hello!
James MacLean wrote:
Hi Folks,
Have only known enough SQL to do what we needed.
Today on mysql-3.23.51 we found out that :
select something from table where index1 = 'value' or index2 = 'value';
Runs considerably slower than:
select
values, which might or might not work for
your situation.
Hope it helps.
James
-Original Message-
From: Michael Zelina [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 01, 2002 10:40 AM
To: Brent Baisley
Cc: [EMAIL PROTECTED]
Subject: Re: maximum number of columns max row size
Hi
|
+---+--++--+-+--+++
| user | ALL | PRIMARY,aliasid,userid | NULL |NULL | NULL | 107891 | where used |
+---+--++--+-+--+++
1 row in set (0.00 sec)
JES
--
James B
Hi,
If this is trivial, please bare with me:
How do I alter a table in Sql to add a column
which is the multiple of two existing
columns:
A Table has columns a,b,c and I want to
add column d which will be b*c
Many Thanks
Beginner
There didn't seem to be any responses to this question last time I posted.
So I'll try again. Does anyone know where to locate mysqlimport logs, if
there are any?
TIA
James
-Original Message-
From: James Ching [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:54 PM
to the
table after altering it
to the MyISAM type, replicate? What am I missing. I would really like the
replication to work well
with InnoDB types instead of MyISAM.
Please, can someone point me in the right direction?
Thanks!
-James
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
for this at all? Replication is REALLY key here, as
is InnoDB. (We need the foreign keys, and transaction support, as WELL as
replication). Thanks a lot to anyone who replies!
-James
P.S. I am STILL looking in the doc's, but I just thought that I would ask!
Thanks again! sql query (to satify spam
to the rescue! It errored out (as you would expect). Thanks for all
the help!
-James
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 13, 2002 1:11 AM
To: [EMAIL PROTECTED]
Subject: Re: Error 150 on 3.23.51
James,
- Original Message -
From: James
create table './everbase/#sql-955_b.frm' (errno: 150)
I found references to a bug that was fixed in .51, but I can't find anything
as to what is going on. We think we have the syntax right, but some help
would be appreciated. Thanks!
-James
P.S. I also included my my.cnf file as well
This is not specific to MySQL (probably) but I thought this wizened
community might have a definitive answer.
Take this simple grouped select:
SELECT Value1,Value2 FROM Table1 GROUP BY Value1,Value2
Value1 Value2
---
Joe Red
Joe Blue
Joe Green
Jim Red
Jim
/per0xide/mysql-3.23.49'
make:*** [all-recursive-am] Error 2
i have tried it with 3 different versions.. 3.23.49, and 2 of the older
versions... and they all crash the same way...
i am running debian 2.2...
anyone know what the problem could be, and how i can fix it?
Thanks,
James Thogmartin
Philip Spradling wrote:
I'm trying to link libmysqlclient into a C/C++ program using g++.
But I get the following errors:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0xaa): undefined reference to 'uncompress'
:
gcc 2.95 (minGW distribution)
MySQL Ver 11.15 Distribution 3.23.38 for Win95/Win98
Windows NT 4
Regards,
--
David A. James
Statistics Research, Room 2C-253Phone: (908) 582-3082
Bell Labs, Lucent Technologies Fax:(908) 582-3340
Murray Hill, NJ 09794
;
$qry.=FROM $this-table ;
$qry.=WHERE module = '$module' ;
$qry.=ORDER BY date ASC;
Get rid of the as date from your sql query. I think that should
make it work the way you want.
James
-
Before posting
=0);
?
Best regards,
James
--- Jay Blanchard
[EMAIL PROTECTED] wrote:
Howdy,
I need to write some data out to Excel spreadsheets
for some of our managers
to muddle with for projections. The query works
fine...
SELECT RecordID, RecordDate, count(*) AS Quantity
FROM tblFOO
Group
Mysql-front is v.good, www.mysqlfront.de i think.
james
Jerry wrote:
Does anyone know of a good color coded SQL editor for MySQL that
works in Windows?
TIA,
Jerry
-
Before posting, please check:
http
Hi Nick
It'll be something like:
/usr/bin/safe_mysqld --defaults-file=/etc/my.cnf --skip-grant-tables
Cheers
james
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi everyone,
I have searched the archives and read the manual but am at a loss as to
how to get my root
It's OK Nick - it started. It's just writing that to the terminal
window. Hit enter to get the command prompt back (or ctrl-c if that
doesn't work).
james
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then James Carrier declared
It'll be something like
Ah...
Do you have permissions over the mysql directories?
Can you start safe_mysqld as root? (purely for problem solving
purposes ;)
And of course - are your databases in /var/lib/mysql?
james
Nick Wilson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Gerald Clark
Hi All,
I have over 68,000 records in a table with unique ID
field that has 10 chars. Need to create a query to
find all matching or duplicate IDs up to 8 chars.
(Eg. 12345678%%)
Can anyone help me?
Thanks in advance for any comments.
James
id
FROM my_rank
WHERE id LIKE \$id%\
GROUP BY id
HAVING COUNT(*) 1
;
$result1 = mysql_query($query);
while ($row = mysql_fetch_array($result1))
{
echo $row[id]br;
}
}
?
Best regards,
James
--- Jay Blanchard
[EMAIL
801 - 900 of 1078 matches
Mail list logo
