| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> Yes.
<1> ^] is what key
<2> daeos bind-address=127.0.0.1
<3> Hi there. I'd like to know if a COMMIT query with MySQL waits until all datas have been flushed to disk before returning or not ?
<3> or if COMMIT simply returns immediately, and lets MySQL finish the transaction in the background ?
<4> anyone know the difference between bind variables and stored procedures
<5> need help with a subselect in an update. http://pastebin.com/627732
<6> I am having a problem with an sql query, in php
<6> I am having a problem with an sql query, in php. It doesn't like they way I format a date, I think ? here is the code http://iol.homelinux.org/foo.php.txt
<6> does anybody know how to fix it?
<5> yeah
<5> put it all on one line
<5> or use concatenator operator
<6> cloaked: ok I will give that a try
<5> for instance:
<5> $query = "select inc.incident_date ".
<5> "from incident inc ".
<5> "where inc.incident_date > '2004-12-06'";
<5> that should work
<7> Cannot connect to mysql database on Windows 2003 server x64 using ODBC. Is there a workaround or another connector to use with MS Access?
<5> SMaction: no idea. I don't do windows stuff.
<5> imo, windows == evil
<5> I am forced to use it as a client here at work :(
<6> cloaked: that worked perfect thank u so much :)
<5> but we don't use it in our server env.
<6> cloaked windows is so evil
<5> clarks: np
<6> cloaked: i hate windows sooo much
<0> why, clarks?
<6> jbrimble: because I sent a client a bill for about 500 hours work
<6> and he says "the port to windows took too long"
<6> and he wants me to knock of like 40 hours or something
<6> the port to windows took a long time, becuase
<6> of a broken menu in MSVC
<6> when I clicked on "release mode"
<0> oh true
<6> it never took
<6> right click project, left click properties, pull down release mode, doesn't work. It resets the project to debug mode, when you aren't looking
<8> does mysqladmin have an option to drop a table from a database
<6> you have to do pull down menu, release mode, from the main menu
<6> :'(
<0> oh god, this isn't the place for it i know.. but has anyone ever written an inventory management program for a warehouse?
<0> I'm using MySQL, so i guess it's appropriate
<6> jbrimble: That is potentially a big project, in fact there are probably 1000 different apps out there, ranging from small apps, to huge apps, which meet that description.
<6> jbrimble: you need to break down the system design / specifications a little more
<2> not something you write in a day
<5> IOscanner: it should. But if it doesn't then you can log into the server using the mysql client and drop the db manually.
<5> try right-clicking on the database.
<2> think multi wharehouse if you can just in case
<6> jbrimble: I looked around the web, for sample applications covering your description
<6> jbrimble: it sounds like an app, that would be built as an example in a text book
<2> those examples often have a lot missing
<0> The application I'm developing will be running multiple warehouses linked together, order tracking with a web-based interface for clients too.
<2> and locations in wh and serial nos?
<0> yes.
<9> I am dealing with a weird database column...instead of making it numerical...some genious made it text and put values like |1| and |4| which match to one tables PK and 2 other tables FK...IF you strip the | off, how can I do that with MySQL?
<0> And a timetable for orders coming in and out.
<2> and incomming in 1 pack size outt in another
<4> anyone know the difference between bind variables and stored procedures
<0> its definately a large project.
<2> albo define bind variables
<4> archivist: i cant,but is there a way to "store" a variable in the select part and then use it in the where part
<9> I am dealing with a weird database column...instead of making it numerical...some genious made it text and put values like |1| and |4| which match to one tables PK and 2 other tables FK...IF you strip the | off, how can I do that with MySQL?(sorry if I just re-posted, I forgot to identify with nickserv)
<10> Shane-S, replace(weirdcolumn,'|','')
<6> jbrimble: http://www.weberdev.com/get_example-1772.html
<9> thanks bobfield
<6> jbrimble: I just read the description, didn't check it too carefully
<2> albo what are you actually trying to do
<9> bobfield: would you have a doc link to that functions usage?
<0> thanks clarks
<4> archivist:if there was such a way, then i would be able to not duplicate this piece of sql which is 8 lines and make tiny changes
<10> !m Shane-S string functions
<11> Shane-S: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<9> I tried it in a WHERE and that didn't work out
<9> TY
<4> archivist: AND have to deal with combining the results of the two slightly different queries which eventually go into the same table
<2> albo http://dev.mysql.com/doc/refman/5.0/en/example-user-variables.html
<4> archivist: any idea if those can be used in the same query as when you create them
<2> dunno try it
<7> Cannot connect to mysql database on Windows 2003 server x64 using ODBC. Is there a workaround or another connector to use with MS Access?
<4> archivist: why does this only return 1 row select @blah:=if(agentid=1,'HAHAHA',agentid),@blah,agentid from agent where agentid=@blah
<4> theres hundreds of rows
<2> @blah is 1 variable
<2> use a temp table
<12> hello
<12> how do you write sql statements to do updates
<12> between tables
<10> lorfds, join them
<12> so if i want to update a column in one table with values from another, can i do that
<12> Does a join physically join them, or is it just for sql purposes
<10> !m lorfds join syntax
<12> i dont want to physically join the tables
<11> lorfds: (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<10> !m lorfds update syntax
<11> lorfds: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<12> cool
<12> thanks
<10> np
<13> what is wrong here? UPDATE news SET tittle='cah' , contents='teste', date=NOW(), poster='nightz' WHERE id = 7; , i got QUERY ERROR: 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 'cah'.')' at line 1
<13> mysql 5.0
<13> if anyone can help, thanks already =)
<10> romulo, I can't see anything obviously wrong except where is that ')' coming from?
<13> dunno, really dunno
<13> =P
<10> looks like some php syntax leaking into your statement
<13> hmm
<13> let me check
<13> how i can discover it ? theres a easy way?
<2> buils an $sql string and echo it
<13> that what i done to print it here
<2> and use it in the qry
<10> mysql_query ($query) or die (myql_error() . "\nActual query:" . $query)
<13> found it
<13> it was one "'"
<13> that way
<13> =P
<14> Hi. I'm setting up a foreign key relationship between two tables and having a hard time understanding the index requirements. parent table.primary_key - vendors.id; child table.foreign_key - chemicals.vendor_name. I keep getting "No index defined! (vendor_name)" error. What is my mistake?
<14> I do have an index for chemicals.vendor_name.
<7> Cannot connect to mysql database on Windows 2003 server x64 using ODBC. Is there a workaround or another connector to use with MS Access?
<15> so vendors.id _is_ the primary key for vendors?
<14> bigfoot-: yes
<15> and chemicals.vendor_name is the same type as vendors.id?
<15> id sounds like "int", name sounds like "varchar" or alike...
<14> bigfoot-: yes
<14> bigfoot-: Both fields are the same int(10) unsigned type
<15> Show me the output of SHOW CREATE TABLE chemicals; --> nopaste.php-q.net
<14> bigfoot-: http://nopaste.php-q.net/201661
<15> malex: hmm. same for vendors?
<16> is there a good way to implement a linked list in a table somehow? i need to be able to sort records in an arbitrary order (not by name or anything that can be done automatically)
<17> SMaction: do you use the MySQL Connector/ODBC ?
<14> http://nopaste.php-q.net/201663
<14> bigfoot-: http://nopaste.php-q.net/201663
<17> malex: create an index on both the column you referencing and referenced
<15> malex: Hmmm. The only relevant difference I see is that vendor.id is INT(5), chemicals.vendor_name is INT(10)...
<15> What's the ALTER TABLE request you're using to add the foreign key?
<17> bigfoot: default NULL could be a problem
<15> No, imho not.
<17> bigfoot: since the other 1 cannot has NULL
<15> foreign keys may be NULL.
<14> bigfoot-: I am using phpmyadmin to set up this relationship.
<17> bigfoot: I remember you cannot has 1 column with NULL and another with NOT NULL
<17> it shuold be for malex
<15> lokus: IMHO this is allowed.
<17> ok, null is not the problem
<15> I'd suggest trying a manual ALTER TABLE query.
<15> malex: http://dev.mysql.com/ALTER%20TABLE%20syntax
<18> will: an update -- somehow I managed to get my old databases back and the new installation. Don't ask how. Thanks for your help.
<14> ERROR 1005 (HY000): Can't create table './zlab/#sql-11a6_2a5.frm' (errno: 150)
<14> When I try to run a manual ALTER TABLE query
<17> !perror 150
Return to
#mysql
or
Go to some related
logs:
distrowatch podcast
hald-addon-acpi acpid busy
%u2018 encoding
#debian
several default routes
gentoo ati-drivers Permission denied
#debian
error when calling the metaclass bases must be code
courier-pop ERR maildir
g_ether error inserting
|
|