it? Please give an example of the command you are
running.
James
Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm
trying to import the data from backup, into an empty table since the data
was corrupt.
Looks like you are on the right track now! :)
James
--
MySQL
the options for mysqldump.
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On 4/8/04 9:18 AM, Barry . [EMAIL PROTECTED] wrote:
Hi
I recently began to work through the Book entitled PHP MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
everything as said so in the book but i keep getting an error message. Here
is an outline
On 4/8/04 1:05 PM, Michael Stassen [EMAIL PROTECTED] wrote:
James McConnell wrote:
On 4/8/04 9:18 AM, Barry . [EMAIL PROTECTED] wrote:
Hi
I recently began to work through the Book entitled PHP MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
Thank you all for the responses. Looks like no one's had problems getting
5.0 running on the Mac. I'll be trying it after this weekend. If I have
any problems, you'll be hearing from me again! Thanks for all the info.
James
--
MySQL General Mailing List
For list archives: http
it.
Thanks, all!
James McConnell
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from here. I read through the
page, but there doesn't seem to be anything suggestive of my problem...
Can anybody pass on any hints on what I should be doing next?
Thanks,
~James~
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
On Mar 17, 2004, at 4:41 PM, Paul DuBois wrote:
At 14:06 -0800 3/17/04, James Hughes wrote:
I want to set up some automated table checking and the research I've
done has left me scratching my head.
I'm looking for a definitive answer to this thread:
http://marc.theaimsgroup.com/?l=mysqlm
!
-James Hughes
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this
right and what it means.
Any help would be appreciated...
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that could
help? I'm new to the MySQL arena as well.
Thanks,
James
Todd,
I'm also pretty new to MySQL and Linux but I have years of DB2 experience
on
various platforms.
I've bash scripts very useful and cron them when I have something that I
want to automate, such as a daily backup of my
InnoDB that you like, and not MySQL
specifically?
-James
-Original Message-
From: David Griffiths [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 03, 2004 10:28 AM
To: [EMAIL PROTECTED]; Mark Warner; [EMAIL PROTECTED]
Subject: Re: PgSQL vs MySQL
As a DBA and someone who has worked both
electroteque wrote:
well dude u never showed what the parser returned, i am pretty sure u need
curly brackets if u are including more than one line in an if statement
well dude u r like totally wrong.
--
jimoe at sohnen-moe dot com
--
MySQL General Mailing List
For list archives:
reference material also indicates I need to add a line to the
httpd.conf to give mod_auth_mysql the parameters it needs to connect to
MySQL:
Auth_MySQL_Info hostname user password
Is this right? Where in the httpd.conf should this be placed.
Any help would be great!
Thanks,
James
--
MySQL
this Index.
I thought this Index should be non-unique since I didn't specify the
UNIQUE keyword.
This table does not have a Primary Key either.
Kinda need help ASAP, so any ideas would be appreciated.
Thanks.
--
James Lamanna
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
:02:43 PM, James Lamanna [EMAIL PROTECTED] wrote
regarding Problem with indexes:
So I'm having issues with indexes in mysql 4.0
I issue the following:
Create Index Index1 on Table1 (ParentID,ClassID,Amount,Memo(20));
That works fine. However I'm running into problems when I'm trying to
insert
Yes.
[EMAIL PROTECTED] wrote:
I am assuming that the Memo field is a text datatype and you were
encountering the duplicate key bug.
Original Message
On 2/25/04, 3:28:58 PM, James Lamanna [EMAIL PROTECTED] wrote
regarding Re: Problem with indexes:
Found out that the problem was actually
Check the max_connections variable
Mysql show variables liks '%connection%';
-James
-Original Message-
From: Christof Egner [mailto:[EMAIL PROTECTED]
Sent: Friday, February 20, 2004 9:03 AM
To: [EMAIL PROTECTED]
Subject: Can't create a new thread (errno 11)
Hello,
I'm having
We have a job opening at MyPoints.com in San Francisco for a MySQL
database administrator/database developer.
We are building a new system from scratch with distributed and
replicated MySQL databases, Apache, Java, Linux.
Actual duties will depend on the particular skills and interests of the
to alias all fields. I'm lazy! Thanks.
James Hicks
sql mysql row query table column
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to alias all fields. I'm lazy! Thanks.
James Hicks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, from_line2,
from_line3, from_line4, from_line5.
James
mysql, sql, row, select, delete, from, *,
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How is 'next-key' locking correctly advertised as 'row-level' locking? I
don't actually see that InnoDB has row-level locking at all. Am I totally
wrong on that?
-James
Does it have exclusive and shared?
-James
-Original Message-
From: Chris Nolan [mailto:[EMAIL PROTECTED]
Sent: Monday, February 16, 2004 4:52 AM
To: James Kelty
Cc: [EMAIL PROTECTED]
Subject: Re: Locking
Hi!
Next-key locking essentially doesn't work on rows - it works on indexes
Try /usr/bin/safe_mysqld
The mysqld_safe is 4.0.x version.
Also, try reading the installtion instructions and check out the manual
online at mysql.com
-James
-Original Message-
From: Claritinet.com [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 15, 2004 11:28 AM
To: [EMAIL PROTECTED
Hello,
We have currently tuned MySQL for a high rate of traffic. But, now we are
seeing issues with memory usage. It reaches about 2GB and the server becomed
wildly unstable. Below is our my.cnf file. Can anyone point out any glarring
errors? We are running this on a Dell 2650 with Red Had
Andrew Iles wrote:
Is this the true behavior or does it just appear to work this way? And if
so, is there any way to force MySQL to automatically save data to disk in a
way that is chronologically correct? This would make it much easier for me
to recover from an unexpected crash.
What
Hey guys,
I was wondering if there is a converter for access databases to mysql or
phpmyadmin
I downloaded some stats files for my football league, but they are in
access,
Anyway I can convert them?
Karl James (TheSaint)
[EMAIL PROTECTED]
http://theufl.com/
--
MySQL General Mailing List
is checking (in intervals) the binlog positions
between the slave and the master. I am worried about this being out of
synch, for just about every 3 reads, there is a write. I am looking to
see if this is a good idea, and what others comments/suggestions are.
Thanks,
James
--
MySQL General
position)?
Also will this method actually remove load from the servers? Thanks for
your input so far.
Thanks,
James
-Original Message-
From: Mike Johnson [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 10:19 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Read Slaves
rmck wrote:
I have ip_address and ports that I want to use in my table. I was just going to make each one a varchar. But was wondering if anyone has a better suggestion?
Should I use int for ports, which will have an index. Not sure how to store ip_address.
Use a varchar for the IP address.
This statement works if I enter it directly into mysql:
UPDATE BEX_USER_REG_INFO SET STATUS_ID=5 WHERE
BEX_USER_REG_INFO.BEX_USER_REG_INFO_ID=2
Utilizing the openquery command I'm trying to do the same thing from a
MS SQL Server
SELECT * FROM OPENQUERY(MYSQLTEST, 'UPDATE BEX_USER_REG_INFO
Center?
Yes
Could you work on MySQL with both programs on at the
same time?
Yes
Thanks.
You're welcome.
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
intested in helping me out?
Please email me directly
Karl James
[EMAIL PROTECTED]
http://theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test
Karl James
[EMAIL PROTECTED]
http://theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hi - ive been playing with the OGC support for WKT but cant find data type size
constraints for GEOMETRY types. does anybody know what they are? Ive a polygon with
140,000 bytes as WKT but inserts all produce a NULL geometry...
any ideas?
regards
Programming today is a race between
Hello everyone,
I'm new to mysql so please forgive the basic question. I'm running redhat
8.0 with Mysql 4. The install was done with the mysql user. However every
time I try to get access, I get denied. Can someone tell me how to change
the password?
Thanks,
James
--
MySQL General Mailing
NOT NULL default '0.0',
associated_document char(30) NOT NULL default '',
PRIMARY KEY (office,ticket_id),
KEY move_id (ticket_id)
) TYPE=MyISAM COMMENT='Material Move Orders';
mysql --version says:
mysql Ver 12.20 Distrib 4.0.13, for pc-linux-gnu (i686)
What can I try now?
James Hicks
On Thursday 04 December 2003 03:42 pm, Stéphane Bischoff wrote:
Hi,
w do I know what my MySQL server IP is ??
thanks
How about ifconfig?
James Hicks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
test
Karl James
[EMAIL PROTECTED]
http://www.theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
list!
Your help would greatly be apprectiated, please email if you can help!!!
Karl James
[EMAIL PROTECTED]
http://www.theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does anyone use Microsoft access?
I need help with creating a query that will delete records,
If you can help me please email me directly!
Karl James
[EMAIL PROTECTED]
http://www.theufl.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Since moving to mysql 4.0.15 from 3.23.5x, I am getting a crash
once a week on an hourly run set of queries that are disk intensive.
# ./resolve_stack_dump -n /tmp/mysqld.stack -s mysqld.sym
0x8070640 handle_segfault + 420
0x8288108 pthread_sighandler + 184
0x80aca70 __9Log_eventP3THDUsb + 64
Ever since upgrading I haven't been able to use the 'mysql' command--it just
hangs. Otherwise, the database seems to be working properly. I even tried
rebuilding from source but it didn't solve the problem. I've attached
ktrace/kdump output of the problem. I'm hoping someone can interpret this
'mysql -A sampdb' hangs as does every other mysql command. There are no
recent entries in hostname.err.
-Original Message-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 5:52 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem
I should add that I can access the database via a java program, just not
using the mysql command.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The database is working fine, by the mysql command hangs indefinitely. Any thoughts
how I can determine the cause?
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Much to my surprise and chagrin, I'm having a problem using MySQL after upgrading to
the latest release of Mac OS X this past weekend. As far as I can tell, the server
seems to be running, but when I attempt to execute the mysql command it just hangs.
Any ideas?
Thanks,
jim
--
MySQL General
-
From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 4:42 PM
To: Anderson, James H [IT]; [EMAIL PROTECTED]
Subject: RE: problem with MySQL and latest release of Mac OX X (Panther)
Can you post you're my.cnf options / your query in question / how long
have you seen
. The system /bin/date command was correct
however.
We restarted the MySQL server and the time was corrected. I have looked
at 'most' of our other servers, and none of them (so far) has had this
issue.
I am just wondering if anyone else has seen this problem?
-James
signature.asc
Description
that
it's logging everything for every database.
Your help is appreciated!
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
this
problem ?
-
James Cradock, [EMAIL PROTECTED]
me3 Technology Consultants, LLC
24 Preble Street
Portland, Maine, USA 04101
207-772-3217 (office)
207-838-8678 (mobile)
http://www.me3.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
-u stw -p
...enter the password when prompted, and you're in.
- Jim
On Monday, October 13, 2003, at 11:20 AM, Stephan Wölfel wrote:
thanks for the advise.
What you tell all works. But even after this I still get the same
error 1045
when typing grant all on *.* to stw. Why ?
-
James Cradock
and type mysql to begin.
- Jim
-
James Cradock, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, start the Command Prompt from
Accessories, change to C:\mysql, and type mysql.
In Unix, including Linux, BreeBSD and Mac OS X, mysql ought to be in your
path, which means you should just be able to start a terminal application
and type mysql to begin.
-
James Cradock, [EMAIL PROTECTED
if, for examples, values in the records you are trying
to load contain tabs, new line and other special (to MySQL) characters.
Different options, and good examples, are documented for MySQL 4.x here:
http://www.mysql.com/doc/en/LOAD_DATA.html
- Jim
-
James Cradock, [EMAIL PROTECTED]
--
MySQL
I'm running OS X 10.2.8 and installed the latest OS X mysql package. The problem is
the server won't start and there don't seem to be any logs available to help diagnose
the problem. I've tried both
sudo safe_mysqld
Starting mysqld daemon with databases from
:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 10:54 AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem
James,
Hey James! I'm also running MySQL on OS X. Maybe I can lend a hand. First
question, are you running this on an X-Serve?
So you're doing
AM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED]
Subject: RE: Installation problem
James,
Yea, I have to agree its not starting.
Alright, you're probably already in the /usr/local/mysql or you would've
seen a nasty message reminding you to execute the mysqld_safe script from
mysql's directory
the ownership/group changes you suggest below and let you
know the results.
Thanks!
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE: Installation problem
Adam,
It works! I also had to run the initialization script...
Thanks very much for the help.
jim
-Original Message-
From: Fortuno, Adam [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 09, 2003 12:49 PM
To: Anderson, James H [IT]
Cc: [EMAIL PROTECTED] (E-mail)
Subject: RE
Is there one that's especially outstanding?
Thanks,
jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where can I find the configure string MySQL AB uses to compile their
solaris binaries?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
=tv.tv_usec*1000;\
}
uname -a shows: SunOS hostname 5.8 Generic_108528-21 sun4u sparc
SUNW,Ultra-60
Any help would be VERY appreciated!
- James Dennis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
From: James Sullivan
To: [EMAIL PROTECTED]
Subject:Can't install Mysql 4.0.15 on Redhat AS Beta 2
Description:
Can't install on Redhat AS Beta 2
Installing all prepared tables
/usr/bin/mysql_install_db: line 1: 2242 Segmentation fault
/usr/sbin/mysqld --bootstrap --skip-grant
.
Suggestions?
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is not a 0 works.
I have tried both
$tr_p1SUF = $_POST['phone1SUF'];
...SET phone1SUF = '$tr_p1SUF'...
AND
...SET phone1SUF = $tr_p1SUF...
I have tried changing the DB field types to char, int, text, varchar
Idea, suggestions?
Thanks,
James
--
MySQL General Mailing List
For list archives
Hi Matt,
Thanks. That did the trick.
James
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 11:34 PM
To: [EMAIL PROTECTED]
Subject: Re: INSERT/UPDATE number weirdness
Hi James,
Well if you used [VAR]CHAR/TEXT and then did the INSERT query
Does anyone think I would have better luck installing MySQL with something
other than an RPM??
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 11:59 AM
To: 'mos'
Cc: [EMAIL PROTECTED]
Subject: RE: random access denied
Thank you
: Wednesday, September 17, 2003 5:20 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: random access denied
At 03:09 PM 9/17/2003, you wrote:
Anything that anyone can suggest that might point me in some direction
would be very helpful. I'm just at a complete lose right now ...
James,
See
accept connections
all day long, but randomly it will just deny one, but the accept it on
the next try.
I've googled this problem to death, I don't know what else I can do
James,
Are you sure it's not something simple like exceeding the Max_Connections?
(Default is 100) I'm sure you've checked
Anything that anyone can suggest that might point me in some direction would
be very helpful. I'm just at a complete lose right now ...
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 3:58 PM
To: [EMAIL PROTECTED]
Subject: random
Look in /usr/share/doc/packages/MySQL-server/ for some example my.cnf and
find the one that works for you and copy it the /etc
Jamie
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:17 PM
To: [EMAIL PROTECTED]
Subject:
-Original Message-
From: James M Kupernik [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 17, 2003 4:35 PM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: RE: /etc/my.cnf config file doesn`t exist on my system
Look in /usr/share/doc/packages/MySQL-server/ for some example
Hello,
I am having a frustrating problem with MySQL. I don't consider myself a
newbie, nor am I a master, but either way I can't figure out this problem
and I'm hoping someone here has an idea of what is going wrong.
Every so often MySQL decides it doesn't want to authenticate a user, doesn't
|
+--+---+--+-+
5 rows in set (0.85 sec)
-James
On Wed, 2003-09-03 at 18:41, Paul DuBois wrote:
At 16:49 -0700 9/3/03, James Kelty wrote:
So, we have this table: ArpMon that looks like this:
-- mysql describe ArpMon;
++---+--+-+-+---+
| Field
I was wondering of there is a way to kill multiple processes in MySQL
rather than one at a time?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
) from ArpMon, I get 111 entries as well as
select am_rtr from ArpMon.
But! It I run select am_mac from ArpMon, I get the 27498 entries.
What's up with that? Can someone help me to figure this one out?
-James
James Kelty
E-Commerce / Financial Systems Administrator
Portland State University
basically making my webmail stuff crap out.
Should I just move the sessions away from the database?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Well, there isn't a my.cnf file, so other that setting the
max_connections with the -O option, it's whatever is default for
3.23.56.
-James
On Tue, 2003-09-02 at 10:50, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:37:34AM -0700, James Kelty wrote:
So, we have a webmail application
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure how to tell that, can you give me a
hint there as well? *look sheepishly around*...
-James
On Tue, 2003-09-02 at 11:06, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 10:58:03AM -0700, James
Ahhh! Ok, yeah the index file was 1.0k and the data file was 8.6M.
-James
On Tue, 2003-09-02 at 12:17, Jeremy Zawodny wrote:
On Tue, Sep 02, 2003 at 11:23:57AM -0700, James Kelty wrote:
Whoa, ok. Sorry. I didn't read the questions about the data and index
files. I'm, uh, not exactly sure
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote:
I need to access a database thru internet. It is secure to do this using
MySql?
If the database traffic is encrypted, yes. I do not know if that is an option in
Mysql.
If you did not do
help, just ask.
--James Hughbanks
Mikro-Data Engineering Dept.
[EMAIL PROTECTED]
1-866-457-6287
http://www.mikro-data.net
On Monday, Aug 18, 2003, at 05:49 America/New_York, Andrew Keating
wrote:
To whom it may concern,
We are having some trouble installing a MySQL database onto one of our
servers
.
Is there a way via MySQL Admin or the command line that I can transfer from
my machine to the server?
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:19 am 14/08/03, Jim Smith wrote:
I repeat. Why do you need the parentheses? Union queries don't require them.
Sorry, missed this.
They do need them if you want to use ORDER BY on the result of the UNION.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General
).
Suggestions?
Thanks,
James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Brian Austin says:
Have you read the following page in the Manual on their site?
http://www.mysql.com/doc/en/Linux.html
This gives you some tips to increase thread allocation. Especially
interesting is the part about the LinuxThreads hack.
That's where I started, and it's why I compiled my
) is considered a char to
remove, but since it's in the middle of the string, I don't understand why
it's being removed.
or you could fix or replace the trim function with one that does not remove
that data.
Is there a library of PHP user defined functions out there?
Thanks,
James
-Original
, thanks to everyone's help, I have it working now.
James
-Original Message-
From: Paul Chvostek [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 6:08 PM
To: James Johnson
Cc: [EMAIL PROTECTED]
Subject: Re: MySQL field data type for ISBN numbers
On Sun, Aug 10, 2003 at 05:25:05PM
INTO.
Is this a bug? I can't find it documented anywhere.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error)
CREATE TABLE Foo2 (SELECT * FROM Bar);
DROP DATABASE Foobar;
-- Cut Here --
Using MacOS so please forgive any errors due to case-sensitivity.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
is, why do the parentheses cause a syntax error and is this a bug?
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
At 10:28 am 14/08/03, Sergei Golubchik wrote:
It's in the 4.0.14 changelog, and thus, is available in 4.0.14
Hmm, I am using
Ver 13.5 Distrib 4.1.0-alpha, for apple-darwin6.4 (powerpc)
which I should have said in the first place, sorry. So it ought to be
working?!?
Jim
--
James Fryer
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 10 Aug 2003 17:25:05 -0700, James Johnson wrote:
$ISBN = $_GET['isbn'];
$query = SELECT * FROM book_details WHERE ISBN = '$ISBN';
Try using where isbn like '$ISBN'
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http
At 10:19 am 14/08/03, Jim Smith wrote:
Are you saying that any query containing parentheses fails?
No. Any query beginning with a SELECT statement in parentheses.
Jim
--
James Fryer / [EMAIL PROTECTED] / [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
table_name WHERE a=10 AND B=1 ORDER BY a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY a LIMIT 10)
ORDER BY a;
which is what I am doing.
The problem seems to be with the syntax of CREATE TABLE and INSERT INTO,
not the syntax of UNION.
Jim
--
James Fryer / [EMAIL PROTECTED
Hi Daniel,
Here's what is echoed back. It looks valid to me.
SELECT * FROM book_details WHERE ISBN = '1---1'
James
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 5:40 PM
To: James Johnson; [EMAIL PROTECTED]
Subject: Re: MySQL field
I'm baffled by reaching a limit of between 1456 and 1458 connections, at
which
point I can no longer make new connections. I've tried compiling my own
MySQL and using the stock MySql RPM's. I've experimented with ulimits,
values in my.cnf, and kernel parameters, and all the permutations of the
, should wrapping the variable (1--111-11)
in single quotes work?
If I change the data in the table to 'abcd' and run this query
$ISBN = 'abcd';
$query = SELECT * FROM book_details WHERE ISBN = '$ISBN';
It works.
PHP Version 4.3.2
mysql-4.0.14b
Thanks,
James
--
MySQL General Mailing List
701 - 800 of 1078 matches
Mail list logo