Hi,
I need a little help on my SQL syntax.
I want to store forbidden inputs from the GUI in a table and query it on
input from the user;
simple layout:
CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0'
AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`),
Hi Jason,
Sorry for the late reply.
If all of the 100,000 entries have extra backslashes, that can be fixed
with a query. But then you have all your code. :-(
Speaking of code, what language are you using? I always assume PHP, but
with 500k lines I'm thinking you're using C?
Is somebody\'s the
Hi Joe,
No, I don't know exactly. Releases usually come out at about the same
interval. So going by previous releases, I would say 4.0.17 should be
released within 2-4 weeks -- probably shortly after 4.1.1.
Matt
- Original Message -
From: "Joe Lewis"
Sent: Friday, November 14, 2003 11:
Hi all,
I have already asked it a few days ago, but I got no answer.
Does anyone know how to obtain the newest version of libmysql.dll and the header
file(s) for it?
Thanks,
niel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
I don't think you can do what you want in one query if you use the adjacency
list tree model (i.e. a self join to the parent node). See the article
below comparing the adjacency list and the modified preorder tree traversal:
http://www.sitepoint.com/article/1105
I'm not sure if that is what yo
Hello:
I'm using mysqlcc version 0.9.3 on RH 9.0.
When I upgraded from RH 7.2, the application seems
to have changed into a bizarre, unreadable font.
Does anyone know what could be the problem?
Obviously, this renders the application entirely
unusable. I suspect a QT problem, will look for
sou
At 14:13 +0200 15-11-2003, Davut Topcan wrote:
> I have just started working on MYSQL.
Can ne one help on How to take a database Backup?
Backup;
shell # mysqldump table > table.sql
I use a command-line PHP script (-rwx--, owned by root, executed
with a cron job) to backup MySQL databases.
"John Berman" <[EMAIL PROTECTED]> wrote:
>
> Hi. using MYSql 3.28
There is no such version of MySQL :)
>
> I have a surname column with a standard index and this is the column
> were search are performed on, currently the filed only has the one name
> i.e.:
>
> Surname: smith
>
> I want to in
Dear all
Getting confused in the mysqlcc as a [EMAIL PROTECTED], I managed
that I cannot grant privileges any more. Any hint how I can undo
that?
Thanks, W. Bauer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
I have the following columns in a table:
posts.id
posts.parentId REFERENCES posts.id
This represents a tree that has a single root node, and each node can
have 0 or more children. posts.id is the id number of a node, and
posts.parentId is the id number of that node's parent (is NULL for the
root
Hi
From: "Swati K" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 15, 2003 1:40 PM
> I have just started working on MYSQL.
> Can ne one help on How to take a database Backup?
Backup;
shell # mysqldump table > table.sql
for details; http://www.mysql.com/doc/en/Backup.html
Hi All
I have just started working on MYSQL.
Can ne one help on How to take a database Backup?
and how does one transfer the MYSQL database from one Comp to another one?
Regards
Swati kalia
http://www.mecklai.com
where risk meets its match
***
This message i
Roger,
> * Elisenda
> [...]
>> The explain select says as follows:
> [...]
>
> I re-formatted the query and the EXPLAIN output for readability:
Sorry for not re-formatted the query, I've learn it for next time.
Well, I've learn a lot with your lessons.
>
> Select FASE.PR_Date_Visita_2, CE.CE_
>Description:
mysqld (4.0.16) built with SSL support (--with-vio --with-openssl)
crashes if both of the following conditions are met:
1. Permissions for a user have been set with GRANT...REQUIRE SUBJECT
or GRANT...REQUIRE ISSUER.
2. A client program attempts to connect to the server by calling
m
Subqueries aren't supported in MySql prior to ver 4.1.
- Original Message -
From: "Becky OGrady" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, November 15, 2003 12:28 PM
Subject: NEWBIE!! need help with nested select query
> Hi-
>
> I have 2 queries that I know work in SQ
Hi-
I have 2 queries that I know work in SQL Server, but I
can't figure out why they won't work with mySQL.
SELECT email, comments, (select count(*) from guests
where decision=3) as total, (select count(*) from
guests where decision=2) as secondtotal
FROM guests
AND
SELECT email, comments, NULL
16 matches
Mail list logo
