Folks,
please forgive the newbie panic but I believe I've gotten myself into
trouble.
After experiencing some problems with a db I decided to run the
'Repair' commands from the MySQL Administrator program. After failing
to find anything significant I (somewhat foolishly) ran the Use FRM
Hello,
I'm creating a new MySQL database from an existing Filemaker db.
My problem is that some of the existing 'numbers' in one column (it
was a text field in FMP) have leading zeros. eg: 003, 0007, 012,
001234. I need to maintain these numbers 'as is' - complete with
zeros. I've tried al
G'day Braulio
> What is the best way to learn php and mysql? What book is recommended for
> self study of both ?
As an absolute newbie I used "Build Your Own Database Driven Website Using
PHP & MySQL" from http://www.sitepoint.com/books/phpmysql1/ It got us up
and running pretty painlessly
G'day Brian
> I've installed the latest MySQL from www.mysql.com to my computer, but
> decided later to try the Complete series of web tools to get access to
> Apache v2. Complete Apache v2 and Complete PHP is installed, but I
> have to remove the original install of MySQL to install the Complete
G'day Sam
> I am upgrading to Panther and I need to install MySQL. Does anybody
> know if the Mac OS X Installer Package v10.2 (Standard) works with
> 10.3? If it doesn't then what would be the best installation method on
> a clean 10.3 installation?
FWIW, I upgraded to Panther on the weeke
Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with the PHP I use to query the db but I have faile
G'day Victoria
> You can use mysql in a batch mode like:
> mysql -e "LOAD_DATA_command_here"
That's perfect, thanks. Exactly what I was looking for and now up and
running.
Cheers and thanks again
kim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
G'day all
I'm trying to run a connection and query from one line (it will eventually
be called as part of a 'do shell script' Applescript on Mac OSX)
The connection works fine:
/library/mysql/bin/mysql -uroot -ppassword mydatabase
And then I want to load a file using:
load data infile '/Users/S
G'day Bob
>> I'm a novice Unix user, and I can't get MySQL set up properly on my
>> Mac. It seems to have installed OK, but when I try to run the
>> mysql_install_ db script, I get errors. I can't set the root password
>> either that the documentation tells me to.
There is an alternative inst
G'day Nils
> just send a reply a minute ago. I got it now. You want to change the way the
> data is presented at the screen and thats a different issue. You would have
> to make this in your apllication, not with mysql itself I believe.
> You basically want the DISTINCT function within the JOINS -
G'day Nils
Well, I can't speak for Daniel, and I'm not really up on his tables, but I'm
not using left joins. The situation I have is not one where I need to
display items that don't exist from one table or another.
The data I get from a basic join is the _data_ I want - I just can't get it
to di
G'day Nils
> no offense, but are you actually using the JOIN syntax correctly ?
No offence taken - that's why I'm asking the question - I don't know whether
I'm approaching this correctly. As I said, I'm new to MySQL ...
> Could you post your query please ?
OK.
Adtrack - holds data a
G'day all,
I'm pretty new to MySQL and very new to v4.
This is probably going to sound strange, but is it possible to create a
union using the logic of a join? I have 4 tables and I need to join data
from them, but I'd like to display them like a Union. If I do a straight
join, I get lots of mul
G'day Jim
> What about this?
That's it, thanks!
I'll be fiddling a bit to get a few other columns but so far this seems be
be what I want. The only book I have which handles Unions is the MySQL
Cookbook (Paul Dubois) and the examples didn't include any 'where' clauses
so I didn't realise t
G'day Charles
> I am desperately searching for a GUI RAD environment to develop database
> applications for MySQL.
Try www.servoy.com and you might find what you're looking for
cheers
kim
-
Before posting, please check:
G'day César
> I have a problem when posting. The thing is that every time I post to
> the mailing list, I get an error saying that the message could not be
> delivered but it does indeed.
It's getting delivered to the list OK but one of the subscribers to the list
is rejecting it. I've seen
G'day Cameron
> Of course MySQL stores dates in -MM-DD
> whilst filemaker uses DD-MM- and so when I import my delimited text file
> MySQL interprets the dates incorrectly. I can't seem to find a way of
> changing the date format in Filemaker,
This can be done easily (we do it every
G'day Nic
> Just by typing part of the word ,how can I make a
> search in databse possible by using something like
> SELECT in SQL?
Seems like you just need the % wildcard character
SELECT LASTNAME, FIRSTNAME, DEPARTMENT FROM EMPLOYEES WHERE LASTNAME LIKE
"%searchdata%";
cheers
kim
G'day Dave
> What was this? I just threw it in the bin without opening, but it looks
> very smelly(presumably even more so if you use OE)!
Yes it' a virus - one of the klez variants that are rampant at the moment.
It exploits a security hole in IE and creates its own smtp server/socket to
fu
G'day Son Nguyen
> Do anybody knows the range of MEDIUMINT, and BIGINT type to use
> when I do the create table in mySQL ?
>From the manual at http://www.mysql.com/doc/C/o/Column_types.html
MEDIUMINT[(M)] [UNSIGNED] [ZEROFILL]
A medium-size integer. The signed range is -8388608 to 8388607
G'day All
>"kimtest","Kim","","","this is kim¹s test stories¹ to see how we c¹n
>accommodate single quotes¹ There are a ³couple² of ³double² quotes here
>to. And ³here are some single¹ quotes that¹re enclosed in
>doubles²","2002-4-4","",""
I seem to have found the problem to my own questi
G'day Colin
> load data local infile '~/Documents/web export.txt' into table stories
> fields terminated by ',' enclosed by '"' escaped by '\\' lines
> terminated by '\r'
> (StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication);
Thanks for your suggestion but sadly it didn't fi
Hello All,
I'm having a problem when using Load Data where the single and double quotes
in the text file are getting nuked. It appears that the escape character is
not being respected but I'm not sure why. It is also knocking out
characters near the quotes.
The command I'm running is:
load dat
G'day rory
> it is possible to link his filemaker database to the MySQL database
Perhaps this php class would be of use to you. From the Read Me:
FX.php is a PHP class for accessing FileMaker Pro data. FX is free and
open-source. Thanks to FX.php, FileMaker enthusiasts can now access thei
G'day Ron, all
> Tailor your query to the request of your user(s).
> if ($param1)
> $sql .= "(ad_copy) against ('$param1')";
> if ($param1 && $param2)
Thank you for your reply. If at all possible though, I'd like to do it from
the mysql side rather than the php side of things.
Is there su
Hello all
I am trying to query two columns in mysql which have fulltext indexes using
the following:
SELECT ID,publication,run_date,left(ad_copy,40) as Advertisement FROM
classifieds WHERE MATCH (long_group) against ('\"$param2\"') AND MATCH
(ad_copy) against ('\"$param1\"')
As you can probably
G'day Arjen
> FULLTEXT search generally uses an index (the FULLTEXT index), so the
> server will not use an index on Writer.
> So far for the answer to Kim.
So is an index on Writers worthless in this circumstance? My concern would
be if someone did a query using the writer's name as the _on
G'day Paul
Thank you for your response.
> Sure, but no index will be used for the LIKE pattern match part of the
> query because your pattern doesn't begin with a literal string.
I realised after I sent the previous post that I should have omitted the
first '%'. I had mentally noted this f
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a table
Hi All,
My apologies for asking what may be a very newbie question. I'm having
trouble getting my head around searching multiple indexed columns. I have
read the MySQL docs 5.4.3, 5.4.4, 5.4.5 and 6.8 full text and have scoured
Paul's book but haven't been able to find an answer.
We have a table
G'day Daren
> $query = "SELECT * FROM tbl_name WHERE LEFT(last_name, 1) == '$letter')";
> NOTE: LEFT() is a "special" function, I'd consider it a derivative of
> SUBSTRING()
Does MySQL have a function that can selectively return words from a column?
What I'm looking for is the equivalent of
G'day Cathy
> we feel it only
> fair to be given the opportunity to correct said misinformation.
You're forgetting that your original mail was forced upon us by you - in my
eyes, your right of reply is dissolved with this action. If you don't like
the negative response, don't make the origi
G'day all,
For some reason I am receiving messages from the MySQL list (only) which I
have already received - some more the a week ago. Is anyone else getting
repeat posts?
kim
-
Before posting, please check:
http://www.mys
G'day Michael, (I can't believe I'm _really_ replying to you:-)
> I don't agree that we should make the list subscribers only, as this
> would be a big drawback for newcomers to MySQL.
I'm a classic newcomer to mysql and have only been on the list for a week or
so. It surprised me how much s
34 matches
Mail list logo
