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).
>
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.
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 slav
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 e
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 mysql
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 rest
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 saf
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 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() l
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 ($stri
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 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 foreig
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 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
