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
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 weekend
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
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
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
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
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
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
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
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
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 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
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.
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
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 fix
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 question and it didn't
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
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 such a
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
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
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
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
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
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:
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
33 matches
Mail list logo