Your solution was exactly what the doctor ordered. Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
The solution was CREATE TABLE copyname SELECT * FROM originalname
I was having problem with a PHP command that's not pulling what I want
from the table Ruling out random order for the rows was narrowing the
focus on the PHP problem.
--
MySQL General Mailing List
For list archives:
INDEXES - A Science AND an Art
I've been continuing to look for answers to my own questions. I've found
a few ...
Q1. What good does it do to store the primary key or a unique key if
you're normally SELECTing columns that don't use that primary or unique
key?
As you can see, it only
I have a few questions about indexes. I understand (1) what an index
is, and (2) why indexes are useful, but I don't have even a rough idea
about HOW they work. The internet resources I've been able to find don't
answer the questions I'm asking. I also tried
cat
For years, I've been using FileMaker Pro to generate a staff photo
gallery and staff phone directory from the same table of staff
information. I'm switching to PHP/MySQL for the year ahead. In STEP 1
below, I concatenate a name for the teacher/staff person image and in
STEP 3 I concatenate
John Meyer wrote ...
you may want to do a perl script to find and replace the spaces.
Scott Haneda wrote ...
I would move your html and string parse logic into php,
If I'm doing data entry for individuals via a web page, Javascript is a third
option.
Instead of individual replacements, as in ...
SELECT REPLACE('De Long', ' ', '');
would this global approach work?
SELECT REPLACE(imgName,' ','') FROM staff WHERE imgName REGEXP ' ';
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Databases are used to store data
This line spoke the loudest to me. Over the years I had become very
proficient with FileMaker Pro's built in scripting language. I had even
gotten FileMaker to construct the web pages that would be used to
connect to FileMaker (including writing the page's
When I try using the --xml or --html option with a batch file using INTO
OUTFILE 'dirpath', the --xml or --html option seems to be ignored in
favor of the tab-delimited default. (If I get rid of the INTO OUTFILE,
xml or html displays fine in the terminal.)
I tried using the pager to write to a
Fortunately, I'm learning MySQL on my home machine, so this
MEGA-Mistake doesn't sink a Fortune 500 corporation.
I was experimenting with a batch file that ...
(1) Created a set of user accounts with tiered privileges,
(2) Set passwords for the new accounts, and then
(3)
The Synaptic checkbox menu has a Mark for Removal and Mark for Complete
Removal. Complete Removal seems to be same as Purge; when I look at
details, it says the configuration files are being removed.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Even though I completely removed everything I could find related to
MySQL in Synaptic Package Manager, a folder still remained
at /var/lib/mysql/ containing all my old table information. If that info
hung around, it seemes logical to assume the Grants table were still
somewhere interfering
Is there a mysql command line equivalent to | less or | more to make it
easier to scan rows one screen at a time?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a ?, and then look
at the options ... hint pager.
and/or search the documentation for set pager.
- Rick
Original Message
Date: Thursday, May 03, 2007 08:33:57 AM -0400
From: John Kebbel [EMAIL PROTECTED]
To: MySQL mysql@lists.mysql.com
Subject: Less
I went to the MySQL documentation pages and read up on using COLLATE. I
knew SELECT was case-insensitive, but I was sort of surprised that using
a character class didn't override that. Anyway, I next tried the
status command to see if it gave me any characterset information.
Client characterset:
* = mods last to grab anything after that...
actually you should just be able to get by with ^[a-z]
John Kebbel
[EMAIL PROTECTED]
05/02/2007 05:33 AM
Please respond to
[EMAIL PROTECTED]
To
MySQL
mysql@lists.mysql.com
cc
John,
Are you sure they are actually NULL and not NULL (i.e. the string NULL)?
Try this:
SELECT first, last, ISNULL(suffix), LENGTH(suffix) FROM persons LIMIT 5;
Regards,
Jeremy
John Kebbel wrote:
I'm having problems understanding NULL. I grasp what a NULL value is,
but I can't
Linux Version: Linux version 2.6.15-28-386
MySQL Version: 5.0.22-Debian_0ubuntu6.06.3-log
I have two queries using REGEXP character classes and their respective
outputs below. The first is supposed to match an upper case character in
a column, but I wind up with 4 rows out of 25 that contain
I've discovered that I can type ...
use mysql;
show tables;
describe user;
update user set user='newName' where user='oldName'
However, this seems to have no effect on the user name in the privileges
table when I searched them.
The MySQL site says the alternative way to do this has the same
, there is a trivial hack to do it on
not-so-secure unix systems but it's still far from common practice. I
recommend that you take the easy road and just delete/create.
On 5/1/07, John Kebbel [EMAIL PROTECTED] wrote:
I've discovered that I can type ...
use mysql;
show tables;
describe
-zero count, then you know that there is a possibility of
CEIL(RND()) not hitting an ID.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: John Kebbel [mailto:[EMAIL
I'm having problems understanding NULL. I grasp what a NULL value is,
but I can't get NULL to perform correctly. For instance, if I do a
Select statement, I see that I have columns with a NULL value.
select first, last, suffix from persons LIMIT 5;
+---+--++
| first |
For possible educational research purposes, I was playing around with a
query that would randomly select people from a database. The database I
experiment with has a group of fictitious persons with id numbers
(primary key) ranging sequentially from 2 to 378. When I ran these
queries below, I was
using char(10) {I think that is new
line} instead of \n. That should work in both scenerios.
-Original Message-
From: John Kebbel [mailto:[EMAIL PROTECTED]
Sent: Saturday, April 28, 2007 7:19 AM
To: mysql@lists.mysql.com
Subject: Giving Back...Well, Maybe
I don't have enough
for another day. Thank you for your
solution Michael.
On Sun, 2007-04-29 at 08:48 -0400, Michael Dykman wrote:
If might suggest:
SELECT * FROM BAR
ORDER BY RAND()
LIMIT 10
On 4/29/07, John Kebbel [EMAIL PROTECTED] wrote:
For possible educational research purposes, I was playing around
I don't have enough MySQL knowledge to contribute much to this mailing
list, but as a 23 year veteran teacher, I have some expertise when it
comes to developing methods of instruction (especially
self-instruction). While studying for the MySQl CMDEV exam, I created a
method for MySQL
Thank you. It's working now.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I experimented with a local /var/www folder. I assumed setting 2, 6, or
7 for the Other value would give mysql write privileges, but mysql would
not settle for anything less than a 7 in that last slot. What was really
curious to me was that the User and Group settings were inconsequential.
I even
28 matches
Mail list logo