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 b
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 wrote:
> I
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:
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 |
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 multi
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 th
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
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
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
--
My
September 10, 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
, 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-Wi
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 wrong.)
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 happ
>-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 lin
6, 2009 11: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
base Administrator (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: N
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 did
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 have a project for which need to import cvs file
fied 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
Greet
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 t
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 wrote:
> This is on a Mac OS X (v10.5.6) s
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 wrote:
> This is on a Mac OS X (v10.5.6) system in case that matters.
>
>
>
> 1. - MySQL Administrator Help button says:
>
> HELP
>
> H
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 me
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
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.
http://body.aol.com/fitn
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
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 =
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:
> 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, $dat
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 netwo
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 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= 33
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) de
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 wi
Perhaps you were using CAST() incorrectly? What was your attempt?
my test table:
show create table ultimas_repuestas;
+---+-+
| Table | Create Table
ECTED]
Sent: 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
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 agen
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
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 s
"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
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 th
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 case,
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
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 intege
[mailto:[EMAIL 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 s
ately, time is running out.
>
> TIA,
>
> Joseph "Tito" Kraer
> Business Systems Analyst
> Taylor, Bean & Whitaker Mortgage Corp
>
> -Original Message-
> From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, December 0
uot;Tito" Kraer
> Business 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: listin
ss 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
Hello.
> Ple
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 h
Kraer, Joseph wrote:
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 ( condition, va
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 wel
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 don't
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. WHE
ial, an add on to PHPMyAdmin? Or should it be there
> with the standard installation? If it is special, where can it be found?
>
> Thank you for your help.
>
> Joe.
>
>
>
>
>
> -Original Message-
> From: Joe Herman [mailto:[EMAIL PROTECTED]
seph "Tito" Kraer
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 Questio
time = number3.
hth,
melanie
From: "Kraer, Joseph" <[EMAIL PROTECTED]>
To:
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
"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 condition
re de 2005 10: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 se
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 by
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
work
ial, an add on to PHPMyAdmin? Or should it be there
> with the standard installation? If it is special, where can it be found?
>
> Thank you for your help.
>
> Joe.
>
>
>
>
>
> -Original Message-
> From: Joe Herman [mailto:[EMAIL PROTECTED]
lation? 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,
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
PROTECTED]>
Cc:
Sent: Monday, November 14, 2005 8:19 PM
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 fiel
> > 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.
--
Sco
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 index
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" erro
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
getti
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 sa
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
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 ali
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 G
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'
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 dat
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,
s
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 us
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
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 P
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
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 _int_
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 ()
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),
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 th
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 it
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, the
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 using
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, an
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 shut
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 orde
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
something
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 fo
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 script
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 st
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 b
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 unsu
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"'
S
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
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
str
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 se
1 - 100 of 420 matches
Mail list logo