Matthew Stuart schrieb:
> I've got this statement to select the last two entries in my db:
>
> SELECT top 2 *
> FROM Content
> ORDER BY ContentID desc
>
> and it works fine because it selects the last two items entered into
the db. However, I only want to be able to select item 2 rather than
bo
tom wang schrieb:
Hi,
I have the following sql request:
SELECT projects.`id` AS t0_r0, projects.`name` AS
[..endless sql..]
Hi Tom,
did you understand that query (in lets say 3 months) if you need to fix
a bug? If not it maybe better to simplify that.
regards
-ralf
--
MySQL General Mai
Hi Jesse,
071020 14:43:51 InnoDB: Started; log sequence number 0 142497221
071020 14:43:51 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: ready for connections.
as i can see you are running mysql on windows.
If i start my db server (5.0.45/innodb/win2k) the server uses about ~
Hi,
can i change the datetime format on mysql in a german format?
At the moment the dates are stored like "2007-10-19 19:06:17" but if i
send a query (which comes from user input) the query looks like "WHERE
Datum >= '19.10.2007'" and i got not what i want.
iam using mysql (5.0.45) on (germa
Olav Mørkrid schrieb:
> hello
>
> i would like to search a table column for a range of non-ascii
> characters, or a particular non-ascii character. how can i do this?
Maybe via a inverted regular expression [1] like this?:
SELECT * FROM WHERE RLIKE '[^-, a-zA-Z0-9]'
[1]: http://dev.mysql.c
Hi,
When i try:
"SELECT *, id FROM "
all is fine.
But if i want the "*" at the end (because the table is large)
i try:
"SELECT id, * FROM "
and got:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '*
