A Newbie question about make and the term.c file

2011-10-08 Thread Peter Schrock
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:

Re: A Newbie question about make and the term.c file

2011-10-08 Thread Michael Dykman
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

Re: A Newbie question about make and the term.c file

2011-10-08 Thread 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

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Dhaval Jaiswal
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

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread Wagyu Beef
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

Re: Newbie question: Association table and Foreign Key

2011-03-01 Thread S�ndor Hal�sz
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

Re: newbie question database tables

2010-09-11 Thread Patrice Olivier-Wilson
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

RE: newbie question database tables

2010-09-10 Thread Jerry Schwartz
, 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

Re: newbie question database tables

2010-09-10 Thread Patrice Olivier-Wilson
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 --

Re: Newbie question: importing cvs settings - followup

2009-09-30 Thread Patrice Olivier-Wilson
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

RE: Newbie question: importing cvs settings

2009-09-29 Thread Jerry Schwartz
-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

Re: Newbie question: importing cvs settings

2009-09-29 Thread Patrice Olivier-Wilson
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

RE: Newbie question: importing cvs settings

2009-09-28 Thread Gavin Towey
: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

Re: Newbie question: importing cvs settings

2009-09-27 Thread Patrice Olivier-Wilson
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

RE: Newbie question: importing cvs settings

2009-09-27 Thread John
(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

RE: Newbie question: importing cvs settings

2009-09-26 Thread John
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

Re: Newbie question: importing cvs settings

2009-09-26 Thread Patrice Olivier-Wilson
+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

Re: Newbie Question - MySQL Administrator

2009-02-20 Thread Walter Heck
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

Re: Newbie Question - MySQL Administrator

2009-02-19 Thread Darryle Steplight
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

RE: Newbie question, how do I respond to post?

2008-01-23 Thread David Ruggles
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

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
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

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread Sebastian Mendel
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);

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
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,

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread Sebastian Mendel
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

Re: Newbie Question connecting with windows named pipes (resolved)

2007-05-16 Thread John Comerford
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

Re: Newbie Question connecting with windows named pipes

2007-05-15 Thread Sebastian Mendel
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

Re: Importing CSV file into MySQL DB - Newbie Question

2006-03-13 Thread sheeri kritzer
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)

Importing CSV file into MySQL DB - Newbie Question

2006-03-05 Thread Derek Doerr
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

Re: Hi, newbie question on a select statement

2006-02-20 Thread sheeri kritzer
Perhaps you were using CAST() incorrectly? What was your attempt? my test table: show create table ultimas_repuestas; +---+-+ | Table | Create Table

Hi, newbie question on a select statement

2006-02-16 Thread Ariel Sánchez Mora
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

RE: Hi, newbie question on a select statement

2006-02-16 Thread Logan, David (SST - Adelaide)
: 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

Query Complexity Limit Question [Newbie Question]

2006-02-07 Thread David T. Ashley
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

Re: Query Complexity Limit Question [Newbie Question]

2006-02-07 Thread nigel wood
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

Re: Query Complexity Limit Question [Newbie Question]

2006-02-07 Thread Alec . Cawley
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:

Re: Query Complexity Limit Question [Newbie Question]

2006-02-07 Thread David T. Ashley
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

Re: Query Complexity Limit Question [Newbie Question]

2006-02-07 Thread James Harvard
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

AUTOINCREMENT / UNIQUE Behavior [Newbie Question]

2006-02-06 Thread David T. Ashley
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

Re: AUTOINCREMENT / UNIQUE Behavior [Newbie Question]

2006-02-06 Thread Dan Nelson
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

Re: Newbie Question: listing open issues regardless of project

2005-12-06 Thread Gleb Paharenko
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

RE: Newbie Question: listing open issues regardless of project

2005-12-06 Thread Kraer, Joseph
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

RE: Newbie Question: listing open issues regardless of project

2005-12-06 Thread SGreen
[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

Re: Newbie Question: listing open issues regardless of project

2005-12-06 Thread Gleb Paharenko
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

RE: Newbie Question: listing open issues regardless of project

2005-12-06 Thread Kraer, Joseph
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

Re: Newbie question to both lists on listing open issues regardless of project

2005-12-05 Thread Daniel Kasak
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 (

Re: Newbie Question on Update

2005-11-30 Thread Michael Stassen
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

RE: Newbie Question on Update

2005-11-30 Thread ISC Edwin Cruz
: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

Re: Newbie Question on Update

2005-11-30 Thread SGreen
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

RE: Newbie Question on Update

2005-11-30 Thread mel list_php
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

RE: Newbie Question on Update

2005-11-30 Thread Kraer, Joseph
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

Re: Newbie question: UPDATE

2005-11-30 Thread Gleb Paharenko
? 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

Re: Newbie Question on Update

2005-11-30 Thread Peter Brawley
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 ...

Re: Newbie question: UPDATE

2005-11-28 Thread Gleb Paharenko
, 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

Re: Newbie Question

2005-11-14 Thread Michael J. Pawlowsky
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

Re: Newbie Question

2005-11-14 Thread Scott Noyes
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

Re: Newbie Question

2005-11-14 Thread Rhino
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

Re: Newbie question: number of connections

2005-08-02 Thread Brian Dunning
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

Re: Newbie question: number of connections

2005-08-02 Thread Devananda
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

Re: Newbie question about test database...

2005-03-14 Thread Michael Dykman
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

RE: newbie question

2005-02-22 Thread Pete Moran
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

RE: newbie question

2005-02-22 Thread Tom Crimmins
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

Re: Easy newbie question re: option file and passwords

2005-01-28 Thread Gleb Paharenko
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

Re: Easy newbie question re: option file and passwords

2005-01-28 Thread Sebastian Tennant
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

Easy newbie question re: option file and passwords

2005-01-27 Thread Sebastian Tennant
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

Re: Newbie question: segmentation fault in mysql_init

2004-12-13 Thread Paul DuBois
At 19:32 +0100 12/13/04, Alina BiŸkowska 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 ()

Re: Newbie question about index (why are they not updating?)

2004-12-13 Thread Gleb Paharenko
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)

Re: Newbie question about web users

2004-11-04 Thread SGreen
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

Re: Newbie question about web users

2004-11-04 Thread John McCaskey
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

Re: Newbie question on multiple tables

2004-10-30 Thread Gleb Paharenko
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

Re: **newbie question** renaming a database

2004-10-07 Thread gerald_clark
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

Re: **newbie question** renaming a database

2004-10-07 Thread Paul DuBois
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

Re: Newbie question - Input limitations on mysql client?

2004-09-30 Thread Ted Byrne
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

Re: Newbie question - Input limitations on mysql client?

2004-09-29 Thread Andrew Kreps
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

Re: Newbie question about blob data types ie. Storing .xls in blob

2004-09-27 Thread DreamWerx
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

RE: newbie question on scrolling through a table one record at a time

2004-08-21 Thread Kerry Frater
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

RE: newbie question on scrolling through a table one record at a time

2004-08-20 Thread Tom Horstmann
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

RE: Another newbie question - using OR in WHERE clauses

2004-07-24 Thread Hardik Doshi
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 WHERE clauses Is there a simpler way to write something like: SELECT * FROM

Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Paul Fine
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!

RE: Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Kevin Ward
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 WHERE

Re: Another newbie question - using OR in WHERE clauses

2004-07-23 Thread Scott Haneda
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

Re: newbie question about sp

2004-07-08 Thread SGreen
: Fax to: 07/08/2004 11:44 Subject: newbie question about sp AM

Stupid newbie question - adding comments for columns tables?

2004-05-30 Thread Randy Burgess
Apologies for what is a pitifully simple question from someone who has just started using MySQL 4.0. I've looked in the documentation and elsewhere, but can't find the exact syntax for adding comments to columns when creating a table. My attempts at guessing the syntax so far have failed.

Re: Stupid newbie question - adding comments for columns tables?

2004-05-30 Thread Victoria Reznichenko
Randy Burgess [EMAIL PROTECTED] wrote: Apologies for what is a pitifully simple question from someone who has just started using MySQL 4.0. I've looked in the documentation and elsewhere, but can't find the exact syntax for adding comments to columns when creating a table. My attempts at

Re: Another Stupid Newbie Question ^.^

2004-05-09 Thread Kip Gordon
that up! Kip Gordon - Original Message - From: Michael Stassen To: Kip Gordon Cc: [EMAIL PROTECTED] Sent: Saturday, May 08, 2004 10:05 PM Subject: Re: Another Stupid Newbie Question ^.^ Kip Gordon wrote: I connect to my data base... $dbh=mysql_connect (localhost

Re: Another Stupid Newbie Question ^.^

2004-05-09 Thread Jigal van Hemert
$query=SELECT * FROM women WHERE 'id=$id'; This would result in something like: SELECT * FROM women WHERE 'id=1' Do you see the error here? $query=SELECT * FROM women WHERE id=$id; or $query=SELECT * FROM women WHERE id='$id'; would be better... Tips for debugging this in PHP: - print the

Re: Another Stupid Newbie Question ^.^

2004-05-09 Thread beacker
Query failed : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'index = 21' at line 3 I believe 'index' is a reserved word, usually used for creating indexes. Using it as a field in a table could quite likely

Another Stupid Newbie Question ^.^

2004-05-08 Thread Kip Gordon
I connect to my data base... $dbh=mysql_connect (localhost, kipples_women, ) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db (kipples_hotwomen); and then I issue a query.. $query=SELECT * FROM women WHERE index = $id;

Re: Another Stupid Newbie Question ^.^

2004-05-08 Thread Michael Stassen
Kip Gordon wrote: I connect to my data base... $dbh=mysql_connect (localhost, kipples_women, ) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db (kipples_hotwomen); and then I issue a query.. $query=SELECT * FROM women WHERE

Re: Newbie question: difference between MySQL shipped w/ Linux distro and downloading from mysql.com

2004-05-06 Thread Sasha Pachev
[EMAIL PROTECTED] wrote: Hi folks. I've got MySQL running on a W2K dev box and want to run it on a production Linux box. Being new to Linux, I'm wondering what's the difference between the version of MySQL that ships with a Linux distro and downloading it from the MySQL website. By way of

Re: newbie question: best column type for other languages

2004-04-20 Thread Ligaya Turmelle
. Otherwise, MySQL has to reserve 30 bytes for a CHAR(10) CHARACTER SET utf8 column, because that's the maximum possible length. Venkatesh Madurai [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello ! I am not very sure about this, and so, this could be viewed as a dumb newbie

RE: Newbie question on Comparing fields in 2 tables?

2004-03-11 Thread Ian Izzard
[mailto:[EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 11:29 PM To: Ian Izzard Cc: Rocar Peças; [EMAIL PROTECTED] Subject: Re: Newbie question on Comparing fields in 2 tables? An equivalent, but slightly simpler, query would be SELECT sw.pcname, sw.product FROM software sw, keywords kw

Re: Newbie question on Comparing fields in 2 tables?

2004-03-10 Thread Rocar Peças
, %) == Best wishes, Leandro M Neves, ROCAR PEÇAS LTD. Sete Lagoas/MG - Brazil - Original Message - From: Ian Izzard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 2:05 PM Subject: Newbie question on Comparing fields in 2 tables

Re: Newbie question on Comparing fields in 2 tables?

2004-03-10 Thread Michael Stassen
- Brazil - Original Message - From: Ian Izzard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 10, 2004 2:05 PM Subject: Newbie question on Comparing fields in 2 tables? Hi, I am new to using MySQL and SQL queries. I have in the past only carried out simple queries. I am

Re: Newbie question

2004-02-23 Thread Brad Eacker
Donny Simonton [EMAIL PROTECTED] writes: But as a manager, the first thing I do is ask for code examples, as well as table structures. I don't even need to see a resume once I look at somebody's code and table structures. Unfortunately I will have to disagree with you on this one. Having

Re: Newbie question

2004-02-23 Thread Bernard Clement
Dear Brad, Your problem is too much experiences not the lack of skills. I am in the same situation...it is very frustating. Regards, Bernard On Monday 23 February 2004 11:14, Brad Eacker wrote: Donny Simonton [EMAIL PROTECTED] writes: But as a manager, the first thing I do is ask for code

Re: Newbie question

2004-02-23 Thread beacker
Bernard Clement [EMAIL PROTECTED] writes: Your problem is too much experiences not the lack of skills. I am in the same situation...it is very frustating. Bernard, It appears I'm not the only one :( Though such an observation makes me wonder if it may be a case of age discrimination being

Re: Newbie question

2004-02-22 Thread Walt
, 2004 12:10 AM Subject: Re: Newbie question - Original Message - From: Walt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 8:00 AM Subject: Newbie question I need a little advice on where to get started. I want to create a db and simple form

Re: Newbie question

2004-02-22 Thread Rhino
program are definitely your best bets from the technologies you mentioned. Just my two cents worth, Rhino - Original Message - From: Walt [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 22, 2004 2:45 PM Subject: Re: Newbie question I recently

RE: Newbie question

2004-02-22 Thread Donny Simonton
-Original Message- From: Walt [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 1:46 PM To: Rhino; [EMAIL PROTECTED] Subject: Re: Newbie question I recently graduated from college, BS in computer science, I am familiar with a variety of languages including C++, Java, VB

Re: Newbie question

2004-02-22 Thread Walt
' [EMAIL PROTECTED]; 'Rhino' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 22, 2004 4:15 PM Subject: RE: Newbie question As a manager of over 20 programmers, I would say from a web point of via PHP would be your best bet. Everybody who graduates today can program in Java

RE: Newbie question

2004-02-22 Thread Donny Simonton
are in might only be looking for C programmers, so you become a C programmer. Just my opinion. Donny -Original Message- From: Walt [mailto:[EMAIL PROTECTED] Sent: Sunday, February 22, 2004 7:52 PM To: Donny Simonton; 'Rhino'; [EMAIL PROTECTED] Subject: Re: Newbie question Those

  1   2   3   4   >