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: http://lists
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 make
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 /var/lib/mysql/srms07/staff.
"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 Javasc
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:
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.
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
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 fil
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
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:
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) Displaye
pt enter 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
> >
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]
ower case
> . = any character
> * = 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
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:
ows usernames
> to be changed.. I mean, sure, 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 PR
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 pro
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 only
emy Cole wrote:
> Hi 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 Kebb
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 |
gt; > and leave that unsolved problem 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()
roblem 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 e
-0700, Gordon wrote:
> Just one suggestion re the behavior of special characters between file
> input and command line input. Try using char(10) {I think that is new
> line} instead of \n. That should work in both scenerios.
>
> -Original Message-
> From: John Kebbel [ma
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 e
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 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 skill-
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 s
28 matches
Mail list logo