data_teams
data_games
Ron
On 10/10/15 10:28, Richard Reina wrote:
If I were keeping tract of high school sports statistics and thus designed
the following tables:
sports, rules, statistical definitions
and
players, teams, games
Would it be a good or bad idea to put the first set of tables in a
On 29/09/15 13:01, Richard Reina wrote:
If I have three simple tables:
mysql> select * from customer;
+++
| ID | NAME |
+++
| 1 | Joey |
| 2 | Mike |
| 3 | Kellie |
+++
3 rows in set (0.00 sec)
mysql> select * from fruit;
++-+
| ID | NA
The only way I could see this work would be to write forms to a temporary
text file array. Then using a cron job to update the database.
On Thu, January 8, 2015 10:01 am, bruce wrote:
> hey.
>
> within php (or any other language)
>
> is there a way to create the mysql sql, and execute the sql, wh
ropriate_content_flag_moderator_comments` longtext COLLATE
utf8_unicode_ci NOT NULL,
`inappropriate_content_flag_moderator_review_date` datetime NOT NULL,
`views` bigint(250) NOT NULL,
PRIMARY KEY (`reference`)
I appreciate any help you are able to give me.
Ron Piggott
www.TheVerseOfTheDay.info
other
node(s) (Arbitration error)
when i start the ndb again, it will run for some time (a day or two)
then just dies again.
hope anybody can help, this has been bugging me the whole week.
regards
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
::createAsyncFile
Program: /usr/sbin/ndbd
Pid: 13388
Trace: /var/lib/mysql-cluster/ndb_4_trace.log.8
Version: Version 5.0.51
I have tried increasing MaxNoOfOpenFiles by 100, i started at 500, i'm
now at 1200 and i'm still receiving the error.
Regards
Ron
--
MySQL General Mailing List
For lis
ption values:
ALTER TABLE tbl_name MAX_ROWS=xxx AVG_ROW_LENGTH=yyy
but, currently i dont have the table yet, i'm just trying to create a
new table and i get that message? any clue? TIA.
Regards
Ron
Carlos Proal wrote:
This might help
http://dev.mysql.com/doc/refman/5.0/en/repair.html
Carlo
Hi All,
why do i have this error. i have recently setup a mysql cluster, i now
have around 60 tables on it. when i create a new one, it gives me this
error.
ERROR 1005 (HY000): Can't create table './mydb/#sql-3e87_24c9a5d.frm'
(errno: 135)
any idea? TIA!
Regards
Ron
-
Hi Peter,
Thanks for your help. I now created a trigger that would do an insert on
another table on what changes has been made to the other table.
another question is, is it possible to get the host from where the
update request came from from the trigger?
Regards
Ron
Peter Brawley wrote
updated but i could
not tell where or when. thanks in advanced.
Regards,
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
t
want to queyr the cdr table all the time and compute how much.
thank you
regards,
ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
how can make it that the result is without
duplicate, which in this case should be 2 rows. TIA.
Regards
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
|
--
Hi,
How can i count by countrycode with that table? I kind of need a summary
to count how many calls went to certain country. Thank You. I hope my
question is clear.
Regards
Ron
#x27;) and
INET_ATON('%192.168.0.2%');
For instance I know this IP (192.168.0.1) is in 14 different records, what I
was hoping for is
a result like so doing a wildcard search for any IP in this text field.
+--+
| id |
+--+
| 66 |
| 148 |
etc..
14 rows in s
#x27;) and
INET_ATON('%192.168.0.2%');
For instance I know this IP is in 14 different records, what I was hoping for
is a result like so:
+--+
| id |
+--+
| 66 |
| 148 |
etc..
14 rows in set (0.01 sec)
Any other ideas on how I could do this?
Ron
--
l the first
process has closed the file. Been bit by this a few times. Could this be the
case here?
Thanks,
Ron.
"The software said to install Windows 98 or better... So I installed linux."
"Friends don&
bet it is simple.
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Found the problem. For some reason, error messages where being sent to
hohup.out, once I found that I discovered I was using an option in
my.cnf that is not supported on 3.23 (I use 4.1 on my other server).
All is well now. Thanks for the help
Ron
On Apr 29, 2005, at 6:47 AM, Gleb Paharenko
After almost a year of being up, my RH9 server lost power and rebooted.
When it came back up, mysql was not running. I went in and ran
safe_mysql to start it back up (I also tried the init.d script) but it
failed to start. No errors, nothing in the log. After some
investigation, it appears
I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
full-text search be done for IP numbers?
If so could you show me an example query?
Thanks
Rob
Season_RID, Show_RID, and Show_Name. osc1_company has First_Name, Last_Name,
and RID. Cast has RID, Role, Show_RID. Production_team has RID, title,
Show_RID.
Any help folks could give would be hugely appreciated. Been working on this
for quite a while now.
Thanks
Ron
Shows has
Season_RID, Show_RID, and Show_Name. osc1_company has First_Name, Last_Name,
and RID. Cast has RID, Role, Show_RID. Production_team has RID, title,
Show_RID.
Any help folks could give would be hugely appreciated. Been working on this
for quite a while now.
Thanks
Ron
If you are using 4.1 or later, you could do a subquery to count the
clicks,
then left join that with the views.
I am using 4.1. I tried to do a sub-query, but never got it run. Can
you give me a quick example? Is the sub-query a better (faster) way to
do this?
Ron
On Dec 6, 2004, at 6:19 AM
Views` (
`AdID` int(10) NOT NULL default '0'
[snip]
)
CREATE TABLE `Ads` (
`ID` int(10) NOT NULL default '0'
[snip]
)
I have tried a lot of combinations for LEFT JOIN with no luck. I've
read all the posts on this list and they don't seem to be doing what I
am, or
What do most people use for a report designer for linux? I need to design a
report similar to a
phone book directory, ie, multi-column with page breaks when the first letter
of the field changes.
Thanks,
Ron.
"To really screw up Linux you have to work at it...To really screw up Wi
No, I did not see the reply, sorry, I just saw the original message.
I got 4.1 from the debian site, 4.1 that is on the mysql site is a RPM
and I've had no luck installing rpm's on debian, even using alien.
Ron
On Oct 31, 2004, at 12:02 PM, Michael Stassen wrote:
If you're ta
mutex error and only find one hit with someone
experiencing the same problem I am having and no solution.
Any ideas? I'm new to debian, BTW.
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks, that did the trick.
On Aug 17, 2004, at 12:34 PM, [EMAIL PROTECTED] wrote:
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
entries
that had the last 10 comments, but there are duplicates. For example,
if entry "A" just had 3 comments added, it gets return as the first 3
results, not just once. I assume the DISTINCT is failing because of
the ORDER. How should this be accomplished? I am running 3.23
T
I now have mysql running on my Mac OS X 10.3.4 box.
The socket file is now being created correctly in my
/usr/local/mysql/run directory.
Thank you for all your help.
Regards,
Ron Phelps
--- Ron Phelps <[EMAIL PROTECTED]> wrote:
> 1. I re-examined the error messages in conf
Thanks for any suggestions and for the help to get me
this far.
Ron
--- Ron Phelps <[EMAIL PROTECTED]> wrote:
> I executed the following preparation work:
>
> 1. Upgraded Mac OS X 10.3.1 to 10.3.4
> 2. Installed two additional security updates
> 3. Examined the status
to flush it, and
start over with a clean setup - which of course raises
the question how to clean up the current environment
correctly in order to start over.
Thanks for any suggestions.
Ron
configure:2913: checking for gcc option to accept ANSI
C
configure:2974: gcc -c -O3 -fno-omit-frame
. I'm
wondering if the Mac OS X 10.3.1 client needs
additional development files (libraries, etc.)
installed because my box is the standard setup shipped
from Apple.
Thanks for any suggestions.
Ron
configure:2913: checking for gcc option to accept ANSI
C
configure:2974: gcc -cconf
I am going to upgrade my MySQL server from 3.23 to 4.1, but I have a C
program that needs to continue to connect to the new server, and it
can't be recompiled. Is the old API 100% backwards compatible with a
4.1 server? I assume the performance is the same?
Ron
--
MySQL General Mailing
t I want it returned like:
192.168.0.1
Can my select statement do that for me?? Or should I use php when the data
is
printed.
I was hoping to do it with mysql since the db server as much more memory and
cpu power...
Thanks
Ron
Db info:
mysql> create table june04 ( src int unsigned);
Query OK, 0 ro
Is there any benefit to having the .MYD files on one drive, and the .MYI on
its own dedicated hard drive??
rm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
return them all to me in the right order, if possible.
Thanks, Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
When you connect to a MySQL server remotely (from the C API, in my
case), is your MySQL password sent in clear text?
I've looked but I can find an answer to this question in the
docs...maybe I'm missing it.
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
th it.
Other than whats in the docs, are there other issues to think about when
upgrading from 3.23? Can I go straight from 3.23 to 5.0? According to
the docs, it just seem to be the GRANT tables.
Ron
Josh Trutwin wrote:
On Sun, 16 May 2004 13:51:29 -0700
Ron Gilbert <[EMAIL PROTECTED]>
I'd stick to 4.0.18.
What I would really like is go to 5.0 (for stored procedures), is 5.0
stable enough for casual use?
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
s 15 or 20 minutes to run though a 10K to 20K GPS track
logs. This seems too long to me. I took out the INSERTS to just to
make sure it wasn't my PHP scripts, and they run in a few seconds
without the MySQL calls.
Ron
--
MySQL General Mailing List
For list archives: http://lists.
dents from
happening.
Does any of this make sense? Am I missing something obvious?
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ve a query only
pay attention to the DATE part of a DATETIME or TIMESTAMP column?
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ning.
Does any of this make sense? Am I missing something obvious?
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
is is running on RH9, but will be moved to a FreeBSD
server in the near future.
Thanks, Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
done online, and I assume it uses mysql's spatial extensions am I on
the right track here?
Any help much appreciated.
Thanks
Ron
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.614 / Virus Database: 393 - Release Date:
ments pertaining to the
other databases, from which they can gather information I would rather they
not see.
So my question is - can one instance of mysqld maintain multiple binary
logs, specific to each database, or would I need separate instances of
mysqld for each database?
TIA
Ron He
clicks update second
user b's line is added/appended to record 5, user a's line is overwritten
not even seen.
Ron
-Original Message-
From: Batara Kesuma [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 17, 2004 4:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Do I n
about innodb that it will handle updates with out specifying
begin; commit;?
"UPDATE ... SET ... WHERE ...: sets an exclusive next-key lock on every
record the search encounters."
Or in my php do I need to ;
BEGIN WORK;
update statement;
COMMIT;
Thanks
Ron
--
MySQL General Mailin
I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.
This works with LOAD DATA INFILE :
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES"
but when i try:
mysqlimport --ignore-lines=2 -uro
until the new month.
Has anyone else had mysql db data files on a Netapp or nfs'ed? and if so
could they share there config tips? Also any Mysql my.cnf tips, I basically
used the my.huge.cnf file.
Thanks,
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
At 01:26 PM 12/3/2003, Chuck Gadd <[EMAIL PROTECTED]> wrote:
This is your standard "I am not a lawyer" type answer, because reading
the text of the GPL can be overwhelming, but the way I understand it,
if you are shipping MySql with your app, then you've either got to
release your app under the GP
Thats seems like a bug to me.
I would think FROM_UNIXTIME would take a unixtime stamp
and covert it to what it is. We know its from GMT
UNIX timestamp =
The timestamp is the current time measured in the number
of seconds since
the Unix Epoch (January 1 1970 00:00:00 GMT).
Ron
-Original
(0.00 sec)
Any ideas?
Ron
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:30 AM
To: Ron McKeever; [EMAIL PROTECTED]
Subject: RE: unixtime update syntax
The time zone matters... your results are exactly 8 hours off... PST is
gmt -8.
read:
2003-12-01 16:36:00
2003-12-01 15:36:00
Does it matter if im on the PST if I get the data from GMT???
Help
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
|
+---+--++-+
| 1 | test | 1070296560 | 2003-12-01 08:36:00 |
| 2 | test | 1070292960 | 2003-12-01 07:36:00 |
+---+--++-+
2 rows in set (0.01 sec)
the urtime I thought should read:
2003-12-01 16:36:00
2003-12-01 15:3
[EMAIL PROTECTED] 5554321 1-112403
Bunny [EMAIL PROTECTED] 5554331 2-112403
name [EMAIL PROTECTED] 5554341 3-112403
[EMAIL PROTECTED] 5554351 4-112503
Thanks,
Ron
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 5:30 PM
To: MySQL
readable.
My question is:
Should I create this column "begin" as "DATETIME, DATE, or TIMESTAMP" or
since I'm converting the unix time leave it as a varchar???
Thanks,
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
start);
I issue I'm trying to figure out is I dont want this update command to run
on rows that have already been
converted. What would someone suggest? thanks
Ron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Has anyone gotten this to compile, and if so can you point me in the right direction
of the library?
Thanks
td::reverse_iterator'
c:\AMS_Build\AMS_Server V2.0\Libraries used in
AMS\MySQL++\sqlplus\fields1.hh(10) : see reference to class template instantiation
'const_subscript_container' being compiled
with
[
OnType=MysqlFields,
ValueType=My
I would like to use MySQL++ in an application I am writing in Visual Studio.NET 2003.
Does anyone out there have or could point me to a zip of the source that could easily
be compiled for this purpose. The VC++6 one gave me 157 errors, which would be a bear
to track down.
Thanks!
Ron Ohmer
I am receiving a "Segmentation Fault" error when closing the connection to a
database. Using MySQL 4.0.10-0 on Redhat linux 7.3
static void closeDatabase( DBMS_STATE_INFO *dbmsInfo )
{
mysql_close( dbmsInfo->connection );
dbmsInfo->connection = NULL;
}
Th
Using MySQL 4.0.10-0 on Redhat linux 7.3
./libmysqlclient.a(my_compress.o): In function `my_uncompress':
my_compress.o(.text+0xaa): undefined reference to `uncompress'
./libmysqlclient.a(my_compress.o): In function `my_compress_alloc':
my_compress.o(.text+0x13c): undefined reference to `compre
the "tmpdir" setting in my.cnf.
e.g.:
tmpdir = /usr/tmp/
Ron Jamison
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
D] ' (Using password: YES)
* SQLState: 28000
* Vendor Info: 1045
I don't get an error if I use, with the same password: "serf@'myhost.com'"
Anything else I should be looking at? Thanks.
-ron
--
Ron Parker
Software Creationshttp://www.scbbs.
'%' with the
hostname of the client from which I am executing the sql query. The
MySQL documentation seems to say that using '%' will allow access to a
table from any host on the Internet, but my tests don't seem to bear
that out. Am I missing something here? Thanks.
have to keep track of the row ID (which would be the primary
key in this example).
Nice to see quiz software being built by an .EDU!
Ron Jamison
-Original Message-
From: Jule [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 5:27 PM
To: [EMAIL PROTECTED]
Subject: Alter table and ad
Forgive me if I've missed something in the
manual pages; I've always had to do two SELECTs and thus have been
looking for a quick[er] solution to this for some time now.
Thank you in advance!
Ron Jamison
(moderators: although I've looked at the manual page plenty of times
before,
ha.html), using Compaq's
compilers, but as those instructions are optimized for the EV6 I am left
thinking there are better/different optimizations for the EV56.
Thanks in advance!
Ron Jamison
-
Before posting, p
While I haven't tested this, you might try something like...
mysqldump -h -u -p | mysql -h -u
-p
or, share out and NFS mount the new system's partition to the old system
and do a dump that way.
Just a few thoughts,
Ron
Richard Idalski wrote:
>
> I have before
If you need to do a join:
http://www.mysql.com/doc/J/O/JOIN.html
However I don't see much logic in what you're doing. Stats should not
include information that exists in another table, such as name and team.
You need to decide what information will be unique (such as player
number) or come up
I have a Raq4 running with MySQL + php no problem.
Save yourself a great deal of time by loading the packages available
from:
http://pkgmaster.com/
These Cobalt support team guys maintain security update and misc.
packages which, for the Raq 3 and above, happen to include PHP and
MySQL. I hig
26, 2002 2:36 AM
To: <[EMAIL PROTECTED]>
Subject: Re: Trapping for no user input in a query
G'day Ron, all
> Tailor your query to the request of your user(s).
> if ($param1)
> $sql .= "(ad_copy) against ('$param1')";
> if ($param1 && $param2)
Tailor your query to the request of your user(s). I.e. if only one
parameter was passed from the form only match against one field.
E.g.:
$sql = "SELECT ID, publication,run_date,left(ad_copy,40) as
Advertisement FROM classifieds WHERE MATCH ";
if ($param1)
$sql .= "(ad_copy) against ('
To answer your question I don't think the fabled price slash of Oracle
will have any impact on MySQL or its community. Surely you can
understand that since this is a mailing list, any posts of such
titillating rumors will get a large response.
I'd also like to add that after having used MySQL fo
I agree; theres no reason to use anything but phpMyAdmin for database
maintenance over the web. The guys at phpwizard.net keep adding more
and more features which strengthen its position as THE package to use
for this application. I wouldn't use anything else.
$0.02
-Original Message-
Or simply create a symbolic link as suggested in the documentation:
ln -s /usr/local/mysql-3.23.49a-pc-linux-gnu-i686 /usr/local/mysql
cd /usr/local/mysql
./bin/safe_mysqld &
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 2:46 AM
To: [EM
c/T/a/Table_maintenance.html as it has saved my
own data numerous times.
Good luck,
Ron Jamison
-Original Message-
From: Andy Woolley [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 23, 2002 2:44 AM
To: [EMAIL PROTECTED]
Subject: datafile.MYI has been destroyed & can't recover
Hi,
I&#
And/or
whether I'm supposed to execute these manually from
a console prompt or have them run automatically at
boot and shutdown.
Thanks in advance for your help.
Ron Swanson
-
Before posting, please check:
http://www.
I need to store large files in a MySQL database (in Windows). To do
this, I have created a table that has a BLOB column. How can I insert
the files into this table?
Thanks,
Ron
-
Before posting, please check
o use PHP to
solve the above problems. Is there any way that this could be
accomplished?
Thanks in advance for any advice that you might have.
Ron
-
Before posting, please check:
http://www.mysql.com/manual.php
o use PHP to
solve the above problems. Is there any way that this could be
accomplished?
Thanks in advance for any advice that you might have.
Ron
-
Before posting, please check:
http://www.mysql.com/manual.php
by
number. Remember, as text, sort order would be 1, 10, 11, 2, 21, 22,
etc...
Regards,
Ron
Vishakha Mali_Wagh wrote:
>
> Hi all,
>
> I have been using mysql since long time. But suddenly I noticed that, there is no
>function for sorting intervalues from the tabel.
> Clarifying m
I am not familiar with cron. Could you expound? Is it Unix or Windows
based? Where can I get it?
Thanks,
Ron
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 7:33 PM
To: Jeffrey Lomas; [EMAIL PROTECTED]
Subject: Re: scheduling tasks
When working with normal connections i.e. non-persistent months ago, using
what must've been PHP 4.0.1 or .2, I had some similar experiences.
In a number of my more lengthy scripts I was seeing MySQL connections
closing on me before the script was done executing. Thus PHP would spit out
errors a
I don't think theres a MySQL function to return the number of times a phrase
appears inside a field.
Another way you could achieve the same goal:
SELECT field FROM table WHERE field LIKE '%word%word%word%'
^-- would match on three occurences of 'word'
If you need a count of the number of times
I'm fairly sure there's no difference in performance when using PHP tags
mixed with HTML blocks as you are doing.
Think of it as PHP knowing that it should send everything not in tags
directly to the browser. Like an echo or a print, but without needing to
specify calls to those functions.
nux binary distribution: Core dumped on
AlphaServer 1200
Robert Alexander <[EMAIL PROTECTED]> writes:
> >Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
> >
> >> Ron Jamison writes:
> >> > Using MySQL 3.23.46 from:
> >> >
> >> &g
Tack on a "LIMIT 1" on the end of your query to limit the returned rows to
1.
Reference:
http://www.mysql.com/doc/S/E/SELECT.html
-Original Message-
From: Steve Osborne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 13, 2001 12:47 PM
To: MySQL (E-mail)
Subject: SELECT'ing only 1st
?
What steps did the MySQL team take to get sql-bench running on the alpha EV6
machine? I'd prefer to continue using sql-bench as its easier imho than
installing a 3rd party benchmark app.
Thanks,
Ron Jamison
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
of the week
no matter what compile flags you used ;).
Any and all suggestions are welcome.
Thanks in advance!
Ron Jamison
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.co
cuted again and the information is duplicated in
the temporary table. Is there a way to leave 'tbl' and its data alone if it
exists?
___
Ron Bickers
Logic Etc, Inc.
-
Before posting, please check
another
database to learn and care for.
Any suggestions and links would be greatly appreciated.
Thanks & regards,
Ron
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
main.cc: In function `void if_conn()':
main.cc:464: no matching function for call to `MysqlConnection::clinet_info
()'
main.cc:529: no matching function for call to `MysqlConnection::clinet_info
()'
make: *** [main.o] Error 1
I am using mysql++-1.7.9, and do not see any references to clinet_in
convert everything to pennies and use integers?
Aaron Clausen wrote:
>
> I've been having some problems with currency calculations in SQL queries.
> I've been using Double, but often get some very small rounding errors. What
> is the recommended column type for currency in MySQL?
>
> Aaron
>
I've always used the following...
mysql -h -u -p
and it's worked pretty well for me.
Ron
[EMAIL PROTECTED] wrote:
>
> My goal is to be able to connect to the MySQL server on my web server from a local
>computer. I need to do this for something I'm develo
No, it's not normal. You managed to create your database with a space
in front. You'll probably have to delete and recreate the database.
Chris Hallgren wrote:
>
> ok here is my problem i have redhat 7 i installed mysql via the rpm and
> i get the following error
>
> mysql> select chrishallg
] piece in the subject line.
Ron
Jeff Gannaway wrote:
>
> Here's an idea for the list memebers and list master
>
> Since a lot messages have undescriptive subjects ("Help", "Check This",
> "What's This?", etc...) I think it would be a good
e was no entry. And, I wanted to do it
without rewriting my code. Unfortunately, it looks like I may have to
do a code rewrite for that section, which means documenting, testing,
acceptance...
Anyway, thanks for all the suggestions
Ron
suggestions vie email *
> selec
1 - 100 of 104 matches
Mail list logo
