| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> when i do insert into TABLE1 set name='john',age=21; it works fine... when i do insert into TABLE1(name,age) VALUES('john',21); it gives me syntax error... any ideas why it doesn't work the second way?
<1> Interesting.
<2> timmy2: Are you sure you're not doing an UPDATE rather than an insert?
<3> timmy2: try with a space between TABLE1 and (
<0> shabbs: COOL!!! the space worked
<3> awesome!
<0> i didnt know the whitespace was so important between words and parentheses
<3> not in all cases
<3> but in this case it can't tell where your table name ends without a space
<1> why would someone use --sing-etransaction?
<1> single, rather
<4> i want to do a select replace for a certain value in a field
<4> how do i do this
<3> dan__t: it dumps all transaction based tables in one large transaction
<3> dan__t: keeping the data consistant
<1> Just trying to troubleshoot this error which I get when I try to import.
<1> ERROR 1064 (42000) at line 3132: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2006-03-30 1' at line 1
<1> I understand what it is, but wondering why it happened if it was just a dump
<3> did you find the line in question?
<1> yeah, it's probably 30k characters long
<3> ok, more precisely did you find the string it's showing in the error message?
<1> nah, looking for it now
<1> gonna take a few mins
<3> yeah, when you do find it, look at what's directly before it, that's where the error is
<1> oh, ok.
<1> Thanks.
<1> omg.
<1> this is so gouign to ****.
<3> you could redo the dump with --skip-opt :D
<3> unless you're trying to restore a borked server
<5> Hi
<1> Well I'm trying to dump data from a live server to a new testing server
<1> but if this"backup" does not work, it's worthless.
<3> same version of the server?
<5> How to check if master is using ssl-ca from my.cnf ?
<1> no, actually
<1> from 5.0.19 to 5.0.21
<3> close enough
<1> but it's so close I didn't even bother to investigate that.
<1> yeah
<1> why would mysqldump dump broken data
<1> wtf
<3> it wouldn't, normally
<1> but it did! h eh
<5> mysql replication using ssl is just pain in the butt :(
<1> no it's not
<1> heh
<3> kokoko1: why not use an ssh tunnel?
<1> i ened to get this **** solved before I move on to that.
<1> That's the reason why I'm using this test server here
<5> shabbs, I love to use linux solution like ssh tunnel but boss kinda love SSL
<3> it's not just a linux solution
<6> I have mysql and can make basic databases but how can I make mysql more user friendly? Is there a way to make a GUI and what other things than databases can you make?
<3> !tell us about gui
<7> shabbs asked me to tell you this: MySQL Query Browser and MySQL Administrator from mysql.com; phpMyAdmin from phpmyadmin.net; Rekall from rekallrevealed.org; DBDesigner from fabforce.net; Windows users may prefer MySQL-Front and SqlYog at mysqlfront.de and webyog.com
<3> !m sayed tutorial
<8> !tell us about date
<7> sayed: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<7> But I don't know a thing about that.
<6> SQL Thank you :)
<3> !m mizZo date time functions
<7> mizZo: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<6> What is using mysql in batch mode?
<9> sayed: err... may *is* a database system. it's not intended for direct interaction with the average user. You would write an application in your favorite proggramming language that in turn uses the database...
<6> Ah.. Would I be able to make a program with say Perl that could send and display information from a database and even make tables in said database?
<6> I mean python* Not perl
<9> yes, that's the idea
<9> perl, php, java, c++, whatever
<6> Ah. I see.
<9> there's libraries/drivers for mysql in most major programming languages.
<6> IS there anything else other than tables that you can use?
<9> well, err...
<9> maybe you should read about what a relational database is?
<6> Hum.
<9> start here, perhaps: http://en.wikipedia.org/wiki/Database#Relational_model
<6> Say I wanted to use a python program to make a databse that stored information, and did basic adding and subtracting. Wiould this be difficult?
<1> shabbs, looks like --quick is what i'm looking for.
<9> no, that would be easy.
<1> it would definitely help me troubleshoot those inserts better.
<9> well, i havn't used mysql with python, but i'd imagine it would work more or less as with otehr languages
<6> Duesentrieb Could you help me? o.o
<9> but before you start, you should really try to understand what a relational database is and does, and what it isn't.
<6> Hmm I have somewhat of an idea.
<9> sayed: no, i can't help you. it's bin a while since i have used pythin, and i don't know the details of how it interacts wiuth mysql.
<6> Any programming language? o.o
<9> perhaps you should use the mysql command line, or phpmyadmin or whatever, to get a feeling for what a database can do
<2> sayed: What are you trying to do?
<9> inviso: he's trying to understand what a database is.
<6> Create a program that can create tables and do a few basic addition and subtraction commands.
<6> With respects to mysql
<2> sayed: that's inspecific fluff. What are you trying to do.
<2> ?
<9> sayed: sorry, i'm not going to do databases 101 tonight
<1> how about 102
<6> invisio Create a database that you can enter numbers into, an id for the numbers. You enter in these numbers for one table and the table will sort them to it's ID #, then you will make another table with the same ID #'s and the program will add or subtract the numbers you enter.. They should all equal a total number entered by a user. It's a currency system i'm trying to do. A tax sort of thing.
<6> But for an online sort of community
<2> hehe, that smacks of a WoW DKP system ;)
<6> Something like that :)
<6> invisio Can you help me?
<2> anyway, very doable. You'll need to decide on your presenation medium. If web, you'll want to pick a decent language you can work with. PHP, Python, Ruby and several others are all good choices.
<6> invisio Say I did python, how could I host it or even make the program in the first place?
<2> Then, you'll need to sit down with paper and pencil and detail out exactly what data you want to store and "design" your database structure.
<2> sayed: Do you have a host?
<6> I've already got a basic design and an example table.
<6> Well I don't really do it on the web, the people will tell me the numbers..
<1> wtf
<1> --opt includes --quick
<1> how come my dump looks like crap then.
<2> sayed: Ok, do you have your own server to host it on?
<2> dan__t: Use the pink bow.
<6> invisio I don't plan on hosting it. The people of the community will tell me the numbers.
<3> dan__t: if you're trying make it one insert per row, then do --skip-opt and don't specify -e
<2> sayed: it's gotta "run" somewhere....
<6> I can't just run it out of a console or something? o.o
<2> If you want to, sure
<3> it's not access
<6> inisio Or off a disk or a cd, what ever is free..
<3> sayed: sounds more like you need Excel
<6> shabbs I don't want Excel. I want to use MYSQL
<2> Ok, so going that route, your python program will prompt the user for input, hit the database to store/calculate/etc and then display the results on the console
<6> invisio Could i not just use that program that works with Python.. I forget the name... it makes it so you can do all that out of the one program.
<2> sayed: that makes almost exactly 0 sense
<6> invisio o.o You can make run and display the program and save it out of that one program.
<3> because that one dude in that place said so
<10> I'm working on normalizing user preferences in an app that I wrote a while back. The preferences are actually stored in a text field as a serialized PHP array. Almost everything works fine in a "user settings" table...but one of the things was "row_colors"...the alternating colors for rows of data...
<2> sayed: make what run? display what? It's not magic. You're going to have to write the code to ask the user for input. You're going to have to write the code to calcuate totals. You're going to have to write that code that displays output. That's just life
<1> Can I do --opt --skip-extended-insert instead, shabbs ?
<10> My user settings table is just user_id, setting_id, value(varchar 255)
<3> dan__t: --skip-extended-insert isn't a mysqldump option :)
<11> does anyone know if Innodb supports creation of indexes without rebuilding the table yet?
<10> Should I have another table for row colors? Should I comma separate them in the varchar field? Or just store them as a serialized PHP array as they were?
<3> dan__t: mysqldump --help if you look under --skip-opt it tells you what it turns off. you can use --skip-opt and whatever options you actually need off that list
<1> shabbs, read the man page - it tells you what to do if you do not want asingle option from --opt
<1> This option is enabled by default, but can be disabled with --skip-opt. To disable only certain of the options enabled by --opt, use their --skip forms; for example, --skip-add-drop-table or --skip-quick.
<6> inviso CAn you help me do this?
<2> sayed: Do "what"?
<6> MAke the program.. >.>
<1> oh fsck heh.
<3> dan__t: oh, maybe then. I never read that paragraph :)
<1> the dump wasn't copied over all the way, that's why I get the syntax error
<3> haha
<1> hurrrr duh hurr
<1> that one goes down in the books
<1> haha
<3> at least I learned somethin new :D
<6> inviso ?
<2> sayed: Nope. I can point you to the tools you need. I can critique your database design. I can help answer sql problems you're having. But that's all way past where you're at right now. You need to learn how to program first. And you'll need to learn how to write Python code. Start with some basic, non-DB practice programs first and visit #python for help when you get stuck.
<6> Alright. Where can I read a guide for that sort of thing?
<2> sayed: And to be realistic, you're probably at *least 2 months from having anything workable. It simply takes time to learn this stuff
<2> sayed: http://www.google.com/search?q=python+tutorial&ie=UTF-8&oe=UTF-8
<12> I
Return to
#mysql
or
Go to some related
logs:
#debian
whereis package.mask
installing telnetd in ubuntu
citadel init.d ubuntu
network-admin ubuntu taskbar
mssql replace Msg 8114
#perl
#php
gentoo 200M dri xorg hang
dbx_connect php5
|
|