| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> will_: "better" as in "covered by the standard", or why?
<1> !tell us about quotes
<2> will_ asked me to tell you this: Use ` around identifiers (database/table/column/alias names) and ' around strings and dates.
<1> MySQL allows " for strings, but that's not what ANSI standards say.
<0> that's what I wanted to know ;)
<3> !define quotes as Use ` around identifiers (database/table/column/alias names) and ' around strings and dates. MySQL does allow " for strings, but ANSI standard uses " for identifiers (which you can enable with ANSI QUOTES option)
<2> Defined.
<0> whatever made the mysql devs choose to deviate from the standard here...
<3> Because MySQL wanted to be easy to use any everyone uses " for strings??
<4> does anyone have any suggestions on doing something along the lines of 'split' for a mysql field?
<5> can you do in a where statement a comparison like where id>2/
<3> Try it.
<0> will: mmkay, sounds reasonable
<5> will that directed to me?
<5> ah it appears ya can nvm
<3> bigfoot-, There are many standards define, but there are NO databases out there that completely follows it.
<3> daum, Yes :)
<3> dp_, Example?
<4> will: I want to do something along the lines of: select count(split(field, ' ')) from table
<4> and have it return the count of field delimited by ' '
<3> What is split?
<3> You know that is against database theory/design? :)
<4> an example: http://www.perlfunc.org/function.php?name=split
<4> will: storing text in a field is against database theory/design?
<3> heh. I was thinking you were storing an array.
<4> no
<6> i'm ***uming he wants a word count
<3> Yeah :)
<4> gleam_: correct
<6> i have a solution for that
<6> it's awesome.
<3> WHY DIDNT HE JUST SAY THAT FROM THE START?
<6> do you want it?
<6> and by awesome i mean horrible.
<4> and I found an example of it, but it requires a substring_index for *each* delimited item
<6> nah
<4> hit me with it
<4> I was gonna try some REGEXP stuff, but it didn't look like that would work
<6> length(field)-length(replace(field,' ',''))+1
<4> hey
<4> hadn't thought about that
<4> thanks :)
<3> dp_, For a word count on a body of text, I would do it in your app, and store the value. I would ***ume that the data does not change very much.
<6> yes, i'd generally suggest that too
<4> will: I'm not at liberty to change the app, and I just want to run some reports on the data
<3> ok
<4> thanks though
<4> takes a bit longer, but works for what I need :)
<7> hi everybody, salut tout le monde
<6> like i said, it's horrible :)
<6> it may be faster to calculate in your app
<6> but hey.
<6> it works.
<7> i have a big problem, have deleted the root user with phpmyadmin for my mysql server, how can i add it again ?
<6> !m usinagazirc resetting permissions
<2> usinagazirc: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<6> follow that
<6> but instead of "set p***word for " in the init file
<6> use an equivalent grant statement to create a root user
<7> ok thanks a lot, i go and see that link and devices ... but for the moment, i have only one user with no privilege at all
<7> i will see, i am on debain, and make a "mysql -u root -p " give an error, and with the only user i can use , it's impossible to do something so ... well, i think you gave me part of the solution in the link, thanks all of you
<8> is there away to run an sql query that utilizes '?' for placeholders and then run the query with parameters p***ed via the mysql client? i'm debugging a query via Perl-DBI and want to somehow run the query manually without having to rewrite the query
<9> hi
<9> searching for something in all the tables in phpmyadmin is very fast
<9> what kind of search does it use ?
<10> #phpmyadmin
<9> thanks Darien_
<11> what type of security features does mysql have if i want to store things like p***words and credit card #s?
<6> aes_encrypt/aes_decrypt for encryption (aes-128 unless you recompile). sha1 and md5 for hashes.
<6> memory tables available.
<12> hello
<12> how can i select a subset of rows where date_column is dated after 22. april and before 30. april?
<6> where datecol between date and date
<12> clever.
<13> is there a way to search every column of a table for a value
<14> Is it possible to just import one database from a mysqldump of all the databases?
<13> i don't think anyone is in here
<12> gleam_, something like datecol btween "2006-04-22 00:00:00" and "2006-04-30 00:00:00" then?
<6> use '' instead of ""
<6> but yeah.
<6> is it date or datetime?
<12> okey. thanks
<12> the coltype?
<6> ya
<12> datetime
<13> oh hey is there anyway to search for a value in every column
<6> if you want after apr 22 you probably want 2006-04-23 00:00:00
<6> and 2006-04-29 23:59:59
<12> gleam_, yeah ;)
<12> pretty cool i don't have to use a function to convert that string into a numeric value or something... (as i first expected)
<15> i've got an odd question. i'm workign with some database files - all my dbs are in /var/lib/mysql as subdirs, and I can see MYI and MYD files for *every single database* except for the one I care about, which is abotu 1.8 gigs of SQL. I can see all the .frm files in its directory, just no MYI/MYD. What does this tell me?
<13> you're in deep trouble
<6> do you have any ibd or ibdata files?
<13> tranfer your MYI to a DLS
<15> gleam_: I do.
<15> why am I in big trouble?
<13> lol i'm just pullin your leg
<6> are you currently able to use those tables?
<6> are you sure they aren't just innodb tables?
<15> gleam_: i was a few minutes ago. i'm checking again.
<6> show table status
<15> i believe they may be innodb tables. what's that mean?
<10> [RainMkr]: about?
<6> innodb and myisam are storage engines for mysql. they store data differently on disk
<6> innodb in either a few ibdata files for all tables, or in individual ibd files for each table
<15> yes, a show table status was successful, and they're all innodb
<6> then you're fine
<15> so, where do the files live?
<15> i need to transfer/back them up.
<15> and yes, i have a mysqldump too.
<6> backing up innodb you hav ea few options. you can shut down the server and copy the files, you can use mysqldump, you can use innodb hot copy, etc
<15> but where is the innodb store? i only see a bunch of .frm files.
<6> they're either in the ibdata files in the main datadir
<15> aaah. ok.
<6> or in .ibd files in the database directories
<15> there's no way i can flush that in some sort of singular file? wouldn't other db data be in there too?
<6> probably ibdata files for you
<6> yes, other db data is in there too
<6> there's the innodb_file_per_table option, but even after you set that you'll have to dump+reload the dbs you want to move from shared tablespace to individual tablespaces
<6> you still need the shared tablespace also, itll just be a lot smaller
<15> ugh.
<15> 1.8 gigs of SQL takes a *long* time to import.
<6> yup
<6> !m Morbus multiple tablespaces
<2> Morbus: (Using Per-Table Tablespaces) : http://dev.mysql.com/doc/mysql/en/Multiple_tablespaces.html
<10> Therion: you about either mate?
<13> so isn't all SQL basically the same for oracle mysql etc?
<3> Define "basically"
<13> so if i use a mysql tutorial it shouldn't matter that i'm working in an oracle DB
<3> Why don't you use an Oracle tutorial?
<16> Darien_: sup?
<10> Leith: not much, just wondering if those slackers are about
<10> buncha lazy bastards
<17> well it's me that's slacking ;)
<17> they're working
<10> pfft
<17> prolificg: no they are different
<17> prolificg: for a start, basic data types are different
<3> Leith, THEY BOTH HAVE SELECTs!
<17> if you follow "standard SQL" it's mostly the same, but there are different functions etc.
<17> will: I SHALL SMITE THEE
<10> woo smite
<14> I am using mysqldump --all-databases to dump all my databases to a text file...is it possible for me to only import 1 database instead of all of them?
<18> yarg
<19> captrespect: In English please?
<18> ok, mysql is telling me that it's starting a rollback of over 36K in transactions
<18> that's gotta be close to my entire database
<18> why would all these transactions be uncommited?
Return to
#mysql
or
Go to some related
logs:
controlling birds talking OR commanding
#debian
install header files + ubuntu
surcelist
xstartup VNC Xfce debian
#python
#debian
fedora rescue mode radeon
EmergePackageError :FATAL: emerge: gentoo-sources
kwifimanager autostart
|
|