| |
| |
| |
|
Comments:
<0> Is there a way to set MySQL into true read-only mode? I've attempted "SET GLOBAL read_only=1;", but this still seems to allow updates and inserts to take place.
<1> chmod -w /var/www/mysql/database/table
<2> anyone know the criterion syntax in access for filtering a list where char len > 3?
<3> can i get the min/max value of a field(int) ?
<4> rtfm
<5> ?
<2> In a query, what's the syntax for a criterion which looks at the value of Field1 and applies that?
<6> perhaps you mean WHERE
<7> hi
<8> I created a DB with WAMP in windows .. how do i port it on freebsd 6.0 (mysql 5 ) ?
<5> what is wamp?
<8> :)
<8> it's like LAMP for Linux
<8> AMP = apache, MySQL, PHP
<7> there is a way to create a global variable into a database ? because I have 2 program, one is the client and other one is the manager and I dont want the client access to the database while the database is in maintenance
<7> si I would like to declare a global variable with value 1 or 0
<5> a bit
<7> and I think is stupid to create a table just to hold a bit lol
<5> yeah maybe
<5> I don't know much about those database stuff
<7> ok
<5> but I get the thing I think
<5> you want to put the variable at 1 if it's in maintenance, and check every time a client logs in wheter or not that variable is 1
<5> if is 1
<5> he can't do anything
<7> yes
<7> that's right
<5> looks a good idea to me
<7> because I dont want the user use the application while the admin guy is adding some stuff into the database
<5> yeah I understand that
<5> why not create one table for that
<5> you have to store it somewhere
<5> unless there is some kind of function
<5> that checks if there's allready a database connection open
<5> but again, if there are multiple users
<5> who are all clients
<5> no use of that function
<5> oh well don't listen to me
<5> I'm too noobish at this stuff :p
<7> :P
<7> but I will create a table to add the name of each pc is connected so the admin cannot modify the db while the application client running
<7> so it can know wich pc is using the database
<5> well then
<7> but on the other side, only 1 person can modify the db so a table for 1 value ...
<5> I know sounds useless
<7> could be a thing to add in future version of sgbd :)
<5> ok i'll google that one
<7> brb later but I'll keep online
<5> is that french?
<7> what ?
<5> sgbd?
<7> oh yes, sorry :)
<5> you're french?
<7> in english I think it is: database managment system
<7> yes
<5> cms :p
<7> cms ?
<5> content managment system
<7> oh ok :)
<7> brb :)
<5> ok
<5> good luck
Return to
#mysql
or
Go to some related
logs:
#linux
#php
#linuxhelp
WhitneyMcGuire occ
#AllNiteCafe
12WHAT IS THE NEAREST REPUBLIC TO THE U.K?
#c++
#php
okmu heck
linux donwald
|
|