Janek,
Thanks for responding.
I was really hoping to not have to go to any third parties and start a
whole new learning curve.
Is what I'm after really not possible with MySQL?
--
Dave M G
Ubuntu 6.10 Edgy Eft
Kernel 2.6.20-5-generic
Pentium D Dual Core Processor
PHP 5, MySQL 5, Apache 2
--
Sorry for the beginner's question, but I'm confused. I can easily create
passwords and usernames for my online databases by going into my C-Panel and
clicking a MySQL icon. It fetches a page that allows me to easily create and
delete databases, add and change passwords, etc. But I can't remember
I'm in the process of moving a MySQL database with about 170 tables from my PC
to a new MacBook Pro. On my PC, I exported each database table as a SQL file,
then copied a folder containing all these files to my Mac.
I'd like to know if there's a way to import all these SQL files into a database
That still didn't work. I think I just need to restart the mysql
service.
Denise Lopez
UCLA Center for Digital Humanities
Network Services
Systems Engineer
337 Charles E. Young Drive East
PPB 1020
Los Angeles, CA 90095
310/206-8216
From: Juan Eduardo Mo
Denise,
Hola!.
1) Connect to the system like root user
2) $ chown -R mysql:mysql /usr/local/mysql/
3) In oder to create user use :
mysql> GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@"%"
IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Regards,
Juan Eduardo
On 3/20/07, Lopez
Hello everyone,
I had a really weird thing happen and I was wondering if anyone has seen
anything like this. From a shell command line I connected to a running
instance of mysql with the mysql -u root -p command. I successfully get
to a mysql prompt. I needed to create a new database and user for
How about...
SET @x=(SELECT COUNT(*) FROM ... WHERE ...) - 20;
SET @sql=CONCAT("SELECT ... FROM ... WHERE ... LIMIT 20,", @x );
PREPARE stmt FROM @sql;
EXECUTE stmt;
DROP PREPARE stmt;
PB
-
Dan Buettner wrote:
Another solution might be something like:
SELECT * FROM tablename
WHERE id NOT
Another solution might be something like:
SELECT * FROM tablename
WHERE id NOT IN (SELECT id FROM tablename WHERE some criteria ORDER BY
something LIMIT 20)
ORDER BY something
Dan
On 3/20/07, Rolando Edwards <[EMAIL PROTECTED]> wrote:
SELECT ... FROM ... LIMIT 20,1;
100 million is a
Hmm!
Clever!
Thanx
Rolando Edwards wrote:
SELECT ... FROM ... LIMIT 20,1;
100 million is a little exaggeration
but you can other reasonably high numbers.
Remember, LIMITs are zero-based not 1-based.
- Original Message -
From: "nikos" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.
On Tue, Mar 20, 2007 at 02:38:25PM -0400, Mohsen Pahlevanzadeh wrote:
> Happy new Nourooz!
>
> I hope to you have a good year...
Happy new year :)
Cheers,
David.
--
David Fetter <[EMAIL PROTECTED]> http://fetter.org/
phone: +1 415 235 3778AIM: dfetter666
SELECT ... FROM ... LIMIT 20,1;
100 million is a little exaggeration
but you can other reasonably high numbers.
Remember, LIMITs are zero-based not 1-based.
- Original Message -
From: "nikos" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Tuesday, March 20, 2007 12:50:49 PM
On 20 Mar 2007 at 12:50p -0400, nikos wrote:
Does any body knows how to select not the LIMIT 20 records but the
rest of them?
MySQL version is 4.1.21-standard and I cant make a VIEW.
In Venn-speak, you are asking for Circle A less(, minus, or subtract)
Circle B. In SQL, this would transla
Hello list.
Does any body knows how to select not the LIMIT 20 records but the rest
of them?
MySQL version is 4.1.21-standard and I cant make a VIEW.
Thank you
Nikos
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
To you all,
Thanks for your input. The "TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')%
4" where statement worked perfectly. And, thanks for the reference to
the manual. It can be a bit daunting for a newbie.
Bob Cooper
> Dan:
>
> Thanks!
>
> Jim
>
> > In the last episode (Mar 18), Jim Ginn said
Not sure what is going on, but the version of MySQL you are using is
ancient. The current version of MySQL is 5.0.37. Even MySQL 4.1 (which
has been end-of-lifed) has a latest version of 4.1.22. If it is a bug
you are seeing, it likely has been fixed in a later version.
Cheers,
Jay
Kishor
Sorry, you can't use a preceding asterisk. It is annoying. The only
alternative is to use a LIKE operator.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Philipp Wabinski [ma
You need do SHOW INDEXES FROM ;
You will see a column called Cardinlaity (another word for a unique count).
This tells you how many distinct values exists at the given Seq_in_index for
the index.
If the Cardinality of an index is low in relation to the number of rows in the
table,
then MySQL m
Hiep Nguyen wrote:
i believe "date" is a reserved word for mysql. don't use reserved word
for the column name. it's confused.
Using reserved words may be confusing, but it is fine as long as you put
them between backticks, as I'm sure the OP is aware of.
On Tue, 20 Mar 2007, Peter wrot
i believe "date" is a reserved word for mysql. don't use reserved word for
the column name. it's confused.
On Tue, 20 Mar 2007, Peter wrote:
Hello,
I have a a large a table which a field called date, type date.
When I select a smaller range e.g 3 months system uses the index 'date'.
That
Hi,
can somebody tell me, if it`s possible to search for substrings with a
fulltext search?
We are using a fulltextsearch in boolean mode. I tried a lot but the search
doesn`t find any substrings.
The mysql reference just hast got an example like this:
"apple*" that finds everything that begin
>Description:
Mysqldump seg faults if compiled with openssl support.
gdb output:
Starting program: /usr/local/bin/mysqldump -cf anydb
Program received signal SIGSEGV, Segmentation fault.
0xff24db6c in mysql_options () from /usr/local/lib/mysql/libmysqlclient.so.15
(gdb) bt
#0 0xff24db6c in mysql_
Hello,
I have a a large a table which a field called date, type date.
When I select a smaller range e.g 3 months system uses the index 'date'.
That is for let's say 2 million rows.
If I select wider date range mysql stops using key. It says possible key
"date", but do not use it and goes over a
- Original Message -
From: Jonathan Trahair
To: MySQL General
Sent: Monday, March 19, 2007 11:10 AM
Subject: Error message "Row cannot be located for updating"
Hi Everyone
I am using VB6 and MySQL, recently installed. I have a FlexGrid of items. I
save them, and in a large order (25
23 matches
Mail list logo
