On 10/03/2016 08:16 PM, Richard wrote:
> If
> you want/need to use it I believe you need to use the "backtick" to
> quote the name
>
Yes, that worked. Thank you.
Is there an easy way to rename a database?
--
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
T
' at line 1
If I replace 'sma-v4-01' with 'sma_joomla', the statement is accepted.
What is wrong with 'sma-v4-01'?
--
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
Think.
signature.asc
Description: OpenPGP digital signature
' at line 1
If I replace 'sma-v4-01' with 'sma_joomla', the statement is accepted.
What is wrong with 'sma-v4-01'?
--
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
Think.
signature.asc
Description: OpenPGP digital signature
>
That is rather vague.
What data is stored for each user?
What are these queries that a user may perform?
- --
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
-BEGIN PGP SIGNATURE-
Version: GnuPG v2
iEYEARECAAYFAlXUvlgACgkQzTcr8Prq0ZPrHQCdFDqY9uEa1mS6
w records.
>
I see no reason to create a unique user account for this use case.
Each user's data goes into a singe table, and a view based on the
user's ID would restrict data access for each user.
- --
James Moe
moe dot james at sohnen-moe dot com
520.743.3936
-BEGIN PGP SIGNATU
Walter Andreas wrote:
#define SYSTEM_TYPE "pc-linux"
#define VERSION "4.0.18"
configure: exit 77
andy ideas?
That's singularly sparse; not even a line number. All I can suggest is to
find where configure tests for an executable output and see what it's doing.
It may be misinterpreting "icc" f
Walter Andreas wrote:
CFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" CC=icc CXX=icc CXXFLAGS="-O3 -unroll2 -ip -mp -no-gcc -restrict" ./configure --prefix=/usr/local/mysql--with-mysqld-user=mysqladm --without-debug --with-client-ldflags=-all-static--with-mysqld-ldflags=-all-static --d
electroteque wrote:
well dude u never showed what the parser returned, i am pretty sure u need
curly brackets if u are including more than one line in an if statement
well dude u r like totally wrong.
--
jimoe at sohnen-moe dot com
--
MySQL General Mailing List
For list archives: http://lists.my
Andrew Iles wrote:
Is this the true behavior or does it just appear to work this way? And if
so, is there any way to force MySQL to automatically save data to disk in a
way that is chronologically correct? This would make it much easier for me
to recover from an unexpected crash.
What os/vers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 29 Aug 2003 15:59:18 -0400, Fortuno, Adam wrote:
> I need to access a database thru internet. It is secure to do this using
> MySql?
>
If the database traffic is encrypted, yes. I do not know if that is an option in
Mysql.
If you did not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 10 Aug 2003 17:25:05 -0700, James Johnson wrote:
>$ISBN = $_GET['isbn'];
>$query = "SELECT * FROM book_details WHERE ISBN = '$ISBN'";
>
Try using "where isbn like '$ISBN'"
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.key
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote:
>I need to replicate data (approx. 10,000 records) from a mySQL database into
>a different (non mySQl) database automatically on a regular basis. I have no
>control over the mySQL server (apart fro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 18 Jul 2003 15:42:47 -0400, Chris Edwards wrote:
>I have multiple OR logic in the where clause.
> where id = 1 or id = 2 or id = 3
>The list is finite, at about 20 ids.
>
You can also do this:
where id in (1,2,3)
- --
jimoe at sohnen-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 02:49:21 -0400, [EMAIL PROTECTED] wrote:
>I don't understand how to morph the following with your specification:
>SELECT firstName, lastName, deptPOS, workPH, homePH, location, model,
>make, propID, addressIP, OS FROM people, make
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 27 Jun 2003 01:44:53 -0400, [EMAIL PROTECTED] wrote:
>
>umm... how do I specify which "one"? (this sounds really "slow-poke"
>to me, sorry.)
>
Use either "people.peopleID = some_specific_ID" or "models.modelID =
some_specific_ID".
- --
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 30 May 2003 11:40:11 +1000, phieu huynh wrote:
>The problem is my netscape browser, somehow the file had been corrupted.
>I just re-download the file by using another computer and I can unpack
>the file.
>
Yes, navigator can be twitchy abou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 15:18:16 -0400, Hassan Farha wrote:
>SELECT * FROM TAB1 WHERE TAB1_ID IN (SELECT TAB2_ID FROM TAB2 WHERE TAB2_ID
>> 2)
>
>I know I this select is very simple, ...
So what's the problem?
- --
jimoe at sohnen-moe dot com
pgp/gpg
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 28 May 2003 14:17:55 -0500, Peter Fleck wrote:
The results you wanted and the results you get were not very clear. Some examples
would have gone a long way.
>SELECT grants.grantid, grants.refnum, dates.subdaynum FROM grants, dates
> WHER
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 16:33:45 +0200, Anthony Ward wrote:
>SELECT userid,subject,date,code FROM testing WHERE userid="testid"
>
Use only single quotes.
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.net/en/
-BEGIN PGP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote:
>I can ask for the data in any data format, but I would like to get some
>advice on what is best to ask for.
>
I have found text format to be the most flexible method for transferring be
20 matches
Mail list logo
