On Fri, Sep 07, 2001 at 09:28:28AM +0200, Antonio Ortega Sancho wrote:
I'm trying to do select count (*) from table. but it doesn't work
ERROR 1064: You have an error in your SQL syntax near '(*) from pendientes'
at line 1
Same happens with max (column) and min (column).
Do
On Mon, Sep 03, 2001 at 06:18:34PM +, ahmed wrote:
please can you give me a cooorect programme source using C APIs
mysql to acces mysql database
http://www.dataloss.nl/software/dteq/ is such a thing. /plug
Greetz, Peter
--
Monopolyhttp://www.dataloss.nl/monopoly.html
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote:
[snip]
Here, seems that are the slaves that pop data from master.
So where is the truth ? Is the master that pushes or the slaves the pops ?
Or it is a combination of the two ?
In normal operation, the master pushes to the slave.
On Fri, Aug 17, 2001 at 09:32:05AM -0700, Christopher Teli wrote:
How can I check if an index exists on a table???
Is there some where I can query the admin tables?
'DESCRIBE tablename' or 'SHOW COLUMNS FROM tablename'. Figure out
where it says 'index' for yourself :) (since I don't know
On Mon, Aug 06, 2001 at 04:57:41PM -0400, Kevin wrote:
I need a utility that will probe my existing mysql database, analyze the 90+
tables and spit out the data definition language (create table, create
index, etc.) needed to recreate the database. Does such a utility exist?
Tried
On Tue, Jul 31, 2001 at 06:48:07PM +0400, System Administrator wrote:
I wonder whether the default directory structure of all future mysql
releases could also be GPL'led. That would prevent others from placing
the releases on directories of their own choice.
The GPL does not impose any
On Wed, Jul 25, 2001 at 07:12:17PM +0200, Alexander Skwar wrote:
[snip]
'encryption'? Hmm, how about: none? If you don't need to reconstruct
the cc#, md5 will be good.
Indeed. That is however rarely the case with credit card numbers.
However, if you need to reconstruct it, nothing is safe.
On Mon, Jun 18, 2001 at 02:44:00PM -0400, Shrout, Ryan wrote:
Here is the full error I am getting when running the query included:
Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
1054 : Unknown column 'CMET3558539239' in 'where clause'
Here's the problem, I know
On Wed, Jun 13, 2001 at 02:14:48PM -0700, samuel wrote:
Hi,
I need a one way encryption for a 16 digits string.
let's call $string the clear string, and e($string) the encypted string.
I need e($string) to give always the same result for any $string,
and I need e($string1) != e ($string2)
On Wed, Jun 13, 2001 at 03:25:55PM -0600, Matt Heaton wrote:
I can't seem to find a specificatoin on order by rand() and have a question.
Lets say a table has 10,000 rows in it, and I want to get one row that
matches
so I do a
select * from table where number=1 order by rand() limit 1;
On Fri, Jun 01, 2001 at 09:26:08PM +1000, Howard Picken wrote:
After reading the manual and doing vaious searchs around
the net, I'm damned if I can work out the syntax for
mysql_info().
Could anyone give me an example please?
In what programming language?
Greetz, Peter.
On Mon, May 14, 2001 at 09:32:05AM -0400, lkeeton wrote:
[snip]
how does it take place. For instance in this example I pass 5 it then gets to
the line below and evaluates value = 5 * factorial(5-1)- right there that
tells me to call the function again and pass it 4 then when I get to the
On Mon, May 14, 2001 at 07:26:44AM -0700, Shtykh Roman wrote:
When I try to telnet MySQL which uses port 3030 as
below:
telnet grdmss57 3030
I get :
Trying 163.143.156.38...
Connected to grdmss57.u-aizu.ac.jp.
Escape character is '^]'.
(
3.23.38jN(xIDWiConnection closed by foreign host.
On Fri, Apr 20, 2001 at 12:03:22PM -0300, Fabio Galarraga wrote:
Hi to all:
I have a linux script and I need it can execute some mysql commands.
Is it possible? If possible, how?
http://www.dataloss.nl/dteq/
(you probably want to disable DEBUGging in the Makefile).
Greetz, Peter.
14 matches
Mail list logo