Hi All,
I am hoping to implement a simple MySQL client on a PIC18 microcontroller. Basically
the client will need to connect to a server
upload some data and then disconnect. My current stumbling block is the handshaking
involved in establishing a connection. I would
like to find an RFC or simil
Im sorry if this classified as OOT
One example of the confussion
C Header File declaration of statement handler (taken from the 4.1.3)
typedef struct st_mysql_stmt
{
MEM_ROOT mem_root; /* root allocations */
LIST list; /* list to keep track of all
Dear All,
Not long ago Jorge del Conde gave me his amazing translation of mysql C
header file to object pascal unit
Including the remade dll,
It was able to solve my problem of migrating the apps from using mysql 3.x
to 4.x
But now I am facing a new difficulty of trying to implement mysql 4.1.3
pr
can anyone tell me why when i build/use perl/dbi it crashes because it's
looking for libmysqlclient.so.10.
i'm using perl 5.8.3 and mysql4.1.3. i've gotten the latest DBI (1.43).
why does DBI look for libmysqlclient.so.10, instead of using
libmysqlclient.so.14. is there anyway to force a change,
In all likelihood in your database you have not setup any access
privilege yet. You need to look at GRANT command and assign password
to atleast root account and any other accounts which will be
connecting over network.
On Fri, 23 Jul 2004 11:38:06 -0700 (PDT), john sayre
<[EMAIL PROTECTED]> wrote
I often find I am using a field called 'status' and almost always store
boolean 1 or 0 in it, sometimes I may need a 2 or 3, but never greater than
9 for sure, Is tinyint(1) pretty much the most efficient storage means for
this type?
--
-
on 7/23/04 3:00 PM, Paul Fine at [EMAIL PROTECTED] wrote:
> SELECT * FROM tablename
>
> WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty'
This is perfectly accurate
--
-
Scott Haneda
Thanks but that's not v helpful. Actually that was my thread! The problem
there was that I didn't have a large-file enabled filesystem. The problem I
have now is being able to create another index on a table but getting an
errcode 27 despite no ulimits and a large enabled filesystem.
This shoul
> "j.rabbit" <[EMAIL PROTECTED]> wrote:
>
> > This is how the redhat 9.0 mysql.spec file adds the mysql user:
> >
> > ' useradd -M -o -r -d /var/lib/mysql -s /bin/bash -c "MySQL Server" -u =
> > 27 mysql '
> >
> > Anybody know why the shell is '/bin/bash' instead of '/sbin/nologin' =
> > lik
Paul,
You can do the following:
SELECT * FROM tablename WHERE columname IN ('Bob','Mike','Betty');
Kevin
> -Original Message-
> From: Paul Fine [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 23, 2004 3:01 PM
> To: [EMAIL PROTECTED]
> Subject: Another newbie question - using OR in WHE
Is there a simpler way to write something like:
SELECT * FROM tablename
WHERE columname = 'Bob' OR columname = 'Mike' OR columname = 'Betty'
Clearly this does not work:
WHERE columname = 'Bob' OR 'Mike' OR 'Betty'
Thanks!
on 7/23/04 5:30 AM, Harald Fuchs at [EMAIL PROTECTED] wrote:
> The behavior is indeed strange, but it's not a bug, since it's documented:
>
> If you use `INSERT IGNORE' and the record is ignored, the
> `AUTO_INCREMENT' counter still is incremented and
> `LAST_INSERT_ID()' returns t
This should be a useful thread for you
http://lists.mysql.com/mysql/167953
Suggests using ALTER TABLE MAX_ROWS=
On Fri, 23 Jul 2004 20:20:24 +, "J S" <[EMAIL PROTECTED]> wrote :
> Hi,
>
> I'm trying to run the following SQL (on
> mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc):
>
> CREA
Hi,
I'm trying to run the following SQL (on
mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc):
CREATE INDEX timeindex ON internet_usage (time);
CREATE INDEX urlindex ON internet_usage (urlid);
but keep running into the following error:
Error writing file '/proxydb/mysql/tmp/STeR39Er' (Errcode: 27)
$ perro
That's just perfect!
Than you so much!
--
Aeon McNulty
On 23/7/04 8:50 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
>
> Yep, just what I needed.
>
> SELECT
> c.CompanyName
> , MAX(IF(m.Member_Initials='ABS', s.Subscription_Expiry_Date,
> NULL))as 'ABS'
> , M
On Friday 23 July 2004 03:02 pm, you wrote:
> sqlog program
What is "sqlog program"? Google shows me nothing familiar:
http://www.google.com/search?q=sqlog+program
You need to provide more information if you want help. How do you run this?
What OS? What options are you selecting? How do you con
Yep, just what I needed.
SELECT
c.CompanyName
, MAX(IF(m.Member_Initials='ABS', s.Subscription_Expiry_Date,
NULL))as 'ABS'
, MAX(IF(m.Member_Initials='BV', s.Subscription_Expiry_Date,
NULL))as 'BV'
, MAX(IF(m.Member_Initials='CCS', s.Subscription_Expiry_Date,
NU
oops...
clarification, i'm using mysql-4.1.3. the reason i can't use the
binaries/rpms is that i have a dependency conflict with openssl..., so i
need to be able to rebuild to make everything work. unless anyone has a
different solution...
thanks
-bruce
-Original Message-
From: bruce [
hi...
i'm building mysql-5.0 from src for rh8.0. my question has to do with
how/where i find the libmysqlclient.so.10 lib.
when i've built the mysql-5.0 i haven't found this file. it appears that
this file has been included in the mysql-shared-compat* file, but i can't
find this file either for t
I have come across a very strange occurrence while working on a client's
system. I get different behavior between the two servers (one Windows, one
Linux) when it comes to a column defined as double(5,4). The Windows system
truncates new values (existing data in the table is not truncated) whereas
Hi Shawn
I hope this gives you what you need:
SELECT
member.Member_Initials,
company.Company_Name,
subscription.Subscription_Expiry_Date
FROM
subscription
INNER JOIN member
ON
member.Member_URN = subscription.Member_URN
INNER JOIN company
ON
company.Company_URN = subscription.Company_URN
>From
Your default anonymous account is still active. The Fine Manual describes
how to fix this: http://dev.mysql.com/doc/mysql/en/Default_privileges.html
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Victor Pendleton <[EMAIL PROTECTED]> wrote on 07/23/2004 03:01:56 PM:
Have you tried: GRANT USAGE on mysql.* TO ... (fill in with your user's
information).
>From the docs (http://dev.mysql.com/doc/mysql/en/GRANT.html)
USAGE = Synonym for ``no privileges''
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ginger Cheng <[EMAIL PROTECTED]>
Is the ODBC account still enabled on the database server?
-Original Message-
From: john sayre
To: [EMAIL PROTECTED]
Sent: 7/23/04 1:38 PM
Subject: Logging on through ODBC w/o UN & Password (Why is my query tool
allowing this?)
I am able to log onto a database through ODBC without using a
Hello, MySQL gurus,
I am wondering how I can grant a user the privileges to all the db except
for mysql DB. THere are many databases so I don't want to grant one by one.
But 'revoke all on mysql.* from user' does not work. Thank you for help
ginger
--
MySQL General Mailing List
For list archiv
You could consider another option: To have a robust script (daemon?) in
each web server that periodically pushes metrics data into the master. I
think this gives you better control over your data. If you lose connection
or something goes wrong your web servers will be able to tell what DIDN'T
m
I am able to log onto a database through ODBC without using a user name or password.
I don't want this to be possible for obvious security reasons.
What do I need to do to prevent this?
This seems pretty freaky!
I will be more than happy to help you build a case-specific crosstab
report. I have almost enough information. Could you post a 3 column-query
that will actually produce from your data the information you would like
to have reformatted?
Column one needs to be your column names, column two nee
Greetings!
I have several (~12) web servers which all record web metrics to their own
local mysql database. I would like to consolidate data from each web server
database to one master DB to within the hour. I wish to avoid running
multiple instances of mysql on the "master" server, so repli
Hi Shawn
Yes, that's pretty much it. I'm impressed that you managed to work that out
from my previous email which was a bit thin on detail!
> Good news: For a specific case (when you know the number of columns) the
> query you seek to write follows a simple and predictable pattern and is
> not h
Hi David
Thanks your response. I'm using Lasso but that's largely unimportant because
I still need to get the data returned in a way that I can use it. I should
not have said "displaying" - I meant "returning".
I need to return only one column from table A (there could be up to 14
records). I nee
Does MyISAM lock the whole table when doing SELECTs?
How about if there are several processors? Is there locking?
If I understand you correctly Basically you want to convert this query
output:
+---+---+---+
|A.value|B.value|C.value|
+---+---+---+
| a1 | b1 | c1 |
| a1 | b1 | c2 |
| a2 | b1 | c3 |
| a2 | b1 | c4 |
| a1 | b2 | c5 |
| a1 |
Helpful Hint:
I had a major problem not being able to register a DSN (Data Source Name)
with the CF Administrator, using username and password from a MySQL 4.1.3
beta user table.
After much hair-pulling, I discovered that CF cannot apparently handle the
new 41-character format of the passwords
Thanks! that worked great!
I ended up using the first one, I just liked the look of it better.
Because the customer might not have any deposit records or any
purchases I changed the code to this:
SELECT @purchases := SUM(amount_of_credit_used)
FROM purchases WHERE customer_id="jdoe";
Hi, I hope someone on the list can help me.
Is there an easy and straightforward way way of displaying the data from
three tables in a spreadsheet like format using MySQL 4.0?
Table A has the column headings
Table B has the row headings
Table C is a line items file than cross relates the two
Man
You don't say what version you are running.
Did you forget to commit?
[EMAIL PROTECTED] wrote:
Dear friends,
When I import records fron csv file.I window pops up, stating total number of
records imported, however when I check table nothing has been imported.Any
guidance,
--
MySQL General Mai
On Friday 23 July 2004 11:14 am, [EMAIL PROTECTED] wrote:
> Dear friends,
> When I import records fron csv file.I window pops up, stating total number
> of records imported, however when I check table nothing has been
> imported.
You are using some kind of middle-man program to populate a databas
Dear friends,
When I import records fron csv file.I window pops up, stating total number of
records imported, however when I check table nothing has been imported.Any
guidance,
Hello,
I made a small c++ program which uses the mysql embedded server. I would like
to manually connect to the local database for faster debugging. Is it
possible ?
Thanks.
Adrien
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
Hello,
the following problem occurs when I want to configure MySQL 4.1:
Building aclocal.m4
Running autoheader to build config.hin
Running autoconf to build configure
645046
644916
Building RPC client/server files
Building tags
+++ cd innobase
+++ aclocal
+++ autoheader
+++ aclocal
+++ automake
+
Hi all!
Estaba trabajando con el ArcView by ESRI,
con una extension "MySQL Connection"
http://arcscripts.esri.com/details.asp?dbid=12896
l) permitiendo poder exportar un Shapefile (Archivo Vectorial) a MySQL
generandome el siguiente Peru.sql(que con gusto enviaria al correo que me
preste su ayu
# perror 2
Error code 2: No such file or directory
You sure that directory exists?
On Tue, 2004-07-20 at 15:48, [EMAIL PROTECTED] wrote:
> >Description:
> I can not start the mysqld daemon. I had it running for a long time, but
> then had to reboot. Then I could no longer connect.
I have MySQL 4.0.18-standard on RH 9 and it works fine
+
mysql> grant all on *.* to 'mysqladmin'@'localhost';
Query OK, 0 rows affected (0.06 sec)
mysql> show grants for 'mysqladmin'@'localhost';
+-+
| Grants
Solo hablo espaĆol. (Que Problema)
Estoy tratando de hacer lo mismo que tu.
ya ingrese la parte grafica a MySQL. Ahora estoy tratando de Visualizarala
por un browser.
Sorry, I don't write English clearly.
I speak Spanish (That is Problem) I am trying to do just like
your. The map already enters to
I try to set *all* privileges to a user, which should not called 'root'
but should have its privileges (I'm connected as root):
mysql> grant all on *.* to 'mysqladmin'@'localhost';
Query OK, 0 rows affected (0.00 sec)
But now I get
mysql> show grants for 'mysqladmin'@'localhost';
ERROR 1141: Ther
There is an easier path-
you *could buy* a data migration tool such as ispirer
http://www.ispirer.com/products
HTH,
Martin Gainty
(cell) 617-852-7822
From: matt ryan <[EMAIL PROTECTED]>
To: Martin Gainty <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: How do I import a
In some cases mysql crashes while restore is trying to destroy persistent databases
and mysql.err says
000121 21:02:23 InnoDB: Database was not shut down normally.
InnoDB: Starting recovery from log files...
InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 867418
In
Your settings need to be based upon usage patterns. Some systems have
lots of inserts, others are mostly selects, some have lots of joins,
others don't. All these would have different settings. There are even
cases where you would want a table to be InnoDB instead of ISAM or the
other way aroun
Hi List,
I have been looking for solutions to my problem for a while and this
morning someone told me that MySQL 5.1 might be the answer.
In short what I need is an interactive map displayed in a web browser.
Users should be able to click on any point in the map and add text. The
map and the
Hi List,
We are using 4.0.15a MySQL. We need to backup database at times and we employ the
following method
FLUSH TABLES WITH READ LOCK
tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1
UNLOCK TABLES
and restore is reverse. We cannot overwrite all databases, some of them needs to be
uncha
I know there are more ways to solve this problem (I can think of at least
2 more) but I think the easiest approach is to break this into two stages.
First stage, we compute the sums of the purchases and the credits:
SELECT @purchases := SUM(amount_of_credit_used)
FROM purchases
WHERE customer_id
In article <[EMAIL PROTECTED]>,
Scott Haneda <[EMAIL PROTECTED]> writes:
> I am not sure this is just how it is, my issue, or a bug, I searched the
> bugs database, but don't really know what to call this in order to properly
> look up the info:
> MySQL 4.0.18-standard
> CREATE TABLE `addresses`
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: MySQL is not starting
>Description:
my mysqlserver is
"Matsunobu, Yoshinori" <[EMAIL PROTECTED]> wrote:
> I'd like to ask about backup/restore(roll forward recovery) solutions
> using mysqldump and binary logs.
>
> ^[$B!&^[(JVersion : 4.0.20
> ^[$B!&^[(JUsing 1 database.(ex. sample1db)
> ^[$B!&^[(JAll tables are InnoDB.
>
>
> I'm considering the
I hope this isn't a stupid question but this is my best place to ask...
I have a database where I need to do a sum of a returned select...
SELECT SUM(purchases.amount_of_credit_used) WHERE customer_id="jdoe";
and do a sum of another returned select...
SELECT SUM(amount) from deposits WHERE customer
David Griffiths wrote:
We just put a new dual-Opteron server into our production environment.
We ordered a Megaraid SCSI card and five 10k drives, and a 3Ware
Escalade SATA card with six 7200 RPM drives (Maxtor) to see which ones
were best.
Our network guy did a bunch of benchmarking on the dri
I previously had a server runnning RH 7.3, cPanel 9.41 and MySQL
4.0.20. I'm moving to a different server running Fedora 1, DirectAdmin
and MySQL 4.0.17.
I have a large database (200mb) and I'm trying to move it over.
I made a dump using "mysqldump -u USER -pPASSWORD DATABASE >
filename.sql", tra
There are three tables:
This stores just a cosmetic name and a user_id which is used to find all the
account holders campaigns...
CREATE TABLE `campaigns` (
`id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`campaign_name` varchar(24) NOT NULL default '',
`updat
Is there any kind of performance / tuning guide software for MySQL?
I am looking for something which can look at the SHOW VARIABLES and SHOW
STATUS commands, do some calculations and give some tips on how to
improve the system?
Any such product available?
--
MySQL General Mailing List
For list a
MySQL wrote:
I want searches for News to be on the author, headline and content fields.
What is the best way to index and search this?
I would suggest a Fulltext index on headline and content. And then do a
search using MATCH() and AGAINST(). For searching on author's names you
can use LIKE .
Fr
61 matches
Mail list logo