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
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
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
iEYEARECAAYFAlXUvlgACgkQzTcr8Prq0ZPrHQCdFDqY9uEa1mS62LuUr7FhqzEa
.
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 SIGNATURE-
Version: GnuPG v2
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 for
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
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:
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
-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 do
-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:
-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 from
-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-moe
-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.
- --
jimoe at
-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, 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 about
-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
WHERE
-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 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
-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
20 matches
Mail list logo