 | | | MySQL on Win32 | | Hello
I know I 've been a bit of a pain of late but am really pushing myself to
the limit.
The site has eight different sections and will probably end up with some
100++ files (pages).
I 'm quitHello
I 've deliberately left the look up table blank to test if
elseif ($ok1 OR $ok2 OR $ok3 0) {
echo ' <p > No entries found to delete </p > '
}
Works in the query below it doesn 't... I 'm usHello
Part of the script
$jokelist mysql_query(
'SELECT joketext name email
FROM joke author WHERE authorid author.id AND jokedate > "2004-04-01 " ' .
'AND joketext LIKE "w% " ')
If (!$jokeHello
I 'm trying to build an Estate Agents search but keep finding silly errors
I 'm making. Here 's one
<html >
<head >
<title > </title >
</head >
<body >
<?php
$dbcnx @(protected)( 'localhost 'Who has experience with setting up master-master replication with MySQL
between two Windows-servers. I would like to try setting it up and am
looking for experiences tips an possibly a hands-on manHello
This is not the QUERY that is a bit longer than this but the theory is the
same. Can this be done if so how should it be structured?
SELECT id LEFT(joketext 20) WHERE jokedate > "2004Hello
I 'm having to upgrade from 4.0.4 beta (which I 've had installed on my
testing server for (who knows how long - ever).
How do I back up all the databases on this server and will they all wo Kami dari pihak DataEntrySystem menawarkan pekerjaan part time ataupun full time kepada sesiapa yang berminat. Sila klik laman web di bawah untuk maklumat lanjut.
http //dataentrysystem.gobigoIt depends a bit on what you actually want to do with the duplicates but
if you are just interested in knowing if you have some then the
following should do the trick.
SELECT Name COUNT(*)
FROM MyTaRomeo
That depends a little on which version of mySql you are running. If
you 're running version 4.1 or higher you can use a subQuery. Something
like this
SELECT * FROM myTable
WHERE Code IN
table
Code int 7
Name char 30
need to find duplicate fields for field name. any
ideas please !
Romeo Petruca
George Enescu 16/13
Hunedoara
Romania
tel 0720301842/0354401534
e-mail rpetruca@(protected)Mark Mchugh wrote
> hi
> i need double the number of them cos in the database the file/path
> name is stored as
>
> \\192.168.0.100\clients\\o ' 'orielly\file1.pdf
>
> wierd?
>
Oh sorry in this case Mark
If you are trying to find the row as listed below you still have too
many backslashes.
To find '\\192.168.0.100\clients\\o 'rielly\file1.pdf '
Look for '\\\\192.168.0.100\\clients\\\\o\ 'rieMark
My experience is mainly Oracle but it may help. I would expect you to
have to include the ' in quotes i.e. ' ' '.
If I read your statement correctly I would expect something like the
followisorry thats a typo its the more traditional spelling....
----- Original Message ----
From Lawson Cronlund <lawson@(protected) >
To Mark Mchugh <mark_mch@(protected) > mysql list <win32@(protected)Just a na?ve question. Was your query to find a client of o 'oreilly (as
shown) or o 'reilly (a more traditional spelling)?
Regards
Lawson Cronlund
lawson@(protected)
+1(480)308-0641 (voice)
+1(602hi
i need double the number of them cos in the database the file/path name is stored as
\\192.168.0.100\clients\\o ' 'orielly\file1.pdf
wierd?
----- Original Message ----
From Todd Farmer <todd@(protected)Mark Mchugh wrote
> for some reason this does not seem to work either?
I think Petr 's comment is correct but perhaps there are other reasons
this is not working the way you expect. It seems like for some reason this does not seem to work either?
----- Original Message ----
From Petr Vileta <petr@(protected) >
To mysql list <win32@(protected) >
Sent Thursday October 25 2007 1 04 10 AMark Mchugh wrote
> Hi
> I am writing an sql to retrieve data relating to certain files in a
> folder from my database. Some times part of the data may contain a '
> character.
>
> here 's an exampleHi
I am writing an sql to retrieve data relating to certain files in a folder from my database. Some times part of the data may contain a ' character.
here 's an example of the sql
select * from filyes i dont see it there when i 'm installing the
install path is blank which makes me belive its not
installing correctly?
--- "Bonnett John " <John.Bonnett@(protected) >
wrote
> Be careful Be careful you won 't see it in the list of user data sources until you
have created one. Try adding a data source and you should see "MySQL
ODBC 3.51 Driver " in the list. If it 's not there THEN you You 're running 64 bit Windows 2003 Server and you 're using the 64 bit ODBC
tool. But the MyODBC driver is 32 bit. There 's a 32 bit ODBC
Administrator at
%SystemRoot%\SysWOW64\odbcad32.exe
You canSilly Question 1 Is it in Add/Remove Programs?
Silly Question 2 Have you rebooted your server since the install? You shouldn 't have to but this is Windows we are talking about and you may havi dont even see it in the drivers tab all i can see
is one for sql server it apprears to have installed
correctly according to the install program seems very
odd?
--- "J.R. Bullington " i dont eveNot at all as it is not apparent to the first tab where the driver is installed.
If you have not installed the MyODBC before then none of your DSN 's will reflect the new driver.
To ensure thatI 've installed the above but when i got to admin
tool/ data sources i cant see it have i been very
dumb again?
I 'm trying to figure out how to use SSL support with MySQL 4.1.22. The
help indicates that mysqld-max includes SSL support but no matter which
binary I run (mysqld mysqld-max etc.) if I start it I think we need a bit more than "it wont work ". Do you get any error
messages? What exactly happens?
I do restores like this
mysql -hlocalhost -uroot -p [DatabaseName] <dump.sql
Replace [DatabaseNa |
|
|
