Hi,
try command: flush privileges;
flush tables;
Michal Dvoracek [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
i have my.ini in %systemroot% directory (eg. winnt)
but if you run winmysqladmin an there is my.ini Setup tab, so here
you can set anything
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
-
Before p
Hi,
try check your permission in your MySQL and in scripts.
S pozdravem
Michal Dvoracek [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hi,
if you have 6 colums, you are inserting only 5 in table
INSERT INTO songs VALUES (' 1, blah', ' ***', ' 45', ' 2', ' ')
[1th ] [2nd] [3rd] [4th] [5th]
i think that first apostrophe is shifted to left side
should be:
INSERT INTO songs VALUES (1, 'blah', ' **
Hi,
try complete your query by adding word 'AS' syntax:
field AS name
so:
select USERS.name AS name1, USERS.name AS name2, USERLIST.user_id AS
id1, STUDENTLIST.user_id AS id2 student_id
from USERS, USERLIST, STUDENTLIST
WHERE
Michal Dvoracek [EMAIL PROTECTED]
Hi,
it's possible that db 'test' doesn't exists
mysql should run, 'coz mysql_connect was successfull.
check if you are connecting to right host and permissions from mysql
(if usr1 has access to db test and have logon from another host other
than localhost)
but if mysql_error return this error -
Probably you run mysql without user: mysql
try: mysql -u -p
or check perms(guest logins, user logins) for creating new databases
and RTFM.
Almost root (superuser) have access to table mysql, where are
permissions stored.
Michal Dvoracek [EMAIL PROTECTED]
-
For best performance i prefer this way (it's faster):
SELECT MAX(price) FROM shop;
rather than
SELECT price FROM shop ORDER BY price DESC LIMIT 1;
--
In second case MySQL must select all records from table, sort it and then apply
LIMIT (it's must be logicaly slower than first one)
Michal D
This is a forwarded message
From: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
To: Dvoøáèek Michal <[EMAIL PROTECTED]>
Date: Friday, June 15, 2001, 1:24:16 PM
Subject: Can only create 127 records in a table :o(
get back, due post not cointains some key words:
database
===8<==Original messa
Hi
is possible to create FULLTEXT index on column which is varchar(100)
binary ???
trying this i got:
"ERROR 1005: Can't create table './xxx/#sql-19b_444.frm' (errno: 140)"
i need column which can be fulltext searchable and case-sensitive
(therefore column is binary)
i alter column to normal (
Try link is with -L/path to your library -lmysqlclient
You need library libmysqlclient which is currently in
instaldir/lib/mysql/...
---
Dvoøáèek Michal mailto:[EMAIL PROTECTED]
-
Before posting, pl
Hi there,
little problem. I have program (like phorums) and there is command
mark all posts as readed. On one board is about 4000 posts, and if is
new user and want mark all posts as readed - it's problem (big).
All is written in ANSI C (using C API functions). And here is main
problem: when i e
12 matches
Mail list logo
