I am trying to install mysql 5.1.59 on my ppc running os x and I get this
error message in the term.c file.
cc1: warnings being treated as errors
term.c: In function ‘term_set’:
term.c:946: warning: passing argument 1 of ‘tgetflag’ discards qualifiers
from pointer target type
term.c:947: warning:
I can't help directly with the error message (the warning seems fairly
harmless), but may I inquire why you are building MySQL instead of using one
of the prepared binaries? Compiling under OS/X can be pretty harrowing.
- michael dykman
On Sat, Oct 8, 2011 at 2:49 AM, Peter Schrock
I can understand your point, however, as stated, I am using a ppc
architecture and am not afforded the luxury of binaries in the most up to
date versions. I know using 5.1.59 isn't the most up to date, but I was also
having issues with the most current version. I might start with the most
current
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1
Just curious as it is not mentioned. Can Category ID also have multiple
event id ?
--
Cheers
Dhaval Jaiswal
On 01/03/2011 5:53 PM, Wagyu Beef wrote:
Hey guys,
Am a newbie here and need a little help.
Part of the database consists of two tables events and categories which
look like this
Oh yeah, forgot to mention that. Yes, one event will have multiple
categories. And one category can be applicable to multiple events.
On Tue, Mar 1, 2011 at 8:33 PM, Dhaval Jaiswal
jaiswal.dha...@enzenglobal.com wrote:
Just curious as it is not mentioned. Can Category ID also have multiple
2011/03/01 20:23 +0800, Wagyu Beef
Part of the database consists of two tables events and categories which
look like this
+---+-+
| eventID | eventName |
+---+-+
| 1 | Event A
Thanks all... I got this to work! Much appreciated..
And thanks for patience with a newbie!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
, but then I couldn't expand
later.
Reverse is true if I add user_ID to the Topics.
So, need an idea how to solve this so it doesn't matter how many new
users I keep adding, I can still see who is using the topics.
As I said, a newbie question. Thanks much.
--
Patrice Olivier-Wilson
http://biz
, 2010 12:09 PM
To: mysql@lists.mysql.com
Subject: newbie question database tables
I'm working on a database that needs to do a few things and getting
brain freeze on one part.
Scenario:
I want to compile a db of articles with these tables:
Categories
Topics
Users
Categories
cat_ID | cat_name
On 9/10/10 12:31 PM, Jerry Schwartz wrote:
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
Thank you!
--
Patrice Olivier-Wilson
http://biz-comm.com
--
Thanks again for assistance. FYI, I did track this thread down
http://ask.metafilter.com/57007/Missing-commas-in-CSV-file
(exerpt:
Maybe there is a space or something in the 14th column of the first 15 rows.
posted by. on February 14, 2007
It's a bug in Excel (not something you did
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: Sunday, September 27, 2009 10:19 AM
Cc: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around
Jerry Schwartz wrote:
[JS] This is just a shot in the dark, but Excel can be rather surprising when
it puts out a CSV file. Depending upon the data, and exactly how you've
specified the export, it can put double-quotes in unexpected places.
If you leave out the 17th line of data what
:02 AM
To: 'mysql'
Subject: Re: Newbie question: importing cvs settings
Yep, typo ...:-(
I did some screen shots of 2 tests. A workaround solution is to make a
final entry in the csv file that I don't really need. Then everything up
to that point gets imported ok using CSV method. The LOAD DATA
Back again... I have 192 records to import, and tried my extra line at
the end hoping for a work around, but nope, it failed at line 17 again.
Invalid field count in CSV input on line 17.
Anyone have an idea why this might be happening?
Patrice Olivier-Wilson wrote:
Yep, typo ...:-(
I
(CMDBA)
Certified MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 27 September 2009 15:19
Cc: 'mysql'
Subject: Re: Newbie question: importing
Greetings:
I have a project for which need to import cvs files into db.
I can do so up to a point. The import will only do 16 lines,
consistently. Error is failing at line 17.
Steps:
create table fields in Excel document, where they all match database fields
enter information in several of
MySQL 5 Developer (CMDEV)
IBM Cognos BI Developer
Telephone +44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greetings:
I
+44 (0)7812 451238
Email j...@butterflysystems.co.uk
-Original Message-
From: Patrice Olivier-Wilson [mailto:b...@biz-comm.com]
Sent: 26 September 2009 17:08
To: mysql
Subject: Newbie question: importing cvs settings
Greetings:
I have a project for which need to import cvs files into db
The online help for mysql administrator is here:
http://dev.mysql.com/doc/administrator/en/index.html
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 20, 2009 at 7:17 AM, Jeff Murdock jeff_murd...@yahoo.com wrote:
This is on
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button says:
HELP
Help isn’t available for MySQL Administrator.
Really, no help or did I screw-up the install somehow?
2. - I tried to create my first Table in MySQL Administrator but got
this
Jeff,
For starters, it looks like you need a value for VARCHAR. Try the
same statement but with VARCHAR(255) .
On Fri, Feb 20, 2009 at 1:17 AM, Jeff Murdock jeff_murd...@yahoo.com wrote:
This is on a Mac OS X (v10.5.6) system in case that matters.
1. - MySQL Administrator Help button
Hello,
I feel stupid here... How do I respond to a specific post?
I posted last night, I got a response... now I want to post a response to the
response.
Don't see a way to do that...
Thanks,
Lee
**
Start the year off right. Easy ways to stay in shape.
MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 10:19 AM
To: mysql@lists.mysql.com
Subject: Newbie question, how do I respond to post
Thanks Sebastian, that did the trick.
The full command I use is:
$mysqli = new mysqli(., $username,$password,
$database,null,/tmp/mysql.sock);
Regards,
JC
Sebastian Mendel wrote:
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable network
John Comerford schrieb:
Thanks Sebastian, that did the trick.
The full command I use is:
$mysqli = new mysqli(., $username,$password,
$database,null,/tmp/mysql.sock);
there is no need for the socket, their are no sockets on windows
$mysqli = new mysqli('.', $username, $password, $database);
Hi Sebastian,
I did read somewhere that sockets was not valid for windows, and
'/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
tried the following commands:
$mysqli = new mysqli(., $username,$password, $database);
or
$mysqli = new mysqli(., $username,$password,
John Comerford schrieb:
Hi Sebastian,
I did read somewhere that sockets was not valid for windows, and
'/tmp/mysql.sock' doesn't resolve to anything on my machine. But I have
tried the following commands:
$mysqli = new mysqli(., $username,$password, $database);
or
$mysqli = new
Hi Sebastian,
That was it alright. I commented out the socket lines from mysql.ini
(restarted it) and changed my php command to:
$mysqli = new mysqli(., $username,$password, $database);
and all seems to be working fine now.
Thanks again for your help, much appreciated.
Regards,
John
Hi Folks,
I have a database running on Window XP, that I want to disable network
connections to and enable 'named pipes'. I am running MySQL 5.0.27
and my.ini looks like...
[client]
#password= your_password
port= 3306
socket= /tmp/mysql.sock
[mysqld]
#port=
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable network
connections to and enable 'named pipes'. I am running MySQL 5.0.27
and my.ini looks like...
[...]
I can connect to the DB using the GUI tools if I set my pipe name to
Hi Derek,
You never gave us a SHOW CREATE TABLE simple1, which would have
helped. To replicate your problem, I did the following, on a linux
box (it looks like you're using Windows), using mysql
5.0.18-standard-log:
CREATE DATABASE cars;
use cars;
CREATE TABLE `simple1` (
`one` char(10)
I have a CSV file that I want to import into a MySQL DB table. The file
contains 15 fields. The able to import into will contain those same 15
fields, plus an auto-generated Primary Key fields.
Since this is the first time I'm working with mysqlimport, I created a
small test table to start
Perhaps you were using CAST() incorrectly? What was your attempt?
my test table:
show create table ultimas_repuestas;
+---+-+
| Table | Create Table
I searched the other lists and couldn't find one that was more appropiate for
this question; if there is, please tell me so :)
I am monitoring networking equipment and so far I'm saving all my data in a
MySQL database (hence an email to this list). I'm using only VARCHARs because
the SNMP
: Friday, 17 February 2006 11:29 AM
To: mysql@lists.mysql.com
Subject: Hi, newbie question on a select statement
I searched the other lists and couldn't find one that was more appropiate for
this question; if there is, please tell me so :)
I am monitoring networking equipment and so far I'm saving all
Hi,
I have several tables linked in various ways so that an inner join is
possible. However, at the same time and in the same SQL query, I'd also
like to query by some field values in one of the tables.
Two quick questions:
a)Will MySQL allow joins that involve more than two tables (in my
David T. Ashley wrote:
Hi,
I have several tables linked in various ways so that an inner join is
possible. However, at the same time and in the same SQL query, I'd also
like to query by some field values in one of the tables.
Two quick questions:
a)Will MySQL allow joins that involve more
David T. Ashley [EMAIL PROTECTED] wrote on 07/02/2006 14:03:04:
Hi,
I have several tables linked in various ways so that an inner join is
possible. However, at the same time and in the same SQL query, I'd also
like to query by some field values in one of the tables.
Two quick questions:
On Tue, February 7, 2006 10:46 am, [EMAIL PROTECTED] wrote:
David T. Ashley [EMAIL PROTECTED] wrote on 07/02/2006 14:03:04:
a)Will MySQL allow joins that involve more than two tables (in my case,
perhaps as many as 5)?
b)Can limits on a key field be included in the join in the same SQL
At 3:46 pm + 7/2/06, [EMAIL PROTECTED] wrote:
Yes, you can do multi-way joins, and people often do. My biggest is 3-way, but
some people do at least 5-way.
My record is and 8-way join (7 tables, one twice). So there! ;-)
Beware that it is easy to specify operations which will heavily load
I remember in MySQL that you can define an integer table field as
AUTOINCREMENT and UNIQUE (I might have the specific keywords wrong, but
everyone will know what I mean).
In the life of a database where there are frequent additions and
deletions, 2^32 isn't that large of a number.
When the
In the last episode (Feb 06), David T. Ashley said:
I remember in MySQL that you can define an integer table field as
AUTOINCREMENT and UNIQUE (I might have the specific keywords wrong,
but everyone will know what I mean).
In the life of a database where there are frequent additions and
Hello.
Please, I don't need comments telling me that I'm missing the semicolon
or that comments such as doesn't work are worthless. I know there's
something inherently wrong with this query (obviously . . . since it
doesn't give me the results that I am looking for). Does anyone havea
Analyst
Taylor, Bean Whitaker Mortgage Corp
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
Please, I don't need comments
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
Please, I don't need comments telling me that I'm missing the
semicolon
or that comments such as doesn't work
Systems Analyst
Taylor, Bean Whitaker Mortgage Corp
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 06, 2005 6:52 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
PROTECTED]
Sent: Tuesday, December 06, 2005 11:03 AM
To: mysql@lists.mysql.com
Subject: Re: Newbie Question: listing open issues regardless of project
Hello.
So it is clear now, that you should have 16 columns and to build
dynamically the column headings. The usual way to do such things
in SQL
I am trying to write a select statement in the MySQL Query Browser (v.
1.1.10) on my Eventum (v. 1.4) database; MySQL version is 4.0.21 (PHP is
4.3.10). My goal is to list certain data from all open issues, across
projects, as well as listing some issue details contained in custom
fields. I
I am sending this message to both Eventum and MySQL support lists.
I am trying to write a select statement in the MySQL Query Browser (v.
1.1.10) on my Eventum (v. 1.4) database; MySQL version is 4.0.21 (PHP is
4.3.10). My goal is to list certain data from all open issues, across
projects, as
Kraer, Joseph wrote:
snipped
I thought that IF
statements would do the job, but I get a syntax error (1064).
Obviously, they are not the way to go. Nevertheless, here's the
complete query so you can get an idea of where I want to go:
Your if statement is wrong.
The syntax is:
if (
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated by
commas (where column 1 = number2, column1 = number3) and also didn't
Kraer, Joseph wrote:
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
This appears to be correct syntax.
but it is not working.
We can't help you if you don't tell us what you mean
:59 a.m.
Para: mysql@lists.mysql.com
Asunto: Newbie Question on Update
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated
Kraer, Joseph [EMAIL PROTECTED] wrote on 11/30/2005 11:58:56 AM:
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated
From: Kraer, Joseph [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Newbie Question on Update
Date: Wed, 30 Nov 2005 11:58:56 -0500
I am trying to update a couple of rows in a table by doing the
following:
update table
set column5 = number1
where column 1 = number2
and column1 = number3
Business Systems Analyst
Taylor, Bean Whitaker Mortgage Corp
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 30, 2005 12:13 PM
To: Kraer, Joseph
Cc: mysql@lists.mysql.com
Subject: Re: Newbie Question on Update
Kraer, Joseph
? If it is special, where can it be found?
Thank you for your help.
Joe.
-Original Message-
From: Joe Herman [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 12:21 AM
To: mysql@lists.mysql.com
Subject: Newbie question: How to import data into a table
Joseph
update table
set column5 = number1
where column 1 = number2
and column1 = number3
but it is not working. I tried listing the conditions separated by
commas (where column 1 = number2, column1 = number3) and also didn't
work. What am I doing wrong?
No commas in the WHERE clause. WHERE ...
, where can it be found?
Thank you for your help.
Joe.
-Original Message-
From: Joe Herman [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 12:21 AM
To: mysql@lists.mysql.com
Subject: Newbie question: How to import data into a table?
Hello
? If it is special, where can it be found?
Thank you for your help.
Joe.
-Original Message-
From: Joe Herman [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 27, 2005 12:21 AM
To: mysql@lists.mysql.com
Subject: Newbie question: How to import data into a table?
Hello folks,
What
Hello folks,
What is the best way to import an excel spreadsheet, or text file for
that matter into a table?
Is there a way to do this with PHPMyAdmin?
Thank you so much for your kind help.
Joe
Jeffrey G. Ubalde wrote:
Good day list!
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built... so if you did that, for every query that
alters the data many
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built
They also consume disk space, so if you're tight on hard drives, they
might put you over the top.
--
Scott
Subject: Re: Newbie Question
Jeffrey G. Ubalde wrote:
Good day list!
I would just like to ask a somewhat not so intelligent question. What
is the downside of indexing almost all of the fields in a table? Is it
advisable?
Indexes have to be built... so if you did that, for every query
My RaQ4 is throwing the Too many connections error. Now, it is
getting hit pretty hard by traffic, but I wonder if my coding might
be exacerbating this error.
Due to my relatively lazy structure of includes and functions, my
pages might have half a dozen or so of these (most are to the
In one case I do need to jump back and forth between databases that
are on different physical servers. What's the most efficient way to
handle this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the Too many connections error. Now, it is
Brian Dunning wrote:
In one case I do need to jump back and forth between databases that are
on different physical servers. What's the most efficient way to handle
this?
On Aug 2, 2005, at 11:14 AM, Devananda wrote:
Brian Dunning wrote:
My RaQ4 is throwing the Too many connections
hi seniors,
I'm trying to create a table, here my table
properties,
create table user (
UserID int primary,
Password varchar (20),
User_stats int multi
);
i'm still confuse in User_stats properti's that is
multi,
what really use 'multi' is ?
Thx before the guide,
Aji
Okay, so MySQL is now installed and running. It looks like a database
named test was created with no tables. Is this just used for
installation purposes? Can it now be deleted or is there a reason to
keep it? Or does it have some magical purpose like the mysql
database?
Jeff
--
MySQL
on one level, the test database is there just have something to log into
after intall to prove it's working.. some init.d startup scripts (I'm
thinking RedHat here) try to log into the database as an authenticated
user after each start up and when doing a 'status' call just to make
sure it's
This may be more of a PHP question than a MySQL question but here goes:
I have a small database with two tables in it. It's a database of
Botanical Gardens in the US.
Table 1 contains the botanical gardens and has 8 fields:
(I'm abbreviating for brevity and clarity): id, name, address, town,
need.
-Original Message-
From: jsf [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 23 February 2005 3:08 PM
To: mysql@lists.mysql.com
Subject: newbie question
This may be more of a PHP question than a MySQL question but here goes:
I have a small database with two tables in it. It's a database
On Tuesday, February 22, 2005 22:08, jsf wrote:
This may be more of a PHP question than a MySQL question but here
goes:
I have a small database with two tables in it. It's a database of
Botanical Gardens in the US.
Table 1 contains the botanical gardens and has 8 fields:
(I'm
Hello.
The mysql program uses user sebyte and password for user ddj.
When mysql starts it calls for load_defaults(), which put
the arguments from your config file before the command line options
that you specified. And than uses the last given argument. It looks like
mysql was invoked with
On Fri, 28 Jan 2005 09:47:24 +0200, Gleb Paharenko wrote:
Hello.
The mysql program uses user sebyte and password for user ddj.
When mysql starts it calls for load_defaults(), which put
the arguments from your config file before the command line options
that you specified. And than uses
Hi there,
For some reason, despite entering my passwords in ~/.my.cnf, I still have
to enter a password on the command line to login to mysql. I have tried
this with each of the accounts I have created and all return the same
error:
$ mysql -u sebyte
ERROR 1045: Access denied for user: '[EMAIL
Hi,
greetings to the list.
I'm in process of compiling MySQL 4.1.9 using BerkeleyDB 4.3.27.
When i start make, after configuring i get the following
error-message :
--snipp--
ha_berkeley.cc:103: error: type specifier omitted for parameter `db_notices'
ha_berkeley.cc:103: error: syntax error before
At 19:32 +0100 12/13/04, Alina Bikowska wrote:
Description:
When I try to call mysql_init() several times in
my program it finishes with segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate ()
Description:
When I try to call mysql_init() several times in my program it finishes with
segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate () from /lib/tls/libc.so.6
#1 0x007b9e6a in
Hello.
Cardinality of index is updated by running ANALYZE TABLE or
myisamchk -a. See:
http://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html
I've created a table with several indexes as follows:
$query = CREATE TABLE `data_raw` (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
run_id VARCHAR(20)
I've created a table with several indexes as follows:
$query = CREATE TABLE `data_raw` (
id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
run_id VARCHAR(20) DEFAULT 'error_internal' NOT NULL,
time_run DATETIME DEFAULT '-00-00 00:00:00' NOT NULL,
...clip.
PRIMARY KEY (id),
INDEX x_run_id (run_id),
Hello all,
Basic question about creating a database that will be accessed by many users. Do I
create one web user account with no password in the mysql.user table or add each user
to the mysql.user table as they join up to my site? (Lots of books and documentation
says how to create users,
It's not a simple question at all.
Your users actually DON'T talk to the database, your PHP application does.
Your users converse with your PHP code. Your web server will have one
layer of authentication just to allow the user to view the pages your site
is composed of. Assume for a second
The answer is you create one user for the PHP (webserver) process to
use.
Then you keep track of user permissions in your application code. This
probably involves creating your own user table within your own database
and storing users of your site there. Then in the other tables you
associate
Hi.
You may read:
http://dev.mysql.com/doc/mysql/en/JOIN.html
http://dev.mysql.com/doc/mysql/en/SELECT.html
There is a good description.
Searching in more than two tables (3 in my example) may be done
in such way:
select t1.* from t1,t2,t3 where t1.a=t2.a and t1.b=t3.b
But
I am just now getting the hang of searching through 2 tables, and
getting the corresponding information using a pri foreign key
(ID1=ID1) kinda thing. How is this done with more than 2 tables?
I had asked on a different forum, but I got some funky select statement
using a left inner join,
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql database in order to do
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to shutdown and restart the mysql database in
At 11:16 -0500 10/7/04, gerald_clark wrote:
Carolina wrote:
using mysql version 4.0.13
- **total newbie here**... something as simple as renaming a
database...i've not found anything relating to that on the mysql site
or anywhere else. what i have found is that in order to do this, i'd
have to
As I mentioned in my post, I did wind up using a perl script, and I will
continue down that path in the future. I was mainly wondering about limits
to the mysql client for quick-n-dirty testing (as someone who is learning
MySQL, as opposed to developing for a production environment).
Thanks
Greetings,
I posted this to the MySQL Newbie forum, but have not received a
response. Any feedback would be appreciated.
-tb
Environment:
mysql server v4.0.13 (Win2K)
mysql client v5.0.0.0(Win2K)
In attempting to (manually) insert records with some rather lengthy
strings, I pasted the insert
On Wed, 29 Sep 2004 10:05:29 -0400, Ted Byrne [EMAIL PROTECTED] wrote:
Is the apparent line length limit a restriction imposed by the client? (And
does it apply if you are piping or redirecting output from another process
or a file?)
It sounds like you should either be using a scripting
Is it possible to store an excel file into a blob field in mysql? If so how
do I go about importing the file into the blob field, and get it back out
into an .xls file?
Thanks in advnace
Jack Taffar
AOG
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Good binary storage article w/ sample code:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
On Mon, 27 Sep 2004 16:47:37 -0500, Jack Taffar [EMAIL PROTECTED] wrote:
Is it possible to store an excel file into a blob field in mysql? If so how
do I go about importing the file into the blob
Many thanks for your reply Tom.
I will read it more closely over the week-end, but wanted to say thanks
straight away.
Kerry
-Original Message-
From: Tom Horstmann [mailto:[EMAIL PROTECTED]
Sent: 20 August 2004 15:52
To: 'Kerry Frater'; 'MySQL List'
Subject: RE: newbie question
Hi all,
I don't think this is the right list for the question but I am hoping
someone in the list will be able to point me in the right direction.
I am testing the use of Delphi with MySQL (using Micoolap's DAC) to access
and manipulate a number of tables in a databse. Some of the more complex
Hi Kerry,
The problem is more fundamental with the scrolling through
the records/rows of Master. [..] It is not sensible to allow
200 million pieces of data to be transferred to the Delphi PC
to build a local Dataset to scroll through.
[..]
Getting the first row is easy
select * from
Just been using mysql for a couple of days, so this is possibly old ground,
but i have searched and can't find any solution. i'm sure it must have come
up before.
The project is to allow resources to be shared amongst community groups
throughout uk. there are a number of attributes that can be
1 - 100 of 398 matches
Mail list logo
