Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with the PHP I use to query the db but I have faile
Just wondering if things like number of contemporary user connected etc. are
predefined
in mysql-max, in order to handle many connections. Can I handle 3000++
users/clients?
Pls help me with mysql max tunning.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I'm not sure what you're using to query with, but with the REGEXP expression
you can OR(|) regular expression out the wazoo, so the capablility is built
in MySQL.
and I would consider it to be a pretty straightforward solution, you can do
something like
WHERE lookup RLIKE "this|that|other|^start
* Unnar
> I have a problem with this query
>
> Version MySQL 4.0.15-nt
>
> The query gets all articles written by author but excludes those articles
> which are related to products
>
> SELECT DISTINCT
> post.post_id,
> post.title
> FROM
> c_posts post,
> c_post_produ
Pls help me, I want to know if this connection string can be used for multi user, coz
when I change "Server=localhost" with "server=127.0.0.1" it can not work. thanks
Connect_Str = "Driver={MySQL ODBC 3.51 Driver};" & _
"SERVER=127.0.0.1;" & _
"Database=seko
After modifying user privileges, the new privileges do
not take immediate effect. You need to "load" the
changes by issuing the following command:
FLUSH PRIVILEGES;
See the MySQL manual page
http://www.mysql.com/doc/en/FLUSH.html#IDX601 for more
detail.
--- Dan Jones <[EMAIL PROTECTED]> wrote:
>
Hi Dan,
If you manually modify the mysql database without using GRANT, then you
need to FLUSH PRIVILEGES afterwards to get MySQL to reload the
permissions. Of course, restarting the server has the same effect. Using
GRANT takes care of everything automatically, though.
Hope that helps.
Matt
-
When you make changes to the mysql database (the database which controls
how MySQL works), does MySQL automatically load the updates? When
adding users or changing security permissions for hosts or users or
databases, it seems like some updates take affect immediately and some
don't. Are you supp
Off the top of my head, I'd say use the
DATE_SUB(date,INTERVAL expression type) Function (see
manual page
http://www.mysql.com/doc/en/Date_and_time_functions.html
for details)
For example:
SELECT * FROM myTable WHERE date_field >=
DATE_SUB('2003-10-19', INTERVAL 7 DAY);
To get the records for th
How can I pull all records within a 1 week time frame? So if I enter
2003-10-19, how can I write a query that will get all records from
2003-10-12 - 2003-10-19.
Thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.my
Hello,
Roger Baklund schrieb am Freitag, 17. Oktober 2003 um 23:40:
> ok, then something is obviously wrong. :)
> Try selecting some columns from each table, to see what is going on:
> SELECT a.ID,b.EAN,b.ISRC,c.StationID,d.status,c2.StationID,d2.status
> ...
I found the problem: Normally, the
I have a problem with this query
Version MySQL 4.0.15-nt
The query gets all articles written by author but excludes those articles
which are related to products
SELECT DISTINCT
post.post_id,
post.title
FROM
c_posts post,
c_post_product prod,
authors_relati
Hello,
I'm curious as to if something is possible - I don't know if its possible to explain
it right.
I have a table which contains a bunch machine specific information, file paths, names
etc.
What I would like to try and accomplish is when I query this table for the information
I need, I a
Hi experts,
I need to create a static library for an embedded application with a
4-Byte alignment with BCC32 version 5.0.
I prefer using the command line version.
Using the files from the current distribution .\mysql\libmysqld results
in early compile errors already in config-win.h, line 93, obv
Thanks, Mark, for the syntax. I had actually played around enough to
figure it out already and got it to work the way that I wanted to. I
guess when I asked the question, I wasn't fully aware of what I was
wanting. The LAST_INSERT_ID wasn't a major issue. I ended up using the
following code:
Hi Jason,
For MyISAM tables only, you can manually set the auto
increment counter using the syntax:
ALTER TABLE table_name AUTO_INCREMENT = 1000
Keep in mind, however, that this does not change the
value of the LAST_INSERT_ID() since it still
represents the value last inserted. On a freshly
crea
Hi
I can write a query such
where left(t1.txtDevPostCode,5) in
(#QuotedValueList(qryRadius.postcode)#)
but unfortunately UK postcodes are variable length
SO I really want something like
where REGEXP(t1.txtDevPostCode,"^[a-z]{1,2}[0-9]0,2}") in
(#QuotedValueList(qryRadius.postcode)#)
This use
Hello,
> mysql> select *from accounting where uid = (select uid
> from user wher gid="apswan");
> ERROR 1064: You have an error in your SQL syntax near
> 'select uid from user wher gid="apswan")' at line 1
> mysql>
Take care, you wrote "wher" instead of "where".
And as Leonardo pointed out, th
Probably there's nothing wrong with the query. The problem seems to be
that MySQL you're using (v3) does NOT support subqueries. Note that MySQL
v4.0, the actual production release, does NOT support subqueries either.
Subqueries are supported on MySQL v4.1, which is still in ALPHA stages
Hello Friends,
i am new to mysql and plz don't treat my question as a
cilly as i am just getting into mysql.
my problem is:
when i am executing the following query i am getting
the error. whats wrong with the query? "desc" of table
"accounting" and "user" and contents of them are also
listed bel
We use MS Access with ODBC links to MySQL, but prefer a commercial product
called MyManager. It cost about $199.00 US. for the professional version.
looks and works much like MS Access. There are several on the market, we chose
this one as the best for our purposes.
Here's the link: http:
Attention Folks!
These letters are trap for you. If you vanna loose some money and maybee Your
life, try it!
On Sat, 18 Oct 2003 19:46:29 GMT, chrislor100 wrote
> Mr.Christopher Tayelor
> Brait Merchant Bank.
> 9 Fricker Road,
> Illovo Boulevard
> Illovo Sandton
> Republic of South Africa.
>
Sorry folks, just wondering about my email provider
-Jakob
--
To Unix or not to Unix. That is the question whether 'tis nobler in the
mind to suffer slings and arrows of vast documentation or to take arms
against a sea of buggy OS and by raping the support lines end then? ;>
--
MySQL General Ma
I have a ticketing system that sets the ID of the ticket as the
LAST_INSERT_ID. By default, it was counting up from 0. I updated the
ID of the last ticket to reflect a different numbering scheme
(MM). I would like to automate this but I don't want to change
the ID of a current ticket. I
On Sat, 18 Oct 2003 09:42:30 -0600 Colleen Dick said:
>CD- Have anybody ever set up MS Access as a frontend to mysql?
>CD-
>CD- the dB is an already established mysql db running on linux
>CD- I don't want to convert it, just use access to get to it.
>CD-
>CD- I have followed the recipe at
>CD- htt
25 matches
Mail list logo
